Re: Mysql 4.1.1, InnoDB - Slow TRUNCATE operations with Multiple Tablespaces

2004-05-24 Thread Heikki Tuuri
, 2004 4:59 AM Subject: Mysql 4.1.1, InnoDB - Slow TRUNCATE operations with Multiple Tablespaces --=_NextPart_000_0050_01C43F2A.002F6960 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi everybody, I'm experiencing that the command TRUNCATE TABLE

Mysql 4.1.1, InnoDB - Slow TRUNCATE operations with Multiple Tablespaces

2004-05-20 Thread Richard Dale
Hi everybody, I'm experiencing that the command TRUNCATE TABLE with InnoDB takes an extraordinary amount of time on large ( 400MB) tables - ie about 3-4 minutes. In comparison, performing a DROP TABLE then recreating it takes about 2 seconds. When the truncate operation is performed

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 Chris Nolan
Could you send us your my.cnf / my.ini ? We might be able to help you tune your InnoDB config for this setup. In my experience, InnoDB performance should approach MyISAM in most environments where the disk is the bottleneck (due to the fact, as said in the InnoDB table type intro in the docs,

Re: InnoDB slow?

2003-09-02 Thread Mikhail Entaltsev
. - 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

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 Mikhail Entaltsev
fdatasync() or O_DSYNC because there have 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

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 Heikki Tuuri
Hi! - Original Message - From: Paul Gallier [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Tuesday, September 02, 2003 9:55 PM Subject: Re: InnoDB slow? --060404050304080006000506 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer

Re: InnoDB slow?

2003-09-02 Thread Paul Gallier
PROTECTED] Newsgroups: mailing.database.myodbc Sent: Tuesday, September 02, 2003 9:55 PM Subject: Re: InnoDB slow? --060404050304080006000506 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit I've not a clue - digging around somewhere