From: Rick James
Date: May 31 2012 6:46pm
Subject: RE: Mysql starts to die at 27 SQL processes
List-Archive: http://lists.mysql.com/mysql/227573
Message-Id: <2E7DD7ADE53B044C8C8BCD9C5829E1EB148724F1CC@SP2-EX07VS01.ds.corp.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Find the queries that are not Locked.  One of them is being naughty.  Perha=
ps 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 PROCE=
SSLIST).

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 I=
nnoDB?

Probably some user has a zillion documents, and WP was not adequately desig=
ned for that kind of scaling.

Another question -- how many WP users do you have?  If I am not mistaken, W=
P creates about a dozen tables for each user.  Since MyISAM uses 3 files pe=
r table, a thousand users would bring the Operating System to its knees!  T=
o 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:jerome.m@stripped]
> Sent: Thursday, May 31, 2012 11:17 AM
> To: Baron Schwartz
> Cc: MySql
> Subject: Re: Mysql starts to die at 27 SQL processes
>=20
> Thank Baron,
>=20
>    i want to see if there is something i can do from the DB end.
>=20
>   and BTW, i've been using the plugin already.....
>=20
>=20
> On Thu, May 31, 2012 at 1:01 PM, Baron Schwartz <baron@stripped>
> 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
> >
>=20
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql