All pastes #941380 Raw Edit

Miscellany

public text v1 · immutable
·published 2008-03-13 17:36 UTC
rendered paste body
Edit /etc/my.cnf and change or add the following variables:
# Set long_query_time=5
# Decrease the max_connections variable - server is using 3.92% of current max.
# Increase the key_buffer_size. Current size is 7 MB.
# Set the query_cache_size. Good starting point is query_cache_size=32M
# Increase the join_buffer_size. Current size is 1 MB
# Increase tmp_table_size, Current size is 32 MB.
# Increase max_heap_table_size, Current size is 16777216.
# Consider using InnoDB for some tables as your table_locks are high.
# Set concurrent_insert=2
# Increase the innodb_thread_concurrency to 16, Current size is 8.
# Increase the innodb_commit_concurrency to 8, Current size is 0.
# Increase the innodb_buffer_pool_size if possible, Current size is 7 MB.
# Max memory limit exceeds 85% of total system memory.
# You need to decrease some buffers or allowed connections.
# Please see full report.