information_schema系统表——PROCESSLIST
来源:互联网 发布:美工设计招聘要求 编辑:程序博客网 时间:2024/06/05 14:22
进程列表
The PROCESSLIST
table provides information about which threads are running.
INFORMATION_SCHEMA
NameSHOW
NameID
Id
MySQL extensionUSER
User
MySQL extensionHOST
Host
MySQL extensionDB
db
MySQL extensionCOMMAND
Command
MySQL extensionTIME
Time
MySQL extensionSTATE
State
MySQL extensionINFO
Info
MySQL extensionFor an extensive description of the table columns, see Section 13.7.5.29, “SHOW PROCESSLIST Syntax”.
Notes:
The
PROCESSLIST
table is a nonstandard table.Like the output from the corresponding
SHOW
statement, thePROCESSLIST
table will only show information about your own threads, unless you have thePROCESS
privilege, in which case you will see information about other threads, too. As an anonymous user, you cannot see any rows at all.If an SQL statement refers to
INFORMATION_SCHEMA.PROCESSLIST
, MySQL populates the entire table once, when statement execution begins, so there is read consistency during the statement. There is no read consistency for a multi-statement transaction, though.Process information is also available from the
performance_schema.threads
table. However, access tothreads
does not require a mutex and has minimal impact on server performance.INFORMATION_SCHEMA.PROCESSLIST
andSHOW PROCESSLIST
have negative performance consequences because they require a mutex.threads
also shows information about background threads, whichINFORMATION_SCHEMA.PROCESSLIST
andSHOW PROCESSLIST
do not. This means thatthreads
can be used to monitor activity the other thread information sources cannot.
The following statements are equivalent:
SELECT * FROM INFORMATION_SCHEMA.PROCESSLISTSHOW FULL PROCESSLIST
- information_schema系统表——PROCESSLIST
- information_schema模式表介绍 processlist
- information_schema系统表——CHARACTER_SETS
- information_schema系统表——COLLATIONS
- information_schema系统表——COLLATION_CHARACTER_SET_APPLICABILITY
- information_schema系统表——COLUMNS
- information_schema系统表——COLUMN_PRIVILEGES
- information_schema系统表——ENGINES
- information_schema系统表——EVENTS
- information_schema系统表——FILES
- information_schema系统表——TABLES
- information_schema系统表——TABLESPACES
- information_schema系统表——TABLE_CONSTRAINTS
- information_schema系统表——TABLE_PRIVILEGES
- information_schema系统表——TRIGGERS
- information_schema系统表——USER_PRIVILEGES
- information_schema系统表——GLOBAL_STATUS and SESSION_STATUS
- show processlist 输出ID 和 information_schema.PROCESSLIST 的id,information_schema.innodb_trx的TRX_MYSQL_T
- Spring 系列: Spring 框架简介
- 练习(5)
- 字符串和数组相互转换
- 实验3_类与对象的构造和应用
- 在使用spring-kafka进行并发推送和接收数据
- information_schema系统表——PROCESSLIST
- 五周三次课(11月15日) 11.4 re的matche方法和search方法 11.5 re的split,findall,finditer方法 11.6 re的match对象
- 【设计模式】单例模式优化
- 欢迎使用CSDN-markdown编辑器
- 恋情小结
- 分布式架构spring mvc +mybatis +shiro+ Activiti +Alibaba Druid
- 学习笔记_python_python编程从入门到实践1.0
- ubuntu更新火狐
- Mac将多张图片转为PDF