[imp] mysql tuning

[Cristobal Sabroe Yde]

   Hi, my mysql database is eating all my cpu time. Does anybody have  
tuning sugestions? I have about 120 online users in a werver with 2 GB  
RAM.

   horde 3.1.3
IMP H3 (4.1.3)

   SuSE Linux + apache 1.3

   Thanks.

   This is my 'my.cnf' file:

# The MySQL server
[mysqld]
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
myisam_sort_buffer_size = 8M
skip-networking

   [mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

-- 
Cris.

.............................................................
Este mensaje ha sido enviado usando el servicio de webmail
de la Universidad Nacional de Rio Cuarto.