, 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
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
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
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,
.
- 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
.
- 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
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
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
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
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
10 matches
Mail list logo