Converting HEAP to MyISAM in SHOW PROCESSLIST
来源:互联网 发布:航天金税盘软件下载 编辑:程序博客网 时间:2024/05/21 14:57
http://www.mysqlab.net/knowledge/kb/detail/topic/myisam/id/6149
Discussion
The state "converting HEAP to MyISAM" happens when a query that needs a temporary table is converting from an in-memory temporary table to a disk-based temporary table.
MySQL uses memory-based temporary tables up to the size limit set by the tmp_table_size system variable. If a query needs a temporary table larger than this it will be converted to a disk-based temporary table using the MyISAM storage engine.
GROUP BY queries and ORDER BY queries that can't use an index for the ordering are the most common causes of temporary table creation.
Solution
You could consider raising the per-session value of tmp_table_size if you have sufficient memory. Use theSHOW GLOBAL STATUS statement to see the value of the Created_tmp_tables variable. It will show the total number of temporary tables that have been created:
SHOW GLOBAL STATUS LIKE 'Created_tmp_tables';+--------------------+-------+| Variable_name | Value |+--------------------+-------+| Created_tmp_tables | 13 | +--------------------+-------+
The
Created_tmp_disk_tables
variable shows how many of those have been converted to disk temporary tables:
SHOW GLOBAL STATUS LIKE 'Created_tmp_disk_tables';+-------------------------+-------+| Variable_name | Value |+-------------------------+-------+| Created_tmp_disk_tables | 1 | +-------------------------+-------+
调2个参数
tmp_table_size和max_heap_table_size ============> converting HEAP to MyISAM
原文地址:http://7567567.blog.51cto.com/706378/630036
- Converting HEAP to MyISAM in SHOW PROCESSLIST
- show processlist
- Show Processlist
- show processlist
- Image Programming in JavaScript: Converting to Monochrome
- mysql show processlist state
- show full processlist /G
- 【转】SHOW PROCESSLIST
- mysql show processlist详解
- msyql show processlist
- mysql show processlist 使用
- Mysql Show Processlist 解读
- mysql show processlist state
- show processlist 命令详解
- mysql show processlist分析
- show processlist结果筛选
- SHOW PROCESSLIST整理
- mysql SHOW PROCESSLIST介绍
- Quartz绘图Paths
- 移动应用测试点
- 如何启用或停用 Mac OS X 系统快捷键
- Fragment——startActivityForResult后onActivityResult无反应之问题总结
- VS2005 中C++文件无法设置断点调试
- Converting HEAP to MyISAM in SHOW PROCESSLIST
- Bitmap内存管理
- Flume-ng的原理和使用
- JS 获取数据库日期-时间格式MM-dd-YYYY hh:mm p/a互相转换格式YYYY-MM-dd hh:mm
- Spring Security教程(6)---- 使用数据库管理用户及权限
- SSH框架学习
- NodeJs第一章
- 基于Hadoop的分布并行加法的实现
- jboss启动脚本