hi dear mysql list members
i have setup a mysql database 4.013 with innodb enabled. when i set the transaction
isolation level to serializable. after executing a specific query is the insertion
into a table blocked for about 20 seconds. the table is defined as follows
CREATE TABLE `slide`
(
`id` bigint(20) unsigned NOT NULL auto_increment,
`identifier` varchar(255) NOT NULL default '',
`comment` varchar(255) default NULL,
`fromid` bigint(20) unsigned NOT NULL default '0',
`system` tinyint(1) unsigned NOT NULL default '0',
`size` int(10) unsigned NOT NULL default '0',
`data` text NOT NULL,
`modifyid` bigint(20) unsigned NOT NULL default '0',
`modifytime` bigint(20) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=InnoDB
executing the following query seems to work well. it returns quickly and the result is
as expected.
SELECT `id`, `data` FROM `slide` WHERE LOCATE('filterid="7"',`data`) != 0
but the first insertion into the slide table after that select is locked for about 20
seconds. selects work without any timeout. i would be happy if someone has an idea how
i can resolve the problem.
best regards
benny
