473,326 Members | 2,090 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

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 1519

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Morten Gulbrandsen | last post by:
Dear MySQL developers, Could some experienced Database developer please take a look at this ? It is supposed to be plain SQL2. How can it be coded under MySQL Especially all referential...
0
by: Marc Slemko | last post by:
Suppose I have an innodb table in 4.0.14 and do: LOCK TABLE maggie INSERT INTO maggie values(123, 'simpson'); UNLOCK TABLES As soon as I issue LOCK TABLE, any transaction in progress is...
1
by: Yo | last post by:
My users want to create innodb tables. This was a basic default installation of mysql3.23 using apt-get install mysql-server. They attempt the below.. USE test; CREATE TABLE testTable (i INT)...
3
by: Jeremy Howard | last post by:
I am finding delete queries on large InnoDB tables very slow - are there ways to speed this up? I have a table with about 100 million rows: I am trying to delete just a few of these rows (the...
1
by: Andy | last post by:
I'm using Mysql Max-4.1.4-gamma for Linux. I have a question related to a problem with my database server. If on my db server I have 2 different database, say DB1 & DB2, I create two INNODB tables...
17
by: Nodir Gulyamov | last post by:
Hello All! I met some strange situation. In MainThread my program wating changes of some variable. This variable should be changed in another thread, but loop, which wait changing variable blocks...
0
by: shakahshakah | last post by:
Just started investigating InnoDB after having used MyISAM tables in the 4.0.12 version, almost immediately ran into a locking issue with INSERTs, DELETEs, and transactions. Given the following...
21
by: Johan Tibell | last post by:
I would be grateful if someone had a minute or two to review my hash table implementation. It's not yet commented but hopefully it's short and idiomatic enough to be readable. Some of the code...
4
by: Tonio Tanzi | last post by:
I have the following problem in a Win 2000 Server + SQL Server 2000 environment and I hope somewhat can help me to resolve it (after many days of useless attempts I am desperate). In my database...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.