------=_NextPart_000_0030_01C34C51.B8F4D1A0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
hi dear mysql list members
=20
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
=20
CREATE TABLE `slide`=20
(=20
`id` bigint(20) unsigned NOT NULL auto_increment,=20
`identifier` varchar(255) NOT NULL default '',=20
`comment` varchar(255) default NULL,=20
`fromid` bigint(20) unsigned NOT NULL default '0',=20
`system` tinyint(1) unsigned NOT NULL default '0',=20
`size` int(10) unsigned NOT NULL default '0',=20
`data` text NOT NULL,=20
`modifyid` bigint(20) unsigned NOT NULL default '0',=20
`modifytime` bigint(20) unsigned NOT NULL default '0',=20
PRIMARY KEY (`id`) =20
) TYPE=3DInnoDB=20
=20
=20
executing the following query seems to work well. it returns quickly and =
the result is as expected.
=20
SELECT `id`, `data` FROM `slide` WHERE LOCATE('filterid=3D"7"',`data`) =
!=3D 0
=20
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.
=20
best regards
benny
------=_NextPart_000_0030_01C34C51.B8F4D1A0--