Linux ip-172-26-2-223 5.4.0-1018-aws #18-Ubuntu SMP Wed Jun 24 01:15:00 UTC 2020 x86_64
Apache
: 172.26.2.223 | : 13.59.196.41
Cant Read [ /etc/named.conf ]
8.1.13
www
www.github.com/MadExploits
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
UNLOCK SHELL
HASH IDENTIFIER
CPANEL RESET
CREATE WP USER
BLACK DEFEND!
README
+ Create Folder
+ Create File
/
www /
server /
mysql /
mysql-test /
suite /
innodb /
r /
[ HOME SHELL ]
Name
Size
Permission
Action
add_foreign_key.result
1.28
KB
-rw-r--r--
alter_crash.result
4.43
KB
-rw-r--r--
alter_foreign_crash.result
751
B
-rw-r--r--
alter_kill.result
2.42
KB
-rw-r--r--
alter_missing_tablespace.resul...
1.46
KB
-rw-r--r--
alter_page_size.result
1.14
KB
-rw-r--r--
alter_rename_existing.result
5.32
KB
-rw-r--r--
alter_rename_files.result
557
B
-rw-r--r--
alter_row_format.result
1.59
KB
-rw-r--r--
alter_table_redundant.result
278
B
-rw-r--r--
alter_table_stage_progress.res...
942
B
-rw-r--r--
analyze_index.result
705
B
-rw-r--r--
analyze_table.result
538
B
-rw-r--r--
attachable_trx.result
2.48
KB
-rw-r--r--
autoinc_debug.result
2.53
KB
-rw-r--r--
blob-crash-16k.result
2.1
KB
-rw-r--r--
blob-crash-4k.result
2.1
KB
-rw-r--r--
blob-crash.result
4.59
KB
-rw-r--r--
blob-update-debug.result
489
B
-rw-r--r--
blob_page_reserve.result
3.81
KB
-rw-r--r--
blob_redo.result
1.05
KB
-rw-r--r--
buf_pool_resize_oom.result
493
B
-rw-r--r--
bulk_create_index_online.resul...
1.21
KB
-rw-r--r--
cascade_lock_wait.result
1.52
KB
-rw-r--r--
check_ibd_filesize_16k.result
1.58
KB
-rw-r--r--
check_sector_size.result
276
B
-rw-r--r--
checksum.result
331
B
-rw-r--r--
cmp_per_index.result
2.96
KB
-rw-r--r--
crc32_endianness.result
540
B
-rw-r--r--
create-index.result
283
B
-rw-r--r--
create_isl_with_direct.result
328
B
-rw-r--r--
create_table.result
1.97
KB
-rw-r--r--
create_tablespace.result
81.15
KB
-rw-r--r--
create_tablespace_16k.result
69.23
KB
-rw-r--r--
create_tablespace_32k.result
7.33
KB
-rw-r--r--
create_tablespace_4k.result
36.13
KB
-rw-r--r--
create_tablespace_64k.result
7.64
KB
-rw-r--r--
create_tablespace_8k.result
50.53
KB
-rw-r--r--
create_tablespace_debug.result
5.02
KB
-rw-r--r--
create_tablespace_notembedded....
692
B
-rw-r--r--
create_tablespace_partition.re...
33.17
KB
-rw-r--r--
create_tablespace_replication....
2.02
KB
-rw-r--r--
deadlock_detect.result
562
B
-rw-r--r--
default_row_format.result
17.56
KB
-rw-r--r--
default_row_format_16k.result
17.91
KB
-rw-r--r--
default_row_format_compatibili...
4.14
KB
-rw-r--r--
default_row_format_tablespace....
8.64
KB
-rw-r--r--
deprecate_part_in_shared_ts.re...
5.87
KB
-rw-r--r--
doublewrite.result
8.1
KB
-rw-r--r--
dropdb.result
222
B
-rw-r--r--
end_range_check.result
3.06
KB
-rw-r--r--
end_range_check_2.result
811
B
-rw-r--r--
events-merge-tmp-path.result
1.33
KB
-rw-r--r--
file_format_defaults.result
2.84
KB
-rw-r--r--
file_format_upgrade_16k.result
420
B
-rw-r--r--
flush-hang.result
1.27
KB
-rw-r--r--
foreign_key.result
9.21
KB
-rw-r--r--
fts_exec_interrupt.result
723
B
-rw-r--r--
help_verbose.result
80
B
-rw-r--r--
high_prio_trx_1.result
505
B
-rw-r--r--
high_prio_trx_2.result
581
B
-rw-r--r--
high_prio_trx_3.result
665
B
-rw-r--r--
high_prio_trx_4.result
711
B
-rw-r--r--
high_prio_trx_5.result
858
B
-rw-r--r--
high_prio_trx_6.result
775
B
-rw-r--r--
high_prio_trx_7.result
5.67
KB
-rw-r--r--
high_prio_trx_commit_crash.res...
1
KB
-rw-r--r--
high_prio_trx_debug.result
1.09
KB
-rw-r--r--
high_prio_trx_fk.result
918
B
-rw-r--r--
high_prio_trx_predicate.result
824
B
-rw-r--r--
high_prio_trx_rpl.result
1.65
KB
-rw-r--r--
i_s_files_debug.result
471
B
-rw-r--r--
ibuf_not_empty.result
969
B
-rw-r--r--
import.result
1.72
KB
-rw-r--r--
import_compress_encrypt.result
5.28
KB
-rw-r--r--
import_compress_encrypt_upgrad...
2.53
KB
-rw-r--r--
import_export_4k.result
724
B
-rw-r--r--
import_tablespace_page_corrupt...
555
B
-rw-r--r--
import_tablespace_schema_missm...
2.11
KB
-rw-r--r--
import_update_stats.result
2.86
KB
-rw-r--r--
index-online-norebuild.result
897
B
-rw-r--r--
index_length.result
1.28
KB
-rw-r--r--
index_merge_threshold.result
54.7
KB
-rw-r--r--
index_tree_operation.result
1.65
KB
-rw-r--r--
innodb-2byte-collation.result
3.28
KB
-rw-r--r--
innodb-ac-non-locking-select.r...
861
B
-rw-r--r--
innodb-alter-autoinc.result
4.27
KB
-rw-r--r--
innodb-alter-debug-wl6554.resu...
12.79
KB
-rw-r--r--
innodb-alter-debug.result
2.64
KB
-rw-r--r--
innodb-alter-nullable.result
1.52
KB
-rw-r--r--
innodb-alter-wl6554.result
3.13
KB
-rw-r--r--
innodb-alter.result
30.33
KB
-rw-r--r--
innodb-analyze.result
58
B
-rw-r--r--
innodb-autoinc-18274.result
805
B
-rw-r--r--
innodb-autoinc-44030.result
732
B
-rw-r--r--
innodb-autoinc-56228.result
847
B
-rw-r--r--
innodb-autoinc-optimize.result
321
B
-rw-r--r--
innodb-autoinc.result
41.48
KB
-rw-r--r--
innodb-blob.result
4.91
KB
-rw-r--r--
innodb-bug-14068765.result
2.81
KB
-rw-r--r--
innodb-bug-14084530.result
701
B
-rw-r--r--
innodb-bug12552164.result
1.73
KB
-rw-r--r--
innodb-bug14219515.result
244
B
-rw-r--r--
innodb-change-buffer-recovery....
1.08
KB
-rw-r--r--
innodb-consistent.result
670
B
-rw-r--r--
innodb-import-partition-rpl.re...
2.46
KB
-rw-r--r--
innodb-import-partition.result
40.01
KB
-rw-r--r--
innodb-index-debug.result
13.64
KB
-rw-r--r--
innodb-index-online-delete.res...
642
B
-rw-r--r--
innodb-index-online-fk.result
26.4
KB
-rw-r--r--
innodb-index-online-purge.resu...
1.2
KB
-rw-r--r--
innodb-index-online.result
13.35
KB
-rw-r--r--
innodb-index.result
67.62
KB
-rw-r--r--
innodb-index_ucs2.result
3.62
KB
-rw-r--r--
innodb-isolation.result
43.25
KB
-rw-r--r--
innodb-large-prefix.result
1.27
KB
-rw-r--r--
innodb-lock-inherit-read_commi...
4.18
KB
-rw-r--r--
innodb-lock.result
3.22
KB
-rw-r--r--
innodb-multiple-tablespaces.re...
14.79
KB
-rw-r--r--
innodb-read-view.result
2.73
KB
-rw-r--r--
innodb-replace-debug.result
309
B
-rw-r--r--
innodb-semi-consistent.result
1.35
KB
-rw-r--r--
innodb-status-output.result
1.3
KB
-rw-r--r--
innodb-system-table-view.resul...
9.07
KB
-rw-r--r--
innodb-table-online.result
13.11
KB
-rw-r--r--
innodb-timeout.result
953
B
-rw-r--r--
innodb-truncate-debug.result
4.46
KB
-rw-r--r--
innodb-truncate.result
2.28
KB
-rw-r--r--
innodb-ucs2.result
15.38
KB
-rw-r--r--
innodb-update-insert.result
1.1
KB
-rw-r--r--
innodb-wl5522-1.result
29.45
KB
-rw-r--r--
innodb-wl5522-debug.result
30.05
KB
-rw-r--r--
innodb-wl5522.result
20.99
KB
-rw-r--r--
innodb-wl5980-alter.result
38.86
KB
-rw-r--r--
innodb-wl5980-debug.result
1.33
KB
-rw-r--r--
innodb-wl5980-discard.result
29.2
KB
-rw-r--r--
innodb-wl5980-linux.result
9.7
KB
-rw-r--r--
innodb-wl5980-windows.result
10.07
KB
-rw-r--r--
innodb-wl6045-1.result
3.72
KB
-rw-r--r--
innodb-wl6045-linux.result
11.11
KB
-rw-r--r--
innodb-wl6445-1.result
69
KB
-rw-r--r--
innodb-wl6445-2.result
3.57
KB
-rw-r--r--
innodb-wl6445.result
1.78
KB
-rw-r--r--
innodb.result
108.76
KB
-rw-r--r--
innodb_32k.result
3.25
KB
-rw-r--r--
innodb_64k.result
3.47
KB
-rw-r--r--
innodb_autoinc_lock_mode_zero....
1.22
KB
-rw-r--r--
innodb_autoinc_reset.result
423
B
-rw-r--r--
innodb_buffer_pool_dump_pct.re...
1.49
KB
-rw-r--r--
innodb_buffer_pool_load.result
2.02
KB
-rw-r--r--
innodb_buffer_pool_load_now.re...
1.6
KB
-rw-r--r--
innodb_buffer_pool_resize.resu...
1.29
KB
-rw-r--r--
innodb_buffer_pool_resize_debu...
3.24
KB
-rw-r--r--
innodb_buffer_pool_resize_with...
1.08
KB
-rw-r--r--
innodb_bug-13628249.result
988
B
-rw-r--r--
innodb_bug11754376.result
180
B
-rw-r--r--
innodb_bug11766634.result
396
B
-rw-r--r--
innodb_bug11789106.result
404
B
-rw-r--r--
innodb_bug11933790.result
135
B
-rw-r--r--
innodb_bug12400341.result
966
B
-rw-r--r--
innodb_bug12429573.result
708
B
-rw-r--r--
innodb_bug12661768.result
524
B
-rw-r--r--
innodb_bug14006907.result
934
B
-rw-r--r--
innodb_bug14007109.result
223
B
-rw-r--r--
innodb_bug14007649.result
1.17
KB
-rw-r--r--
innodb_bug14147491.result
730
B
-rw-r--r--
innodb_bug14169459.result
1.48
KB
-rw-r--r--
innodb_bug14676111.result
1.99
KB
-rw-r--r--
innodb_bug14704286.result
1.12
KB
-rw-r--r--
innodb_bug19164038.result
1023
B
-rw-r--r--
innodb_bug21704.result
2.65
KB
-rw-r--r--
innodb_bug30113362.result
2.95
KB
-rw-r--r--
innodb_bug30423.result
3.79
KB
-rw-r--r--
innodb_bug30594501.result
317
B
-rw-r--r--
innodb_bug30919.result
17.44
KB
-rw-r--r--
innodb_bug31205266.result
798
B
-rw-r--r--
innodb_bug34053.result
35
B
-rw-r--r--
innodb_bug34300.result
439
B
-rw-r--r--
innodb_bug35220.result
35
B
-rw-r--r--
innodb_bug38231.result
35
B
-rw-r--r--
innodb_bug39438.result
35
B
-rw-r--r--
innodb_bug40360.result
274
B
-rw-r--r--
innodb_bug40565.result
311
B
-rw-r--r--
innodb_bug41904.result
195
B
-rw-r--r--
innodb_bug42101-nonzero.result
810
B
-rw-r--r--
innodb_bug42101.result
704
B
-rw-r--r--
innodb_bug42419.result
858
B
-rw-r--r--
innodb_bug44032.result
313
B
-rw-r--r--
innodb_bug44369.result
300
B
-rw-r--r--
innodb_bug44571.result
334
B
-rw-r--r--
innodb_bug45357.result
290
B
-rw-r--r--
innodb_bug46000.result
906
B
-rw-r--r--
innodb_bug46676.result
362
B
-rw-r--r--
innodb_bug47167.result
1.51
KB
-rw-r--r--
innodb_bug47621.result
777
B
-rw-r--r--
innodb_bug47622.result
748
B
-rw-r--r--
innodb_bug47777.result
612
B
-rw-r--r--
innodb_bug48024.result
592
B
-rw-r--r--
innodb_bug49164.result
913
B
-rw-r--r--
innodb_bug51378.result
2.19
KB
-rw-r--r--
innodb_bug51920.result
316
B
-rw-r--r--
innodb_bug52199.result
175
B
-rw-r--r--
innodb_bug52663.result
857
B
-rw-r--r--
innodb_bug53046.result
1016
B
-rw-r--r--
innodb_bug53290.result
771
B
-rw-r--r--
innodb_bug53592.result
1.9
KB
-rw-r--r--
innodb_bug53674.result
234
B
-rw-r--r--
innodb_bug53756.result
3.62
KB
-rw-r--r--
innodb_bug54044.result
678
B
-rw-r--r--
innodb_bug56143.result
73.71
KB
-rw-r--r--
innodb_bug56716.result
168
B
-rw-r--r--
innodb_bug56947.result
406
B
-rw-r--r--
innodb_bug57252.result
89
B
-rw-r--r--
innodb_bug57255.result
501
B
-rw-r--r--
innodb_bug57904.result
1.3
KB
-rw-r--r--
innodb_bug59307.result
483
B
-rw-r--r--
innodb_bug59410.result
529
B
-rw-r--r--
innodb_bug59641.result
927
B
-rw-r--r--
innodb_bug59733.result
822
B
-rw-r--r--
innodb_bug60049.result
258
B
-rw-r--r--
innodb_bug60196.result
2.86
KB
-rw-r--r--
innodb_bug60229.result
955
B
-rw-r--r--
innodb_bug70867.result
126
B
-rw-r--r--
innodb_bulk_create_index.resul...
29.62
KB
-rw-r--r--
innodb_bulk_create_index_debug...
11.38
KB
-rw-r--r--
innodb_bulk_create_index_flush...
1.46
KB
-rw-r--r--
innodb_bulk_create_index_repli...
5.82
KB
-rw-r--r--
innodb_bulk_create_index_small...
4.26
KB
-rw-r--r--
innodb_corrupt_bit.result
2.61
KB
-rw-r--r--
innodb_corrupt_readonly.result
1011
B
-rw-r--r--
innodb_ctype_ldml.result
27.55
KB
-rw-r--r--
innodb_deadlock_with_autoinc.r...
565
B
-rw-r--r--
innodb_file_format.result
3.11
KB
-rw-r--r--
innodb_file_limit_check.result
457
B
-rw-r--r--
innodb_force_recovery.result
3.7
KB
-rw-r--r--
innodb_fts_limit_check.result
1.04
KB
-rw-r--r--
innodb_high_prio_commit_crash....
1.13
KB
-rw-r--r--
innodb_high_prio_rpl.result
1.07
KB
-rw-r--r--
innodb_i_s_innodb_locks.result
4.89
KB
-rw-r--r--
innodb_i_s_innodb_trx.result
2.85
KB
-rw-r--r--
innodb_information_schema_buff...
2.29
KB
-rw-r--r--
innodb_io_pf.result
407
B
-rw-r--r--
innodb_lock_wait_timeout_1.res...
9.04
KB
-rw-r--r--
innodb_misc1.result
29.29
KB
-rw-r--r--
innodb_multi_update.result
1.62
KB
-rw-r--r--
innodb_mysql.result
95.87
KB
-rw-r--r--
innodb_mysql_rbk.result
629
B
-rw-r--r--
innodb_notembedded.result
637
B
-rw-r--r--
innodb_page_size_func.result
1.49
KB
-rw-r--r--
innodb_pagesize_max_recordsize...
14.37
KB
-rw-r--r--
innodb_prefix_index_check.resu...
1.14
KB
-rw-r--r--
innodb_prefix_index_restart_se...
2.69
KB
-rw-r--r--
innodb_rename_index.result
31.12
KB
-rw-r--r--
innodb_rename_index_err.result
1.81
KB
-rw-r--r--
innodb_replace.result
2.7
KB
-rw-r--r--
innodb_row_log_read.result
867
B
-rw-r--r--
innodb_stats.result
11.62
KB
-rw-r--r--
innodb_stats_auto_recalc.resul...
1.33
KB
-rw-r--r--
innodb_stats_auto_recalc_ddl.r...
1.13
KB
-rw-r--r--
innodb_stats_auto_recalc_lots....
2.07
KB
-rw-r--r--
innodb_stats_auto_recalc_on_no...
2.19
KB
-rw-r--r--
innodb_stats_create_on_corrupt...
705
B
-rw-r--r--
innodb_stats_create_table.resu...
1.1
KB
-rw-r--r--
innodb_stats_del_mark.result
2.81
KB
-rw-r--r--
innodb_stats_drop_locked.resul...
1.55
KB
-rw-r--r--
innodb_stats_external_pages.re...
880
B
-rw-r--r--
innodb_stats_fetch.result
3.35
KB
-rw-r--r--
innodb_stats_fetch_corrupted.r...
1.01
KB
-rw-r--r--
innodb_stats_fetch_nonexistent...
980
B
-rw-r--r--
innodb_stats_flag_global_off.r...
7.36
KB
-rw-r--r--
innodb_stats_flag_global_on.re...
7.36
KB
-rw-r--r--
innodb_stats_rename_table.resu...
1.48
KB
-rw-r--r--
innodb_stats_rename_table_if_e...
1.89
KB
-rw-r--r--
innodb_stats_sample_pages.resu...
1023
B
-rw-r--r--
innodb_stats_table_flag_auto_r...
2.97
KB
-rw-r--r--
innodb_stats_table_flag_sample...
4.23
KB
-rw-r--r--
innodb_sys_var_valgrind.result
2.35
KB
-rw-r--r--
innodb_tablespace.result
22.76
KB
-rw-r--r--
innodb_tablespace_zip.result
1.13
KB
-rw-r--r--
innodb_thread_concurrency_debu...
824
B
-rw-r--r--
innodb_timeout_rollback.result
570
B
-rw-r--r--
innodb_trx_weight.result
35
B
-rw-r--r--
innodb_upd_stats_if_needed_not...
466
B
-rw-r--r--
innodb_ut_format_name.result
140
B
-rw-r--r--
innodb_wl6326.result
10.95
KB
-rw-r--r--
innodb_wl6326_big.result
17.67
KB
-rw-r--r--
innodb_wl6469_1.result
1.48
KB
-rw-r--r--
innodb_wl6469_debug.result
1.63
KB
-rw-r--r--
innodb_wl6470.result
3.11
KB
-rw-r--r--
innodb_wl6470_debug.result
1.42
KB
-rw-r--r--
innodb_wl6501_crash_1.result
15.37
KB
-rw-r--r--
innodb_wl6501_crash_2.result
15.37
KB
-rw-r--r--
innodb_wl6501_crash_6.result
13.07
KB
-rw-r--r--
innodb_wl6501_crash_7.result
13.07
KB
-rw-r--r--
innodb_wl6501_crash_8.result
468
B
-rw-r--r--
innodb_wl6560_1.result
7.27
KB
-rw-r--r--
innodb_wl6560_debug.result
3.36
KB
-rw-r--r--
innodb_wl6915.result
3.99
KB
-rw-r--r--
innodb_wl6915_debug.result
2.88
KB
-rw-r--r--
innodb_wl8114.result
1.78
KB
-rw-r--r--
insert_debug.result
956
B
-rw-r--r--
iodku.result
6.34
KB
-rw-r--r--
iodku_debug.result
2.71
KB
-rw-r--r--
log_alter_table.result
521
B
-rw-r--r--
log_corruption.result
843
B
-rw-r--r--
log_file.result
4.84
KB
-rw-r--r--
log_file_name.result
1.55
KB
-rw-r--r--
log_file_name_debug.result
345
B
-rw-r--r--
log_file_size.result
1.09
KB
-rw-r--r--
log_file_size_1.result
4.85
KB
-rw-r--r--
log_file_size_checkpoint.resul...
106
B
-rw-r--r--
missing_tablespaces.result
664
B
-rw-r--r--
monitor.result
23.64
KB
-rw-r--r--
monitor_restart.result
324
B
-rw-r--r--
mysqldump_max_recordsize.resul...
8.78
KB
-rw-r--r--
optimizer_temporary_table.resu...
114.72
KB
-rw-r--r--
page_reorganize.result
638
B
-rw-r--r--
partition-blob.result
1.53
KB
-rw-r--r--
partition-upgrade.result
33.24
KB
-rw-r--r--
partition.result
39.54
KB
-rw-r--r--
readahead.result
398
B
-rw-r--r--
readonly.result
713
B
-rw-r--r--
records_in_range.result
35.31
KB
-rw-r--r--
redo_log_during_checkpoint.res...
827
B
-rw-r--r--
rename_table.result
890
B
-rw-r--r--
row_format_redundant.result
1.71
KB
-rw-r--r--
sp_temp_table.result
5.72
KB
-rw-r--r--
stored_fk.result
3.52
KB
-rw-r--r--
strict_checksum.result
1.02
KB
-rw-r--r--
strict_mode.result
3.54
KB
-rw-r--r--
sys_tablestats.result
571
B
-rw-r--r--
table_compress.result
25.4
KB
-rw-r--r--
table_encrypt_1.result
6.82
KB
-rw-r--r--
table_encrypt_2.result
3.44
KB
-rw-r--r--
table_encrypt_3.result
66.48
KB
-rw-r--r--
table_encrypt_4.result
3.64
KB
-rw-r--r--
table_encrypt_5.result
56.6
KB
-rw-r--r--
table_encrypt_debug.result
3.22
KB
-rw-r--r--
table_encrypt_fts.result
1.7
KB
-rw-r--r--
table_encrypt_kill.result
7.59
KB
-rw-r--r--
table_encryption.result
3.42
KB
-rw-r--r--
tablespace_crash.result
8.16
KB
-rw-r--r--
tablespace_embedded.result
6.89
KB
-rw-r--r--
tablespace_embedded_windows.re...
6.93
KB
-rw-r--r--
tablespace_per_table.result
21.6
KB
-rw-r--r--
tablespace_per_table_not_windo...
9.11
KB
-rw-r--r--
tablespace_per_table_windows.r...
3.12
KB
-rw-r--r--
tablespace_portability.result
24.68
KB
-rw-r--r--
tablespace_portability_windows...
24.41
KB
-rw-r--r--
timestamp.result
790
B
-rw-r--r--
tinytext-groupby.result
1.33
KB
-rw-r--r--
tmpdir.result
1.8
KB
-rw-r--r--
trx_id_future.result
329
B
-rw-r--r--
undo.result
850
B
-rw-r--r--
update-cascade.result
8.04
KB
-rw-r--r--
update_time.result
1.62
KB
-rw-r--r--
update_time_wl6658.result
8.08
KB
-rw-r--r--
virtual_basic.result
53.55
KB
-rw-r--r--
virtual_blob.result
359
B
-rw-r--r--
virtual_debug.result
53.92
KB
-rw-r--r--
virtual_debug_purge.result
3.98
KB
-rw-r--r--
virtual_fk.result
28.34
KB
-rw-r--r--
virtual_fk_restart.result
1.48
KB
-rw-r--r--
virtual_index.result
7.71
KB
-rw-r--r--
virtual_purge.result
3.95
KB
-rw-r--r--
virtual_stats.result
4.84
KB
-rw-r--r--
xa_prepare_lock_release.result
1.21
KB
-rw-r--r--
xa_recovery.result
381
B
-rw-r--r--
xa_recovery_debug.result
528
B
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : innodb-import-partition.result
SET @old_innodb_file_per_table = @@innodb_file_per_table; SET GLOBAL innodb_file_per_table = 1; SELECT @@innodb_file_per_table; @@innodb_file_per_table 1 # Following testcases are created from JET cases (where import # export instance are different servers) # Here test will be run on same import and export instance. # # case 1 Simple export, discard and import. # CREATE TABLE t1 (c1 INT) ENGINE = InnoDB PARTITION BY HASH(c1) PARTITIONS 3; INSERT INTO t1 VALUES (1),(123),(331); SELECT c1 FROM t1; c1 123 1 331 FLUSH TABLES t1 FOR EXPORT; SELECT * FROM t1 ORDER BY c1; c1 1 123 331 backup: t1#P#p0 backup: t1#P#p1 backup: t1#P#p2 UNLOCK TABLES; DROP TABLE t1; CREATE TABLE t1 (c1 INT) ENGINE = InnoDB PARTITION BY HASH(c1) PARTITIONS 3; ALTER TABLE t1 DISCARD TABLESPACE; restore: t1#P#p0 .ibd and .cfg files restore: t1#P#p1 .ibd and .cfg files restore: t1#P#p2 .ibd and .cfg files ALTER TABLE t1 IMPORT TABLESPACE; SELECT * FROM t1 ORDER BY c1; c1 1 123 331 DROP TABLE t1; # # case 2 With indexes and more datatypes. # CREATE TABLE t1 ( col1 BIT(1), col2 BOOLEAN, col3 TINYINT, col4 SMALLINT, col5 MEDIUMINT, col6 INT, col7 BIGINT, col8 FLOAT (14,3), col9 DOUBLE (14,3), col10 VARCHAR(20), col11 TEXT, col12 ENUM('a','b','c'), col13 TEXT, col14 CHAR(20), col15 VARBINARY (400), col16 BINARY(40), col17 BLOB (400), col18 INT NOT NULL PRIMARY KEY, col19 DATE, col20 DATETIME, col21 TIMESTAMP NULL, col22 TIME, col23 YEAR) ENGINE = InnoDB PARTITION BY RANGE (col18) SUBPARTITION BY HASH (col18) SUBPARTITIONS 3 (PARTITION `First_partition` VALUES LESS THAN (10), PARTITION `Last_partition` VALUES LESS THAN MAXVALUE); CREATE INDEX idx1 ON t1(col18); CREATE INDEX prefix_idx ON t1(col14 (10)); INSERT INTO t1 VALUES (1,1,-128,32767,-8388608,2147483647,-9223372036854775808, 92233720368.222, -92233720368.222,'aaa', + 'aaaaaaaaaa','b','bbbbb','ccccc', REPEAT('d',40),REPEAT('d',40),REPEAT('d',40),1,'1000-01-01', '3000-12-31 23:59:59.99','1990-01-01 00:00:01.00', '01:59:59.00','1901'); INSERT INTO t1 VALUES (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, NULL,NULL,NULL,3,NULL,NULL,NULL,NULL,NULL); INSERT INTO t1 VALUES (NULL,NULL,NULL,NULL,NULL,NULL,NULL, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); ERROR 23000: Column 'col18' cannot be null INSERT INTO t1 VALUES (NULL,NULL,NULL,NULL,NULL,NULL,NULL, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL); ERROR 23000: Duplicate entry '1' for key 'PRIMARY' FLUSH TABLES t1 WITH READ LOCK; SELECT * FROM t1; col1 col2 col3 col4 col5 col6 col7 col8 col9 col10 col11 col12 col13 col14 col15 col16 col17 col18 col19 col20 col21 col22 col23 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 3 NULL NULL NULL NULL NULL 1 -128 32767 -8388608 2147483647 -9223372036854775808 92233719808.000 -92233720368.222 aaa aaaaaaaaaa b bbbbb ccccc dddddddddddddddddddddddddddddddddddddddd dddddddddddddddddddddddddddddddddddddddd dddddddddddddddddddddddddddddddddddddddd 1 1000-01-01 3001-01-01 00:00:00 1990-01-01 00:00:01 01:59:59 1901 backup: t1#P#First_partition#SP#First_partitionsp0 backup: t1#P#First_partition#SP#First_partitionsp1 backup: t1#P#First_partition#SP#First_partitionsp2 backup: t1#P#Last_partition#SP#Last_partitionsp0 backup: t1#P#Last_partition#SP#Last_partitionsp1 backup: t1#P#Last_partition#SP#Last_partitionsp2 UNLOCK TABLES; DROP TABLE t1; CREATE TABLE t1 ( col1 BIT(1), col2 BOOLEAN, col3 TINYINT, col4 SMALLINT, col5 MEDIUMINT, col6 INT, col7 BIGINT, col8 FLOAT (14,3), col9 DOUBLE (14,3), col10 VARCHAR(20), col11 TEXT, col12 ENUM('a','b','c'), col13 TEXT, col14 CHAR(20), col15 VARBINARY (400), col16 BINARY(40), col17 BLOB (400), col18 INT NOT NULL PRIMARY KEY, col19 DATE, col20 DATETIME, col21 TIMESTAMP NULL, col22 TIME, col23 YEAR) ENGINE = InnoDB PARTITION BY RANGE (col18) SUBPARTITION BY HASH (col18) SUBPARTITIONS 3 (PARTITION `First_partition` VALUES LESS THAN (10), PARTITION `Last_partition` VALUES LESS THAN MAXVALUE); CREATE INDEX idx1 ON t1(col18); CREATE INDEX prefix_idx ON t1(col14 (10)); ALTER TABLE t1 DISCARD TABLESPACE; restore: t1#P#First_partition#SP#First_partitionsp0 .ibd and .cfg files restore: t1#P#First_partition#SP#First_partitionsp1 .ibd and .cfg files restore: t1#P#First_partition#SP#First_partitionsp2 .ibd and .cfg files restore: t1#P#Last_partition#SP#Last_partitionsp0 .ibd and .cfg files restore: t1#P#Last_partition#SP#Last_partitionsp1 .ibd and .cfg files restore: t1#P#Last_partition#SP#Last_partitionsp2 .ibd and .cfg files ALTER TABLE t1 IMPORT TABLESPACE; CHECK TABLE t1; Table Op Msg_type Msg_text test.t1 check status OK SELECT * FROM t1; col1 col2 col3 col4 col5 col6 col7 col8 col9 col10 col11 col12 col13 col14 col15 col16 col17 col18 col19 col20 col21 col22 col23 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 3 NULL NULL NULL NULL NULL 1 -128 32767 -8388608 2147483647 -9223372036854775808 92233719808.000 -92233720368.222 aaa aaaaaaaaaa b bbbbb ccccc dddddddddddddddddddddddddddddddddddddddd dddddddddddddddddddddddddddddddddddddddd dddddddddddddddddddddddddddddddddddddddd 1 1000-01-01 3001-01-01 00:00:00 1990-01-01 00:00:01 01:59:59 1901 DROP TABLE t1; # # case 3 - with blob objects # CREATE TABLE t1 ( col_1_varbinary VARBINARY (4000), col_2_varchar VARCHAR (4000), col_3_text TEXT (4000), col_4_blob BLOB (4000), col_5_text TEXT (4000), col_6_varchar VARCHAR (4000), col_7_binary BINARY (255) ) ROW_FORMAT=DYNAMIC ENGINE = InnoDB PARTITION BY KEY (col_7_binary) PARTITIONS 3; INSERT INTO t1 VALUES( REPEAT('a', 4000),REPEAT('o', 4000),REPEAT('a', 4000), REPEAT('o', 4000), REPEAT('a', 4000),REPEAT('a', 4000),REPEAT('a', 255)); SELECT col_1_varbinary = REPEAT("a", 4000), col_2_varchar = REPEAT("o", 4000), col_3_text = REPEAT("a", 4000), col_4_blob = REPEAT("o", 4000), col_5_text = REPEAT("a", 4000), col_6_varchar = REPEAT("a", 4000), col_7_binary = REPEAT("a", 255) FROM t1; col_1_varbinary = REPEAT("a", 4000) col_2_varchar = REPEAT("o", 4000) col_3_text = REPEAT("a", 4000) col_4_blob = REPEAT("o", 4000) col_5_text = REPEAT("a", 4000) col_6_varchar = REPEAT("a", 4000) col_7_binary = REPEAT("a", 255) 1 1 1 1 1 1 1 FLUSH TABLES t1 FOR EXPORT; backup: t1#P#p0 backup: t1#P#p1 backup: t1#P#p2 UNLOCK TABLES; DROP TABLE t1; CREATE TABLE t1 ( col_1_varbinary VARBINARY (4000), col_2_varchar VARCHAR (4000), col_3_text TEXT (4000), col_4_blob BLOB (4000), col_5_text TEXT (4000), col_6_varchar VARCHAR (4000), col_7_binary BINARY (255) ) ROW_FORMAT=DYNAMIC ENGINE = InnoDB PARTITION BY KEY (col_7_binary) PARTITIONS 3; ALTER TABLE t1 DISCARD TABLESPACE; restore: t1#P#p0 .ibd and .cfg files restore: t1#P#p1 .ibd and .cfg files restore: t1#P#p2 .ibd and .cfg files ALTER TABLE t1 IMPORT TABLESPACE; SELECT col_1_varbinary = REPEAT("a", 4000), col_2_varchar = REPEAT("o", 4000), col_3_text = REPEAT("a", 4000), col_4_blob = REPEAT("o", 4000), col_5_text = REPEAT("a", 4000), col_6_varchar = REPEAT("a", 4000), col_7_binary = REPEAT("a", 255) FROM t1; col_1_varbinary = REPEAT("a", 4000) col_2_varchar = REPEAT("o", 4000) col_3_text = REPEAT("a", 4000) col_4_blob = REPEAT("o", 4000) col_5_text = REPEAT("a", 4000) col_6_varchar = REPEAT("a", 4000) col_7_binary = REPEAT("a", 255) 1 1 1 1 1 1 1 DROP TABLE t1; # # case 4 - transportable tablespace with auto_increment # CREATE TABLE t1 ( col_1_int INT AUTO_INCREMENT, col_2_varchar VARCHAR (20), PRIMARY KEY (col_1_int)) ENGINE = InnoDB PARTITION BY HASH (col_1_int) PARTITIONS 3; INSERT INTO t1 VALUES (1,'a1'),(2,'a2'),(3,'a3'); INSERT INTO t1 (col_2_varchar) VALUES ('a4'),('a5'),('a6'); SELECT * FROM t1 ORDER BY col_1_int; col_1_int col_2_varchar 1 a1 2 a2 3 a3 4 a4 5 a5 6 a6 FLUSH TABLES t1 FOR EXPORT; backup: t1#P#p0 backup: t1#P#p1 backup: t1#P#p2 UNLOCK TABLES; DROP TABLE t1; CREATE TABLE t1 ( col_1_int INT AUTO_INCREMENT, col_2_varchar VARCHAR (20), PRIMARY KEY (col_1_int)) ENGINE = InnoDB PARTITION BY HASH (col_1_int) PARTITIONS 3; ALTER TABLE t1 DISCARD TABLESPACE; restore: t1#P#p0 .ibd and .cfg files restore: t1#P#p1 .ibd and .cfg files restore: t1#P#p2 .ibd and .cfg files ALTER TABLE t1 IMPORT TABLESPACE; SELECT * FROM t1 ORDER BY col_1_int; col_1_int col_2_varchar 1 a1 2 a2 3 a3 4 a4 5 a5 6 a6 INSERT INTO t1 VALUES (1,'a1'); ERROR 23000: Duplicate entry '1' for key 'PRIMARY' INSERT INTO t1(col_2_varchar) VALUES ('a101'),('a102'),('a103'); SELECT * FROM t1 ORDER BY col_1_int; col_1_int col_2_varchar 1 a1 2 a2 3 a3 4 a4 5 a5 6 a6 7 a101 8 a102 9 a103 ALTER TABLE t1 MODIFY col_1_int BIGINT; SELECT * FROM t1 ORDER BY col_1_int; col_1_int col_2_varchar 1 a1 2 a2 3 a3 4 a4 5 a5 6 a6 7 a101 8 a102 9 a103 DROP TABLE t1; # # case 5 - check with primary and foreign key # # Foreign Keys not supported by partitioned tables. # # case 6 - transportable tablespace with transactions # CREATE TABLE t1 ( col_1_int int,col_2_varchar VARCHAR (20), PRIMARY KEY (col_2_varchar)) ENGINE = InnoDB PARTITION BY KEY (col_2_varchar) PARTITIONS 3; SET AUTOCOMMIT = 0; INSERT INTO t1 VALUES (1,'a1'),(2,'a2'); SELECT * FROM t1; col_1_int col_2_varchar 1 a1 2 a2 COMMIT; INSERT INTO t1 VALUES (3,'a3'),(4,'a4'); ROLLBACK; INSERT INTO t1 VALUES (5,'a5'),(6,'a6'); COMMIT; SELECT * FROM t1 ORDER BY col_1_int; col_1_int col_2_varchar 1 a1 2 a2 5 a5 6 a6 FLUSH TABLES t1 FOR EXPORT; backup: t1#P#p0 backup: t1#P#p1 backup: t1#P#p2 UNLOCK TABLES; DROP TABLE t1; CREATE TABLE t1 ( col_1_int int,col_2_varchar VARCHAR (20), PRIMARY KEY (col_2_varchar)) ENGINE = InnoDB PARTITION BY KEY (col_2_varchar) PARTITIONS 3; ALTER TABLE t1 DISCARD TABLESPACE; SET AUTOCOMMIT = 0; restore: t1#P#p0 .ibd and .cfg files restore: t1#P#p1 .ibd and .cfg files restore: t1#P#p2 .ibd and .cfg files ALTER TABLE t1 IMPORT TABLESPACE; INSERT INTO t1 VALUES (7,'a7'),(8,'a8'); COMMIT; INSERT INTO t1 VALUES (9,'a9'),(10,'a10'); ROLLBACK; INSERT INTO t1 VALUES (11,'a11'),(12,'a12'); COMMIT; SELECT * FROM t1 ORDER BY col_1_int; col_1_int col_2_varchar 1 a1 2 a2 5 a5 6 a6 7 a7 8 a8 11 a11 12 a12 SET AUTOCOMMIT = 1; DROP TABLE t1; # # case 7 - Transportable tablespace with transaction # (earlier failed with jet) # CREATE TABLE t1 (i int) ENGINE = InnoDB PARTITION BY HASH (i) PARTITIONS 3; INSERT INTO t1 VALUES (100),(200),(300); SELECT * FROM t1 ORDER BY i; i 100 200 300 FLUSH TABLES t1 FOR EXPORT; backup: t1#P#p0 backup: t1#P#p1 backup: t1#P#p2 UNLOCK TABLES; DROP TABLE t1; CREATE TABLE t1 (i int) ENGINE = InnoDB PARTITION BY HASH (i) PARTITIONS 3; ALTER TABLE t1 DISCARD TABLESPACE; restore: t1#P#p0 .ibd and .cfg files restore: t1#P#p1 .ibd and .cfg files restore: t1#P#p2 .ibd and .cfg files ALTER TABLE t1 IMPORT TABLESPACE; SELECT * FROM t1 ORDER BY i; i 100 200 300 SET AUTOCOMMIT = 0; INSERT INTO t1 VALUES (101),(102),(103); COMMIT; SELECT * FROM t1 ORDER BY i; i 100 101 102 103 200 300 SET AUTOCOMMIT = 1; DROP TABLE t1; # # case 8 - negative cases # CREATE TABLE t1 (i int) ENGINE = InnoDB PARTITION BY HASH (i) PARTITIONS 3; INSERT INTO t1 VALUES (100),(200),(300); SELECT * FROM t1 ORDER BY i; i 100 200 300 FLUSH TABLES t1 FOR EXPORT; backup: t1#P#p0 backup: t1#P#p1 backup: t1#P#p2 UNLOCK TABLES; # try if we can flush again FLUSH TABLES t1 FOR EXPORT; UNLOCK TABLES; DROP TABLE t1; # create table with incorrect schema CREATE TABLE t1 (i bigint) ENGINE = InnoDB PARTITION BY HASH (i) PARTITIONS 3; ALTER TABLE t1 DISCARD TABLESPACE; restore: t1#P#p0 .ibd and .cfg files restore: t1#P#p1 .ibd and .cfg files restore: t1#P#p2 .ibd and .cfg files # error as mismatch in column data type ALTER TABLE t1 IMPORT TABLESPACE; ERROR HY000: Schema mismatch (Column i precise type mismatch.) # explicitly delete ibd file before creating table with correct schema unlink: t1#P#p0.ibd unlink: t1#P#p0.cfg unlink: t1#P#p1.ibd unlink: t1#P#p1.cfg unlink: t1#P#p2.ibd unlink: t1#P#p2.cfg DROP TABLE t1; CREATE TABLE t1 (i int) ENGINE = InnoDB PARTITION BY HASH (i) PARTITIONS 3; ALTER TABLE t1 DISCARD TABLESPACE; restore: t1#P#p0 .ibd and .cfg files restore: t1#P#p1 .ibd and .cfg files restore: t1#P#p2 .ibd and .cfg files # Import should succeed ALTER TABLE t1 IMPORT TABLESPACE; # Try to import twice ALTER TABLE t1 IMPORT TABLESPACE; ERROR HY000: Tablespace 'test/t1#P#p0' exists. SELECT * FROM t1 ORDER BY i; i 100 200 300 SET AUTOCOMMIT = 0; INSERT INTO t1 VALUES (101),(102),(103); COMMIT; SELECT * FROM t1 ORDER BY i; i 100 101 102 103 200 300 DROP TABLE t1; CREATE TABLE t1 (i int) ENGINE = InnoDB PARTITION BY HASH (i) PARTITIONS 3; ALTER TABLE t1 DISCARD TABLESPACE; # do not delete ibd file and try to import restore: t1#P#p0 .ibd and .cfg files restore: t1#P#p1 .ibd and .cfg files restore: t1#P#p2 .ibd and .cfg files ALTER TABLE t1 IMPORT TABLESPACE; DROP TABLE t1; SET AUTOCOMMIT = 1; # # case 9 - empty table import # CREATE TABLE t1 (c1 INT) ENGINE = InnoDB PARTITION BY HASH(c1) PARTITIONS 3; SET AUTOCOMMIT = 0; INSERT INTO t1 VALUES (1),(123),(331); SELECT c1 FROM t1; c1 123 1 331 ROLLBACK; FLUSH TABLES t1 FOR EXPORT; backup: t1#P#p0 backup: t1#P#p1 backup: t1#P#p2 UNLOCK TABLES; DROP TABLE t1; CREATE TABLE t1 (c1 INT) ENGINE = InnoDB PARTITION BY HASH(c1) PARTITIONS 3; ALTER TABLE t1 DISCARD TABLESPACE; restore: t1#P#p0 .ibd and .cfg files restore: t1#P#p1 .ibd and .cfg files restore: t1#P#p2 .ibd and .cfg files ALTER TABLE t1 IMPORT TABLESPACE; SELECT * FROM t1 ORDER BY c1; c1 DROP TABLE t1; SET AUTOCOMMIT = 1; # # case 10 - Transportable tablespaces with prefix index # CREATE TABLE t1 (col_1 CHAR (255), col_2 VARCHAR (255), col_3 VARCHAR (255), col_4 VARCHAR (255),col_5 VARCHAR (255), col_6 text (255), col_7 text (255), col_8 text (255),col_9 text (255), col_10 BLOB (255),col_11 BLOB (255), col_12 BLOB (255), col_13 BLOB (255), col_14 BLOB (255), col_15 int) ENGINE = InnoDB PARTITION BY KEY (col_1) PARTITIONS 3; CREATE INDEX prefix_idx ON t1( col_1 (50),col_2 (50),col_3 (50), col_4 (50),col_5 (50),col_6 (50), col_7 (50),col_8 (50),col_9 (50), col_10 (50),col_11 (50),col_12 (50), col_13(50)); INSERT INTO t1 VALUES ( REPEAT("col1_00001",10),REPEAT("col2_00001",10),REPEAT("col3_00001",10), REPEAT("col4_00001",10),REPEAT("col5_00001",10),REPEAT("col6_00001",10), REPEAT("col7_00001",10),REPEAT("col8_00001",10),REPEAT("col9_00001",10), REPEAT("col10_00001",10),REPEAT("col11_00001",10),REPEAT("col12_00001",10), REPEAT("col13_00001",10),REPEAT("col14_00001",10),1); SELECT col_1 = REPEAT("col1_00001",10), col_2 = REPEAT("col2_00001",10), col_3 = REPEAT("col3_00001",10), col_4 = REPEAT("col4_00001",10), col_5 = REPEAT("col5_00001",10), col_6 = REPEAT("col6_00001",10), col_7 = REPEAT("col7_00001",10), col_8 = REPEAT("col8_00001",10), col_9 = REPEAT("col9_00001",10), col_10 = REPEAT("col10_00001",10), col_11 = REPEAT("col11_00001",10), col_12 = REPEAT("col12_00001",10), col_13 = REPEAT("col13_00001",10), col_14 = REPEAT("col14_00001",10), col_15 FROM t1; col_1 = REPEAT("col1_00001",10) col_2 = REPEAT("col2_00001",10) col_3 = REPEAT("col3_00001",10) col_4 = REPEAT("col4_00001",10) col_5 = REPEAT("col5_00001",10) col_6 = REPEAT("col6_00001",10) col_7 = REPEAT("col7_00001",10) col_8 = REPEAT("col8_00001",10) col_9 = REPEAT("col9_00001",10) col_10 = REPEAT("col10_00001",10) col_11 = REPEAT("col11_00001",10) col_12 = REPEAT("col12_00001",10) col_13 = REPEAT("col13_00001",10) col_14 = REPEAT("col14_00001",10) col_15 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 FLUSH TABLES t1 FOR EXPORT; backup: t1#P#p0 backup: t1#P#p1 backup: t1#P#p2 UNLOCK TABLES; DROP TABLE t1; CREATE TABLE t1 (col_1 CHAR (255), col_2 VARCHAR (255), col_3 VARCHAR (255), col_4 VARCHAR (255),col_5 VARCHAR (255), col_6 text (255), col_7 text (255), col_8 text (255),col_9 text (255), col_10 BLOB (255),col_11 BLOB (255), col_12 BLOB (255), col_13 BLOB (255), col_14 BLOB (255), col_15 int) ENGINE = InnoDB PARTITION BY KEY (col_1) PARTITIONS 3; CREATE INDEX prefix_idx ON t1( col_1 (50),col_2 (50),col_3 (50), col_4 (50),col_5 (50),col_6 (50), col_7 (50),col_8 (50),col_9 (50), col_10 (50),col_11 (50),col_12 (50), col_13(50)); ALTER TABLE t1 DISCARD TABLESPACE; restore: t1#P#p0 .ibd and .cfg files restore: t1#P#p1 .ibd and .cfg files restore: t1#P#p2 .ibd and .cfg files ALTER TABLE t1 IMPORT TABLESPACE; SELECT col_1 = REPEAT("col1_00001",10), col_2 = REPEAT("col2_00001",10), col_3 = REPEAT("col3_00001",10), col_4 = REPEAT("col4_00001",10), col_5 = REPEAT("col5_00001",10), col_6 = REPEAT("col6_00001",10), col_7 = REPEAT("col7_00001",10), col_8 = REPEAT("col8_00001",10), col_9 = REPEAT("col9_00001",10), col_10 = REPEAT("col10_00001",10), col_11 = REPEAT("col11_00001",10), col_12 = REPEAT("col12_00001",10), col_13 = REPEAT("col13_00001",10), col_14 = REPEAT("col14_00001",10), col_15 FROM t1; col_1 = REPEAT("col1_00001",10) col_2 = REPEAT("col2_00001",10) col_3 = REPEAT("col3_00001",10) col_4 = REPEAT("col4_00001",10) col_5 = REPEAT("col5_00001",10) col_6 = REPEAT("col6_00001",10) col_7 = REPEAT("col7_00001",10) col_8 = REPEAT("col8_00001",10) col_9 = REPEAT("col9_00001",10) col_10 = REPEAT("col10_00001",10) col_11 = REPEAT("col11_00001",10) col_12 = REPEAT("col12_00001",10) col_13 = REPEAT("col13_00001",10) col_14 = REPEAT("col14_00001",10) col_15 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 DROP TABLE t1; # # case 11 - Transportable tablespaces with secondary index # CREATE TABLE t1 (col_1 CHAR (255), col_2 VARCHAR (255), col_3 VARCHAR (255), col_4 VARCHAR (255),col_5 VARCHAR (255), col_6 text (255), col_7 text (255), col_8 text (255),col_9 text (255), col_10 BLOB (255),col_11 BLOB (255), col_12 BLOB (255), col_13 BLOB (255), col_14 BLOB (255), col_15 int) ENGINE = InnoDB PARTITION BY KEY (col_1) PARTITIONS 3; CREATE INDEX idx1 ON t1(col_1); CREATE INDEX idx2 ON t1(col_2); CREATE INDEX idx3 ON t1(col_3); CREATE INDEX idx4 ON t1(col_4); CREATE INDEX idx5 ON t1(col_5); CREATE INDEX idx6 ON t1(col_6(255)); CREATE INDEX idx7 ON t1(col_7(255)); CREATE INDEX idx8 ON t1(col_8(255)); CREATE INDEX idx9 ON t1(col_9(255)); CREATE INDEX idx10 ON t1(col_10(255)); CREATE INDEX idx11 ON t1(col_11(255)); CREATE INDEX idx12 ON t1(col_12(255)); CREATE INDEX idx13 ON t1(col_13(255)); CREATE INDEX idx14 ON t1(col_14(255)); INSERT INTO t1 VALUES ( REPEAT("col1_00001",10),REPEAT("col2_00001",10),REPEAT("col3_00001",10), REPEAT("col4_00001",10),REPEAT("col5_00001",10),REPEAT("col6_00001",10), REPEAT("col7_00001",10),REPEAT("col8_00001",10),REPEAT("col9_00001",10), REPEAT("col10_00001",10),REPEAT("col11_00001",10),REPEAT("col12_00001",10), REPEAT("col13_00001",10),REPEAT("col14_00001",10),1); SELECT col_1 = REPEAT("col1_00001",10), col_2 = REPEAT("col2_00001",10), col_3 = REPEAT("col3_00001",10), col_4 = REPEAT("col4_00001",10), col_5 = REPEAT("col5_00001",10), col_6 = REPEAT("col6_00001",10), col_7 = REPEAT("col7_00001",10), col_8 = REPEAT("col8_00001",10), col_9 = REPEAT("col9_00001",10), col_10 = REPEAT("col10_00001",10), col_11 = REPEAT("col11_00001",10), col_12 = REPEAT("col12_00001",10), col_13 = REPEAT("col13_00001",10), col_14 = REPEAT("col14_00001",10), col_15 FROM t1; col_1 = REPEAT("col1_00001",10) col_2 = REPEAT("col2_00001",10) col_3 = REPEAT("col3_00001",10) col_4 = REPEAT("col4_00001",10) col_5 = REPEAT("col5_00001",10) col_6 = REPEAT("col6_00001",10) col_7 = REPEAT("col7_00001",10) col_8 = REPEAT("col8_00001",10) col_9 = REPEAT("col9_00001",10) col_10 = REPEAT("col10_00001",10) col_11 = REPEAT("col11_00001",10) col_12 = REPEAT("col12_00001",10) col_13 = REPEAT("col13_00001",10) col_14 = REPEAT("col14_00001",10) col_15 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 FLUSH TABLES t1 FOR EXPORT; backup: t1#P#p0 backup: t1#P#p1 backup: t1#P#p2 UNLOCK TABLES; DROP TABLE t1; CREATE TABLE t1 (col_1 CHAR (255), col_2 VARCHAR (255), col_3 VARCHAR (255), col_4 VARCHAR (255),col_5 VARCHAR (255), col_6 text (255), col_7 text (255), col_8 text (255),col_9 text (255), col_10 BLOB (255),col_11 BLOB (255), col_12 BLOB (255), col_13 BLOB (255), col_14 BLOB (255), col_15 int) ENGINE = InnoDB PARTITION BY KEY (col_1) PARTITIONS 3; CREATE INDEX idx1 ON t1(col_1); CREATE INDEX idx2 ON t1(col_2); CREATE INDEX idx3 ON t1(col_3); CREATE INDEX idx4 ON t1(col_4); CREATE INDEX idx5 ON t1(col_5); CREATE INDEX idx6 ON t1(col_6(255)); CREATE INDEX idx7 ON t1(col_7(255)); CREATE INDEX idx8 ON t1(col_8(255)); CREATE INDEX idx9 ON t1(col_9(255)); CREATE INDEX idx10 ON t1(col_10(255)); CREATE INDEX idx11 ON t1(col_11(255)); CREATE INDEX idx12 ON t1(col_12(255)); CREATE INDEX idx13 ON t1(col_13(255)); CREATE INDEX idx14 ON t1(col_14(255)); ALTER TABLE t1 DISCARD TABLESPACE; restore: t1#P#p0 .ibd and .cfg files restore: t1#P#p1 .ibd and .cfg files restore: t1#P#p2 .ibd and .cfg files ALTER TABLE t1 IMPORT TABLESPACE; SELECT col_1 = REPEAT("col1_00001",10), col_2 = REPEAT("col2_00001",10), col_3 = REPEAT("col3_00001",10), col_4 = REPEAT("col4_00001",10), col_5 = REPEAT("col5_00001",10), col_6 = REPEAT("col6_00001",10), col_7 = REPEAT("col7_00001",10), col_8 = REPEAT("col8_00001",10), col_9 = REPEAT("col9_00001",10), col_10 = REPEAT("col10_00001",10), col_11 = REPEAT("col11_00001",10), col_12 = REPEAT("col12_00001",10), col_13 = REPEAT("col13_00001",10), col_14 = REPEAT("col14_00001",10), col_15 FROM t1; col_1 = REPEAT("col1_00001",10) col_2 = REPEAT("col2_00001",10) col_3 = REPEAT("col3_00001",10) col_4 = REPEAT("col4_00001",10) col_5 = REPEAT("col5_00001",10) col_6 = REPEAT("col6_00001",10) col_7 = REPEAT("col7_00001",10) col_8 = REPEAT("col8_00001",10) col_9 = REPEAT("col9_00001",10) col_10 = REPEAT("col10_00001",10) col_11 = REPEAT("col11_00001",10) col_12 = REPEAT("col12_00001",10) col_13 = REPEAT("col13_00001",10) col_14 = REPEAT("col14_00001",10) col_15 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 # perform transaction on imported table SET AUTOCOMMIT = 0; INSERT INTO t1(col_15) VALUES (15000),(16000); SELECT col_15 FROM t1 WHERE col_15 > 11000; col_15 15000 16000 ROLLBACK; SELECT col_15 FROM t1 WHERE col_15 > 11000; col_15 INSERT INTO t1(col_15) VALUES (15000),(16000); COMMIT; SELECT col_15 FROM t1 WHERE col_15 > 11000; col_15 15000 16000 # Perform DDL operations on imported table. ALTER TABLE t1 DROP INDEX idx1; ALTER TABLE t1 DROP INDEX idx6; ALTER TABLE t1 DROP INDEX idx10; SELECT col_1 = REPEAT("col1_00001",10), col_2 = REPEAT("col2_00001",10), col_3 = REPEAT("col3_00001",10), col_4 = REPEAT("col4_00001",10), col_5 = REPEAT("col5_00001",10), col_6 = REPEAT("col6_00001",10), col_7 = REPEAT("col7_00001",10), col_8 = REPEAT("col8_00001",10), col_9 = REPEAT("col9_00001",10), col_10 = REPEAT("col10_00001",10), col_11 = REPEAT("col11_00001",10), col_12 = REPEAT("col12_00001",10), col_13 = REPEAT("col13_00001",10), col_14 = REPEAT("col14_00001",10), col_15 FROM t1; col_1 = REPEAT("col1_00001",10) col_2 = REPEAT("col2_00001",10) col_3 = REPEAT("col3_00001",10) col_4 = REPEAT("col4_00001",10) col_5 = REPEAT("col5_00001",10) col_6 = REPEAT("col6_00001",10) col_7 = REPEAT("col7_00001",10) col_8 = REPEAT("col8_00001",10) col_9 = REPEAT("col9_00001",10) col_10 = REPEAT("col10_00001",10) col_11 = REPEAT("col11_00001",10) col_12 = REPEAT("col12_00001",10) col_13 = REPEAT("col13_00001",10) col_14 = REPEAT("col14_00001",10) col_15 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 15000 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 16000 ALTER TABLE t1 ADD INDEX idx1 (col_1); ALTER TABLE t1 ADD INDEX idx6 (col_1(255)); ALTER TABLE t1 ADD INDEX idx10 (col_10(255)); SELECT col_1 = REPEAT("col1_00001",10), col_2 = REPEAT("col2_00001",10), col_3 = REPEAT("col3_00001",10), col_4 = REPEAT("col4_00001",10), col_5 = REPEAT("col5_00001",10), col_6 = REPEAT("col6_00001",10), col_7 = REPEAT("col7_00001",10), col_8 = REPEAT("col8_00001",10), col_9 = REPEAT("col9_00001",10), col_10 = REPEAT("col10_00001",10), col_11 = REPEAT("col11_00001",10), col_12 = REPEAT("col12_00001",10), col_13 = REPEAT("col13_00001",10), col_14 = REPEAT("col14_00001",10), col_15 FROM t1; col_1 = REPEAT("col1_00001",10) col_2 = REPEAT("col2_00001",10) col_3 = REPEAT("col3_00001",10) col_4 = REPEAT("col4_00001",10) col_5 = REPEAT("col5_00001",10) col_6 = REPEAT("col6_00001",10) col_7 = REPEAT("col7_00001",10) col_8 = REPEAT("col8_00001",10) col_9 = REPEAT("col9_00001",10) col_10 = REPEAT("col10_00001",10) col_11 = REPEAT("col11_00001",10) col_12 = REPEAT("col12_00001",10) col_13 = REPEAT("col13_00001",10) col_14 = REPEAT("col14_00001",10) col_15 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 15000 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 16000 DROP TABLE t1; SET AUTOCOMMIT = 1; # # case 12 - Transportable tablespaces with trigger / view # CREATE TABLE t1(col1 bit(1), col2 boolean,col3 tinyint, col4 smallint, col5 mediumint,col6 int, col7 bigint, col8 float (14,3),col9 double (14,3), col10 VARCHAR(20) CHARACTER SET utf8, col11 TEXT CHARACTER SET binary, col12 ENUM('a','b','c') CHARACTER SET binary, col13 TEXT CHARACTER SET latin1 COLLATE latin1_general_cs, col14 CHAR(20), col15 VARBINARY (400), col16 BINARY(40), col17 BLOB (400), col18 int not null primary key, col19 DATE,col20 DATETIME, col21 TIMESTAMP NULL, col22 TIME, col23 YEAR) ENGINE = InnoDB PARTITION BY HASH (col18) PARTITIONS 3; # table for trigger action CREATE TABLE trigger_table (i int) ENGINE = InnoDB; CREATE TRIGGER tri AFTER INSERT ON t1 FOR EACH ROW INSERT INTO trigger_table VALUES(NEW.col18); CREATE OR REPLACE VIEW VW1 AS SELECT * FROM t1; CREATE INDEX idx1 ON t1(col18); CREATE INDEX prefix_idx ON t1(col14 (10)); INSERT INTO t1 VALUES ( 1,1,-128,32767,-8388608,2147483647,-9223372036854775808,92233720368.222, -92233720368.222,'aaa','aaaaaaaaaa','b','bbbbb','ccccc',REPEAT('d',40), REPEAT('d',40),REPEAT('d',40),1,'1000-01-01','3000-12-31 23:59:59.99', '1990-01-01 00:00:01.00','01:59:59.00','1901'); INSERT INTO t1 VALUES ( NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, NULL,NULL,3,NULL,NULL,NULL,NULL,NULL); INSERT INTO t1 VALUES ( NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); ERROR 23000: Column 'col18' cannot be null INSERT INTO t1 VALUES ( NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, NULL,NULL,1,NULL,NULL,NULL,NULL,NULL); ERROR 23000: Duplicate entry '1' for key 'PRIMARY' SELECT * FROM t1; col1 col2 col3 col4 col5 col6 col7 col8 col9 col10 col11 col12 col13 col14 col15 col16 col17 col18 col19 col20 col21 col22 col23 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 3 NULL NULL NULL NULL NULL 1 -128 32767 -8388608 2147483647 -9223372036854775808 92233719808.000 -92233720368.222 aaa aaaaaaaaaa b bbbbb ccccc dddddddddddddddddddddddddddddddddddddddd dddddddddddddddddddddddddddddddddddddddd dddddddddddddddddddddddddddddddddddddddd 1 1000-01-01 3001-01-01 00:00:00 1990-01-01 00:00:01 01:59:59 1901 SELECT * FROM trigger_table; i 1 3 SELECT * FROM VW1; col1 col2 col3 col4 col5 col6 col7 col8 col9 col10 col11 col12 col13 col14 col15 col16 col17 col18 col19 col20 col21 col22 col23 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 3 NULL NULL NULL NULL NULL 1 -128 32767 -8388608 2147483647 -9223372036854775808 92233719808.000 -92233720368.222 aaa aaaaaaaaaa b bbbbb ccccc dddddddddddddddddddddddddddddddddddddddd dddddddddddddddddddddddddddddddddddddddd dddddddddddddddddddddddddddddddddddddddd 1 1000-01-01 3001-01-01 00:00:00 1990-01-01 00:00:01 01:59:59 1901 FLUSH TABLES t1 FOR EXPORT; backup: t1#P#p0 backup: t1#P#p1 backup: t1#P#p2 UNLOCK TABLES; # trigger is also dropped when table is dropped DROP TABLE t1; CREATE TABLE t1(col1 bit(1), col2 boolean,col3 tinyint, col4 smallint, col5 mediumint,col6 int, col7 bigint, col8 float (14,3),col9 double (14,3), col10 VARCHAR(20) CHARACTER SET utf8, col11 TEXT CHARACTER SET binary, col12 ENUM('a','b','c') CHARACTER SET binary, col13 TEXT CHARACTER SET latin1 COLLATE latin1_general_cs, col14 CHAR(20), col15 VARBINARY (400), col16 BINARY(40), col17 BLOB (400), col18 int not null primary key, col19 DATE,col20 DATETIME, col21 TIMESTAMP NULL, col22 TIME, col23 YEAR) ENGINE = InnoDB PARTITION BY HASH (col18) PARTITIONS 3; CREATE INDEX idx1 ON t1(col18); CREATE INDEX prefix_idx ON t1(col14 (10)); ALTER TABLE t1 DISCARD TABLESPACE; restore: t1#P#p0 .ibd and .cfg files restore: t1#P#p1 .ibd and .cfg files restore: t1#P#p2 .ibd and .cfg files ALTER TABLE t1 IMPORT TABLESPACE; SELECT * FROM t1; col1 col2 col3 col4 col5 col6 col7 col8 col9 col10 col11 col12 col13 col14 col15 col16 col17 col18 col19 col20 col21 col22 col23 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 3 NULL NULL NULL NULL NULL 1 -128 32767 -8388608 2147483647 -9223372036854775808 92233719808.000 -92233720368.222 aaa aaaaaaaaaa b bbbbb ccccc dddddddddddddddddddddddddddddddddddddddd dddddddddddddddddddddddddddddddddddddddd dddddddddddddddddddddddddddddddddddddddd 1 1000-01-01 3001-01-01 00:00:00 1990-01-01 00:00:01 01:59:59 1901 SELECT * FROM trigger_table; i 1 3 SELECT * FROM VW1; col1 col2 col3 col4 col5 col6 col7 col8 col9 col10 col11 col12 col13 col14 col15 col16 col17 col18 col19 col20 col21 col22 col23 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 3 NULL NULL NULL NULL NULL 1 -128 32767 -8388608 2147483647 -9223372036854775808 92233719808.000 -92233720368.222 aaa aaaaaaaaaa b bbbbb ccccc dddddddddddddddddddddddddddddddddddddddd dddddddddddddddddddddddddddddddddddddddd dddddddddddddddddddddddddddddddddddddddd 1 1000-01-01 3001-01-01 00:00:00 1990-01-01 00:00:01 01:59:59 1901 INSERT INTO t1(col18) VALUES (5); SELECT * FROM trigger_table; i 1 3 UPDATE t1 SET col18=10 WHERE col18=1; SELECT * FROM VW1; col1 col2 col3 col4 col5 col6 col7 col8 col9 col10 col11 col12 col13 col14 col15 col16 col17 col18 col19 col20 col21 col22 col23 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 3 NULL NULL NULL NULL NULL 1 -128 32767 -8388608 2147483647 -9223372036854775808 92233719808.000 -92233720368.222 aaa aaaaaaaaaa b bbbbb ccccc dddddddddddddddddddddddddddddddddddddddd dddddddddddddddddddddddddddddddddddddddd dddddddddddddddddddddddddddddddddddddddd 10 1000-01-01 3001-01-01 00:00:00 1990-01-01 00:00:01 01:59:59 1901 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 5 NULL NULL NULL NULL NULL SELECT * FROM t1 WHERE col18=10; col1 col2 col3 col4 col5 col6 col7 col8 col9 col10 col11 col12 col13 col14 col15 col16 col17 col18 col19 col20 col21 col22 col23 1 -128 32767 -8388608 2147483647 -9223372036854775808 92233719808.000 -92233720368.222 aaa aaaaaaaaaa b bbbbb ccccc dddddddddddddddddddddddddddddddddddddddd dddddddddddddddddddddddddddddddddddddddd dddddddddddddddddddddddddddddddddddddddd 10 1000-01-01 3001-01-01 00:00:00 1990-01-01 00:00:01 01:59:59 1901 ALTER TABLE t1 ADD COLUMN col24 varbinary(40) default null; INSERT INTO t1(col18,col24) VALUES (6,REPEAT('a',10)); SELECT col24,col18 FROM t1 WHERE col18 in (6,1,10) ORDER BY col18; col24 col18 aaaaaaaaaa 6 NULL 10 ALTER TABLE t1 DROP INDEX prefix_idx; SELECT col18,col14 FROM t1 WHERE col14 like '_ccc%'; col18 col14 10 ccccc ALTER TABLE t1 ADD INDEX prefix_idx (col24(10)); SELECT col18,col24 FROM t1 WHERE col24 like '_a_a%'; col18 col24 6 aaaaaaaaaa DROP VIEW VW1; DROP TABLE t1; DROP TABLE trigger_table; SET GLOBAL innodb_file_per_table = @old_innodb_file_per_table; # # DISCARD/IMPORT selected partitions only # CREATE TABLE t1 (c1 INT) ENGINE = InnoDB PARTITION BY HASH (c1) PARTITIONS 3; INSERT INTO t1 VALUES (1),(2),(3),(4),(5),(6); SELECT c1 FROM t1 ORDER BY c1; c1 1 2 3 4 5 6 FLUSH TABLES t1 FOR EXPORT; SELECT * FROM t1 ORDER BY c1; c1 1 2 3 4 5 6 backup: t1#P#p0 backup: t1#P#p1 backup: t1#P#p2 UNLOCK TABLES; DROP TABLE t1; CREATE TABLE t1 (c1 INT) ENGINE = InnoDB PARTITION BY HASH (c1) PARTITIONS 3; INSERT INTO t1 VALUES (31), (32), (33); ALTER TABLE t1 DISCARD PARTITION p0,p2 TABLESPACE; restore: t1#P#p0 .ibd and .cfg files restore: t1#P#p2 .ibd and .cfg files ALTER TABLE t1 IMPORT PARTITION p0, p2 TABLESPACE; SELECT * FROM t1 ORDER BY c1; c1 2 3 5 6 31 ALTER TABLE t1 DISCARD PARTITION p1 TABLESPACE; restore: t1#P#p1 .ibd and .cfg files ALTER TABLE t1 IMPORT PARTITION p1 TABLESPACE; SELECT * FROM t1 ORDER BY c1; c1 1 2 3 4 5 6 INSERT INTO t1 VALUES (31), (32), (33); SELECT * FROM t1 ORDER BY c1; c1 1 2 3 4 5 6 31 32 33 ALTER TABLE t1 DISCARD PARTITION all TABLESPACE; restore: t1#P#p0 .ibd and .cfg files restore: t1#P#p1 .ibd and .cfg files restore: t1#P#p2 .ibd and .cfg files ALTER TABLE t1 IMPORT PARTITION p1 TABLESPACE; SELECT * FROM t1 PARTITION (p1) ORDER BY c1; c1 1 4 INSERT INTO t1 PARTITION (p1) VALUES (61), (64); FLUSH TABLES; SELECT * FROM t1 PARTITION (p1) ORDER BY c1; c1 1 4 61 64 Warnings: Warning 1814 InnoDB: Tablespace has been discarded for table 't1' Warning 1814 InnoDB: Tablespace has been discarded for table 't1' SELECT * FROM t1 ORDER BY c1; ERROR HY000: Tablespace has been discarded for table 't1' ALTER TABLE t1 DISCARD PARTITION TABLESPACE; ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 ALTER TABLE t1 IMPORT PARTITION TABLESPACE; ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 ALTER TABLE t1 DISCARD PARTITION pNonExisting TABLESPACE; ERROR HY000: Unknown partition 'pNonExisting' in table 't1' ALTER TABLE t1 IMPORT PARTITION pNonExisting TABLESPACE; ERROR HY000: Unknown partition 'pNonExisting' in table 't1' ALTER TABLE t1 DISCARD PARTITION p1 TABLESPACE; restore: t1#P#p1 .ibd and .cfg files ALTER TABLE t1 IMPORT PARTITION all TABLESPACE; SELECT * FROM t1 ORDER BY c1; c1 1 2 3 4 5 6 DROP TABLE t1; # # DISCARD/IMPORT selected subpartitions only # CREATE TABLE t1 (c1 INT) ENGINE = InnoDB PARTITION BY RANGE (c1) SUBPARTITION BY HASH (c1) SUBPARTITIONS 3 (PARTITION p0 VALUES LESS THAN (100), PARTITION p1 VALUES LESS THAN MAXVALUE); INSERT INTO t1 VALUES (1),(2),(3),(4),(5),(6); INSERT INTO t1 VALUES (101),(102),(103),(104),(105),(106); SELECT c1 FROM t1 ORDER BY c1; c1 1 2 3 4 5 6 101 102 103 104 105 106 FLUSH TABLES t1 FOR EXPORT; SELECT * FROM t1 ORDER BY c1; c1 1 2 3 4 5 6 101 102 103 104 105 106 backup: t1#P#p0#SP#p0sp0 backup: t1#P#p0#SP#p0sp1 backup: t1#P#p0#SP#p0sp2 backup: t1#P#p1#SP#p1sp0 backup: t1#P#p1#SP#p1sp1 backup: t1#P#p1#SP#p1sp2 UNLOCK TABLES; DROP TABLE t1; CREATE TABLE t1 (c1 INT) ENGINE = InnoDB PARTITION BY RANGE (c1) SUBPARTITION BY HASH (c1) SUBPARTITIONS 3 (PARTITION p0 VALUES LESS THAN (100), PARTITION p1 VALUES LESS THAN MAXVALUE); INSERT INTO t1 VALUES (31), (32), (33); INSERT INTO t1 VALUES (131), (132), (133); ALTER TABLE t1 DISCARD PARTITION p0sp1,p1sp0 TABLESPACE; restore: t1#P#p0#SP#p0sp1 .ibd and .cfg files restore: t1#P#p1#SP#p1sp0 .ibd and .cfg files ALTER TABLE t1 IMPORT PARTITION p0sp1, p1sp0 TABLESPACE; SELECT * FROM t1 ORDER BY c1; c1 1 4 32 33 102 105 131 133 ALTER TABLE t1 DISCARD PARTITION p1, p0sp2 TABLESPACE; restore: t1#P#p0#SP#p0sp2 .ibd and .cfg files restore: t1#P#p1#SP#p1sp0 .ibd and .cfg files restore: t1#P#p1#SP#p1sp1 .ibd and .cfg files restore: t1#P#p1#SP#p1sp2 .ibd and .cfg files ALTER TABLE t1 IMPORT PARTITION p0sp2, p1 TABLESPACE; SELECT * FROM t1 ORDER BY c1; c1 1 2 4 5 33 101 102 103 104 105 106 INSERT INTO t1 VALUES (31), (32), (33); SELECT * FROM t1 ORDER BY c1; c1 1 2 4 5 31 32 33 33 101 102 103 104 105 106 ALTER TABLE t1 DISCARD PARTITION all TABLESPACE; restore: t1#P#p0#SP#p0sp0 .ibd and .cfg files restore: t1#P#p0#SP#p0sp1 .ibd and .cfg files restore: t1#P#p0#SP#p0sp2 .ibd and .cfg files restore: t1#P#p1#SP#p1sp0 .ibd and .cfg files restore: t1#P#p1#SP#p1sp1 .ibd and .cfg files restore: t1#P#p1#SP#p1sp2 .ibd and .cfg files ALTER TABLE t1 IMPORT PARTITION p1sp2 TABLESPACE; SELECT * FROM t1 PARTITION (p1sp2) ORDER BY c1; c1 101 104 INSERT INTO t1 PARTITION (p1sp2) VALUES (161), (164); FLUSH TABLES; SELECT * FROM t1 PARTITION (p1sp2) ORDER BY c1; c1 101 104 161 164 Warnings: Warning 1814 InnoDB: Tablespace has been discarded for table 't1' Warning 1814 InnoDB: Tablespace has been discarded for table 't1' Warning 1814 InnoDB: Tablespace has been discarded for table 't1' Warning 1814 InnoDB: Tablespace has been discarded for table 't1' Warning 1814 InnoDB: Tablespace has been discarded for table 't1' SELECT * FROM t1 ORDER BY c1; ERROR HY000: Tablespace has been discarded for table 't1' ALTER TABLE t1 DISCARD PARTITION p1sp2 TABLESPACE; restore: t1#P#p1#SP#p1sp2 .ibd and .cfg files ALTER TABLE t1 DISCARD PARTITION all TABLESPACE; Warnings: Warning 1812 InnoDB: Tablespace is missing for table test/t1#P#p0#SP#p0sp0. Warning 1812 InnoDB: Tablespace is missing for table test/t1#P#p0#SP#p0sp1. Warning 1812 InnoDB: Tablespace is missing for table test/t1#P#p0#SP#p0sp2. Warning 1812 InnoDB: Tablespace is missing for table test/t1#P#p1#SP#p1sp0. Warning 1812 InnoDB: Tablespace is missing for table test/t1#P#p1#SP#p1sp1. Warning 1812 InnoDB: Tablespace is missing for table test/t1#P#p1#SP#p1sp2. restore: t1#P#p0#SP#p0sp0 .ibd and .cfg files restore: t1#P#p0#SP#p0sp1 .ibd and .cfg files restore: t1#P#p1#SP#p1sp0 .ibd and .cfg files restore: t1#P#p1#SP#p1sp1 .ibd and .cfg files restore: t1#P#p1#SP#p1sp2 .ibd and .cfg files # Removing p0sp2's .ibd file ALTER TABLE t1 IMPORT PARTITION all TABLESPACE; ERROR HY000: Internal error: Cannot reset LSNs in table `test`.`t1` /* Partition `p0`, Subpartition `p0sp2` */ : Tablespace not found restore: t1#P#p0#SP#p0sp2 .ibd and .cfg files ALTER TABLE t1 IMPORT PARTITION all TABLESPACE; ERROR HY000: Tablespace 'test/t1#P#p0#SP#p0sp0' exists. ALTER TABLE t1 IMPORT PARTITION p0sp2 TABLESPACE; ALTER TABLE t1 DISCARD PARTITION all TABLESPACE; Warnings: Warning 1812 InnoDB: Tablespace is missing for table test/t1#P#p1#SP#p1sp0. Warning 1812 InnoDB: Tablespace is missing for table test/t1#P#p1#SP#p1sp1. Warning 1812 InnoDB: Tablespace is missing for table test/t1#P#p1#SP#p1sp2. restore: t1#P#p0#SP#p0sp0 .ibd and .cfg files restore: t1#P#p0#SP#p0sp1 .ibd and .cfg files restore: t1#P#p0#SP#p0sp2 .ibd and .cfg files restore: t1#P#p1#SP#p1sp0 .ibd and .cfg files restore: t1#P#p1#SP#p1sp1 .ibd and .cfg files restore: t1#P#p1#SP#p1sp2 .ibd and .cfg files ALTER TABLE t1 IMPORT PARTITION all TABLESPACE; SELECT * FROM t1 ORDER BY c1; c1 1 2 3 4 5 6 101 102 103 104 105 106 DROP TABLE t1; CREATE TABLE t1 (c1 INT) ENGINE = InnoDB; ALTER TABLE t1 DISCARD PARTITION pNonExisting TABLESPACE; ERROR HY000: Partition management on a not partitioned table is not possible ALTER TABLE t1 IMPORT PARTITION pNonExisting TABLESPACE; ERROR HY000: Partition management on a not partitioned table is not possible ALTER TABLE t1 IMPORT PARTITION all TABLESPACE; ERROR HY000: Partition management on a not partitioned table is not possible DROP TABLE t1; # discard partition one by one CREATE TABLE t1 (c1 INT) ENGINE = InnoDB PARTITION BY RANGE (c1) SUBPARTITION BY HASH (c1) SUBPARTITIONS 3 (PARTITION p0 VALUES LESS THAN (100), PARTITION p1 VALUES LESS THAN MAXVALUE); ALTER TABLE t1 DISCARD PARTITION p0sp0 TABLESPACE; restore: t1#P#p0#SP#p0sp0 .ibd and .cfg files ALTER TABLE t1 IMPORT PARTITION p0sp0 TABLESPACE; SELECT * FROM t1 PARTITION (p0sp0) ORDER BY c1; c1 3 6 SELECT * FROM t1 ORDER BY c1; c1 3 6 ALTER TABLE t1 REBUILD PARTITION p0; SELECT * FROM t1 PARTITION (p0sp0) ORDER BY c1; c1 3 6 ALTER TABLE t1 DISCARD PARTITION p1 TABLESPACE; restore: t1#P#p1#SP#p1sp0 .ibd and .cfg files restore: t1#P#p1#SP#p1sp1 .ibd and .cfg files restore: t1#P#p1#SP#p1sp2 .ibd and .cfg files ALTER TABLE t1 IMPORT PARTITION p1 TABLESPACE; SELECT * FROM t1 PARTITION (p1) ORDER BY c1; c1 101 102 103 104 105 106 ALTER TABLE t1 OPTIMIZE PARTITION p1; Table Op Msg_type Msg_text test.t1 optimize note Table does not support optimize on partitions. All partitions will be rebuilt and analyzed. test.t1 optimize status OK SELECT * FROM t1 PARTITION (p1) ORDER BY c1; c1 101 102 103 104 105 106 ALTER TABLE t1 CHECK PARTITION p1; Table Op Msg_type Msg_text test.t1 check status OK ALTER TABLE t1 ANALYZE PARTITION p1; Table Op Msg_type Msg_text test.t1 analyze status OK ALTER TABLE t1 REPAIR PARTITION p0sp0,p1; Table Op Msg_type Msg_text test.t1 repair status OK SELECT * FROM t1 ORDER BY c1; c1 3 6 101 102 103 104 105 106 ALTER TABLE t1 DISCARD PARTITION p0sp0 TABLESPACE; ALTER TABLE t1 DISCARD PARTITION p1 TABLESPACE; ALTER TABLE t1 DISCARD PARTITION p0sp1 TABLESPACE; ALTER TABLE t1 DISCARD PARTITION p0sp2 TABLESPACE; restore: t1#P#p0#SP#p0sp0 .ibd and .cfg files restore: t1#P#p0#SP#p0sp1 .ibd and .cfg files restore: t1#P#p0#SP#p0sp2 .ibd and .cfg files restore: t1#P#p1#SP#p1sp0 .ibd and .cfg files restore: t1#P#p1#SP#p1sp1 .ibd and .cfg files restore: t1#P#p1#SP#p1sp2 .ibd and .cfg files ALTER TABLE t1 IMPORT PARTITION all TABLESPACE; SELECT * FROM t1 ORDER BY c1; c1 1 2 3 4 5 6 101 102 103 104 105 106 DROP TABLE t1;
Close