//查看表结构
//选取表的aid字段，通过hash将表分为10个区，并指定特定的逻辑分区
//每个分区中生成了数据文件和索引文件
[codesyntax lang=”text”]
[root@wohong data]# tree . ├── disk0 │?? ├── health_addonarticle#P#p0.MYD │?? └── health_addonarticle#P#p0.MYI ├── disk1 │?? ├── health_addonarticle#P#p1.MYD │?? └── health_addonarticle#P#p1.MYI ├── disk2 │?? ├── health_addonarticle#P#p2.MYD │?? └── health_addonarticle#P#p2.MYI ├── disk3 │?? ├── health_addonarticle#P#p3.MYD │?? └── health_addonarticle#P#p3.MYI ├── disk4 │?? ├── health_addonarticle#P#p4.MYD │?? └── health_addonarticle#P#p4.MYI ├── disk5 │?? ├── health_addonarticle#P#p5.MYD │?? └── health_addonarticle#P#p5.MYI ├── disk6 │?? ├── health_addonarticle#P#p6.MYD │?? └── health_addonarticle#P#p6.MYI ├── disk7 │?? ├── health_addonarticle#P#p7.MYD │?? └── health_addonarticle#P#p7.MYI ├── disk8 │?? ├── health_addonarticle#P#p8.MYD │?? └── health_addonarticle#P#p8.MYI └── disk9 ├── health_addonarticle#P#p9.MYD └── health_addonarticle#P#p9.MYI 10 directories, 20 files
[/codesyntax]
//数据被均匀的写入到了10个分区内
[codesyntax lang=”text”]
[root@wohong data]# du -sh ./* 241M ./disk0 241M ./disk1 241M ./disk2 241M ./disk3 240M ./disk4 241M ./disk5 241M ./disk6 241M ./disk7 241M ./disk8 241M ./disk9
[/codesyntax]
mysql分区