Alfredo,
----- Original Message -----
From: "Alfredo Cole" <alfredo@stripped>
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 |
------------------------------------------
