Mysql/InnoDB server optimization

[themons]

I need to optimize the mysql server on my zabbix server.
This is our mysql configuration file

[mysqld]
datadir=/folder/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
     
[mysql.server]
user=mysql
basedir=/folder

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Yes, its very simple

I want to know what is the most importants paramters to add/change.
I want to increase our zabbix server performances.

Thx.

[pdwalker]

See here: http://dev.mysql.com/doc/refman/4.1/...he-server.html

A google search of "optimize mysql" should also turn up a lot of interesting results.

- Paul

[themons]

See here: http://dev.mysql.com/doc/refman/4.1/...he-server.html

A google search of "optimize mysql" should also turn up a lot of interesting results.

- Paul

I seach fo the most imortant parameters, I've just finish to red this part of the mysql documentation...

I think some a value have significate effect with zabbix

thx

[phork]

I've found mysql performs much better for me with the InnoDB engine as opposed to the default MyISAM. Basic innodb tuning guides are a dime a dozen.