Find the queries that are not Locked. One of them is being naughty. Perhaps it is this one:
| 20770707 | datadb | server1.domain.com:62606 | datadb | Query | 36 | removing tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. | However, it is truncated, so it is hard to analyze fully. (SHOW FULL PROCESSLIST). Also need to see SHOW TABLE STATUS and SHOW CREATE TABLE for all the tables in the naughty query. Are the tables MyISAM? How much RAM do you have? Can WP be converted to InnoDB? Probably some user has a zillion documents, and WP was not adequately designed for that kind of scaling. Another question -- how many WP users do you have? If I am not mistaken, WP creates about a dozen tables for each user. Since MyISAM uses 3 files per table, a thousand users would bring the Operating System to its knees! To see how bad it is, go to the WP directory and do time ls -l | wc (if you are on unix) > -----Original Message----- > From: J M [mailto:jerom...@gmail.com] > Sent: Thursday, May 31, 2012 11:17 AM > To: Baron Schwartz > Cc: MySql > Subject: Re: Mysql starts to die at 27 SQL processes > > Thank Baron, > > i want to see if there is something i can do from the DB end. > > and BTW, i've been using the plugin already..... > > > On Thu, May 31, 2012 at 1:01 PM, Baron Schwartz <ba...@xaprb.com> > wrote: > > In this case the solution is much easier outside of MySQL than > inside. > > http://ocaoimh.ie/wp-super-cache/ is an excellent option. > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql To unsubscribe: > > http://lists.mysql.com/mysql > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
