Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention. Check out this how-to article for more information.
-- MYSQL PERFORMANCE TUNING PRIMER -- - By: Matthew Montgomery - MySQL Version 5.5.16-log x86_64 Uptime = 2 days 6 hrs 5 min 55 sec Avg. qps = 67 Total Questions = 13113961 Threads Connected = 3 INNODB STATUS Current InnoDB index space = 1.59 G Current InnoDB data space = 15.95 G Current InnoDB buffer pool free = 1 % Current innodb_buffer_pool_size = 16.00 G Depending on how much space your innodb indexes take up it may be safe to increase this value to up to 2 / 3 of total system memory MEMORY USAGE Max Memory Ever Allocated : 17.59 G Configured Max Per-thread Buffers : 6.87 G Configured Max Global Buffers : 16.11 G Configured Max Memory Limit : 22.98 G Physical Memory : 23.52 G Max memory limit exceeds 90% of physical memory KEY BUFFER No key reads?! Seriously look into using some indexes
Join the community of 500,000 technology professionals and ask your questions.