Re: Bayes innodb problems

2007-09-29 Thread Nigel Frankcom
On Sat, 29 Sep 2007 03:24:17 +0200, Alex Woick <[EMAIL PROTECTED]> wrote: processing has ground down to really slow. I'm seeing some incredibly long queries now in my slow-query log, such as: >>> Try an "optimize table " for each of the sa >>> tables. You just filled the database f

Re: Bayes innodb problems

2007-09-28 Thread Alex Woick
processing has ground down to really slow. I'm seeing some incredibly long queries now in my slow-query log, such as: Try an "optimize table " for each of the sa tables. You just filled the database from scratch, so perhaps the counters/statistics do not reflect the actual value distribution yet

Re: Bayes innodb problems

2007-09-28 Thread Jari Fredriksson
> On Fri, 28 Sep 2007 at 21:57 +0300, [EMAIL PROTECTED] > confabulated: > >> >> Optimize table does not work with InnoDB. > > Are you sure? An excerpt from the MySQL 5.0 documentation > found here: > May be old information what I told. I tried and no errors from optimize table with InnoDB t

Re: Bayes innodb problems

2007-09-28 Thread Duane Hill
On Fri, 28 Sep 2007 at 21:57 +0300, [EMAIL PROTECTED] confabulated: Micah Anderson schrieb am 27.09.2007 02:20: processing has ground down to really slow. I'm seeing some incredibly long queries now in my slow-query log, such as: Try an "optimize table " for each of the sa tables. You just f

Re: Bayes innodb problems

2007-09-28 Thread Jari Fredriksson
> Micah Anderson schrieb am 27.09.2007 02:20: > >> processing has ground down to really slow. I'm seeing >> some incredibly long queries now in my slow-query log, >> such as: > > Try an "optimize table " for each of the sa > tables. You just filled the database from scratch, so > perhaps the cou

Re: Bayes innodb problems

2007-09-28 Thread Alex Woick
processing has ground down to really slow. I'm seeing some incredibly long queries now in my slow-query log, such as: Try an "optimize table " for each of the sa tables. You just filled the database from scratch, so perhaps the counters/statistics do not reflect the actual value distribution y

Re: Bayes innodb problems

2007-09-28 Thread Micah Anderson
* Alex Woick <[EMAIL PROTECTED]> [070927 02:14]: > Micah Anderson schrieb am 27.09.2007 02:20: > >> processing has ground down to really slow. I'm seeing some incredibly >> long queries now in my slow-query log, such as: > > Try an "optimize table " for each of the sa tables. You just > filled the

Re: Bayes innodb problems

2007-09-28 Thread micah
* Michael Parker <[EMAIL PROTECTED]> [070926 21:14]: > micah wrote: > > On Wed, 26 Sep 2007 17:54:05 -0700, John D. Hardin wrote: > > > >> On Wed, 26 Sep 2007, Micah Anderson wrote: > >> > >>> SELECT count(*) > >>>FROM bayes_token > >>> WHERE id = '4' > >>>

Re: Bayes innodb problems

2007-09-27 Thread John D. Hardin
On Thu, 27 Sep 2007, Henrik Krohns wrote: > mysql> SELECT count(*) FROM bayes_token WHERE id = '1' AND (1190870335 - > atime) > 345600; > +--+ > | count(*) | > +--+ > | 1710591 | > +--+ > 1 row in set (5.69 sec) > > mysql> SELECT count(*) FROM bayes_token WHERE id = '1'

Re: Bayes innodb problems

2007-09-27 Thread Alex Woick
Micah Anderson schrieb am 27.09.2007 02:20: processing has ground down to really slow. I'm seeing some incredibly long queries now in my slow-query log, such as: Try an "optimize table " for each of the sa tables. You just filled the database from scratch, so perhaps the counters/statistics d

Re: Bayes innodb problems

2007-09-27 Thread Mark Martinec
> > >> >> SELECT count(*) > > >> >>FROM bayes_token > > >> >> WHERE id = '4' > > >> >> AND ('1190846660' - atime) > '345600'; > > >> > Who the hell wrote *that* query? Is MySQL smart enough to rearrange > > >> > that equation to give an indexable compar

Re: Bayes innodb problems

2007-09-26 Thread micah
On Thu, 27 Sep 2007 08:22:31 +0300, Henrik Krohns wrote: > On Thu, Sep 27, 2007 at 05:11:09AM +, micah wrote: >> On Thu, 27 Sep 2007 07:48:02 +0300, Henrik Krohns wrote: >> >> > On Thu, Sep 27, 2007 at 03:27:51AM +, micah wrote: >> >> On Wed, 26 Sep 2007 17:54:05 -0700, John D. Hardin wro

Re: Bayes innodb problems

2007-09-26 Thread micah
On Thu, 27 Sep 2007 05:11:09 +, micah wrote: > On Thu, 27 Sep 2007 07:48:02 +0300, Henrik Krohns wrote: > >> On Thu, Sep 27, 2007 at 03:27:51AM +, micah wrote: >>> On Wed, 26 Sep 2007 17:54:05 -0700, John D. Hardin wrote: >>> >>> > On Wed, 26 Sep 2007, Micah Anderson wrote: >>> > >>> >>

Re: Bayes innodb problems

2007-09-26 Thread micah
On Thu, 27 Sep 2007 07:48:02 +0300, Henrik Krohns wrote: > On Thu, Sep 27, 2007 at 03:27:51AM +, micah wrote: >> On Wed, 26 Sep 2007 17:54:05 -0700, John D. Hardin wrote: >> >> > On Wed, 26 Sep 2007, Micah Anderson wrote: >> > >> >> SELECT count(*) >> >>FROM bayes_token >> >>

Re: Bayes innodb problems

2007-09-26 Thread Michael Parker
micah wrote: > On Wed, 26 Sep 2007 17:54:05 -0700, John D. Hardin wrote: > >> On Wed, 26 Sep 2007, Micah Anderson wrote: >> >>> SELECT count(*) >>>FROM bayes_token >>> WHERE id = '4' >>> AND ('1190846660' - atime) > '345600'; >> Who the hell wrote *tha

Re: Bayes innodb problems

2007-09-26 Thread micah
On Wed, 26 Sep 2007 17:54:05 -0700, John D. Hardin wrote: > On Wed, 26 Sep 2007, Micah Anderson wrote: > >> SELECT count(*) >>FROM bayes_token >> WHERE id = '4' >> AND ('1190846660' - atime) > '345600'; > > Who the hell wrote *that* query? Is MySQL s

Re: Bayes innodb problems

2007-09-26 Thread John D. Hardin
On Wed, 26 Sep 2007, Micah Anderson wrote: > SELECT count(*) >FROM bayes_token > WHERE id = '4' > AND ('1190846660' - atime) > '345600'; Who the hell wrote *that* query? Is MySQL smart enough to rearrange that equation to give an indexable comparison

Bayes innodb problems

2007-09-26 Thread Micah Anderson
I was having problems with scalability with my bayes DB, so I read up on the mailing list and found that it was recommended to switch to the innodb storage engine because of the row-level locking (versus the table-level locking that comes with MyISAM). Sounds great. So I switched, and everything w