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

Re: InnoDB slow?

2003-09-02 Thread Paul Gallier
. - 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 300 million rows in about a dozen tables totaling 7GB of storage

Re: InnoDB slow?

2003-09-02 Thread Paul Gallier
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 Redhat 8.0

Re: InnoDB slow?

2003-09-02 Thread Paul Gallier
with 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 Gallier [EMAIL