Timeline for MySQL large number of opened tables -- we're noticing performance hits
Current License: CC BY-SA 3.0
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 24, 2017 at 15:59 | comment | added | Wilson Hauck | @mave Would you expect any negative results if you limited SELECT ... to 1M rows? Do you ever expect this kind of row volume in delivering data to your users? Would you consider using in your my.cnf/ini sql_select_limit = 1M to avoid 'runaway' SELECT attempt? | |
| Nov 23, 2017 at 18:45 | answer | added | Wilson Hauck | timeline score: 0 | |
| Nov 15, 2017 at 0:09 | comment | added | Rick James | To be safer, set swappiness to 1. | |
| Nov 14, 2017 at 14:22 | history | edited | Mave | CC BY-SA 3.0 |
added 24 characters in body
|
| Nov 14, 2017 at 11:25 | history | edited | Mave | CC BY-SA 3.0 |
More information added as required
|
| Nov 13, 2017 at 18:04 | answer | added | Rick James | timeline score: 3 | |
| Nov 13, 2017 at 13:14 | history | edited | Lennart - Slava Ukraini | CC BY-SA 3.0 |
added 10 characters in body
|
| Nov 13, 2017 at 12:57 | answer | added | Ben Schmeltzer | timeline score: 0 | |
| Nov 13, 2017 at 12:14 | comment | added | Mave |
It is 3 servers, each containing up to 200 databases. Each database contains roughly 250 tables. The stats I posted are from 1 server, sql-01.
|
|
| Nov 13, 2017 at 11:49 | review | First posts | |||
| Nov 13, 2017 at 12:56 | |||||
| Nov 13, 2017 at 11:46 | history | asked | Mave | CC BY-SA 3.0 |