Alfredo,
----- Original Message ----- From: "Alfredo Cole" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Wednesday, March 02, 2005 2:09 AM
Subject: Re: Switching to InnoDB turns out dissapointing
El Mar 01 Mar 2005 17:32, Gary Richardson escribi=F3:What have you actually done to 'tune' the server? How are you doing the inserts?
InnoDB uses transactions. If you are doing each row as a single transaction (the default), it would probably take a lot longer.
I assume you're doing your copying as a INSERT INTO $new_table SELECT * FROM $old_table. Try wrapping that in a BEGIN; INSERT INTO $new_table SELECT * FROM $old_table; COMMIT;
How do you have your table space configured?
Just some random thoughts..
This is the InnoDB related stuff from my.cnf:
innodb_data_file_path =ibdata1:10M:autoextend set-variable =innodb_buffer_pool_size=192M
the buffer pool may be a bit too small for a database of this size. Remember that tables in the InnoDB format typically take 2 to 4 x the space of a MyISAM table. The zip-compressed InnoDB table format in MySQL-5.1 will squeeze InnoDB tables to about the same size as MyISAM.
set-variable =innodb_additional_mem_pool_size=32M set-variable =innodb_log_file_size=5M
The log file size is too small.
set-variable =innodb_log_buffer_size=32M
The log buffer is too big.
innodb_flush_log_at_trx_commit=0 set-variable =innodb_lock_wait_timeout=50
I am using the syntax as you describe it. In my notebook, with 512M RAM, it=
takes 4 hours to complete.
The top command says mysqld is using about 8% of CPU, so it must be a disk=
problem. Funny thing is, it did not show when the tables were MyISAM.
Thank you and regards.
Alfredo J. Cole Grupo ACyC www.acyc.com - www.clshonduras.com - SolCom - www.acycdomains.com
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables
http://www.innodb.com/order.php
------------------------------------------ Save the Pacific Northwest Tree Octopus! | http://zapatopi.net/treeoctopus.html | ------------------------------------------
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
