Zabbix And Mysql Server

[maruscya]

Hello Guys..

After some tests... i buy a new server for Zabbix. I buy Hp DL140 with 5Gb of Ram and quadcore cpu. I hope that server can manage 50 servers.

IMHO, i can increase performance if Mysql is correctly setup. This is my questions

Which is the best configuration for mysql server? Do you have some suggestion abou t mysql configuration file ?

Thanks !

AndreA

[bbrendon]

Search the forums then let us know what you think

[maruscya]

Search the forums then let us know what you think


Many thanks. I found some tricks on forum !http://www.zabbix.com/forum/showthread.php?t=4435

[mikecrowe]

Suggestion: http://forge.mysql.com/projects/view.php?id=44

[maruscya]

Suggestion: http://forge.mysql.com/projects/view.php?id=44

I' m using tuning-primer.sh :) and it works realy fine.

Now i'm searching tuning about mysql ... for zabbix only :)

After some tests, mysql can increase performance of zabbix server if setup is correctly.... i need found the best configuration for mysql in zabbix enviroment.

Thanks for you replay...

And... i'm sorry about not realy good english .. :)