Community
Learn
Tools Library
AI Tools
Leisure
search
English
Home > Database > Mysql Tutorial > 查看Mysql索引页碎片_MySQL

查看Mysql索引页碎片_MySQL

WBOY
Release： 2016-06-01 13:43:16
Original
1822 people have browsed it

bitsCN.com
查询索引页碎片:SHOW TABLE STATUS LIKE '表名'; //当Data_free 列值大于0时表示有碎片(只要删除过数据就会产生,前提是有建立索引) 优化表:OPTIMIZE TABLE 表名; 建立索引条件(或):表数据量大(数据量小的话建立索引效果不明显,反而浪费物理空间,增加维护表难度等)主键列/外键列(加快联接)/常用搜索列 查看数据库编码:show variables like 'character_set%';设置返回结果编码:SET character_set_results= utf-8;   作者 897457487 bitsCN.com

Related labels：
Inquire
source：php.cn
Previous article：在本地计算机无法启动MySql服务错误1067的解决方案_MySQL Next article：联合多表查询_MySQL
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Where should I place CustomLog directive in apache I'm using php:7.2-apachedocker. I need to disable health check url login access log. Based...
From 2024-04-06 22:03:59
0
1
990
The query and formula form the entire table, with new columns, where the new columns are formulas involving other conditional column values EDIT: The formula should be the "value" column - the "value" column wi...
From 2024-04-06 21:23:40
0
2
530
Sudoku checker not working? Can anyone help me identify the error? I tried everything on the online editor but still get the error. But when I do this on VSC...
From 2024-04-06 21:21:07
0
1
474
Select woocommerce related products using custom taxonomy with 3 level hierarchy I have a woocommerce store with a custom classification of "Sports". The classif...
From 2024-04-06 20:05:30
0
1
544
Calculate the sum of fields in another table using MySQL SQL query I have a schema like this: User table with attributes "user_id" and "userna...
From 2024-04-06 19:39:29
0
1
441
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template