MySQL Forums
Forum List  »  MyISAM

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
[mysqld]
basedir = /usr/local/mysql
datadir = /usr/local/mysql/var/data
port = 3306
socket = /usr/local/mysql/var/mysql.sock

skip-external-locking
key_buffer_size = 256M
max_allowed_packet = 32M
concurrent_insert = 2
max_write_lock_count=1
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
wait_timeout=28800
interactive_timeout=28800
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 2

log-bin=mysql-bin

binlog_format=mixed


server-id = 1



[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[myisamchk]
key_buffer_size = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

Please give me some advice, thank you!

Options: ReplyQuote


Subject
Views
Written By
Posted
Concurrency probloem of MyIsam.
2945
January 01, 2013 10:08PM
1470
January 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.