Hello, I am running MySQL Ver 12.22 Distrib 4.0.17 for intel-linux (i686) on RedHat 7.3 kernel 2.4.20-20.9smp
We use apache+php with persistant connections. Everything worked fine until we implemented transactions We go this way: BEGIN; select order.state from order where id=100 for update; //waits until another process updating the table if necessary <...php logic....estimating new state for order> update order.state=1 where id=100 for update; COMMIT; we use default global isolation level REPETABLE-READ >From that moment we have many identical slow queries (about 4000 per day) from different tables which should not be invlolved in transaction process and do not have any relations to the order table: # Time: 031226 10:27:29 # [EMAIL PROTECTED]: user [user] @ [192.168.3.2] # Query_time: 51 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 UPDATE go_stat SET count_visitors=count_visitors+1 ,count_uvisitors=count_uvisitors+1 WHERE id='guistuff' and date=' 2003-12-26'; # Time: 031226 10:27:31 # [EMAIL PROTECTED]: user[user] @ [192.168.3.2] # Query_time: 51 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 UPDATE go_stat SET count_visitors=count_visitors+1 ,count_uvisitors=count_uvisitors+1 WHERE id='guistuff' and date=' 2003-12-26'; # [EMAIL PROTECTED]: user[user] @ [192.168.3.2] # Query_time: 51 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 UPDATE pop_under_stat SET count=count+1 WHERE id=1 AND date='2003-12-26'; # Time: 031226 10:27:39 # [EMAIL PROTECTED]: user[user] @ [192.168.3.2] # Query_time: 51 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 UPDATE pop_under_stat SET count=count+1 WHERE id=1 AND date='2003-12-26'; The slow queries appear time to time. Please advise how we can solve this problem. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
