High i'm fed up, i don a lot of things to optimize my servers high load, but with no success...
Will the new version have other , faster and better queries, cause at night when i have a lot of visitors, my server goes mad , having high load of 12-17 !!!
Mysql config is this (my.cnf) :
Code:
[client]
port            = 3306
socket		  = /var/lib/mysql/mysql.sock

[mysqld_safe]
socket		  = /var/lib/mysql/mysql.sock
nice            = 0

[mysqld]
user            = mysql
socket		  = /var/lib/mysql/mysql.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
language        = /usr/share/mysql/english
skip-external-locking

key_buffer         = 16M
key_buffer_size         = 96M
sort_buffer_size        = 1M
read_buffer_size        = 3M
read_rnd_buffer_size    = 1M
max_allowed_packet      = 16M
thread_stack            = 128K
table_cache             = 1504
open_files_limit        = 3760
thread_cache_size       = 72
max_heap_table_size     = 256M
tmp_table_size          = 128M
query_cache_limit       = 3M
query_cache_size        = 256M
query_cache_type        = 1
low_priority_updates    = 1
join_buffer_size        = 3M
max_connections         = 300
long_query_time         = 3
log-slow-queries        = /var/log/slowq.log
skip-bdb

[mysqldump]
quick
quote-names
max_allowed_packet      = 16M

[mysql]
#no-auto-rehash # faster start of mysql but no tab completition

[isamchk]
key_buffer              = 16M