hi,
What are the best practises for MySql configuration ? Is there any config files on itop to optimize MySql.
Actually, We have poor performances on the MySql itop database ( More than 1Go for attachment table)
release : redhat
Hi BenR,
Optimizing an SQL database is a job of its own, it depends ona lot of things... however, as a general rule, the more memory is available to MySQl, the better.
Did you read the wiki? There are two basic hints to try first: https://wiki.openitop.org/doku.php?id=2_0_2:admin:performance#check_mysql_s_key_cache
Log in to post a comment.
hi,
What are the best practises for MySql configuration ? Is there any config files on itop to optimize MySql.
Actually, We have poor performances on the MySql itop database ( More than 1Go for attachment table)
release : redhat
Hi BenR,
Optimizing an SQL database is a job of its own, it depends ona lot of things... however, as a general rule, the more memory is available to MySQl, the better.
Did you read the wiki? There are two basic hints to try first:
https://wiki.openitop.org/doku.php?id=2_0_2:admin:performance#check_mysql_s_key_cache