OP
- Thread Starter
- #26
User23 said:You could run the ab test on a static html page. This will show how the apache perform without mysql.
As i said, i guess it is the wordpress statistic plugin. Keep an eye on the mysql slow queries log and useon the mysql console, while stress testing. If the statistics inserts are the bottleneck it should be easy to identify them in the processlist.Code:show full processlist;
Thanks
I had tried without the statistics plugin (it is called Wassup) and the result was the same.
Yet, when I run the same test it on a static webpage with a fairly large flash element, it rips though it so fast that I don't even see new threads opening in top.
Though it seems it is related to the database I can't immediatly tell much from the results of your query. I am looking into mgm_scheduling which makes a large part of the log:
show full processlist;
^click for results in pastebin.^
Is it worth looking into moving the database to MyISAM?