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?

asked 04.02.2019 at 10:43

SupportIvyTeam's gravatar image

SupportIvyTeam ♦♦
1.4k102118122
accept rate: 77%


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%20Suter's gravatar image

Alex Suter ♦♦
3.1k122247
accept rate: 84%

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×14
×10
×1
×1

Asked: 04.02.2019 at 10:43

Seen: 2,079 times

Last updated: 04.02.2019 at 10:47