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
.
- 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
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
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