troubleshooting Question

tune innodb mysql

Avatar of XK8ER
XK8ERFlag for United States of America asked on
LinuxMySQL Server
28 Comments3 Solutions2107 ViewsLast Modified:
hello there,
ever since I upgraded the server into centos v5.7 and 24GB of ram the server load dropped from 5.00 into about 0.68
I am still trying to lower it and the reason for the high load is because of mysql. what recommendations would you give me?
-- 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
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 3 Answers and 28 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 28 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros