Timeline for Mysql Server high CPU load and high memory usage
Current License: CC BY-SA 4.0
15 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| 2 days ago | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Aug 14 at 19:00 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Apr 14 at 21:07 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Dec 16, 2023 at 17:02 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jan 23, 2022 at 19:05 | comment | added | Wilson Hauck | Do you know the reason for KILLING processes? Very hazardous operation. Problem needs to be corrected, to avoid need for KILL. | |
| Jan 23, 2022 at 19:02 | comment | added | Wilson Hauck | Would you post a new TOP report, 1st page to compare since changing the 4 Global Variables, please. | |
| Jan 23, 2022 at 18:48 | comment | added | Wilson Hauck | Any chance you can post the code used to Connect, Process, Close your client connections? the IOSTAT posted is not readable. Put 4 spaces at beginning of each line and we should be able to read the results. There should be ate least 12 lines of output - for 5 second delav between each of 3 cycles. | |
| Jan 23, 2022 at 8:30 | comment | added | ashkan | hi, thanks for help, Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await r_await w_await svctm %util fd0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 sda 0.00 0.00 6.80 87.20 0.06 1.81 40.93 0.24 2.59 1.97 2.64 1.40 13.12 dm-0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 this is what i have got from the iostate | |
| Jan 21, 2022 at 1:44 | comment | added | Wilson Hauck | The TOP report shows Tasks 15 running and 248 sleeping raises 2 questions to consider. Please post TEXT results from OS Command Prompt of iostat -xm 5 3 for IOPS by device and core/cpu count to see if 15 running tasks are reasonable for your core count. The 248 sleeping tasks indicates missing CLOSE within your Connect, Process, Close code to manage releasing resources when finished with a user's unit of work. Posting your code providing these 3 functions might allow someone an opportunity to suggest CLOSE placement.. | |
| Jan 20, 2022 at 19:30 | answer | added | Wilson Hauck | timeline score: 0 | |
| Jan 19, 2022 at 13:26 | review | Close votes | |||
| Feb 5, 2022 at 3:03 | |||||
| Jan 19, 2022 at 13:10 | comment | added | mustaccio | Does this answer your question? MySQL not releasing memory | |
| Jan 18, 2022 at 19:04 | answer | added | Rick James | timeline score: 0 | |
| Jan 18, 2022 at 17:54 | history | migrated | from stackoverflow.com (revisions) | ||
| Jan 18, 2022 at 14:39 | history | asked | ashkan | CC BY-SA 4.0 |