Timeline for MySQL tuning: INNODB_BUFFER_POOL_SIZE not found?
Current License: CC BY-SA 4.0
2 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 23, 2018 at 18:20 | comment | added | Wilson Hauck | @ColinMac How much RAM is on the replication server? Suggestion to consider for my.cnf [mysqld] section innodb_lru_scan_depth=128 # from 1024 to conserve CPU every second and max_connections=reasonable limit # from 3000 to conserve RAM. SHOW GLOBAL STATUS LIKE 'max_used_connections' to get an idea of a more reasonable number. Please view my profile, Network Profile for contact info and to get FREE My Top 10 Global Variable Suggestions for your specific server. | |
| Jul 22, 2018 at 4:28 | history | answered | Lennart - Slava Ukraini | CC BY-SA 4.0 |