Again Mysql
i have a server with a server load always around 10, do u think that it can be the mysql? i see 91 slow query, i have disable also Keepalive and below my.cnf
MySQL on localhost (4.0.22-standard) up 2+01:58:53 [18:10:55]
Queries: 7.6M qps: 45 Slow: 91.0 Se/In/Up/De(%): 70/08/06/01
qps now: 33 Slow qps: 0.0 Threads: 4 ( 1/ 32) 52/03/02/03
Key Efficiency: 99.7% Bps in/out: 5.7k/22.3k Now in/out: 2.9k/187.6k
Id User Host/IP DB Time Cmd Query or State
-- ---- ------- -- ---- --- ----------
328022 root localhost test 0 Query show full processlist
[mysqld]
max_connections=300
interactive_timeout=10
wait_timeout=10
connect_timeout=10
thread_cache_size=256
key_buffer=128M
max_allowed_packet=15M
table_cache=1024
sort_buffer=2M
record_buffer=1M
join_buffer=1M
thread_cache=1028
thread_concurrency=2
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
