无挑战,不任务之 -系统剖析师招聘谜底（国外英文资料）.docVIP

无挑战,不工作之 -系统分析师招聘答案（国外英文资料） No challenge, no job - system analyst hiring answers The author: the source of caoz: the baidu space cool network collects 2010-09-05 Topic: Title 1 is very simple, A mysql database server A, A mysql link is overmuch, cause the front-end web server database connection could not be opened, now, up to you to solve this problem. Question 1: what steps will you take to deal with this? Notice the steps Problem number 2: how to analyze this problem, there are several possibilities, the analysis of each possibility, what the criterion is. Problem number 1: give the best possible solutions for different possibilities. Dont tell me that you will modify the mysql link parameter, if you only think of this one, dont write. Topic 2: a Linux server load is very light, at ordinary times the CPU between 10% and 20%, but there will be a few days a week in the uncertain time suddenly jumped to 100%, and then lead to the server rejected all response (including the SSH link), in desperation can only phone through the computer to restart. Now, when the load is too high to connect to SSH, you cant confirm the cause of the load surge for a while, and give you the processing steps and the solution that you think of. Dont tell me youll set up a 24-hour SMS reminder, thats basic. Title 3: a Linux server load is very light, but suddenly refused to normal service, still can log in at this time, still see online is very light load, please tell me your train of thought to analyze the screening. Reference answer: This is the most common problem, but it is also the most important issue here Child question 1, why do you mention the steps, and very few people tell me that the first step is to resume the online application as soon as possible, which is consciousness! Back online application there are several scenarios, the simplest is to show the processlist and then kill off blocking the processlist, followed by restart the database, if the database after the restart qui