468,119 Members | 1,820 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,119 developers. It's quick & easy.

i need help, innodb blocks insertion into table for a while

------=_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--

Jul 19 '05 #1
0 1347

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Marc Slemko | last post: by
3 posts views Thread by Jeremy Howard | last post: by
17 posts views Thread by Nodir Gulyamov | last post: by
21 posts views Thread by Johan Tibell | last post: by
13 posts views Thread by didacticone | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.