Dan: Thanks for the suggest. I will check it out. The strange thing is that as I mentioned, the PHP code that I am using is straightforward, and I have never had any problems with the database not disconnecting properly with PHP, but that being said, the possibility that it is a db connector problem I guess would be OS specific rather than PHP or MYSQL specific necessarily?
We will try upgrading PHP to 4.3.4 to see if that helps, and it may be also that a MYSQL 4 upgrade is also on the way. Talking to the host provider, they did mention that the 3 disk array is served only by 1 controller, and they will be adding more, perhaps the bottleneck is in the disk writes, but I cannot see that being a big issue on the relativly low traffic (only around 2GB/month web traffic...) Any other ideas? On 1/6/04 2:29 PM, "Dan Greene" <[EMAIL PROTECTED]> wrote: > 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] >> >> -- 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]
