By kalashari on
I set up new vps for my site.... I put lighttpd, php4, mysql 5.0.32, eAccelerator v0.9.5.... However, I am getting slow Mysql queries.... I don't know why is it... When I run devel module, I see the majority of mysql queries are red colored, meaning, they take more than 5md to load.... I think that I had faster queries on shared hosting.
I turned throttle mod, turned off some unimportant modules, tweaked my.cnf a little bit, but couldn't change the situation about the speed of mysql.... and I cannot make my pages load belod 1 sec.... THey all take approx 1-2-3 sec. to load.
This VPS is with 256 RAM. Here's some of my my.cnf settings:
[mysqld]
myisam_sort_buffer_size = 32M
interactive_timeout = 25
wait_timeout = 1000
connect_timeout = 10
max_allowed_packet = 16M
max_connect_errors = 10
skip-innodb
[myisamchk]
key_buffer = 16M
sort_buffer = 16M
read_buffer = 16M
write_buffer = 16M
query_cache_limit=1M
query_cache_size=16M
query_cache_type=1
key_buffer_size = 32M
max_allowed_packet = 16M
thread_stack = 128K
thread_cache_size = 8
max_connections = 150
max_user_connections = 250
myisam_sort_buffer_size = 16M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1024
thread_cache_size = 16
tmp_table_size = 16M
Any thoughts?
k.
