Title: Extremely High CPU Usage Last modified: August 19, 2016 --- # Extremely High CPU Usage * [onmillertime](https://wordpress.org/support/users/onmillertime/) * (@onmillertime) * [16 years, 2 months ago](https://wordpress.org/support/topic/extremely-high-cpu-usage/) * I converted my site from B2Evolution to 2.9.2 about a week ago. We have been experiencing REALLY high CPU usage usually 80-100% on a dedicated server I own. I was running out of memory but limiting apache to 32 connections stopped it. Something is really wrong and I have no idea what to do to fix it. I installed WP Optimize and WP Super Cache it helped a little but not much. * I get traffic but not enough to cause this, I normally get about 20,000 hits a day. I customized a Elegeant Simplistic template. So that could possibly be part of the issue as well. * Here’s the plugins I have installed… Simple Press Forum Contact Form 7 Exec PHP Register Plus Side Bar Login Webby Chat WP Super Cache WP Optimize * Here’s the server stats… Core 2 Duo w/4gb ram Running Apache on Linux Centos 5.4 64 bit * TOP 27448 apache 15 0 405m 124m 18m S 75.6 3.3 0:09.11 httpd 27444 apache 16 0 401m 120m 18m R 0.7 3.2 0:05.60 httpd 27368 apache 15 0 402m 123m 19m S 0.3 3.2 0:21.85 httpd 27374 apache 15 0 401m 126m 23m S 0.3 3.3 0:27.89 httpd 27449 apache 15 0 401m 125m 23m S 0.3 3.3 0:05.78 httpd 27509 apache 15 0 401m 118m 15m S 0.3 3.1 0:09.45 httpd * Also here’s the Mysql tuner script results…. Joins performed without indexes: 838 [!!] Temporary tables created on disk: 48% (1M on disk / 3M total) [OK] Thread cache hit rate: 94% (2K created / 46K connections) [!!] Table cache hit rate: 14% (533 open / 3K opened) [OK] Open file limit used: 30% (793/2K) [OK] Table locks acquired immediately: 99% (6M immediate / 6M locks) [!!] Connections aborted: 15% * ——– Recommendations —————————————————– General recommendations: Adjust your join queries to always utilize indexes When making adjustments, make tmp_table_size/ max_heap_table_size equal Reduce your SELECT DISTINCT queries without LIMIT clauses Increase table_cache gradually to avoid file descriptor limits Your applications are not closing MySQL connections properly Variables to adjust: join_buffer_size( > 768.0K, or always use indexes with joins) tmp_table_size (> 192M) max_heap_table_size( > 192M) table_cache (> 1024) * My site is [http://www.swaggrabber.com](http://www.swaggrabber.com). I would GREATLY appreciate someone giving me some ideas of where to start. We are stumped and have tried everything we can think of! Viewing 2 replies - 1 through 2 (of 2 total) * [Jonas Grumby](https://wordpress.org/support/users/ss_minnow/) * (@ss_minnow) * [16 years, 2 months ago](https://wordpress.org/support/topic/extremely-high-cpu-usage/#post-1442414) * How big is the database? * Thread Starter [onmillertime](https://wordpress.org/support/users/onmillertime/) * (@onmillertime) * [16 years, 2 months ago](https://wordpress.org/support/topic/extremely-high-cpu-usage/#post-1442648) * Maybe a few gigs, not that big. The bulk of it is the 4600+ posts that were converted. Viewing 2 replies - 1 through 2 (of 2 total) The topic ‘Extremely High CPU Usage’ is closed to new replies. * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) * 2 replies * 2 participants * Last reply from: [onmillertime](https://wordpress.org/support/users/onmillertime/) * Last activity: [16 years, 2 months ago](https://wordpress.org/support/topic/extremely-high-cpu-usage/#post-1442648) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics