MySQL Forums :: MyISAM :: Concurrency probloem of MyIsam.
Concurrency probloem of MyIsam.
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
# 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!
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.