Timeline for MySQL 8.0 Tuning Advice Needed - Slow Locking & Various Issues
Current License: CC BY-SA 4.0
15 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 27, 2021 at 1:44 | vote | accept | peppy | ||
| May 26, 2021 at 15:35 | answer | added | Wilson Hauck | timeline score: 1 | |
| May 25, 2021 at 21:59 | history | edited | peppy | CC BY-SA 4.0 |
added one more pastebin
|
| May 25, 2021 at 0:29 | comment | added | Wilson Hauck | @peppy Thanks, your reputation is 11 now. Huge pages are not active per meminfo. | |
| May 24, 2021 at 22:46 | comment | added | peppy | @ Wilson Hauck - Here is the pastebin for /proc/meminfo: pastebin.com/PKKeumyt . It says I can't add more than 8 links to my post until my reputation is 10+. Unfortunately, I have no idea if OS is running in Full Power mode, nor do I know what most of the other 95% of the processes are in the top report. | |
| May 24, 2021 at 15:17 | comment | added | Wilson Hauck | Please post TEXT results from OS Command prompt request cat /proc/meminfo and press Enter. To allow awareness of Huge Page settings and others. | |
| May 24, 2021 at 14:27 | comment | added | Wilson Hauck | @peppy Thanks for the data posted. Analysis in process. The top report includes events_power_efficient detail - does this mean the OS is not running in Full Power mode? | |
| May 22, 2021 at 13:07 | answer | added | Tadeh Davtian | timeline score: 0 | |
| May 21, 2021 at 21:52 | comment | added | peppy | I apologize for the delay. Had to restart the server and wait a few days for data to be collected. I've added the requested pastebin links above, and the rest of the phpmyadmin data. | |
| May 21, 2021 at 21:51 | history | edited | peppy | CC BY-SA 4.0 |
added pastebins and updated current data
|
| May 18, 2021 at 14:50 | comment | added | Wilson Hauck | Additional information request - from your MySQL 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) STATUS; - NOT show status: F) complete MySQLTuner report AND Optional very 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 18, 2021 at 4:09 | history | edited | peppy | CC BY-SA 4.0 |
update - converted all MyISAM to Innodb
|
| May 18, 2021 at 2:09 | comment | added | peppy | The server uses SSD at Dreamhost's cloud compute. We do have a few MyISAM tables, mostly for fixed, read-only data type stuff that never updates, like our list of IP-geolocation table (4M rows), list of cities/countries, zip codes, various tiny tables, etc. Probably 90% of our tables are innodb. All of the big stuff is innodb. I should probably add that our largest table is a products table with 3.2 GB, followed by supplemental product info table with 2.8 GB - both innodb. | |
| May 18, 2021 at 1:05 | comment | added | matigo |
Memory consumption should go up over time. A database server that isn't using RAM is a database server that's either under-utilised or over-provisioned. There seem to be a lot of hard limits in your configuration. The low value of innodb_io_capacity has me wondering if your server has a spinning disk rather than SSD. The limits on the temporary tables and heaps may be unnecessary. There is also a lot of MyISAM settings in there. Are you still using any MyISAM tables?
|
|
| May 17, 2021 at 21:24 | history | asked | peppy | CC BY-SA 4.0 |