MySQL Forums
Forum List  »  InnoDB

Select queries that immediately follows the commit statement returns EMPTY ResutSet
Posted by: prakash Raman
Date: March 19, 2008 02:43PM

Hi,

I have executed more than 10000 numbers of insert queries under transaction. Then I had tried to read those newly added records using the select queries immediately after performing the commit operation.

While doing this kind of operation, I got empty result set for those select queries at sometimes. Kindly note that I am seeing this issue only one time out of 12 trials.

As a side note, I am also having update queries (for the old records which were committed earlier) along with above said insert queries. Kindly note that I am able to get the ResultSet while selecting the updated records but not for the newly created one.

Setup details are given below :

MySQL Version : 5.0.22-standard-log

Driver : mysql-connector-java-3.1.12-bin.jar

my.cnf configuration :

# The MySQL server
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 256K
net_buffer_length = 8K
thread_stack = 64K
myisam_sort_buffer_size = 8M
innodb_buffer_pool_size = 256M
innodb_additional_mem_pool_size = 20M
innodb_log_buffer_size=8M
innodb_thread_concurrency = 3

Note : mysql server is in replication setup over SSL.

Kindly help us to overcome this issue.

Thanks,
Prakasaraman

Options: ReplyQuote


Subject
Views
Written By
Posted
Select queries that immediately follows the commit statement returns EMPTY ResutSet
4262
March 19, 2008 02:43PM
6160
April 28, 2008 02:17AM


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.