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 index cardinality statistics when you run ANALYZE TABLE > or restart the mysqld server. Sure, I had several restarts while changing settings and testing again... Best regards Matthias -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]