MySQL Forums
Forum List  »  MyISAM

concurrent inserts not working
Posted by: ashish behl
Date: June 29, 2012 05:23AM

Hello all,
We are using mysql version 5.1.56 ( Distrib 5.1.56-ndb-7.1.19). Database engine is innoDb
While testing, we found that the concurrent_insert flag does not run as described.

We have concurrent_insert flag set to 2.
A query fired ( select * from table; For testing) on a table with 100 million rows was running and we ran an insert statement.
The insert statement was blocked on the select and subsequent selects were blocked on insert.

1)
We are running both selects and insert queries directly on the server using putty. So there is no question of READ locks (All are READ Local).
2)
We have log_bin variable set to OFF as mysql concurrent inserts page says:
If you are using the binary log, concurrent inserts are converted
to normal inserts for CREATE ... SELECT or INSERT ... SELECT
statements
3)
These are my my.conf parameters –>
key_buffer_size=512M
table_open_cache = 512
sort_buffer_size = 32M
read_buffer_size = 32M
read_rnd_buffer_size = 64M
myisam_sort_buffer_size = 64M
thread_cache_size = 20
query_cache_size =0

Can anyone guide??

Options: ReplyQuote


Subject
Views
Written By
Posted
concurrent inserts not working
3019
June 29, 2012 05:23AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.