|
create table partest(
|
id int(10) unsigned not null auto_increment,
|
val int(10) unsigned not null default 0,
|
primary key (id, val)
|
) engine=InnoDB
|
default charset=utf8mb4
|
data directory='/tmp/maria-partest/';
|
|
insert into partest(val) values(1);
|
insert into partest(val) values(1001);
|
|
~# ls -alh /tmp/maria-partest/test/
|
total 128K
|
drwxrwx--- 2 mysql mysql 25 Nov 16 23:01 .
|
drwxrwx--- 3 mysql mysql 18 Nov 16 22:55 ..
|
-rw-rw---- 1 mysql mysql 128K Nov 16 23:01 partest.ibd
|
|
~# ls -alh /var/lib/mysql/test/
|
total 12K
|
drwx------ 2 mysql mysql 58 Nov 16 23:22 .
|
drwxr-xr-x 5 mysql mysql 289 Nov 16 22:49 ..
|
-rw-rw---- 1 mysql mysql 65 Nov 16 21:39 db.opt
|
-rw-rw---- 1 mysql mysql 947 Nov 16 23:22 partest.frm
|
-rw-rw---- 1 mysql mysql 35 Nov 16 23:22 partest.isl
|
|
alter table partest partition by range(val)(
|
partition p0 values less than (1000),
|
partition p1 values less than (2000),
|
partition pFFFF values less than maxvalue
|
);
|
|
~# ls -alh /tmp/maria-partest/test/
|
total 0
|
drwxrwx--- 2 mysql mysql 6 Nov 16 23:09 .
|
drwxrwx--- 3 mysql mysql 18 Nov 16 22:55 ..
|
|
~# ls -alh /var/lib/mysql/test/
|
total 300K
|
drwx------ 2 mysql mysql 133 Nov 16 23:11 .
|
drwxr-xr-x 5 mysql mysql 289 Nov 16 22:49 ..
|
-rw-rw---- 1 mysql mysql 65 Nov 16 21:39 db.opt
|
-rw-rw---- 1 mysql mysql 1.2K Nov 16 23:11 partest.frm
|
-rw-rw---- 1 mysql mysql 44 Nov 16 23:11 partest.par
|
-rw-rw---- 1 mysql mysql 96K Nov 16 23:09 partest#P#p0.ibd
|
-rw-rw---- 1 mysql mysql 96K Nov 16 23:09 partest#P#p1.ibd
|
-rw-rw---- 1 mysql mysql 96K Nov 16 23:09 partest#P#pFFFF.ibd
|