InnoDB buffer pool size

MySQL & MariaDB Percona Server for MySQL 8.0
1

In MySQL 8 temporary tables are now using innodb for disk based temp tables. Does this mean that all installs should have an innodb_buffer_pool_size set, even ones that use no innodb user tables (we use all tokudb tables)?

Likewise is there any benefit from having a key_buffer_size set for a db with no MyIsam tables?

1 Like
2

@theJugger,
MySQL 8 introduced the new data dictionary which itself is InnoDB. So there is always an InnoDB presence no matter what your application tables are using. The default buffer pool is 128MB which is fine for a minimized install, but if your PMM is reporting many temporary tables, then increasing this to 1GB might provide a benefit… temptable_max_ram defaults to 1GB, which is the total amount of memory all temporary tables can use before switching to disk-based tables.

However, what is more important is that you start migrating off TokuDB as it was announced over 6 months ago that this engine is deprecated and will be removed at some point in the future.

1 Like
3

Thanks a lot for the info. Any idea about the key_buffer_size?

1 Like
4

leave as default since you have no myisam tables. iirc, it’s 16mb.

1 Like
5

one of my mysqldb innoDB Buffer Usage is 100%.

how do we reduce it

1 Like
6

@virajtky,
InnoDB 100% is normal. Please open a new topic for new questions.

1 Like