MySQL with 250 queries per second optimization

Hello,
I got Dual Xeon 2.8 with 2 GB RAM, about ~200 account and such big MySQL usage:


root@slicznypiekny [/var/log]# mysqladmin status
Uptime: 1702 Threads: 16 Questions: 423997 Slow queries: 1 Opens: 7717 Flush tables: 1 Open tables: 2047 Queries per second avg: 249.117

load is about 3 most time but I would like to optimize it.. Any sugestions except of killing users accounts? ;-)

Code: 
root@slicznypiekny [/var/log]# cat /etc/my.cnf
[mysqld]
set-variable = max_connections=500
safe-show-database
skip-locking
character-sets-dir = /usr/share/mysql/charsets/
default-character-set = latin2
key_buffer = 44M
sort_buffer_size = 6M
record_buffer = 8M
table_cache = 2048
thread_cache_size = 286
connect_timeout = 15
wait_timeout = 15
max_allowed_packet = 10M
query_cache_limit = 8M
query_cache_size = 32M
query_cache_type = 1

 

 

 

 

Top