Re: database slow down

2001-11-19 Thread Heikki Tuuri
.724891 secs (0 rows/sec) > > >... > >Raw contains no more rows than before and pagehits_hr contains at most 20K >rows. > >Any ideas would be really welcome. Maybe I should change the delete from to >a drop and create. > >Rich > > >- Original M

Re: database slow down

2001-11-19 Thread Richard Clarke
<[EMAIL PROTECTED]> Sent: Monday, November 19, 2001 8:10 AM Subject: Re: database slow down > Hi! > > >This is a followup to my previous messages indicating database slow down. > >After noticing the queries start to slow down earlier i decided to try and > >get som

Re: database slow down

2001-11-19 Thread Heikki Tuuri
Hi! >This is a followup to my previous messages indicating database slow down. >After noticing the queries start to slow down earlier i decided to try and >get some debug info. a show table status had one interesting thing. > >| raw| InnoDB | Fixed | 169681 |

database slow down

2001-11-18 Thread Richard Clarke
This is a followup to my previous messages indicating database slow down. After noticing the queries start to slow down earlier i decided to try and get some debug info. a show table status had one interesting thing. | raw| InnoDB | Fixed | 169681 | 1030 | 174817280