search

shatteredsilicon / ssm-submodules

GNU Affero General Public License v3.0
1 stars 2 forks source link

Tuning Advisor: innodb_buffer_pool_size #261

Closed gordan-bobic closed 2 months ago

gordan-bobic commented 3 months ago

First pass approximation for this is:

SELECT SUM(INDEX_LENGTH)
FROM   information_schema.TABLES
WHERE  ENGINE='InnoDB';

rounded up to nearest GiB.

Add a warning highlighted in red if that would exceed 75% of system RAM, and instead suggest 75% of system RAM. List in G rather than raw number.

oblitorum commented 2 months ago

I reckon we should also make sure the suggest value is *equal to or a multiple of innodb_buffer_pool_chunk_size innodb_buffer_pool_instances*, so we should "rounded it up to nearest GiB that is equal to or a multiple of innodb_buffer_pool_chunk_size innodb_buffer_pool_instances" ?

gordan-bobic commented 2 months ago

chunk * instances is a good call. But those won't necessarily round to a GB. So I guess we should round up or down to the nearest multiple of those and show it in biggest round unit, be it K, M, G or T.