Re: InnoDB slow?

2003-09-02 Thread Paul Gallier
MyISAM, however, performance should now be much better when people are accessing the web site while data is being written to the database (which is fairly constant). My thanks to everything that helped! Paul Heikki Tuuri wrote: Hi! - Original Message - From: "Paul Ga

Re: InnoDB slow?

2003-09-02 Thread Paul Gallier
ave been problems with them on many Unix flavors. ** Mikhail. - Original Message - From: Paul Gallier To: Mikhail Entaltsev ; [EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 4:24 AM Subject: Re: InnoDB slow? Thanks for the info. I'm running MySQL 4.0.14 under R

Re: InnoDB slow?

2003-09-02 Thread Paul Gallier
t swap). Best regards, Mikhail. - Original Message - From: "Paul Gallier" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, September 02, 2003 2:57 AM Subject: InnoDB slow? I'm running a large database which is currently using MyISAM. There are approximately

InnoDB slow?

2003-09-02 Thread Paul Gallier
I'm running a large database which is currently using MyISAM. There are approximately 300 million rows in about a dozen tables totaling 7GB of storage. The system is averaging 257 querries per second, probably peaking at around 500-600+ during busy times. We're running a single database with