Timeline for Amazon RDS MySQL Troubleshooting High Sessions
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 5, 2019 at 21:31 | comment | added | Wilson Hauck | Please provide what you have available, we will analyze available data for you. How big is your SWAP space? | |
| Jun 5, 2019 at 21:05 | comment | added | Jyosua | Hey Wilson -- I can't actually provide some of this information because this is an RDS instance and I can't exactly just SSH into it. Further, I've since found other issues and fixed them, so the conditions under which this was occurring no longer exist. Among these issues were: some of my large tables were using MyISAM instead of InnoDB and my RDS instance only had 4GB of RAM and had started to use Swap memory, which increased the amount of disk IO used. | |
| Jun 3, 2019 at 16:02 | comment | added | Wilson Hauck | Additional information request. Post on pastebin.com and share the links. RAM size of your MySQL Host server A) complete (not edited) my.cnf or my.ini 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 very helpful information, if available includes - htop OR top OR mytop 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. | |
| May 28, 2019 at 21:24 | history | answered | Jyosua | CC BY-SA 4.0 |