MySQL и flush

В дефалт конфигурации настройки такие:

| flush | OFF |
| flush_time | 0 |

В подробностях же следующее:

If ON, the server flushes (synchronizes) all changes to disk after each SQL statement. Normally, MySQL does a write of all changes to disk only after each SQL statement and lets the operating system handle the synchronizing to disk. See Section B.5.4.2, “What to Do If MySQL Keeps Crashing”. This variable is set to ON if you start mysqld with the --flush option.

Странно, однако... предельно странно.

(с) http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_flush