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 upda
AIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Wednesday, October 01, 2003 6:04 AM
Subject: InnoDB speed problems
>
> 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 RA
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
