Locking problem. Auto-inc wait

[Adrian Chapela Cordeiro]

Hello,

I have a problem on an InnoDB table. This table has a size of 107 GB (this is a problem to do any change on it).

The table is:
CREATE TABLE `posiciones_tbl` (
`posicion_id` bigint(20) unsigned NOT NULL auto_increment,
`rx_id` int(11) NOT NULL default '0',
`vehiculo_id` int(11) NOT NULL default '0',
`bloque_posiciones_id` int(11) NOT NULL default '0',
`fecha` datetime NOT NULL default '1900-01-01 00:00:00',
etc....... (More fields without importance)
PRIMARY KEY (`posicion_id`),
KEY `bloque_pos_idDESC` (`bloque_posiciones_id`),
KEY `vehiculo_id__fecha__posicion_id__IDX` (`vehiculo_id`,`fecha`,`posicion_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

My problem is to do inserts in the table. I have five intensive applications doing inserts. They are locking themselves and they are waiting for an auto-increment id.