New answers tagged optimization
I have never experienced issue such as long load times like that, however one thing I have noticed that tend to speed up my Wordpress load times is to use WP Super Cache. It caches the pages as plain HTML pages for most users, that way your server doesn't need to recompile the page every time. As others have said, it could be poor server performance on ...
I'm afraid your experience is clearly insufficient to deal with such issues. You probably should hire someone to either supervise the server for you, or at least get it straight now (and get rid of cPanel). He might even tell you it is not a server issue, but rather WordPress thing. You should start with looking at the load itself (CPU, memory, I/O, etc., ...
To me it looks like that the plugin does simply so heavy processing for every request that the requests take such a long time. You should ask the plugin provider if they can explain the slowdown in any way.
You should analyze your most frequent queries with EXPLAIN command. The output will tell you how your queries use table indices, which directly affects the performance.
What happens: you have try to put an elefant into the hamster's ball. What to do: decrease the memory footprint for mysql . . . . . . . . . . [mysqld] user = mysqluser pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock log_error = /var/log/mysql/error.log ...
If you are able to play around with settings a little, I would try this in my.cnf: innodb_buffer_pool_size = 3000M then restart mysql and check your performance. This would allow you to keep much more of your database in memory, reducing the disk/memory thrashing that you may be seeing. Given that you have 4Gb memory, and assuming this server is ONLY a ...
I suspect that you have several issues here that are stacking up and causing problems. Disk i/o is fragmented, and probably inefficient. OPTIMIZE TABLE on each of your tables should sort that out and help a bit. Memory is tuned horribly, likely causing issues with having to swap frequently. Slow queries - this is the big suspect for your high CPU usage. ...
Some other tools: mod_status for Apache (http://httpd.apache.org/docs/2.2/mod/mod_status.html) strace (if you can identify a process which is hanging / running slowly), xdebug profiling (if it's a PHP script) - see http://www.xdebug.org/docs/profiler mytop (or run watch -n 1 "mysql -e 'show processlist'")
Top 50 recent answers are included