https://answers.axonivy.com/questions/3654/huge-mysql-mariadb-system-database-has-slow-response-time<p>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?</p>enMon, 04 Feb 2019 10:47:42 -0500https://answers.axonivy.com/questions/3654/huge-mysql-mariadb-system-database-has-slow-response-time/3655<p>For huge mysql / mariadb installation I recommend to set the option <code>innodb-buffer-pool-size</code> e.g. to 8 gigabyte.</p> <pre><code>[mysqld] innodb-buffer-pool-size=8G </code></pre> <p>With the mysql 8.0.x version you can also enforce with <code>internal-tmp-mem-storage-engine</code> to not write temporary tables to disk:</p> <pre><code>[mysqld] innodb-buffer-pool-size=8G internal-tmp-mem-storage-engine=MEMORY </code></pre>Alex SuterMon, 04 Feb 2019 10:47:42 -0500https://answers.axonivy.com/questions/3654/huge-mysql-mariadb-system-database-has-slow-response-time/3655