Timeline for MySQL Server 5.6 Using all or very little of my resources trouble shooting?
Current License: CC BY-SA 4.0
13 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 21, 2020 at 15:21 | answer | added | Rick James | timeline score: 0 | |
| May 21, 2020 at 13:27 | answer | added | Wilson Hauck | timeline score: 1 | |
| May 20, 2020 at 20:51 | comment | added | Wilson Hauck | Additional information request. RAM size, Any SWAP space?, # cores, any SSD or NVME devices on MySQL Host server? Do you have flexibility to Skype TALK with me? View profile, Network profile for contact info and free downloadable Utility Scripts to assist with performance tuning. | |
| May 20, 2020 at 19:52 | comment | added | Wilson Hauck | I see that you are Windows hosted. Here is URL to download executable for mysqltuner.exe for the Windows version to execute after download from MS Command Prompt, login as root to your instance for the report preparation. github.com/pmachapman | |
| May 20, 2020 at 18:07 | comment | added | bjk116 | I posted what I can. www.mysqltuner.com does not appear to be up at the moment. | |
| May 20, 2020 at 18:06 | history | edited | bjk116 | CC BY-SA 4.0 |
added 671 characters in body
|
| May 20, 2020 at 18:06 | comment | added | Wilson Hauck | You can get the perl script from www.mysqltuner.com to produce the report. It is a low-impact external script, requiring only root login to your MySQL instance. | |
| May 20, 2020 at 18:04 | comment | added | Wilson Hauck | Hoping you can post the rest of the requested info, even if you think it is OK. Thanks for the SGS and SGV. | |
| May 20, 2020 at 18:00 | history | edited | bjk116 | CC BY-SA 4.0 |
added 20857 characters in body
|
| May 20, 2020 at 17:57 | comment | added | bjk116 | Thanks for the list of info. The VM has 16 gigs allocated, of which MySQL settings give it 8 to use. The rest of this is good info to try. Thanks for the insight. Added the GLOBAL VARIABLES and GLOBAL STATUS info to my post. I don't know what most of it means but hopefully it means something to you. | |
| May 20, 2020 at 17:56 | comment | added | Wilson Hauck | Additional information request. RAM size, # cores, any SSD or NVME devices on MySQL Host server? Post on pastebin.com and share the links. From your SSH login root, Text results of: B) SHOW GLOBAL STATUS; after minimum 24 hours UPTIME C) SHOW GLOBAL VARIABLES; D) SHOW FULL PROCESSLIST; E) complete MySQLTuner report AND Optional helpful information, if available includes - htop OR top for most active apps, ulimit -a for a Linux/Unix list of limits, iostat -xm 5 3 for IOPS by device and core/cpu count, for server workload tuning analysis to provide suggestions. | |
| May 20, 2020 at 17:46 | comment | added | nbk | here is essential acopy see if oit helps atlassian.com/blog/archives/…, but it is normal for every program to grap all re4spurces initially to get the job done. | |
| May 20, 2020 at 17:10 | history | asked | bjk116 | CC BY-SA 4.0 |