Timeline for Is query efficiency affected by data not relevant to the query?
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 31, 2017 at 16:17 | vote | accept | Mattiavelli | ||
| May 31, 2017 at 15:18 | comment | added | Rick James | YES - the caching of the buffer_pool is very important to InnoDB performance. By using fewer blocks in one query, you are less likely to be bumping out blocks that someone else may need soon. For a mysql-only server with 64GB, 50G might be a good size for the buffer_pool. (There is no need for it to be much bigger than the total of all tables and indexes.) | |
| May 31, 2017 at 14:56 | comment | added | Mattiavelli |
Thanks for the information @rick. If we hit this scale we'd be running on a 64gb instance so the innodb_buffer_pool_size could be increased to 32gb+. Can you clarify what you mean by : That is, the caching in the buffer_pool may be useful? Do you mean that the buffer_pool could be less (since less blocks are used) or something else ?
|
|
| May 31, 2017 at 5:30 | history | answered | Rick James | CC BY-SA 3.0 |