403Webshell
Server IP : 104.21.38.3  /  Your IP : 108.162.226.252
Web Server : Apache
System : Linux krdc-ubuntu-s-2vcpu-4gb-amd-blr1-01.localdomain 5.15.0-142-generic #152-Ubuntu SMP Mon May 19 10:54:31 UTC 2025 x86_64
User : www ( 1000)
PHP Version : 7.4.33
Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : OFF  |  Sudo : ON  |  Pkexec : ON
Directory :  /www/server/mysql/src/mysql-test/suite/parts/r/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ Back ]     

Current File : /www/server/mysql/src/mysql-test/suite/parts/r/partition_reorganize_innodb.result
SET default_storage_engine=InnoDB;
SET SESSION innodb_strict_mode = ON;
SET GLOBAL innodb_file_per_table=ON;
#
# CREATE a table with SUBPARTITIONS
#
CREATE TABLE emp (
id INT NOT NULL,
store_name VARCHAR(30),
parts VARCHAR(30),
store_id INT
) engine InnoDB
PARTITION BY RANGE(store_id) SUBPARTITION BY HASH(store_id)
(
PARTITION northeast VALUES LESS THAN (50)
DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_northeast'
    (SUBPARTITION ne0, SUBPARTITION ne1),
PARTITION southwest VALUES LESS THAN (100)
DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_southwest'
    (SUBPARTITION sw2, SUBPARTITION sw3)
);
INSERT INTO emp values(1,'Oracle','NUT',10);
INSERT INTO emp values(2,'SAP','BOLT',40);
INSERT INTO emp values(3,'IBM','NAIL',60);
INSERT INTO emp values(4,'SUN','SCREW',90);
SELECT * FROM emp;
id	store_name	parts	store_id
1	Oracle	NUT	10
2	SAP	BOLT	40
3	IBM	NAIL	60
4	SUN	SCREW	90
SHOW CREATE TABLE emp;
Table	Create Table
emp	CREATE TABLE `emp` (
  `id` int(11) NOT NULL,
  `store_name` varchar(30) DEFAULT NULL,
  `parts` varchar(30) DEFAULT NULL,
  `store_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1
/*!50100 PARTITION BY RANGE (store_id)
SUBPARTITION BY HASH (store_id)
(PARTITION northeast VALUES LESS THAN (50)
 (SUBPARTITION ne0 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_northeast/' ENGINE = InnoDB,
  SUBPARTITION ne1 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_northeast/' ENGINE = InnoDB),
 PARTITION southwest VALUES LESS THAN (100)
 (SUBPARTITION sw2 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_southwest/' ENGINE = InnoDB,
  SUBPARTITION sw3 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_southwest/' ENGINE = InnoDB)) */
=== information_schema.innodb_sys_tables  and innodb_sys_tablespaces ===
Table Name	Tablespace	Table Flags	Columns	Row Format	Zip Size	Space Type
test/emp#p#northeast#sp#ne0	test/emp#p#northeast#sp#ne0	97	7	Dynamic	0	Single
test/emp#p#northeast#sp#ne1	test/emp#p#northeast#sp#ne1	97	7	Dynamic	0	Single
test/emp#p#southwest#sp#sw2	test/emp#p#southwest#sp#sw2	97	7	Dynamic	0	Single
test/emp#p#southwest#sp#sw3	test/emp#p#southwest#sp#sw3	97	7	Dynamic	0	Single
=== information_schema.innodb_sys_tablespaces and innodb_sys_datafiles ===
Space_Name	Space_Type	Page_Size	Zip_Size	Formats_Permitted	Path
test/emp#p#northeast#sp#ne0	Single	DEFAULT	0	Dynamic	MYSQL_TMP_DIR/alt_dir_northeast/test/emp#p#northeast#sp#ne0.ibd
test/emp#p#northeast#sp#ne1	Single	DEFAULT	0	Dynamic	MYSQL_TMP_DIR/alt_dir_northeast/test/emp#p#northeast#sp#ne1.ibd
test/emp#p#southwest#sp#sw2	Single	DEFAULT	0	Dynamic	MYSQL_TMP_DIR/alt_dir_southwest/test/emp#p#southwest#sp#sw2.ibd
test/emp#p#southwest#sp#sw3	Single	DEFAULT	0	Dynamic	MYSQL_TMP_DIR/alt_dir_southwest/test/emp#p#southwest#sp#sw3.ibd
=== information_schema.files ===
Space_Name	File_Type	Engine	Status	Tablespace_Name	Path
test/emp#p#northeast#sp#ne0	TABLESPACE	InnoDB	NORMAL	innodb_file_per_table.##	MYSQL_TMP_DIR/alt_dir_northeast/test/emp#p#northeast#sp#ne0.ibd
test/emp#p#northeast#sp#ne1	TABLESPACE	InnoDB	NORMAL	innodb_file_per_table.##	MYSQL_TMP_DIR/alt_dir_northeast/test/emp#p#northeast#sp#ne1.ibd
test/emp#p#southwest#sp#sw2	TABLESPACE	InnoDB	NORMAL	innodb_file_per_table.##	MYSQL_TMP_DIR/alt_dir_southwest/test/emp#p#southwest#sp#sw2.ibd
test/emp#p#southwest#sp#sw3	TABLESPACE	InnoDB	NORMAL	innodb_file_per_table.##	MYSQL_TMP_DIR/alt_dir_southwest/test/emp#p#southwest#sp#sw3.ibd
---- MYSQLD_DATADIR/test
emp#p#northeast#sp#ne0.isl
emp#p#northeast#sp#ne1.isl
emp#p#southwest#sp#sw2.isl
emp#p#southwest#sp#sw3.isl
emp.frm
---- MYSQL_TMP_DIR/alt_dir_northeast/test
emp#p#northeast#sp#ne0.ibd
emp#p#northeast#sp#ne1.ibd
---- MYSQL_TMP_DIR/alt_dir_southwest/test
emp#p#southwest#sp#sw2.ibd
emp#p#southwest#sp#sw3.ibd
#
# REORGANIZE the PARTITIONS and SUBPARTITIONS
#
ALTER TABLE emp REORGANIZE PARTITION northeast INTO
(
PARTITION east VALUES LESS THAN (25)
DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_east'
    (SUBPARTITION e0, SUBPARTITION e1),
PARTITION north VALUES LESS THAN (50)
DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_north'
    (SUBPARTITION n0, SUBPARTITION n1)
);
ALTER TABLE emp REORGANIZE PARTITION southwest INTO
(
PARTITION west VALUES LESS THAN (75)
DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_west'
    (SUBPARTITION w0, SUBPARTITION w1),
PARTITION south VALUES LESS THAN (100)
DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_south'
    (SUBPARTITION s0, SUBPARTITION s1)
);
SELECT * FROM emp;
id	store_name	parts	store_id
1	Oracle	NUT	10
2	SAP	BOLT	40
3	IBM	NAIL	60
4	SUN	SCREW	90
SHOW CREATE TABLE emp;
Table	Create Table
emp	CREATE TABLE `emp` (
  `id` int(11) NOT NULL,
  `store_name` varchar(30) DEFAULT NULL,
  `parts` varchar(30) DEFAULT NULL,
  `store_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1
/*!50100 PARTITION BY RANGE (store_id)
SUBPARTITION BY HASH (store_id)
(PARTITION east VALUES LESS THAN (25)
 (SUBPARTITION e0 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_east' ENGINE = InnoDB,
  SUBPARTITION e1 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_east' ENGINE = InnoDB),
 PARTITION north VALUES LESS THAN (50)
 (SUBPARTITION n0 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_north' ENGINE = InnoDB,
  SUBPARTITION n1 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_north' ENGINE = InnoDB),
 PARTITION west VALUES LESS THAN (75)
 (SUBPARTITION w0 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_west' ENGINE = InnoDB,
  SUBPARTITION w1 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_west' ENGINE = InnoDB),
 PARTITION south VALUES LESS THAN (100)
 (SUBPARTITION s0 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_south' ENGINE = InnoDB,
  SUBPARTITION s1 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_south' ENGINE = InnoDB)) */
=== information_schema.innodb_sys_tables  and innodb_sys_tablespaces ===
Table Name	Tablespace	Table Flags	Columns	Row Format	Zip Size	Space Type
test/emp#p#east#sp#e0	test/emp#p#east#sp#e0	97	7	Dynamic	0	Single
test/emp#p#east#sp#e1	test/emp#p#east#sp#e1	97	7	Dynamic	0	Single
test/emp#p#north#sp#n0	test/emp#p#north#sp#n0	97	7	Dynamic	0	Single
test/emp#p#north#sp#n1	test/emp#p#north#sp#n1	97	7	Dynamic	0	Single
test/emp#p#south#sp#s0	test/emp#p#south#sp#s0	97	7	Dynamic	0	Single
test/emp#p#south#sp#s1	test/emp#p#south#sp#s1	97	7	Dynamic	0	Single
test/emp#p#west#sp#w0	test/emp#p#west#sp#w0	97	7	Dynamic	0	Single
test/emp#p#west#sp#w1	test/emp#p#west#sp#w1	97	7	Dynamic	0	Single
=== information_schema.innodb_sys_tablespaces and innodb_sys_datafiles ===
Space_Name	Space_Type	Page_Size	Zip_Size	Formats_Permitted	Path
test/emp#p#east#sp#e0	Single	DEFAULT	0	Dynamic	MYSQL_TMP_DIR/alt_dir_east/test/emp#p#east#sp#e0.ibd
test/emp#p#east#sp#e1	Single	DEFAULT	0	Dynamic	MYSQL_TMP_DIR/alt_dir_east/test/emp#p#east#sp#e1.ibd
test/emp#p#north#sp#n0	Single	DEFAULT	0	Dynamic	MYSQL_TMP_DIR/alt_dir_north/test/emp#p#north#sp#n0.ibd
test/emp#p#north#sp#n1	Single	DEFAULT	0	Dynamic	MYSQL_TMP_DIR/alt_dir_north/test/emp#p#north#sp#n1.ibd
test/emp#p#west#sp#w0	Single	DEFAULT	0	Dynamic	MYSQL_TMP_DIR/alt_dir_west/test/emp#p#west#sp#w0.ibd
test/emp#p#west#sp#w1	Single	DEFAULT	0	Dynamic	MYSQL_TMP_DIR/alt_dir_west/test/emp#p#west#sp#w1.ibd
test/emp#p#south#sp#s0	Single	DEFAULT	0	Dynamic	MYSQL_TMP_DIR/alt_dir_south/test/emp#p#south#sp#s0.ibd
test/emp#p#south#sp#s1	Single	DEFAULT	0	Dynamic	MYSQL_TMP_DIR/alt_dir_south/test/emp#p#south#sp#s1.ibd
=== information_schema.files ===
Space_Name	File_Type	Engine	Status	Tablespace_Name	Path
test/emp#p#east#sp#e0	TABLESPACE	InnoDB	NORMAL	innodb_file_per_table.##	MYSQL_TMP_DIR/alt_dir_east/test/emp#p#east#sp#e0.ibd
test/emp#p#east#sp#e1	TABLESPACE	InnoDB	NORMAL	innodb_file_per_table.##	MYSQL_TMP_DIR/alt_dir_east/test/emp#p#east#sp#e1.ibd
test/emp#p#north#sp#n0	TABLESPACE	InnoDB	NORMAL	innodb_file_per_table.##	MYSQL_TMP_DIR/alt_dir_north/test/emp#p#north#sp#n0.ibd
test/emp#p#north#sp#n1	TABLESPACE	InnoDB	NORMAL	innodb_file_per_table.##	MYSQL_TMP_DIR/alt_dir_north/test/emp#p#north#sp#n1.ibd
test/emp#p#west#sp#w0	TABLESPACE	InnoDB	NORMAL	innodb_file_per_table.##	MYSQL_TMP_DIR/alt_dir_west/test/emp#p#west#sp#w0.ibd
test/emp#p#west#sp#w1	TABLESPACE	InnoDB	NORMAL	innodb_file_per_table.##	MYSQL_TMP_DIR/alt_dir_west/test/emp#p#west#sp#w1.ibd
test/emp#p#south#sp#s0	TABLESPACE	InnoDB	NORMAL	innodb_file_per_table.##	MYSQL_TMP_DIR/alt_dir_south/test/emp#p#south#sp#s0.ibd
test/emp#p#south#sp#s1	TABLESPACE	InnoDB	NORMAL	innodb_file_per_table.##	MYSQL_TMP_DIR/alt_dir_south/test/emp#p#south#sp#s1.ibd
---- MYSQLD_DATADIR/test
emp#p#east#sp#e0.isl
emp#p#east#sp#e1.isl
emp#p#north#sp#n0.isl
emp#p#north#sp#n1.isl
emp#p#south#sp#s0.isl
emp#p#south#sp#s1.isl
emp#p#west#sp#w0.isl
emp#p#west#sp#w1.isl
emp.frm
---- MYSQL_TMP_DIR/alt_dir_northeast/test
---- MYSQL_TMP_DIR/alt_dir_southwest/test
---- MYSQL_TMP_DIR/alt_dir_east/test
emp#p#east#sp#e0.ibd
emp#p#east#sp#e1.ibd
---- MYSQL_TMP_DIR/alt_dir_north/test
emp#p#north#sp#n0.ibd
emp#p#north#sp#n1.ibd
---- MYSQL_TMP_DIR/alt_dir_west/test
emp#p#west#sp#w0.ibd
emp#p#west#sp#w1.ibd
---- MYSQL_TMP_DIR/alt_dir_south/test
emp#p#south#sp#s0.ibd
emp#p#south#sp#s1.ibd
DROP TABLE emp;
#
# Cleanup
#

Youez - 2016 - github.com/yon3zu
LinuXploit