update after 6 hours

[mrugesh shah]

hello,

As per your advice, I had made those changes and now after 6 hours, my VPS's system usage is 94%. Earlier it was taking only 4 hours to hit 100%. I think something positive has happen. But still not cured fully.



here is my.conf details :

[mysqld]
skip-bdb
skip-innodb
concurrent_insert = 1
connect_timeout = 10

delayed_insert_timeout = 30

join_buffer_size = 1M

interactive_timeout = 30

# memory=key_buffer+(sort_buffer_size+read_buffer_size)*max_connections
max_allowed_packet = 16M
max_connections = 150
max_connect_errors = 10
max_delayed_threads = 20
max_user_connections = 50
max_heap_table_size = 64M
max_tmp_tables = 128
myisam_sort_buffer_size = 64M

key_buffer = 16M
long_query_time=2
log_slow_queries=/var/lib/mysql/slowqueries.log
low_priority_updates = 1

query_cache_limit = 1M
query_cache_size = 16M
query_cache_type = 1

read_buffer_size = 1M
read_rnd_buffer_size = 1M

safe-show-database
skip-locking
socket = /var/lib/mysql/mysql.sock
sort_buffer_size = 1M

table_cache = 1000
thread_cache_size = 128
thread_concurrency = 2
tmp_table_size = 64M

wait_timeout = 20

[mysqld_safe]
log-error = /var/log/mysqld.log
nice = 10
open_files_limit = 8192

[mysqldump]
max_allowed_packet = 16M
quick

[mysql]
no-auto-rehash
safe-updates

[mysqlhotcopy]
interactive-timeout


If you want something, then please let me know. I am sure that I am near to solution now. Please help.