Is it possible that some portions of your code do not disconnect thier db connections when they are done? I've seen issues like this with platforms that do not use db pool managers to ensure release of db connections when they are idle for a while. Particularly if there are error scenerios where the normal connection closure may be skipped...
My $0.02... Dan Greene > -----Original Message----- > From: Mike Morton [mailto:[EMAIL PROTECTED] > Sent: Tuesday, January 06, 2004 2:15 PM > To: [EMAIL PROTECTED] > Subject: Sleeping Processes > > > I have a mysql database that is running in conjunction with a > PHP website, > and I am experiencing some significant slowdowns in times of moderate > traffic. > > Now, by moderate, I mean moderate for them, but fairly light > traffic in > terms of actual visitors. > > The library the is causing the slowdowns simple updates a > 'last_active' > variable in a sessions table in mysql which normally has no affect on > loading speed at all, but what I am noticing during this high traffic > period, is anywhere from 50 - 60 processes that are 'sleeping' in the > database when I do a show processlist. E.g. > +--------+--------+-----------+--------+---------+------+----- > ---------+---- > -------------------------------------------------------------- > --------+ > | Id | User | Host | db | Command | Time | > State | > Info > | > +--------+--------+-----------+--------+---------+------+----- > ---------+---- > -------------------------------------------------------------- > --------+ > | 680849 | tienda | localhost | tienda | Sleep | 22 | > | > NULL > | > | 680859 | tienda | localhost | tienda | Sleep | 154 | > | > NULL > | > | 680878 | tienda | localhost | tienda | Sleep | 101 | > | > NULL > | > | 680942 | tienda | localhost | tienda | Sleep | 96 | > | > NULL > | > > > But upwards of as I said, 50 - 60 of them at any given time. > > I do not have a slow day comparison to offer, but I have done > many a sight > and never seen sleeping processes like this. > > The question is, could these be affecting the slowness of the > database, as I > have determined that it is the database that is slowing down the site. > > The largest table holds only 42K rows, and the most accessed table is > indexed with the most accessed fields and holds only 16K > rows, so there > should be no problem there. > > The max connections is set to 300, and the version is 3.23.47 > > The PHP version is 4.2.3 and I am NOT using mysql_pconnect but rather > mysql_connect: > [EMAIL PROTECTED]("localhost","<blocked>","<blocked>"); > @mysql_select_db("tienda"); > > Because it is a shared box, I do not have access to make a > lot of changes, > but the company is very co-operative and I am sure would be > helpful for > making small setting changes, as long as we are not talking > major version > updates, as they do have other clients using the server. > > I cannot think of anything else that I can pass on, if anyone has any > suggestions or ideas I would appreciate it as I am plumb out > of them! :) > > TIA > > -- > Cheers > > Mike Morton > > **************************************************** > * > * Tel: 905-465-1263 > * Email: [EMAIL PROTECTED] > * > **************************************************** > > "Indeed, it would not be an exaggeration to describe the > history of the > computer industry for the past decade as a massive effort to > keep up with > Apple." > - Byte Magazine > > Given infinite time, 100 monkeys could type out the complete works of > Shakespeare. Win 98 source code? Eight monkeys, five minutes. > -- NullGrey > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
