使用 myisamchk 加参数 -R这是原文-R or --sort-records=#
Sorts records according to an index. This makes your data much more localised and may speed up ranged SELECT and ORDER BY operations on this index. (It may be very slow to do a sort the first time!) To find out a table's index numbers, use SHOW INDEX, which shows a table's indexes in the same order that myisamchk sees them. Indexes are numbered beginning with 1. 示例
1: 停止MySQL服务
2: 执行C:\>myisamchk -R 1 c:/mysql/data/test/ta.MYI
- Sorting records for MyISAM-table 'c:/mysql/data/test/ta.MYI'
Data records: 1 Deleted: 0
Sorts records according to an index. This makes your data much more localised and may speed up ranged SELECT and ORDER BY operations on this index. (It may be very slow to do a sort the first time!) To find out a table's index numbers, use SHOW INDEX, which shows a table's indexes in the same order that myisamchk sees them. Indexes are numbered beginning with 1. 示例
1: 停止MySQL服务
2: 执行C:\>myisamchk -R 1 c:/mysql/data/test/ta.MYI
- Sorting records for MyISAM-table 'c:/mysql/data/test/ta.MYI'
Data records: 1 Deleted: 0
解决方案 »
免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货