{"id":161,"date":"2026-09-07T13:23:33","date_gmt":"2026-09-07T06:23:33","guid":{"rendered":"https:\/\/www.tsongpol.com\/?p=161"},"modified":"2026-09-07T13:23:33","modified_gmt":"2026-09-07T06:23:33","slug":"topic-solving-a-system-breakdown-on-student-registration-day","status":"publish","type":"post","link":"https:\/\/www.tsongpol.com\/?p=161","title":{"rendered":"Topic: Solving a System Breakdown on Student Registration Day"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Here is a simplified English version. It uses shorter sentences and easier words while keeping the important technical ideas, making it much easier to memorize and speak naturally during the interview.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\">Topic: Solving a System Breakdown on Student Registration Day<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">1. Situation<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>&#8220;In my previous job, I managed the\u00a0<strong>Student Registration System<\/strong>.&#8221;<\/li>\n\n\n\n<li>&#8220;On the first day of registration, thousands of students logged in at the same time. The system became very slow, and students could not register.&#8221;<\/li>\n\n\n\n<li>&#8220;Both teams started arguing. The\u00a0<strong>Developer Team<\/strong>\u00a0said their code was perfect and blamed the hardware. My team thought the code was bad. Everyone was pointing fingers while the system was still down.&#8221;<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">2. Task<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>&#8220;My main goal was to stop the argument and get everyone to focus on one thing:\u00a0<strong>fixing the system for the students as fast as possible<\/strong>.&#8221;<\/li>\n\n\n\n<li>&#8220;After that, I needed to find the real problem using clear data, so it would not happen again.&#8221;<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">3. Action<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Stopped the Blame Game:<\/strong>\u00a0&#8220;I called an urgent meeting and told everyone,\u00a0<em>&#8216;The students cannot register right now. Let\u2019s focus on fixing the system first. We can find out who is wrong after the system is back online.&#8217;<\/em>&#8220;<\/li>\n\n\n\n<li><strong>Looked at the Facts:<\/strong>\u00a0&#8220;I shared my screen and showed our\u00a0<strong>Monitoring Dashboard<\/strong>. The data showed that our servers and network were fine, but the\u00a0<strong>Database Server<\/strong>\u00a0CPU was at 100% because there were too many connections.&#8221;<\/li>\n\n\n\n<li><strong>Fixed it Together:<\/strong>\u00a0&#8220;I asked my team to increase the database size (<strong>Scale Up<\/strong>) immediately. At the same time, I asked the Dev team to change the &#8216;Save&#8217; button code so students couldn&#8217;t click it too many times. In 30 minutes, the system was working again.&#8221;<\/li>\n\n\n\n<li><strong>Held a Good Meeting:<\/strong>\u00a0&#8220;The next day, I set up a\u00a0<strong>Blameless Post-Mortem<\/strong>\u00a0meeting. I told everyone we were there to fix the system process, not to punish any person.&#8221;<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">4. Result<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>&#8220;The system worked well for the rest of the day, and the teams stopped arguing.&#8221;<\/li>\n\n\n\n<li>&#8220;We found out that a heavy database query was causing the bottleneck when traffic was high.&#8221;<\/li>\n\n\n\n<li>&#8220;To prevent this, we agreed to do\u00a0<strong>Load Testing<\/strong>\u00a0together before every registration day. We also added a\u00a0<strong>Redis cache<\/strong>\u00a0to make the database work less. This event changed our culture to be more data-driven and supportive.&#8221;<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Here is a simplified English version. It uses shorter sentences and easier words while keeping the important technical ideas, making it much easier to memorize and speak naturally during the interview. Topic: Solving a System Breakdown on Student Registration Day 1. Situation 2. Task 3. Action 4. Result<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-161","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.tsongpol.com\/index.php?rest_route=\/wp\/v2\/posts\/161","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.tsongpol.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tsongpol.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tsongpol.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tsongpol.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=161"}],"version-history":[{"count":1,"href":"https:\/\/www.tsongpol.com\/index.php?rest_route=\/wp\/v2\/posts\/161\/revisions"}],"predecessor-version":[{"id":162,"href":"https:\/\/www.tsongpol.com\/index.php?rest_route=\/wp\/v2\/posts\/161\/revisions\/162"}],"wp:attachment":[{"href":"https:\/\/www.tsongpol.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=161"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tsongpol.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=161"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tsongpol.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=161"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}