Huge MySQL/MariaDB System Database has slow response time

Question

I've got so far some ivy engines running with mysql and mariadb as system database. The databases are huge, with about 10'000'000 tasks. With more and more tasks the responding time will be slower. The more tasks in the database, the worse the response times. Is there anything I can do to optimize this?

Accepted Answer

0

For huge mysql / mariadb installation I recommend to set the option innodb-buffer-pool-size e.g. to 8 gigabyte.

[mysqld]
innodb-buffer-pool-size=8G

With the mysql 8.0.x version you can also enforce with internal-tmp-mem-storage-engine to not write temporary tables to disk:

[mysqld]
innodb-buffer-pool-size=8G 
internal-tmp-mem-storage-engine=MEMORY

link

answered 04.02.2019 at 10:47

Alex Suter ♦♦
3.1k●12●22●47
accept rate: 84%

Huge MySQL/MariaDB System Database has slow response time

Follow this question

Related questions