MySQL 监控
2024-08-29 10:26:44
•Table_locks_immediate
The number of times that a request for a table lock could be granted immediately.
•Table_locks_waited
The number of times that a request for a table lock could not be granted immediately and a wait was needed. If this is high and you have performance problems, you should first optimize your queries, and then either split your table or tables or use replication.
实际上应该关心的是Table_locks_waited的值
这是我们服务器上的一个值
mysql> show global status like 'table%';
+-----------------------+---------+
| Variable_name | Value |
+-----------------------+---------+
| Table_locks_immediate | 1147514 |
| Table_locks_waited | 135 |
+-----------------------+---------+
http://blog.haohtml.com/archives/4760
最新文章
- angular2系列教程(八)In-memory web api、HTTP服务、依赖注入、Observable
- git 中关于LF 和 CRLF 的问题
- Linux 2.6 源码学习-内存管理-buddy算法
- Azure操作手册集合
- jquery之replaceAll(),replaceWith()方法详解
- Python基础 练习题
- hdoj 1087 (DP)
- Solr导入数据库数据
- ajax 传值 中文乱码问题
- LA-3135 - Argus(优先队列)
- Androidstudio2.0.0下载,欢迎下载
- css3 box-shadow让我们实现图层阴影效果
- 提高UI设计效率的4个技巧
- 网络1711c语言函数作业总结
- hibernate之HQL,Criteria与SQL
- python ironicclient源码分析
- Vue2 学习笔记5
- 「JOI 2016 Final」断层
- iOS开发笔记(Swift)-通用App安装引导页的实现
- linux基础操作
热门文章
- 移动端压缩并ajax上传图片解决方案
- opencv png和jpg的叠加
- Android 解析JSON格式数据
- 基于用户相似性的协同过滤——Python实现
- GitHub访问速度慢的解决方法
- Discovering versions from the identity service failed when creating the password plugin.
- maven package
- AngularJS之Provider, Value, Constant, Service, Factory, Decorator的区别与详解
- Codeforces 55D
- ios8 新增的 showViewController 和 showDetailViewController