mysql> show processlist;
+--------+--------+-----------------------+--------+---------+------+-----------+---------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+--------+--------+-----------------------+--------+---------+------+-----------+---------------------------------------+
| 211286 | portal | 192.111.214.1:28234 | portal | Sleep | 146 | | NULL |
| 212706 | portal | localhost:48334 | portal | Sleep | 8 | | NULL |
| 212707 | portal | localhost:48335 | portal | Sleep | 0 | | NULL |
| 349093 | portal | localhost:21945 | portal | Sleep | 35 | | NULL |
| 349094 | portal | localhost:21946 | portal | Sleep | 35 | | NULL |
| 349095 | portal | localhost:21947 | portal | Sleep | 35 | | NULL |
| 350501 | portal | localhost:3187 | portal | Sleep | 35 | | NULL |
| 350502 | portal | localhost:3188 | portal | Sleep | 112 | | NULL |
| 350856 | root | localhost | portal | Query | 0 | NULL | show processlist |
| 350894 | portal | localhost:53418 | portal | Query | 490 | User lock | select nextval('SEQ_AUDIT_AUTHLOGTB') |
| 350896 | portal | 192.111.211.111:34719 | portal | Sleep | 490 | | NULL |
| 350908 | portal | localhost:34724 | portal | Query | 437 | User lock | select nextval('SEQ_AUDIT_AUTHLOGTB') |
| 350996 | portal | 192.111.214.1:21178 | portal | Sleep | 35 | | NULL |
| 350997 | portal | 192.111.211.111:39918 | portal | Sleep | 35 | | NULL |
+--------+--------+-----------------------+--------+---------+------+-----------+---------------------------------------+
14 rows in set (0.00 sec)
mysql> select body from mysql.proc where name='NEXTVAL';
begin
declare tmpvalue integer;
declare tmplock integer;
set seqname_ = upper(seqname_);
set tmplock = 0;
while (tmplock <> 1) do
set tmplock = get_lock(seqname_, 1000);
end while;
update seqtable
set seqvalue = seqvalue + seqincre
where seqname = seqname_;
select seqvalue into tmpvalue
from seqtable
where seqname = seqname_ for update;
set tmplock = release_lock(seqname_);
return tmpvalue;
end
/
kill 350894 还会起来。。