______________________________________________________________________ 001 ___count:372 (46.56%)time:581.404365 s Total, 1.562915 s AVG, 1.001595 s to 4.129653 s Max (46.56%)All time:516.842801 S, 1.464144 s AVG, 1.001595 s to 2.815608 s MaxLock time (s): 40.935 Mobile Ms Total, s AVG, S-211 max (44.74%)All lock:38.016 Ms Total, 108 s AVG, 135? s MaxRows sent:1 AVG, 1 to 1 max (40.57%)Rows examined:387.71k avg, 225.34k to 725.90k Max (33.79%)Databas
---- Start
DB2 SQL error: sqlcode:-911, sqlstate: 40001, sqlerrmc: 2
Message: The current transaction has been rolled back because of a deadlock or timeout. Reason code "2 ".
Yesterday, I executed a simple SQL statement but failed to execute it. The above error is a deadlock. Since it is a deadlock, You can execute it later. After waiting for a while, the deadlock still persists. Which transaction is locked with which transaction? After half a day of query, I found that the data volume upda
. log | mysqlsla-lt binary-Here, the slow log is used as an example:[Root @ localhost mysqlsla-2.03] # mysqlsla-lt slow/tmp/mongo_slow.log | moreReport for slow logs:/tmp/127_slow.log24 queries total, 6 uniqueSorted by 't_ Sum'Grand Totals: Time 16 s, Lock 1 s, Rows sent 18, Rows Examined 2.10 M__________________________________________________________________________ 001 ___Count: 18 (75.00%)Time: 15 s total, 833.333 MS avg, 0 to 8 s max (93.75%)95% of Time: 7 s total, 411.765 MS avg, 0 to 4 s
DOC_HIS_EDITOR_USER_ID_ENCRYPT = 'nfeacawqew5mican2 ';........................................
The Operation Experience of reading directly is poor. After mysqlsla is used for processing, the results are shown as follows:Count: 23 (8.52%)Time: 102 s total, 4.434783 s avg, 3 s to 7 s max (6.79%)95% of Time: 88 s total, 4.190476 s avg, 3 s to 6 s maxLock Time (s): 0 total, 0 avg, 0 to 0 max (0.00%)95% of Lock: 0 total, 0 avg, 0 to 0 maxRows sent: 1 avg
;[EMAILN Bsp;protected] 127.0.0.1:100.00% (+) of query, 100.00% (1586) of allusers Queryabstract:SET timestamp=n; SELECT order_pid from Wfc_delivery WHERE (Order_pid in (S1)) and (status in (S3)) GROUP by Order_pid;Querysample:SET timestamp=1387964641;SELECT ' order_pid ' from ' wfc_delivery ' WHERE (' Order_pid ' in (' 8831 ') ") and (' Status ' in (' 1 ', ' 4 ', '") ') GROUP by Order_ pid______________________________________________________________________ 001 ___count:19.16k (16.78%)time:76
Contact Us
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.