MyISAM vs. InnoDB for an AUTO_INCREMENT counter table

[Eamon Daly]

We have a table containing just one column that we use for
unique IDs:

CREATE TABLE `id_sequence` (
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM 

Watching 'SHOW FULL PROCESSLIST' and reading the slow query
log shows the occasional backlog of locks. Has anyone found
significant speed increases or better concurrency by
switching over to InnoDB for such a table?

____________________________________________________________
Eamon Daly