Heikki,
if you can tolerate losing a few last transactions in a power outage or an
OS crash, you can set
innodb_flush_log_at_trx_commit=2
Does that speed up the thing? I should make some testing.
Have you shut down mysqld and restarted it after populating the tables?
MySQL only updates
Hi all,
Because I want to use transactions in the future I have converted all
tables of a copy of our production database server (1800+, 512 MB RAM,
Linux) to InnoDB format. No problem until now. First, let me show you
settings in my.cnf:
key_buffer= 16M
table_cache