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 at 10:43

SupportIvyTeam's gravatar image

SupportIvyTeam ♦♦
1.2k74102109
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 at 10:47

Alex%20Suter's gravatar image

Alex Suter ♦♦
2.1k91936
accept rate: 84%

Your answer
toggle preview

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:

×12
×6
×1
×1

Asked: 04.02 at 10:43

Seen: 164 times

Last updated: 04.02 at 10:47