MySQL Forums :: MyISAM :: Concurrency probloem of MyIsam.

Advanced Search

Concurrency probloem of MyIsam.
Posted by: landtunes nomatter ()
Date: January 01, 2013 10:08PM

I use mysql 5.5.15 to realize a data exchange queue bewteen two Process. I created a MyIsam table that only include two blob fields.
Processes A and B at the same time to operate the table,Process A insert record continuously,Process B get the first record and delete it continuously.
However, I found that inserted data by process A and obtained data by process B inconsistencies in the number.Such as process A insert 1000 records,but process B only obtained 900 records,and randomly lost some records.
The following is my my.cnf file:

# The MySQL server
basedir = /usr/local/mysql
datadir = /usr/local/mysql/var/data
port = 3306
socket = /usr/local/mysql/var/mysql.sock

key_buffer_size = 256M
max_allowed_packet = 32M
concurrent_insert = 2
low-priority-updates = 1
table_open_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 16M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 2



server-id = 1

max_allowed_packet = 16M

# Remove the next comment character if you are not familiar with SQL

key_buffer_size = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M


Please give me some advice, thank you!

Options: ReplyQuote

Subject Views Written By Posted
Concurrency probloem of MyIsam. 2088 landtunes nomatter 01/01/2013 10:08PM
Re: Concurrency probloem of MyIsam. 912 Rick James 01/05/2013 03:23PM

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.