MYSQL process infinitely hanging on an INSERT
Hi,
I posted this problem since 5 days, desperately waiting for answer but did recieve nothing. May be informations I gave were not clear enough. I do another post with more clear information.
This problem is clearly process hanging infinitely on an INSERT statement. May be the process is waiting for a lock. But, why it does not give up if it does not obtain the lock after having wait for lock wait timeout value ???
Below is innodb parameteres in my.cnf :
innodb_data_home_dir = /opt/mysql/data/
innodb_data_file_path = ibdata_metacads1:1M;ibdata_metacads2:1000M:autoextend
innodb_buffer_pool_size=256M
innodb_additional_mem_pool_size=20M
innodb_log_group_home_dir = /opt/mysql/log
innodb_log_files_in_group = 2
innodb_log_file_size=64M
innodb_log_buffer_size=1M
innodb_flush_log_at_trx_commit=1
innodb_lock_wait_timeout=10
innodb_thread_concurrency=4
innodb_commit_concurrency=0
innodb_concurrency_tickets=500
Help again !
Subject
Views
Written By
Posted
MYSQL process infinitely hanging on an INSERT
10291
October 20, 2007 05:08PM
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.