Hello All,
I have an issue that is seemingly hard to troubleshoot. Every so often
transactions/queries on InnoDB tables will stack up such that all the
queries appear to be waiting for others to execute. The problem is
that the others never finish executing. If you try to kill the
"Updating" threads/queries they never die. Restarting the program
executing the queries also doesn't help. The only way to break out is
to "kill -9" mysql. The update load on the MySQL server is fairly
constant. I've been monitoring this for a couple of days and every
time I check (the most recent being last night) there are no
outstanding queries in the PROCESSLIST or SHOW INNODB STATUS. Also,
even during this issue there are no deadlocks listed/recognized by
InnoDB. I've included the full "SHOW PROCESSLIST" and "SHOW INNODB
STATUS" outputs from during the event. Whatever causes this, it seems
to come upon the server fairly quickly.
Any help is greatly appreciated. Thank you in advance!
Best Regards,
Jason
---SHOW PROCESS LIST---
*************************** 1. row ***************************
Type: InnoDB
Name:
Status:
=====================================
070114 22:09:05 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 23 seconds
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 16008, signal count 15657
Mutex spin waits 0, rounds 0, OS waits 0
RW-shared spins 29962, OS waits 15019; RW-excl spins 1188, OS waits 989
------------
TRANSACTIONS
------------
Trx id counter 0 1472286
Purge done for trx's n:o < 0 1472274 undo n:o < 0 0
History list length 15
Total number of lock structs in row lock hash table 1
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0 0, not started, OS thread id 189
MySQL thread id 1280, query id 330126 localhost root
SHOW INNODB STATUS
---TRANSACTION 0 0, not started, OS thread id 188 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1276, query id 330118 10.1.58.43 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(11, '8563800928955791106', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 0, not started, OS thread id 187 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1275, query id 330117 10.1.58.42 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(433, '3228125312310094225', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 0, not started, OS thread id 186 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1274, query id 330116 10.1.58.43 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(2443, '15435722262529763403', 1, 0, current_date()) ON
DUPLICATE KEY UPDATE last_hit = current_date(), spam_hits =
greatest(0, spam_hits + 1), innocent_hits = greatest(0, innocent_hits
- 0)
---TRANSACTION 0 0, not started, OS thread id 185 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1273, query id 330115 10.1.58.43 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(398, '15160676287902524852', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 0, not started, OS thread id 184 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1272, query id 330114 10.1.58.42 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(3966, '14528798056022965668', 1, 0, current_date()) ON
DUPLICATE KEY UPDATE last_hit = current_date(), spam_hits =
greatest(0, spam_hits + 1), innocent_hits = greatest(0, innocent_hits
- 0)
---TRANSACTION 0 0, not started, OS thread id 183 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1271, query id 330113 10.1.58.43 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(693, '5421332010014503916', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 0, not started, OS thread id 182 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1270, query id 330112 10.1.58.42 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(1386, '16292377253775848661', 1, 0, current_date()) ON
DUPLICATE KEY UPDATE last_hit = current_date(), spam_hits =
greatest(0, spam_hits + 1), innocent_hits = greatest(0, innocent_hits
- 0)
---TRANSACTION 0 0, not started, OS thread id 181 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1269, query id 330111 10.1.58.43 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(1759, '18108299569491841277', 1, 0, current_date()) ON
DUPLICATE KEY UPDATE last_hit = current_date(), spam_hits =
greatest(0, spam_hits + 1), innocent_hits = greatest(0, innocent_hits
- 0)
---TRANSACTION 0 0, not started, OS thread id 180 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1268, query id 330105 10.1.58.43 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(2072, '15353583257255433130', 1, 0, current_date()) ON
DUPLICATE KEY UPDATE last_hit = current_date(), spam_hits =
greatest(0, spam_hits + 1), innocent_hits = greatest(0, innocent_hits
- 0)
---TRANSACTION 0 0, not started, OS thread id 179 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1267, query id 330103 10.1.58.43 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(1038, '601210067541728201', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 0, not started, OS thread id 178 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1266, query id 330102 10.1.58.43 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(535, '3755401304079536039', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 0, not started, OS thread id 177 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1265, query id 330101 10.1.58.42 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(421, '10973999742891970959', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 0, not started, OS thread id 176 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1264, query id 330100 10.1.58.43 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(438, '15200628614960339949', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 0, not started, OS thread id 175 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1263, query id 330099 10.1.58.43 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(170, '12229108568889084721', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 0, not started, OS thread id 174 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1262, query id 330098 10.1.58.42 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(333, '14990782145574077923', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 0, not started, OS thread id 173 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1261, query id 330097 10.1.58.42 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(1372, '15479680000856169010', 1, 0, current_date()) ON
DUPLICATE KEY UPDATE last_hit = current_date(), spam_hits =
greatest(0, spam_hits + 1), innocent_hits = greatest(0, innocent_hits
- 0)
---TRANSACTION 0 0, not started, OS thread id 172 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1260, query id 330096 10.1.58.42 istat Updating
update token_data set last_hit = current_date(), spam_hits =
greatest(0, spam_hits - 0), innocent_hits = greatest(0, innocent_hits
+ 1) where uid = 1153 and token in('13886526367306062682')
---TRANSACTION 0 0, not started, OS thread id 171 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1259, query id 330095 10.1.58.43 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(2443, '15435722262529763403', 1, 0, current_date()) ON
DUPLICATE KEY UPDATE last_hit = current_date(), spam_hits =
greatest(0, spam_hits + 1), innocent_hits = greatest(0, innocent_hits
- 0)
---TRANSACTION 0 0, not started, OS thread id 170 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1258, query id 330094 10.1.58.43 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(456, '9365264194700954954', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 0, not started, OS thread id 169 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1257, query id 330093 10.1.58.42 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(947, '16115090353931693588', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 0, not started, OS thread id 168 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1256, query id 330092 10.1.58.42 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(170, '2917333194889300017', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 0, not started, OS thread id 167 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1255, query id 330091 10.1.58.43 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(1383, '13837287625678618', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 0, not started, OS thread id 166 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1254, query id 330090 10.1.58.42 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(1447, '15733443064039097693', 1, 0, current_date()) ON
DUPLICATE KEY UPDATE last_hit = current_date(), spam_hits =
greatest(0, spam_hits + 1), innocent_hits = greatest(0, innocent_hits
- 0)
---TRANSACTION 0 0, not started, OS thread id 165 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1253, query id 330089 10.1.58.43 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(26, '5775323334071626545', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 0, not started, OS thread id 164 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1252, query id 330088 10.1.58.42 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(709, '8354553082750092635', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 0, not started, OS thread id 163 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1251, query id 330087 10.1.58.42 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(396, '6450138460296755841', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 0, not started, OS thread id 162 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1250, query id 330086 10.1.58.43 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(109, '2633501858524652845', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 0, not started, OS thread id 161 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1249, query id 330085 10.1.58.43 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(2072, '15353583257255433130', 1, 0, current_date()) ON
DUPLICATE KEY UPDATE last_hit = current_date(), spam_hits =
greatest(0, spam_hits + 1), innocent_hits = greatest(0, innocent_hits
- 0)
---TRANSACTION 0 0, not started, OS thread id 160 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1248, query id 330084 10.1.58.42 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(553, '8597574295759244867', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 0, not started, OS thread id 158 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1246, query id 330082 10.1.58.42 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(3966, '14528798056022965668', 1, 0, current_date()) ON
DUPLICATE KEY UPDATE last_hit = current_date(), spam_hits =
greatest(0, spam_hits + 1), innocent_hits = greatest(0, innocent_hits
- 0)
---TRANSACTION 0 0, not started, OS thread id 157 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1245, query id 330081 10.1.58.42 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(421, '10973999742891970959', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 0, not started, OS thread id 156 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1244, query id 330078 10.1.58.42 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(3966, '14528798056022965668', 1, 0, current_date()) ON
DUPLICATE KEY UPDATE last_hit = current_date(), spam_hits =
greatest(0, spam_hits + 1), innocent_hits = greatest(0, innocent_hits
- 0)
---TRANSACTION 0 0, not started, OS thread id 155 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1243, query id 330077 10.1.58.42 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(1381, '13837287625678618', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 0, not started, OS thread id 154 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1242, query id 330076 10.1.58.43 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(1842, '13837287625678618', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 0, not started, OS thread id 153 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1241, query id 330074 10.1.58.43 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(109, '2633501858524652845', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 0, not started, OS thread id 152 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1240, query id 330073 10.1.58.42 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(1447, '15733443064039097693', 1, 0, current_date()) ON
DUPLICATE KEY UPDATE last_hit = current_date(), spam_hits =
greatest(0, spam_hits + 1), innocent_hits = greatest(0, innocent_hits
- 0)
---TRANSACTION 0 0, not started, OS thread id 151 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1239, query id 330069 10.1.58.43 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(439, '8597574295759244867', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 0, not started, OS thread id 150 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1238, query id 330067 10.1.58.42 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(1107, '8597574295759244867', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 0, not started, OS thread id 149 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1237, query id 330065 10.1.58.42 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(402, '5791804340630811603', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 0, not started, OS thread id 148 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1236, query id 330063 10.1.58.43 istat Updating
update token_data set last_hit = current_date(), spam_hits =
greatest(0, spam_hits + 1), innocent_hits = greatest(0, innocent_hits
- 0) where uid = 437 and token in('176034204053473251')
---TRANSACTION 0 0, not started, OS thread id 147 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1235, query id 330062 10.1.58.42 istat Updating
update token_data set last_hit = current_date(), spam_hits =
greatest(0, spam_hits + 1), innocent_hits = greatest(0, innocent_hits
- 0) where uid = 437 and token in('176034204053473251')
---TRANSACTION 0 0, not started, OS thread id 146 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1234, query id 330061 10.1.58.42 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(1372, '15479680000856169010', 1, 0, current_date()) ON
DUPLICATE KEY UPDATE last_hit = current_date(), spam_hits =
greatest(0, spam_hits + 1), innocent_hits = greatest(0, innocent_hits
- 0)
---TRANSACTION 0 0, not started, OS thread id 145 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1233, query id 330060 10.1.58.43 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(2495, '15479680000856169010', 1, 0, current_date()) ON
DUPLICATE KEY UPDATE last_hit = current_date(), spam_hits =
greatest(0, spam_hits + 1), innocent_hits = greatest(0, innocent_hits
- 0)
---TRANSACTION 0 0, not started, OS thread id 144 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1232, query id 330059 10.1.58.43 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(1759, '18108299569491841277', 1, 0, current_date()) ON
DUPLICATE KEY UPDATE last_hit = current_date(), spam_hits =
greatest(0, spam_hits + 1), innocent_hits = greatest(0, innocent_hits
- 0)
---TRANSACTION 0 0, not started, OS thread id 143 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1231, query id 330058 10.1.58.42 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(147, '8368925849360969935', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 0, not started, OS thread id 141 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1229, query id 330057 10.1.58.42 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(170, '2917333194889300017', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 0, not started, OS thread id 142 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1230, query id 330056 10.1.58.42 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(1381, '13837287625678618', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 0, not started, OS thread id 140 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1228, query id 330055 10.1.58.43 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(170, '2917333194889300017', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 0, not started, OS thread id 139 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1227, query id 330054 10.1.58.43 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(1842, '13837287625678618', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 0, not started, OS thread id 138 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1226, query id 330053 10.1.58.43 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(1383, '13837287625678618', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 0, not started, OS thread id 137 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1225, query id 330052 10.1.58.42 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(396, '6450138460296755841', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 0, not started, OS thread id 136 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1224, query id 330051 10.1.58.42 istat Updating
update token_data set last_hit = current_date(), spam_hits =
greatest(0, spam_hits - 0), innocent_hits = greatest(0, innocent_hits
+ 1) where uid = 1378 and token in('10405022649306011353')
---TRANSACTION 0 0, not started, OS thread id 135 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1223, query id 330050 10.1.58.43 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(109, '2633501858524652845', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 0, not started, OS thread id 134 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1222, query id 330049 10.1.58.43 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(535, '3755401304079536039', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 0, not started, OS thread id 133 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1221, query id 330048 10.1.58.42 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(421, '10973999742891970959', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 0, not started, OS thread id 132 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1220, query id 330047 10.1.58.43 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(438, '15200628614960339949', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 0, not started, OS thread id 131 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1219, query id 330046 10.1.58.42 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(1447, '15733443064039097693', 1, 0, current_date()) ON
DUPLICATE KEY UPDATE last_hit = current_date(), spam_hits =
greatest(0, spam_hits + 1), innocent_hits = greatest(0, innocent_hits
- 0)
---TRANSACTION 0 0, not started, OS thread id 130 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1218, query id 330045 10.1.58.43 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(26, '5775323334071626545', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 0, not started, OS thread id 129 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1217, query id 330044 10.1.58.42 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(709, '8354553082750092635', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 0, not started, OS thread id 128 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1216, query id 330043 10.1.58.43 istat Updating
update token_data set last_hit = current_date(), spam_hits =
greatest(0, spam_hits - 0), innocent_hits = greatest(0, innocent_hits
+ 1) where uid = 2508 and token in('4557255557211275077')
---TRANSACTION 0 0, not started, OS thread id 127 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1215, query id 330040 10.1.58.42 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(1107, '8597574295759244867', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 1448153, not started, OS thread id 116 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1133, query id 330041 10.1.58.43 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(354, '8597574295759244867', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 1448149, not started, OS thread id 115 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1132, query id 330042 10.1.58.43 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(439, '8597574295759244867', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 1448148, not started, OS thread id 117 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1134, query id 330031 10.1.58.43 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(438, '15200628614960339949', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 1448141, not started, OS thread id 124 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1141, query id 330034 10.1.58.42 istat Updating
update token_data set last_hit = current_date(), spam_hits =
greatest(0, spam_hits - 0), innocent_hits = greatest(0, innocent_hits
+ 1) where uid = 1378 and token in('10405022649306011353')
---TRANSACTION 0 1448138, not started, OS thread id 120 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1137, query id 330033 10.1.58.43 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(535, '3755401304079536039', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 1448137, not started, OS thread id 126 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1143, query id 330038 10.1.58.42 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(402, '5791804340630811603', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 1448131, not started, OS thread id 125 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1142, query id 330035 10.1.58.42 istat Updating
update token_data set last_hit = current_date(), spam_hits =
greatest(0, spam_hits + 1), innocent_hits = greatest(0, innocent_hits
- 0) where uid = 437 and token in('176034204053473251')
---TRANSACTION 0 1448129, not started, OS thread id 123 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1140, query id 330039 10.1.58.42 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(553, '8597574295759244867', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 1448124, not started, OS thread id 121 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1138, query id 330032 10.1.58.42 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(421, '10973999742891970959', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 1448120, not started, OS thread id 119 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1136, query id 330037 10.1.58.43 istat Updating
update token_data set last_hit = current_date(), spam_hits =
greatest(0, spam_hits + 1), innocent_hits = greatest(0, innocent_hits
- 0) where uid = 334 and token in('6364824612906886657')
---TRANSACTION 0 1448122, not started, OS thread id 113 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1131, query id 330036 10.1.58.43 istat Updating
update token_data set last_hit = current_date(), spam_hits =
greatest(0, spam_hits + 1), innocent_hits = greatest(0, innocent_hits
- 0) where uid = 437 and token in('176034204053473251')
---TRANSACTION 0 1472047, not started, OS thread id 23 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1129, query id 330030 10.1.58.42 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(1447, '15733443064039097693', 1, 0, current_date()) ON
DUPLICATE KEY UPDATE last_hit = current_date(), spam_hits =
greatest(0, spam_hits + 1), innocent_hits = greatest(0, innocent_hits
- 0)
---TRANSACTION 0 1448104, not started, OS thread id 25 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1066, query id 330080 10.1.58.43 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(1759, '18108299569491841277', 1, 0, current_date()) ON
DUPLICATE KEY UPDATE last_hit = current_date(), spam_hits =
greatest(0, spam_hits + 1), innocent_hits = greatest(0, innocent_hits
- 0)
---TRANSACTION 0 1448106, not started, OS thread id 15 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1063, query id 330079 10.1.58.42 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(147, '8368925849360969935', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 1472275, not started, OS thread id 67
MySQL thread id 1065, query id 330020 10.1.58.43 istat end
update stats set spam_learned = spam_learned - 0, innocent_learned =
innocent_learned - 0, spam_misclassified = spam_misclassified - 0,
innocent_misclassified = innocent_misclassified - 0, spam_corpusfed =
spam_corpusfed - 0, innocent_corpusfed = innocent_corpusfed - 0,
spam_classified = spam_classified + 1, innocent_classified =
innocent_classified - 0 where uid = 334
---TRANSACTION 0 1448101, not started, OS thread id 17 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1064, query id 330110 10.1.58.42 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(1381, '13837287625678618', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 1448110, not started, OS thread id 49 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 1062, query id 330108 10.1.58.42 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(170, '12229108568889084721', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 1472276, not started, OS thread id 40
mysql tables in use 1, locked 1
MySQL thread id 736, query id 330018 10.1.58.43 istat update
insert into signature_data(uid, signature, length, created_on, data)
values(437, "45aaa64336072326010550", 13408, current_date(),
"[EMAIL
PROTECTED]'?K\0\0\0\0\0\0\0\0\0????P\0\0\0\0\0\0\0\'=??hC?\0\0\0\0\0\0\0&~??)???\0\0\0\0\0\0\0?
??}E?\0\0\0\0\0\0\0\'=?vM?\0\0\0\0\0\0\0?;r2???p\0\0\0\0\0\0\0\0\0\0?h?wM\0\0\0\0\0\0\0{?
??32?\0\0\0\0\0\0\0??E~|??\0\0\0\0\0\0\0E~?C???\0\0\0\0\0\0\0\0\0\0?
?{R\0\0\0\0\0\0\0?
??O\0B?\0\0\0\0\0\0\0P?;r??\Z?\0\0\0\0\0\0\0\0\0\0??g?C
\0\0\0\0\0\0\0\0\0\0??\'?C\0\0\0\0\0\0\0\0\0\0\0\0??S\0\0\0\0\0\0\0?w?s??9\0\0\0\0\0\0\0?
---TRANSACTION 0 1448089, not started, OS thread id 27 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 539, query id 330075 10.1.58.43 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(438, '15200628614960339949', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 1472272, not started, OS thread id 114
MySQL thread id 402, query id 330021 10.1.58.42 istat Table lock
insert into stats(uid, spam_learned, innocent_learned,
spam_misclassified, innocent_misclassified, spam_corpusfed,
innocent_corpusfed, spam_classified, innocent_classified) values(437,
0, 0, 0, 0, 0, 0, 174, 6)
---TRANSACTION 0 1448091, not started, OS thread id 55 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 390, query id 330109 10.1.58.43 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(693, '5421332010014503916', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 1448095, not started, OS thread id 35 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 368, query id 330106 10.1.58.42 istat Updating
update token_data set last_hit = current_date(), spam_hits =
greatest(0, spam_hits - 0), innocent_hits = greatest(0, innocent_hits
+ 1) where uid = 1153 and token in('13886526367306062682')
---TRANSACTION 0 1448105, not started, OS thread id 30 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 296, query id 330072 10.1.58.43 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(26, '5775323334071626545', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 1448098, not started, OS thread id 69 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 59, query id 330071 10.1.58.43 istat Updating
update token_data set last_hit = current_date(), spam_hits =
greatest(0, spam_hits - 0), innocent_hits = greatest(0, innocent_hits
+ 1) where uid = 2508 and token in('4557255557211275077')
---TRANSACTION 0 1441646, not started, OS thread id 18 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 8, query id 330104 10.1.58.42 istat Updating
update token_data set last_hit = current_date(), spam_hits =
greatest(0, spam_hits - 0), innocent_hits = greatest(0, innocent_hits
+ 1) where uid = 1378 and token in('10405022649306011353')
---TRANSACTION 0 1441642, not started, OS thread id 19 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 9, query id 330070 10.1.58.42 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(61, '7849275369291257064', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 1441641, not started, OS thread id 68 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 58, query id 330107 10.1.58.43 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(170, '12229108568889084721', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 1441651, not started, OS thread id 66 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 56, query id 330068 10.1.58.43 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(354, '8597574295759244867', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 1448115, not started, OS thread id 16 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 6, query id 330066 10.1.58.42 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(553, '8597574295759244867', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
---TRANSACTION 0 1441637, not started, OS thread id 65 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 55, query id 330064 10.1.58.43 istat Updating
update token_data set last_hit = current_date(), spam_hits =
greatest(0, spam_hits + 1), innocent_hits = greatest(0, innocent_hits
- 0) where uid = 334 and token in('6364824612906886657')
---TRANSACTION 0 1472285, ACTIVE 902 sec, OS thread id 159 waiting in
InnoDB queue
mysql tables in use 1, locked 1
1 lock struct(s), heap size 3200 row lock(s)
MySQL thread id 1247, query id 330083 10.1.58.42 istat update
insert into virtual_uids (uid, username) values(NULL,
'[EMAIL PROTECTED]')
Trx has approximately 0 row locks
---TRANSACTION 0 1472284, ACTIVE 958 sec, OS thread id 24, thread
declared inside InnoDB 500
mysql tables in use 1, locked 1
1 lock struct(s), heap size 3200 row lock(s), undo log entries 1
MySQL thread id 1128, query id 330029 10.1.58.43 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(26, '5775323334071626545', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
Trx has approximately 0 row locks
---TRANSACTION 0 1472283, ACTIVE 959 sec, OS thread id 42, thread
declared inside InnoDB 500
mysql tables in use 1, locked 1
1 lock struct(s), heap size 3200 row lock(s), undo log entries 1
MySQL thread id 1127, query id 330028 10.1.58.42 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(709, '8354553082750092635', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
Trx has approximately 0 row locks
---TRANSACTION 0 1472282, ACTIVE 959 sec, OS thread id 118, thread
declared inside InnoDB 498
mysql tables in use 1, locked 1
2 lock struct(s), heap size 3201 row lock(s), undo log entries 1
MySQL thread id 1135, query id 330027 10.1.58.43 istat end
update token_data set last_hit = current_date(), spam_hits =
greatest(0, spam_hits - 0), innocent_hits = greatest(0, innocent_hits
+ 1) where uid = 2508 and token in('4557255557211275077')
Trx has approximately 1 row locks
---TRANSACTION 0 1472281, ACTIVE 962 sec, OS thread id 21, thread
declared inside InnoDB 500
mysql tables in use 1, locked 1
1 lock struct(s), heap size 3200 row lock(s), undo log entries 1
MySQL thread id 538, query id 330026 10.1.58.42 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(1107, '8597574295759244867', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
Trx has approximately 0 row locks
---TRANSACTION 0 1472280, ACTIVE 962 sec, OS thread id 13, thread
declared inside InnoDB 500
mysql tables in use 1, locked 1
1 lock struct(s), heap size 3200 row lock(s), undo log entries 1
MySQL thread id 1130, query id 330025 10.1.58.42 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(553, '8597574295759244867', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
Trx has approximately 0 row locks
---TRANSACTION 0 1472279, ACTIVE 962 sec, OS thread id 29, thread
declared inside InnoDB 500
mysql tables in use 1, locked 1
1 lock struct(s), heap size 3200 row lock(s), undo log entries 1
MySQL thread id 1067, query id 330024 10.1.58.43 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(354, '8597574295759244867', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
Trx has approximately 0 row locks
---TRANSACTION 0 1472278, ACTIVE 962 sec, OS thread id 122, thread
declared inside InnoDB 500
mysql tables in use 1, locked 1
1 lock struct(s), heap size 3200 row lock(s), undo log entries 1
MySQL thread id 1139, query id 330023 10.1.58.43 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(439, '8597574295759244867', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
Trx has approximately 0 row locks
---TRANSACTION 0 1472277, ACTIVE 963 sec, OS thread id 37, thread
declared inside InnoDB 500
mysql tables in use 1, locked 1
1 lock struct(s), heap size 3200 row lock(s), undo log entries 1
MySQL thread id 297, query id 330022 10.1.58.42 istat update
insert into token_data(uid, token, spam_hits, innocent_hits, last_hit)
values(402, '5791804340630811603', 1, 0, current_date()) ON DUPLICATE
KEY UPDATE last_hit = current_date(), spam_hits = greatest(0,
spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0)
Trx has approximately 0 row locks
--------
FILE I/O
--------
I/O thread 0 state: waiting for i/o request (insert buffer thread)
I/O thread 1 state: waiting for i/o request (log thread)
I/O thread 2 state: waiting for i/o request (read thread)
I/O thread 3 state: waiting for i/o request (write thread)
Pending normal aio reads: 0, aio writes: 0,
ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
Pending flushes (fsync) log: 0; buffer pool: 0
15763 OS file reads, 1110491 OS file writes, 114035 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 5, seg size 7,
5858 inserts, 5858 merged recs, 2230 merges
Hash table size 4980539, used cells 186467, node heap has 188 buffer(s)
0.00 hash searches/s, 0.00 non-hash searches/s
---
LOG
---
Log sequence number 1 2122604229
Log flushed up to 1 2122602034
Last checkpoint at 1 2122602034
0 pending log writes, 0 pending chkp writes
415701 log i/o's done, 0.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 1367085783; in additional pool allocated 693888
Dictionary memory allocated 40096
Buffer pool size 76800
Free buffers 1066
Database pages 75546
Modified db pages 40
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages read 15936, created 59610, written 742793
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
--------------
ROW OPERATIONS
--------------
8 queries inside InnoDB, 89 queries in queue
1 read views open inside InnoDB
Main thread id 9, state: waiting for server activity
Number of rows inserted 183511, updated 177804, deleted 0, read 177854
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
1 row in set, 1 warning (0.02 sec)
ERROR:
No query specified
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
