Ady,
----- Original Message -----
From: "Ady Wicaksono" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Monday, March 06, 2006 5:32 PM
Subject: MySQL InnoDB Row insert Calculation
With autocommit=1, anybody could give calculation on how many rows could
be inserted in 1 seconds?
I am assuming that you perform a COMMIT after each insert.
If the computer does not have a battery-backed disk cache, then the commit
speed is limited by the disk rotation speed, which is at most 250 rotations
per second nowadays.
If the computer does have a battery-backed disk cache (or you take the risk
and use a non-battery-backed cache), then the speed is limited by the CPU
usage, and for big tables by the disk seek time.
If the insertion is CPU-bound, you normally can insert 3000 rows per second,
or more.
For a big table, several gigabytes or more, inserts to secondary indexes may
require disk seeks, limiting the maximum insert speed to 100 rows per
second, or less.
Best regards,
Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
