Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

This is my current setup:

[mysqld]
default-storage-engine=MyISAM
local-infile=0
symbolic-links=0
max_connections = 500
max_user_connections = 25
key_buffer = 64M
myisam_sort_buffer_size = 32M
join_buffer_size = 2M
read_buffer_size = 2M
sort_buffer_size = 2M
read_rnd_buffer_size = 2M
table_cache = 1024
thread_cache_size = 16K
wait_timeout = 20
connect_timeout = 10
tmp_table_size = 128M
max_heap_table_size = 128M
max_allowed_packet = 160M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 16M
query_cache_type = 1
low_priority_updates=1
concurrent_insert=ALWAYS

[mysqld_safe]
open_files_limit = 8192

[mysqldump]
max_allowed_packet = 16M

[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M

I've been noticing a lot more I/O lately and was wondering if there was something I could tune to increase performance?

I have an 8GB of RAM. Should I increase the values?

share|improve this question
Do you have something in the slow log? Or other idea about what's slower than usual? A query and its execution plan can help sometimes. – dezso Oct 30 '12 at 20:37
What would be a good value/time to use to track for bad queries? – Tiffany Walker Oct 30 '12 at 20:48
I depends. Did you notice any single process getting slower lately? – dezso Oct 30 '12 at 20:49
Just page load times. We had spikes of LA into 30's randomly today. High I/O and just not sure if this is a MySQL issue or not. – Tiffany Walker Oct 30 '12 at 20:56
I'd add that some settings seem to low for an 8GB machine (like, key_buffer = 64M). Check this blog for a start: Tuning MySQL Server Settings – ypercube Oct 31 '12 at 17:37

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.