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

hi i solved the problem by executing the commit after the select. best regards benny

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

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`