mysql里面show processlist命令作用是什么？ mysql show processlist
- 我的MYSQL下为什么没有show processlist这个命令？
- mysql中show processlist出现的问题
- 请教mysql的show processlist命令能否显示完整的SQL语句
- 在mysql数据库执行show processlist之后出现这种情况请问是怎么回事?
我的MYSQL下为什么没有show processlist这个命令？
您肯定是这么干的C:\Documents and Settings\Administrator>show'show' 不是内部或外部命令，也不是可运行的程序或批处理文件。应该这样：C:\Documents and Settings\Administrator>mysql -uroot -pEnter password: ******Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 1Server version: 5.0.67-community-nt-log MySQL Community Edition (GPL)Type 'help;' or '\h' for help. Type '\c' to clear the buffer.mysql> show processlist -> ;+----+------+----------------+------+---------+------+-------+------------------+| Id | User | Host | db | Command | Time | State | Info|+----+------+----------------+------+---------+------+-------+------------------+| 1 | root | localhost:1954 | NULL | Query | 0 | NULL | show processlist|+----+------+----------------+------+---------+------+-------+------------------+1 row in set (0.03 sec)mysql
mysql中show processlist出现的问题
我看了下自己的，调度事件的线程state是wait for next activation，command是daemon
show processlist的info是show processlist
command是query
别的也和你的差不多，应该不是问题吧sleep是目前没做事的，info就没关系了，介绍用的
请教mysql的show processlist命令能否显示完整的SQL语句
show create procedure proc_name;
在输出结果的create procedure项里，拷出来就看到了。
在mysql数据库执行show processlist之后出现这种情况请问是怎么回事?
这个操作等待其它更新释放锁
查询锁记录
SELECT * FROM information_schema.INNODB_TRX;
SELECT * FROM information_schema.innodb_locks;
select r.trx_id wait_trx_id,r.trx_mysql_thread_id wait_thr_id,r.trx_query wait_query,b.trx_id block_trx_id,
b.trx_mysql_thread_id block_thrd_id,b.trx_query block_query,b.trx_started as trx_started_old,r.trx_started as trx_started_new
from information_schema.innodb_lock_waits w inner join information_schema.innodb_trx b on b.trx_id = w.blocking_trx_id inner join information_schema.innodb_trx r on r.trx_id =w.requesting_trx_id;