Re: VERY slow InnoDB writes (in the teens/sec)

[Aram Mirzadeh]

Just another to show that there is something seriously wrong:

It took 18 seconds to alter two columns on a table with no rows (this is while the inserts are happening in the previous message, it's still running).

mysql TLMA25>ALTER TABLE `customers` CHANGE `cNameLong` `cNameLong` VARCHAR( 128 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL , CHANGE `cNameShort` `cNameShort` VARCHAR( 64 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL;
Query OK, 0 rows affected (18.30 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql TLMA25>select count(*) from customers;
+----------+
| count(*) |
+----------+
| 0 |
+----------+
1 row in set (0.00 sec)