[ Avaa Bypassed ]




Upload:

Command:

hmhc3928@18.222.91.173: ~ $
SET default_storage_engine=MyISAM;
#
# CREATE a table with SUBPARTITIONS
#
CREATE TABLE emp (
id INT NOT NULL,
store_name VARCHAR(30),
parts VARCHAR(30),
store_id INT
) engine MyISAM
PARTITION BY RANGE(store_id) SUBPARTITION BY HASH(store_id)
(
PARTITION northeast VALUES LESS THAN (50)
DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_northeast'
    INDEX 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'
    INDEX 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=MyISAM 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' INDEX DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_northeast' ENGINE = MyISAM,
  SUBPARTITION ne1 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_northeast' INDEX DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_northeast' ENGINE = MyISAM),
 PARTITION southwest VALUES LESS THAN (100)
 (SUBPARTITION sw2 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_southwest' INDEX DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_southwest' ENGINE = MyISAM,
  SUBPARTITION sw3 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_southwest' INDEX DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_southwest' ENGINE = MyISAM)) */
---- MYSQLD_DATADIR/test
emp#P#northeast#SP#ne0.MYD
emp#P#northeast#SP#ne0.MYI
emp#P#northeast#SP#ne1.MYD
emp#P#northeast#SP#ne1.MYI
emp#P#southwest#SP#sw2.MYD
emp#P#southwest#SP#sw2.MYI
emp#P#southwest#SP#sw3.MYD
emp#P#southwest#SP#sw3.MYI
emp.frm
emp.par
---- MYSQL_TMP_DIR/alt_dir_northeast
emp#P#northeast#SP#ne0.MYD
emp#P#northeast#SP#ne0.MYI
emp#P#northeast#SP#ne1.MYD
emp#P#northeast#SP#ne1.MYI
---- MYSQL_TMP_DIR/alt_dir_southwest
emp#P#southwest#SP#sw2.MYD
emp#P#southwest#SP#sw2.MYI
emp#P#southwest#SP#sw3.MYD
emp#P#southwest#SP#sw3.MYI
#
# 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'
    INDEX 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'
    INDEX 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'
    INDEX 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'
    INDEX 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=MyISAM 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' INDEX DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_east' ENGINE = MyISAM,
  SUBPARTITION e1 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_east' INDEX DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_east' ENGINE = MyISAM),
 PARTITION north VALUES LESS THAN (50)
 (SUBPARTITION n0 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_north' INDEX DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_north' ENGINE = MyISAM,
  SUBPARTITION n1 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_north' INDEX DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_north' ENGINE = MyISAM),
 PARTITION west VALUES LESS THAN (75)
 (SUBPARTITION w0 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_west' INDEX DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_west' ENGINE = MyISAM,
  SUBPARTITION w1 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_west' INDEX DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_west' ENGINE = MyISAM),
 PARTITION south VALUES LESS THAN (100)
 (SUBPARTITION s0 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_south' INDEX DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_south' ENGINE = MyISAM,
  SUBPARTITION s1 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_south' INDEX DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_south' ENGINE = MyISAM)) */
---- MYSQLD_DATADIR/test
emp#P#east#SP#e0.MYD
emp#P#east#SP#e0.MYI
emp#P#east#SP#e1.MYD
emp#P#east#SP#e1.MYI
emp#P#north#SP#n0.MYD
emp#P#north#SP#n0.MYI
emp#P#north#SP#n1.MYD
emp#P#north#SP#n1.MYI
emp#P#south#SP#s0.MYD
emp#P#south#SP#s0.MYI
emp#P#south#SP#s1.MYD
emp#P#south#SP#s1.MYI
emp#P#west#SP#w0.MYD
emp#P#west#SP#w0.MYI
emp#P#west#SP#w1.MYD
emp#P#west#SP#w1.MYI
emp.frm
emp.par
---- MYSQL_TMP_DIR/alt_dir_northeast
---- MYSQL_TMP_DIR/alt_dir_southwest
---- MYSQL_TMP_DIR/alt_dir_east
emp#P#east#SP#e0.MYD
emp#P#east#SP#e0.MYI
emp#P#east#SP#e1.MYD
emp#P#east#SP#e1.MYI
---- MYSQL_TMP_DIR/alt_dir_north
emp#P#north#SP#n0.MYD
emp#P#north#SP#n0.MYI
emp#P#north#SP#n1.MYD
emp#P#north#SP#n1.MYI
---- MYSQL_TMP_DIR/alt_dir_west
emp#P#west#SP#w0.MYD
emp#P#west#SP#w0.MYI
emp#P#west#SP#w1.MYD
emp#P#west#SP#w1.MYI
---- MYSQL_TMP_DIR/alt_dir_south
emp#P#south#SP#s0.MYD
emp#P#south#SP#s0.MYI
emp#P#south#SP#s1.MYD
emp#P#south#SP#s1.MYI
DROP TABLE emp;
#
# Cleanup
#

Filemanager

Name Type Size Permission Actions
part_blocked_sql_func_innodb.result File 159.68 KB 0644
part_blocked_sql_func_myisam.result File 159.68 KB 0644
part_ctype_utf32.result File 355 B 0644
part_supported_sql_func_innodb.result File 238.66 KB 0644
part_supported_sql_func_myisam.result File 238.66 KB 0644
partition-dml-1-1-innodb-modes.result File 19.2 KB 0644
partition-dml-1-1-innodb.result File 8.38 KB 0644
partition-dml-1-1-myisam-modes.result File 19.2 KB 0644
partition-dml-1-1-myisam.result File 8.38 KB 0644
partition-dml-1-10-innodb.result File 5.37 KB 0644
partition-dml-1-10-myisam.result File 5.29 KB 0644
partition-dml-1-11-innodb.result File 7.08 KB 0644
partition-dml-1-11-myisam.result File 7.08 KB 0644
partition-dml-1-2-innodb.result File 6.11 KB 0644
partition-dml-1-2-myisam.result File 6.11 KB 0644
partition-dml-1-3-innodb.result File 7.27 KB 0644
partition-dml-1-4-innodb.result File 5.5 KB 0644
partition-dml-1-5-innodb.result File 5.52 KB 0644
partition-dml-1-6-innodb.result File 5.52 KB 0644
partition-dml-1-7-innodb.result File 6.96 KB 0644
partition-dml-1-8-innodb.result File 6.94 KB 0644
partition-dml-1-9-innodb.result File 18.38 KB 0644
partition-dml-1-9-myisam.result File 18.38 KB 0644
partition_alter1_1_2_innodb.result File 1020.49 KB 0644
partition_alter1_1_2_myisam.result File 303.96 KB 0644
partition_alter1_1_innodb.result File 596.87 KB 0644
partition_alter1_1_myisam.result File 309.05 KB 0644
partition_alter1_2_innodb.result File 1.26 MB 0644
partition_alter1_2_myisam.result File 539.78 KB 0644
partition_alter2_1_1_innodb.result File 718.67 KB 0644
partition_alter2_1_2_innodb.result File 719.61 KB 0644
partition_alter2_1_myisam.result File 875.52 KB 0644
partition_alter2_2_1_innodb.result File 720.91 KB 0644
partition_alter2_2_2_innodb.result File 725.47 KB 0644
partition_alter2_2_myisam.result File 880.39 KB 0644
partition_alter3_innodb.result File 27.19 KB 0644
partition_alter3_myisam.result File 28.01 KB 0644
partition_alter4_innodb.result File 3.12 MB 0644
partition_alter4_myisam.result File 3.18 MB 0644
partition_auto_increment_archive.result File 21.62 KB 0644
partition_auto_increment_blackhole.result File 24.09 KB 0644
partition_auto_increment_innodb.result File 23.72 KB 0644
partition_auto_increment_memory.result File 23.73 KB 0644
partition_auto_increment_myisam.result File 23.89 KB 0644
partition_basic_innodb.result File 1.11 MB 0644
partition_basic_myisam.result File 566.34 KB 0644
partition_basic_symlink_innodb.result File 4.11 KB 0644
partition_basic_symlink_myisam.result File 753.67 KB 0644
partition_bit_innodb.result File 6.45 KB 0644
partition_bit_myisam.result File 6.45 KB 0644
partition_char_innodb.result File 56.13 KB 0644
partition_char_myisam.result File 56.13 KB 0644
partition_datetime_innodb.result File 37.62 KB 0644
partition_datetime_myisam.result File 37.62 KB 0644
partition_debug.result File 57.71 KB 0644
partition_debug_innodb.result File 243.04 KB 0644
partition_debug_myisam.result File 192.25 KB 0644
partition_debug_sync_innodb.result File 2.56 KB 0644
partition_decimal_innodb.result File 5.53 KB 0644
partition_decimal_myisam.result File 5.54 KB 0644
partition_engine_innodb.result File 182.75 KB 0644
partition_engine_myisam.result File 184.74 KB 0644
partition_exch_innodb.result File 6.52 KB 0644
partition_exch_myisam.result File 6.52 KB 0644
partition_exch_myisam_innodb.result File 484 B 0644
partition_exch_qa.result File 6.52 KB 0644
partition_exch_qa_10.result File 1.67 KB 0644
partition_exch_qa_11.result File 1.36 KB 0644
partition_exch_qa_12.result File 2.4 KB 0644
partition_exch_qa_13.result File 3.87 KB 0644
partition_exch_qa_14.result File 1.32 KB 0644
partition_exch_qa_15.result File 624 B 0644
partition_exch_qa_1_innodb.result File 4.06 KB 0644
partition_exch_qa_1_myisam.result File 4.06 KB 0644
partition_exch_qa_2.result File 3.32 KB 0644
partition_exch_qa_3.result File 644 B 0644
partition_exch_qa_4_innodb.result File 1.48 KB 0644
partition_exch_qa_4_myisam.result File 1.48 KB 0644
partition_exch_qa_5_innodb.result File 3.09 KB 0644
partition_exch_qa_5_myisam.result File 3.09 KB 0644
partition_exch_qa_6.result File 2.93 KB 0644
partition_exch_qa_7_innodb.result File 1.28 KB 0644
partition_exch_qa_7_myisam.result File 1.28 KB 0644
partition_exch_qa_8_innodb.result File 1.88 KB 0644
partition_exch_qa_8_myisam.result File 1.88 KB 0644
partition_exchange_archive.result File 10.41 KB 0644
partition_exchange_blackhole.result File 440 B 0644
partition_exchange_innodb.result File 12.85 KB 0644
partition_exchange_memory.result File 12.85 KB 0644
partition_exchange_myisam.result File 12.85 KB 0644
partition_float_innodb.result File 3.64 KB 0644
partition_float_myisam.result File 3.64 KB 0644
partition_innodb_status_file.result File 439 B 0644
partition_int_innodb.result File 11.66 KB 0644
partition_int_myisam.result File 11.66 KB 0644
partition_max_parts_hash_innodb.result File 1.72 KB 0644
partition_max_parts_hash_myisam.result File 1.72 KB 0644
partition_max_parts_inv_innodb.result File 748.54 KB 0644
partition_max_parts_inv_myisam.result File 748.54 KB 0644
partition_max_parts_key_innodb.result File 1.64 KB 0644
partition_max_parts_key_myisam.result File 1.64 KB 0644
partition_max_parts_list_innodb.result File 413.37 KB 0644
partition_max_parts_list_myisam.result File 413.37 KB 0644
partition_max_parts_range_innodb.result File 335 KB 0644
partition_max_parts_range_myisam.result File 335 KB 0644
partition_max_sub_parts_key_list_innodb.result File 201.48 KB 0644
partition_max_sub_parts_key_list_myisam.result File 201.48 KB 0644
partition_max_sub_parts_key_range_innodb.result File 167.07 KB 0644
partition_max_sub_parts_key_range_myisam.result File 167.07 KB 0644
partition_max_sub_parts_list_innodb.result File 201.46 KB 0644
partition_max_sub_parts_list_myisam.result File 201.46 KB 0644
partition_max_sub_parts_range_innodb.result File 167.04 KB 0644
partition_max_sub_parts_range_myisam.result File 167.04 KB 0644
partition_mgm_lc0_archive.result File 19.6 KB 0644
partition_mgm_lc0_innodb.result File 24.07 KB 0644
partition_mgm_lc0_memory.result File 24.12 KB 0644
partition_mgm_lc0_myisam.result File 24.07 KB 0644
partition_mgm_lc1_archive.result File 19.99 KB 0644
partition_mgm_lc1_innodb.result File 24.47 KB 0644
partition_mgm_lc1_memory.result File 24.52 KB 0644
partition_mgm_lc1_myisam.result File 24.47 KB 0644
partition_mgm_lc2_archive.result File 19.99 KB 0644
partition_mgm_lc2_innodb.result File 24.47 KB 0644
partition_mgm_lc2_memory.result File 24.52 KB 0644
partition_mgm_lc2_myisam.result File 24.47 KB 0644
partition_recover_myisam.result File 1.71 KB 0644
partition_reorganize_innodb.result File 7.06 KB 0644
partition_reorganize_myisam.result File 5.72 KB 0644
partition_repair_myisam.result File 16.07 KB 0644
partition_special_innodb.result File 18.36 KB 0644
partition_special_myisam.result File 14.85 KB 0644
partition_syntax_innodb.result File 61.36 KB 0644
partition_syntax_myisam.result File 62.92 KB 0644
partition_t55.out File 4.5 KB 0644
partition_value_innodb.result File 7.36 KB 0644
partition_value_myisam.result File 7.36 KB 0644
rpl-partition-dml-1-1-innodb.result File 6.78 KB 0644
rpl-partition-dml-1-1-myisam.result File 6.78 KB 0644
rpl_partition.result File 5.51 KB 0644