Mysql makes high load !!! Please help

[Alexxi]

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) :

[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

[ronymelson]

I agree with the the problem occur during fire of query related to sql in the coding.Part of your high load problem is going to be due to the fact that vShare logs every connection that you get to mySQL. If you have a high traffic site, this can cause mySQL to have to right thousands, if not millions, of entries into the database.I hope this information work well in this type of scenario.