Timeline for What would cause a MySQL database to suddenly get slow with relatively simple queries?
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 2, 2021 at 12:08 | comment | added | Rohan | Thanks Rick. The innodb_buffer_pool_size seemed to be it — my tables were around 100-200mb in size, and my innodb_buffer_pool_size flag was set to 256mb. I increased this flag to 1.5gb, and there is a clear performance improvement. Thank you. | |
| Nov 2, 2021 at 12:05 | vote | accept | Rohan | ||
| Oct 23, 2021 at 13:01 | history | migrated | from stackoverflow.com (revisions) | ||
| Oct 22, 2021 at 23:18 | history | answered | Rick James | CC BY-SA 4.0 |