From: Alex M. <alex@OWAL.co.uk> - 2002-09-16 14:07:29
|
Hi folks, I am trying to tune my MySQL database which is used for three slashcode 2.2.6 sites, and much more stuff and spotted this.... mysql> show processlist ; +------+-----------+------------------+------------+----------------+-------+-----------------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +------+-----------+------------------+------------+----------------+-------+-----------------+------------------+ | 20 | DELAYED | localhost | slashdb3 | Delayed_insert | 995 | Waiting on cond | accesslog | | 48 | DELAYED | localhost | slashdb2 | Delayed_insert | 438 | Waiting on cond | accesslog | | 1854 | going2 | localhost | slashdb1 | Sleep | 657 | | NULL | | 1856 | going2 | localhost | slashdb1 | Sleep | 294 | | NULL | the slashdb1 has several lines like this and it is the popular site. the other two slash sites are very lightly used. What I am confused about is this DELAYED stuff. Is it important? Should I worry? It isn't going away after a few minutes. Alex McLintock Openweb Analysts Ltd, London. Software For Complex Websites http://www.OWAL.co.uk/ Open Source Software Companies please register here http://www.OWAL.co.uk/oss_support/ |
From: Michael J. <mi...@fi...> - 2002-09-16 17:35:32
|
I think it says in the docs that it uses delayed inserts for some of the access log stuff. Read: "Database Schema description" link off the FAQ page on slashcode.org and the entry for "access_log" : access_log: logs page views to the site, logging occures on a delayed insert. I think this is probably what you are seeing. Then again, I could just be on crack.... -mj On Mon, 16 Sep 2002, Alex McLintock wrote: > Hi folks, > > I am trying to tune my MySQL database which is used for three slashcode > 2.2.6 sites, and much more stuff and spotted this.... > > > > > mysql> show processlist ; > +------+-----------+------------------+------------+----------------+-------+-----------------+------------------+ > | Id | User | Host | db | Command | > Time | State | Info | > +------+-----------+------------------+------------+----------------+-------+-----------------+------------------+ > | 20 | DELAYED | localhost | slashdb3 | Delayed_insert | 995 | > Waiting on cond | accesslog | > | 48 | DELAYED | localhost | slashdb2 | Delayed_insert | > 438 | Waiting on cond | accesslog | > | 1854 | going2 | localhost | slashdb1 | Sleep | > 657 | | NULL | > | 1856 | going2 | localhost | slashdb1 | Sleep | > 294 | | NULL | > > the slashdb1 has several lines like this and it is the popular site. the > other two slash sites are very lightly used. > > What I am confused about is this DELAYED stuff. > > Is it important? Should I worry? It isn't going away after a few minutes. > > > Alex McLintock > > > > > > > > Openweb Analysts Ltd, London. > Software For Complex Websites http://www.OWAL.co.uk/ > Open Source Software Companies please register here > http://www.OWAL.co.uk/oss_support/ > > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > Slashcode-general mailing list > Sla...@li... > https://lists.sourceforge.net/lists/listinfo/slashcode-general > |