mysld cpu usage at 128%

[bradmoss]

My Zentyal Server (ver 3.0.32) is running very slowly. When I check the resource usage (using top) I am seeing the mysqld running the CPU Usage at 100% to a max of 128%.

The only temporary solution is to reboot the server which allows the server to run ok for an hour or so, but then it slows down again and the msqld is showing 100% - 128% usage.

I have done a lot of research into this and have made some changes to the keybuffer size (now 128)  but I am still unable to identify and fix the problem.

Does Anyone have any ideas as to what is causing this issue and what the solution is ??

Thank You


I have attached some statistics

[--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MRG_MYISAM
[--] Data in MyISAM tables: 725M (Tables: 66)
[--] Data in InnoDB tables: 32G (Tables: 26)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
[!!] Total fragmented tables: 36

[--] Up for: 1h 14m 26s (421K q [94.435 qps], 607 conn, TX: 621M, RX: 71M)
[--] Reads / Writes: 89% / 11%
[--] Total buffers: 304.0M global + 2.7M per thread (151 max threads)
[OK] Maximum possible memory usage: 709.8M (4% of installed RAM)
[OK] Slow queries: 0% (3/421K)
[OK] Highest usage of available connections: 21% (32/151)
[OK] Key buffer size / total MyISAM indexes: 128.0M/107.6M
[OK] Key buffer hit rate: 99.4% (635K cached / 3K reads)
[!!] Query cache efficiency: 14.8% (50K cached / 337K selects)
[!!] Query cache prunes per day: 1682130
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 453 sorts)
[!!] Joins performed without indexes: 65
[OK] Temporary tables created on disk: 6% (605 on disk / 10K total)
[OK] Thread cache hit rate: 94% (32 created / 607 connections)
[OK] Table cache hit rate: 29% (167 open / 575 opened)
[OK] Open file limit used: 17% (183/1K)
[OK] Table locks acquired immediately: 99% (354K immediate / 354K locks)