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 | : 18.188.132.192
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 : create_tablespace_partition.result
SET @old_innodb_file_per_table=@@global.innodb_file_per_table; SET GLOBAL innodb_file_per_table = OFF; # # Put all partitions of a table into a general tablespace. # CREATE TABLESPACE s1 ADD DATAFILE 's1.ibd' ENGINE InnoDB; CREATE TABLESPACE `s``1` ADD DATAFILE 's-1.ibd' ENGINE InnoDB; CREATE TABLE t1 (a INT, b INT) ENGINE = InnoDB TABLESPACE=`s1` PARTITION BY RANGE(a) SUBPARTITION BY KEY(b) ( PARTITION tens VALUES LESS THAN (100) TABLESPACE=`innodb_file_per_table` (SUBPARTITION subpart11, SUBPARTITION subpart12), PARTITION hundreds VALUES LESS THAN (1000) (SUBPARTITION subpart21, SUBPARTITION subpart22 TABLESPACE=`innodb_file_per_table`), PARTITION onethousands VALUES LESS THAN (2000) TABLESPACE=`innodb_file_per_table` (SUBPARTITION subpart23 TABLESPACE = `s1`, SUBPARTITION subpart24), PARTITION thousands VALUES LESS THAN (10000) (SUBPARTITION subpart31, SUBPARTITION subpart32)); Warnings: Warning 1681 'InnoDB : A table partition in a shared tablespace' is deprecated and will be removed in a future release. SET GLOBAL innodb_file_per_table = ON; CREATE TABLE t2 (a INT, b INT) ENGINE = InnoDB PARTITION BY RANGE(a) SUBPARTITION BY KEY(b) ( PARTITION tens VALUES LESS THAN (100) TABLESPACE=`s1` (SUBPARTITION subpart11, SUBPARTITION subpart12), PARTITION hundreds VALUES LESS THAN (1000) (SUBPARTITION subpart21, SUBPARTITION subpart22 TABLESPACE=`s``1`), PARTITION thousands VALUES LESS THAN (10000) (SUBPARTITION subpart31 DATA DIRECTORY 'MYSQL_TMP_DIR', SUBPARTITION subpart32 DATA DIRECTORY 'MYSQL_TMP_DIR' TABLESPACE `innodb_file_per_table`)); Warnings: Warning 1681 'InnoDB : A table partition in a shared tablespace' is deprecated and will be removed in a future release. ALTER TABLE t1 ALGORITHM=COPY, ADD PARTITION (PARTITION tenthousands VALUES LESS THAN (20000)); ERROR 0A000: ALGORITHM=COPY/INPLACE is not supported. Reason: Partition specific operations do not yet support LOCK/ALGORITHM. Try ALGORITHM=DEFAULT. ALTER TABLE t1 ALGORITHM=DEFAULT, ADD PARTITION (PARTITION tenthousands VALUES LESS THAN (20000)); Warnings: Warning 1681 'InnoDB : A table partition in a shared tablespace' is deprecated and will be removed in a future release. # Only allow tablespace name as ident, not text. I.e. no 'single' quotes. ALTER TABLE t1 ALGORITHM=COPY, ADD PARTITION (PARTITION twentythousands VALUES LESS THAN (30000) TABLESPACE = 'innodb_system'); 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 ''innodb_system')' at line 3 ALTER TABLE t1 ALGORITHM=COPY, ADD PARTITION (PARTITION twentythousands VALUES LESS THAN (30000) TABLESPACE = "innodb_system"); 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 '"innodb_system")' at line 3 SET @old_sql_mode = @@sql_mode; SET @@sql_mode = 'ANSI_QUOTES'; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. ALTER TABLE t1 ALGORITHM=COPY, ADD PARTITION (PARTITION twentythousands VALUES LESS THAN (30000) TABLESPACE = 'innodb_system'); 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 ''innodb_system')' at line 3 ALTER TABLE t1 ALGORITHM=DEFAULT, ADD PARTITION (PARTITION twentythousands VALUES LESS THAN (30000) TABLESPACE = "innodb_system"); Warnings: Warning 1681 'InnoDB : A table partition in a shared tablespace' is deprecated and will be removed in a future release. ALTER TABLE t1 ALGORITHM=DEFAULT, ADD PARTITION (PARTITION thirtythousands VALUES LESS THAN (40000) TABLESPACE = `innodb_file_per_table`); SET @@sql_mode = @old_sql_mode; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. ALTER TABLE t1 ALGORITHM=DEFAULT, ADD PARTITION (PARTITION fortythousands VALUES LESS THAN (50000) (SUBPARTITION p40k_1 TABLESPACE = innodb_system DATA DIRECTORY = 'MYSQL_TMP_DIR', SUBPARTITION p40k_2 DATA DIRECTORY = 'MYSQL_TMP_DIR')); ERROR HY000: InnoDB: DATA DIRECTORY cannot be used with a TABLESPACE assignment. # Verify that it is OK to have TABLESPACE innodb_system with DATA DIR also on table CREATE TABLE t3 (a int) ENGINE = InnoDB TABLESPACE = innodb_system DATA DIRECTORY = 'MYSQL_TMP_DIR'; ERROR HY000: InnoDB: DATA DIRECTORY cannot be used with a TABLESPACE assignment. CREATE TABLE t3 (a int) ENGINE = InnoDB TABLESPACE = innodb_file_per_table DATA DIRECTORY = 'MYSQL_TMP_DIR'; SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `a` int(11) DEFAULT NULL ) /*!50100 TABLESPACE `innodb_file_per_table` */ ENGINE=InnoDB DEFAULT CHARSET=latin1 DATA DIRECTORY='MYSQL_TMP_DIR/' DROP TABLE t3; CREATE TABLE t3 (a int) ENGINE = InnoDB DATA DIRECTORY = 'MYSQL_TMP_DIR'; SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `a` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 DATA DIRECTORY='MYSQL_TMP_DIR/' DROP TABLE t3; ALTER TABLE t1 ALGORITHM=DEFAULT, ADD PARTITION (PARTITION fortythousands VALUES LESS THAN (50000) (SUBPARTITION p40k_1 DATA DIRECTORY = 'MYSQL_TMP_DIR', SUBPARTITION p40k_2 TABLESPACE = innodb_file_per_table DATA DIRECTORY = 'MYSQL_TMP_DIR')); SET GLOBAL innodb_file_per_table = OFF; ALTER TABLE t1 ALGORITHM=DEFAULT, ADD PARTITION (PARTITION fiftythousands VALUES LESS THAN (60000)); Warnings: Warning 1681 'InnoDB : A table partition in a shared tablespace' is deprecated and will be removed in a future release. ALTER TABLE t1 ALGORITHM=DEFAULT, ADD PARTITION (PARTITION sixtythousands VALUES LESS THAN (70000) TABLESPACE = `innodb_system`); Warnings: Warning 1681 'InnoDB : A table partition in a shared tablespace' is deprecated and will be removed in a future release. ALTER TABLE t1 ALGORITHM=DEFAULT, ADD PARTITION (PARTITION seventythousands VALUES LESS THAN (80000) TABLESPACE = `innodb_file_per_table`); ALTER TABLE t1 ALGORITHM=DEFAULT, ADD PARTITION (PARTITION eightythousands VALUES LESS THAN (90000) (SUBPARTITION p80k_1 TABLESPACE = `innodb_file_per_table` DATA DIRECTORY = 'MYSQL_TMP_DIR', SUBPARTITION p80k_2 TABLESPACE = `innodb_file_per_table` DATA DIRECTORY = 'MYSQL_TMP_DIR')); # Test if both TABLESPACE and DATA DIRECTORY is allowed on table level. CREATE TABLE t3 (a int) ENGINE = InnoDB TABLESPACE = innodb_file_per_table DATA DIRECTORY = 'MYSQL_TMP_DIR'; CREATE TABLE t4 (a int) ENGINE = InnoDB TABLESPACE = innodb_system DATA DIRECTORY = 'MYSQL_TMP_DIR'; ERROR HY000: InnoDB: DATA DIRECTORY cannot be used with a TABLESPACE assignment. ALTER TABLE t1 ALGORITHM=DEFAULT, ADD PARTITION (PARTITION ninetythousands VALUES LESS THAN (100000) (SUBPARTITION p90k_1 TABLESPACE = `innodb_file_per_table`, SUBPARTITION p90k_2 TABLESPACE = `innodb_system`)); Warnings: Warning 1681 'InnoDB : A table partition in a shared tablespace' is deprecated and will be removed in a future release. FLUSH TABLES; === information_schema.innodb_sys_tables and innodb_sys_tablespaces === Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type test/t1#p#eightythousands#sp#p80k_1 test/t1#p#eightythousands#sp#p80k_1 97 5 Dynamic 0 Single test/t1#p#eightythousands#sp#p80k_2 test/t1#p#eightythousands#sp#p80k_2 97 5 Dynamic 0 Single test/t1#p#fiftythousands#sp#fiftythousandssp0 s1 161 5 Dynamic 0 General test/t1#p#fiftythousands#sp#fiftythousandssp1 s1 161 5 Dynamic 0 General test/t1#p#fortythousands#sp#p40k_1 test/t1#p#fortythousands#sp#p40k_1 97 5 Dynamic 0 Single test/t1#p#fortythousands#sp#p40k_2 test/t1#p#fortythousands#sp#p40k_2 97 5 Dynamic 0 Single test/t1#p#hundreds#sp#subpart21 s1 161 5 Dynamic 0 General test/t1#p#hundreds#sp#subpart22 test/t1#p#hundreds#sp#subpart22 33 5 Dynamic 0 Single test/t1#p#ninetythousands#sp#p90k_1 test/t1#p#ninetythousands#sp#p90k_1 33 5 Dynamic 0 Single test/t1#p#ninetythousands#sp#p90k_2 innodb_system 161 5 Dynamic 0 System test/t1#p#onethousands#sp#subpart23 s1 161 5 Dynamic 0 General test/t1#p#onethousands#sp#subpart24 test/t1#p#onethousands#sp#subpart24 33 5 Dynamic 0 Single test/t1#p#seventythousands#sp#seventythousandssp0 test/t1#p#seventythousands#sp#seventythousandssp0 33 5 Dynamic 0 Single test/t1#p#seventythousands#sp#seventythousandssp1 test/t1#p#seventythousands#sp#seventythousandssp1 33 5 Dynamic 0 Single test/t1#p#sixtythousands#sp#sixtythousandssp0 innodb_system 161 5 Dynamic 0 System test/t1#p#sixtythousands#sp#sixtythousandssp1 innodb_system 161 5 Dynamic 0 System test/t1#p#tens#sp#subpart11 test/t1#p#tens#sp#subpart11 33 5 Dynamic 0 Single test/t1#p#tens#sp#subpart12 test/t1#p#tens#sp#subpart12 33 5 Dynamic 0 Single test/t1#p#tenthousands#sp#tenthousandssp0 s1 161 5 Dynamic 0 General test/t1#p#tenthousands#sp#tenthousandssp1 s1 161 5 Dynamic 0 General test/t1#p#thirtythousands#sp#thirtythousandssp0 test/t1#p#thirtythousands#sp#thirtythousandssp0 33 5 Dynamic 0 Single test/t1#p#thirtythousands#sp#thirtythousandssp1 test/t1#p#thirtythousands#sp#thirtythousandssp1 33 5 Dynamic 0 Single test/t1#p#thousands#sp#subpart31 s1 161 5 Dynamic 0 General test/t1#p#thousands#sp#subpart32 s1 161 5 Dynamic 0 General test/t1#p#twentythousands#sp#twentythousandssp0 innodb_system 161 5 Dynamic 0 System test/t1#p#twentythousands#sp#twentythousandssp1 innodb_system 161 5 Dynamic 0 System test/t2#p#hundreds#sp#subpart21 test/t2#p#hundreds#sp#subpart21 33 5 Dynamic 0 Single test/t2#p#hundreds#sp#subpart22 s`1 161 5 Dynamic 0 General test/t2#p#tens#sp#subpart11 s1 161 5 Dynamic 0 General test/t2#p#tens#sp#subpart12 s1 161 5 Dynamic 0 General test/t2#p#thousands#sp#subpart31 test/t2#p#thousands#sp#subpart31 97 5 Dynamic 0 Single test/t2#p#thousands#sp#subpart32 test/t2#p#thousands#sp#subpart32 97 5 Dynamic 0 Single test/t3 test/t3 97 4 Dynamic 0 Single === information_schema.innodb_sys_tablespaces and innodb_sys_datafiles === Space_Name Space_Type Page_Size Zip_Size Formats_Permitted Path s1 General DEFAULT 0 Any MYSQLD_DATADIR/s1.ibd s`1 General DEFAULT 0 Any MYSQLD_DATADIR/s-1.ibd test/t1#p#tens#sp#subpart11 Single DEFAULT 0 Dynamic MYSQLD_DATADIR/test/t1#p#tens#sp#subpart11.ibd test/t1#p#tens#sp#subpart12 Single DEFAULT 0 Dynamic MYSQLD_DATADIR/test/t1#p#tens#sp#subpart12.ibd test/t1#p#hundreds#sp#subpart22 Single DEFAULT 0 Dynamic MYSQLD_DATADIR/test/t1#p#hundreds#sp#subpart22.ibd test/t1#p#onethousands#sp#subpart24 Single DEFAULT 0 Dynamic MYSQLD_DATADIR/test/t1#p#onethousands#sp#subpart24.ibd test/t2#p#hundreds#sp#subpart21 Single DEFAULT 0 Dynamic MYSQLD_DATADIR/test/t2#p#hundreds#sp#subpart21.ibd test/t2#p#thousands#sp#subpart31 Single DEFAULT 0 Dynamic MYSQL_TMP_DIR/test/t2#p#thousands#sp#subpart31.ibd test/t2#p#thousands#sp#subpart32 Single DEFAULT 0 Dynamic MYSQL_TMP_DIR/test/t2#p#thousands#sp#subpart32.ibd test/t1#p#thirtythousands#sp#thirtythousandssp0 Single DEFAULT 0 Dynamic MYSQLD_DATADIR/test/t1#p#thirtythousands#sp#thirtythousandssp0.ibd test/t1#p#thirtythousands#sp#thirtythousandssp1 Single DEFAULT 0 Dynamic MYSQLD_DATADIR/test/t1#p#thirtythousands#sp#thirtythousandssp1.ibd test/t1#p#fortythousands#sp#p40k_1 Single DEFAULT 0 Dynamic MYSQL_TMP_DIR/test/t1#p#fortythousands#sp#p40k_1.ibd test/t1#p#fortythousands#sp#p40k_2 Single DEFAULT 0 Dynamic MYSQL_TMP_DIR/test/t1#p#fortythousands#sp#p40k_2.ibd test/t1#p#seventythousands#sp#seventythousandssp0 Single DEFAULT 0 Dynamic MYSQLD_DATADIR/test/t1#p#seventythousands#sp#seventythousandssp0.ibd test/t1#p#seventythousands#sp#seventythousandssp1 Single DEFAULT 0 Dynamic MYSQLD_DATADIR/test/t1#p#seventythousands#sp#seventythousandssp1.ibd test/t1#p#eightythousands#sp#p80k_1 Single DEFAULT 0 Dynamic MYSQL_TMP_DIR/test/t1#p#eightythousands#sp#p80k_1.ibd test/t1#p#eightythousands#sp#p80k_2 Single DEFAULT 0 Dynamic MYSQL_TMP_DIR/test/t1#p#eightythousands#sp#p80k_2.ibd test/t3 Single DEFAULT 0 Dynamic MYSQL_TMP_DIR/test/t3.ibd test/t1#p#ninetythousands#sp#p90k_1 Single DEFAULT 0 Dynamic MYSQLD_DATADIR/test/t1#p#ninetythousands#sp#p90k_1.ibd === information_schema.files === Space_Name File_Type Engine Status Tablespace_Name Path s1 TABLESPACE InnoDB NORMAL s1 MYSQLD_DATADIR/s1.ibd s`1 TABLESPACE InnoDB NORMAL s`1 MYSQLD_DATADIR/s-1.ibd test/t1#p#tens#sp#subpart11 TABLESPACE InnoDB NORMAL innodb_file_per_table.## MYSQLD_DATADIR/test/t1#p#tens#sp#subpart11.ibd test/t1#p#tens#sp#subpart12 TABLESPACE InnoDB NORMAL innodb_file_per_table.## MYSQLD_DATADIR/test/t1#p#tens#sp#subpart12.ibd test/t1#p#hundreds#sp#subpart22 TABLESPACE InnoDB NORMAL innodb_file_per_table.## MYSQLD_DATADIR/test/t1#p#hundreds#sp#subpart22.ibd test/t1#p#onethousands#sp#subpart24 TABLESPACE InnoDB NORMAL innodb_file_per_table.## MYSQLD_DATADIR/test/t1#p#onethousands#sp#subpart24.ibd test/t2#p#hundreds#sp#subpart21 TABLESPACE InnoDB NORMAL innodb_file_per_table.## MYSQLD_DATADIR/test/t2#p#hundreds#sp#subpart21.ibd test/t2#p#thousands#sp#subpart31 TABLESPACE InnoDB NORMAL innodb_file_per_table.## MYSQL_TMP_DIR/test/t2#p#thousands#sp#subpart31.ibd test/t2#p#thousands#sp#subpart32 TABLESPACE InnoDB NORMAL innodb_file_per_table.## MYSQL_TMP_DIR/test/t2#p#thousands#sp#subpart32.ibd test/t1#p#thirtythousands#sp#thirtythousandssp0 TABLESPACE InnoDB NORMAL innodb_file_per_table.## MYSQLD_DATADIR/test/t1#p#thirtythousands#sp#thirtythousandssp0.ibd test/t1#p#thirtythousands#sp#thirtythousandssp1 TABLESPACE InnoDB NORMAL innodb_file_per_table.## MYSQLD_DATADIR/test/t1#p#thirtythousands#sp#thirtythousandssp1.ibd test/t1#p#fortythousands#sp#p40k_1 TABLESPACE InnoDB NORMAL innodb_file_per_table.## MYSQL_TMP_DIR/test/t1#p#fortythousands#sp#p40k_1.ibd test/t1#p#fortythousands#sp#p40k_2 TABLESPACE InnoDB NORMAL innodb_file_per_table.## MYSQL_TMP_DIR/test/t1#p#fortythousands#sp#p40k_2.ibd test/t1#p#seventythousands#sp#seventythousandssp0 TABLESPACE InnoDB NORMAL innodb_file_per_table.## MYSQLD_DATADIR/test/t1#p#seventythousands#sp#seventythousandssp0.ibd test/t1#p#seventythousands#sp#seventythousandssp1 TABLESPACE InnoDB NORMAL innodb_file_per_table.## MYSQLD_DATADIR/test/t1#p#seventythousands#sp#seventythousandssp1.ibd test/t1#p#eightythousands#sp#p80k_1 TABLESPACE InnoDB NORMAL innodb_file_per_table.## MYSQL_TMP_DIR/test/t1#p#eightythousands#sp#p80k_1.ibd test/t1#p#eightythousands#sp#p80k_2 TABLESPACE InnoDB NORMAL innodb_file_per_table.## MYSQL_TMP_DIR/test/t1#p#eightythousands#sp#p80k_2.ibd test/t3 TABLESPACE InnoDB NORMAL innodb_file_per_table.## MYSQL_TMP_DIR/test/t3.ibd test/t1#p#ninetythousands#sp#p90k_1 TABLESPACE InnoDB NORMAL innodb_file_per_table.## MYSQLD_DATADIR/test/t1#p#ninetythousands#sp#p90k_1.ibd SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) DEFAULT NULL, `b` int(11) DEFAULT NULL ) /*!50100 TABLESPACE `s1` */ ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (a) SUBPARTITION BY KEY (b) (PARTITION tens VALUES LESS THAN (100) (SUBPARTITION subpart11 TABLESPACE = `innodb_file_per_table` ENGINE = InnoDB, SUBPARTITION subpart12 TABLESPACE = `innodb_file_per_table` ENGINE = InnoDB), PARTITION hundreds VALUES LESS THAN (1000) (SUBPARTITION subpart21 TABLESPACE = `s1` ENGINE = InnoDB, SUBPARTITION subpart22 TABLESPACE = `innodb_file_per_table` ENGINE = InnoDB), PARTITION onethousands VALUES LESS THAN (2000) (SUBPARTITION subpart23 TABLESPACE = `s1` ENGINE = InnoDB, SUBPARTITION subpart24 TABLESPACE = `innodb_file_per_table` ENGINE = InnoDB), PARTITION thousands VALUES LESS THAN (10000) (SUBPARTITION subpart31 TABLESPACE = `s1` ENGINE = InnoDB, SUBPARTITION subpart32 TABLESPACE = `s1` ENGINE = InnoDB), PARTITION tenthousands VALUES LESS THAN (20000) (SUBPARTITION tenthousandssp0 TABLESPACE = `s1` ENGINE = InnoDB, SUBPARTITION tenthousandssp1 TABLESPACE = `s1` ENGINE = InnoDB), PARTITION twentythousands VALUES LESS THAN (30000) (SUBPARTITION twentythousandssp0 TABLESPACE = `innodb_system` ENGINE = InnoDB, SUBPARTITION twentythousandssp1 TABLESPACE = `innodb_system` ENGINE = InnoDB), PARTITION thirtythousands VALUES LESS THAN (40000) (SUBPARTITION thirtythousandssp0 TABLESPACE = `innodb_file_per_table` ENGINE = InnoDB, SUBPARTITION thirtythousandssp1 TABLESPACE = `innodb_file_per_table` ENGINE = InnoDB), PARTITION fortythousands VALUES LESS THAN (50000) (SUBPARTITION p40k_1 DATA DIRECTORY = 'MYSQL_TMP_DIR' ENGINE = InnoDB, SUBPARTITION p40k_2 TABLESPACE = `innodb_file_per_table` DATA DIRECTORY = 'MYSQL_TMP_DIR' ENGINE = InnoDB), PARTITION fiftythousands VALUES LESS THAN (60000) (SUBPARTITION fiftythousandssp0 TABLESPACE = `s1` ENGINE = InnoDB, SUBPARTITION fiftythousandssp1 TABLESPACE = `s1` ENGINE = InnoDB), PARTITION sixtythousands VALUES LESS THAN (70000) (SUBPARTITION sixtythousandssp0 TABLESPACE = `innodb_system` ENGINE = InnoDB, SUBPARTITION sixtythousandssp1 TABLESPACE = `innodb_system` ENGINE = InnoDB), PARTITION seventythousands VALUES LESS THAN (80000) (SUBPARTITION seventythousandssp0 TABLESPACE = `innodb_file_per_table` ENGINE = InnoDB, SUBPARTITION seventythousandssp1 TABLESPACE = `innodb_file_per_table` ENGINE = InnoDB), PARTITION eightythousands VALUES LESS THAN (90000) (SUBPARTITION p80k_1 TABLESPACE = `innodb_file_per_table` DATA DIRECTORY = 'MYSQL_TMP_DIR' ENGINE = InnoDB, SUBPARTITION p80k_2 TABLESPACE = `innodb_file_per_table` DATA DIRECTORY = 'MYSQL_TMP_DIR' ENGINE = InnoDB), PARTITION ninetythousands VALUES LESS THAN (100000) (SUBPARTITION p90k_1 TABLESPACE = `innodb_file_per_table` ENGINE = InnoDB, SUBPARTITION p90k_2 TABLESPACE = `innodb_system` ENGINE = InnoDB)) */ SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `a` int(11) DEFAULT NULL, `b` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (a) SUBPARTITION BY KEY (b) (PARTITION tens VALUES LESS THAN (100) (SUBPARTITION subpart11 TABLESPACE = `s1` ENGINE = InnoDB, SUBPARTITION subpart12 TABLESPACE = `s1` ENGINE = InnoDB), PARTITION hundreds VALUES LESS THAN (1000) (SUBPARTITION subpart21 ENGINE = InnoDB, SUBPARTITION subpart22 TABLESPACE = `s``1` ENGINE = InnoDB), PARTITION thousands VALUES LESS THAN (10000) (SUBPARTITION subpart31 DATA DIRECTORY = 'MYSQL_TMP_DIR/' ENGINE = InnoDB, SUBPARTITION subpart32 TABLESPACE = `innodb_file_per_table` DATA DIRECTORY = 'MYSQL_TMP_DIR/' ENGINE = InnoDB)) */ SET @@sql_mode = 'ANSI_QUOTES'; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. SET GLOBAL innodb_file_per_table = ON; FLUSH TABLES; SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE "t1" ( "a" int(11) DEFAULT NULL, "b" int(11) DEFAULT NULL ) /*!50100 TABLESPACE "s1" */ ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (a) SUBPARTITION BY KEY (b) (PARTITION tens VALUES LESS THAN (100) (SUBPARTITION subpart11 TABLESPACE = "innodb_file_per_table" ENGINE = InnoDB, SUBPARTITION subpart12 TABLESPACE = "innodb_file_per_table" ENGINE = InnoDB), PARTITION hundreds VALUES LESS THAN (1000) (SUBPARTITION subpart21 TABLESPACE = "s1" ENGINE = InnoDB, SUBPARTITION subpart22 TABLESPACE = "innodb_file_per_table" ENGINE = InnoDB), PARTITION onethousands VALUES LESS THAN (2000) (SUBPARTITION subpart23 TABLESPACE = "s1" ENGINE = InnoDB, SUBPARTITION subpart24 TABLESPACE = "innodb_file_per_table" ENGINE = InnoDB), PARTITION thousands VALUES LESS THAN (10000) (SUBPARTITION subpart31 TABLESPACE = "s1" ENGINE = InnoDB, SUBPARTITION subpart32 TABLESPACE = "s1" ENGINE = InnoDB), PARTITION tenthousands VALUES LESS THAN (20000) (SUBPARTITION tenthousandssp0 TABLESPACE = "s1" ENGINE = InnoDB, SUBPARTITION tenthousandssp1 TABLESPACE = "s1" ENGINE = InnoDB), PARTITION twentythousands VALUES LESS THAN (30000) (SUBPARTITION twentythousandssp0 TABLESPACE = "innodb_system" ENGINE = InnoDB, SUBPARTITION twentythousandssp1 TABLESPACE = "innodb_system" ENGINE = InnoDB), PARTITION thirtythousands VALUES LESS THAN (40000) (SUBPARTITION thirtythousandssp0 TABLESPACE = "innodb_file_per_table" ENGINE = InnoDB, SUBPARTITION thirtythousandssp1 TABLESPACE = "innodb_file_per_table" ENGINE = InnoDB), PARTITION fortythousands VALUES LESS THAN (50000) (SUBPARTITION p40k_1 DATA DIRECTORY = 'MYSQL_TMP_DIR' ENGINE = InnoDB, SUBPARTITION p40k_2 TABLESPACE = "innodb_file_per_table" DATA DIRECTORY = 'MYSQL_TMP_DIR' ENGINE = InnoDB), PARTITION fiftythousands VALUES LESS THAN (60000) (SUBPARTITION fiftythousandssp0 TABLESPACE = "s1" ENGINE = InnoDB, SUBPARTITION fiftythousandssp1 TABLESPACE = "s1" ENGINE = InnoDB), PARTITION sixtythousands VALUES LESS THAN (70000) (SUBPARTITION sixtythousandssp0 TABLESPACE = "innodb_system" ENGINE = InnoDB, SUBPARTITION sixtythousandssp1 TABLESPACE = "innodb_system" ENGINE = InnoDB), PARTITION seventythousands VALUES LESS THAN (80000) (SUBPARTITION seventythousandssp0 TABLESPACE = "innodb_file_per_table" ENGINE = InnoDB, SUBPARTITION seventythousandssp1 TABLESPACE = "innodb_file_per_table" ENGINE = InnoDB), PARTITION eightythousands VALUES LESS THAN (90000) (SUBPARTITION p80k_1 TABLESPACE = "innodb_file_per_table" DATA DIRECTORY = 'MYSQL_TMP_DIR' ENGINE = InnoDB, SUBPARTITION p80k_2 TABLESPACE = "innodb_file_per_table" DATA DIRECTORY = 'MYSQL_TMP_DIR' ENGINE = InnoDB), PARTITION ninetythousands VALUES LESS THAN (100000) (SUBPARTITION p90k_1 TABLESPACE = "innodb_file_per_table" ENGINE = InnoDB, SUBPARTITION p90k_2 TABLESPACE = "innodb_system" ENGINE = InnoDB)) */ SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE "t2" ( "a" int(11) DEFAULT NULL, "b" int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (a) SUBPARTITION BY KEY (b) (PARTITION tens VALUES LESS THAN (100) (SUBPARTITION subpart11 TABLESPACE = "s1" ENGINE = InnoDB, SUBPARTITION subpart12 TABLESPACE = "s1" ENGINE = InnoDB), PARTITION hundreds VALUES LESS THAN (1000) (SUBPARTITION subpart21 ENGINE = InnoDB, SUBPARTITION subpart22 TABLESPACE = "s`1" ENGINE = InnoDB), PARTITION thousands VALUES LESS THAN (10000) (SUBPARTITION subpart31 DATA DIRECTORY = 'MYSQL_TMP_DIR/' ENGINE = InnoDB, SUBPARTITION subpart32 TABLESPACE = "innodb_file_per_table" DATA DIRECTORY = 'MYSQL_TMP_DIR/' ENGINE = InnoDB)) */ # DISCARD will only work on the first partitions that use file_per_table ALTER TABLE t1 ALGORITHM=INPLACE, DISCARD TABLESPACE; ERROR 0A000: ALGORITHM=COPY/INPLACE is not supported for this operation. Try ALGORITHM=DEFAULT. ALTER TABLE t1 ALGORITHM=DEFAULT, DISCARD TABLESPACE; ERROR 42000: InnoDB: Cannot discard table `test/t1#p#hundreds#sp#subpart21` because it is in a general tablespace. It must be file-per-table. SET @@sql_mode = @old_sql_mode; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. ALTER TABLE t2 DISCARD TABLESPACE; ERROR 42000: InnoDB: Cannot discard table `test/t2#p#tens#sp#subpart11` because it is in a general tablespace. It must be file-per-table. call mtr.add_suppression("Table .* Subpartition .* does not exist in the InnoDB internal data dict"); call mtr.add_suppression("Missing .ibd file for table .*subpart"); DROP TABLE t1; DROP TABLE t2; CREATE TABLE `t1` ( `a` int(11) DEFAULT NULL, `b` int(11) DEFAULT NULL ) /*!50100 TABLESPACE `s1` */ ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (a) SUBPARTITION BY KEY (b) (PARTITION tens VALUES LESS THAN (100) (SUBPARTITION subpart11 ENGINE = InnoDB, SUBPARTITION subpart12 ENGINE = InnoDB), PARTITION hundreds VALUES LESS THAN (1000) (SUBPARTITION subpart21 TABLESPACE = s1 ENGINE = InnoDB, SUBPARTITION subpart22 ENGINE = InnoDB), PARTITION onethousands VALUES LESS THAN (2000) (SUBPARTITION subpart23 TABLESPACE = s1 ENGINE = InnoDB, SUBPARTITION subpart24 ENGINE = InnoDB), PARTITION thousands VALUES LESS THAN (10000) (SUBPARTITION subpart31 TABLESPACE = s1 ENGINE = InnoDB, SUBPARTITION subpart32 TABLESPACE = s1 ENGINE = InnoDB), PARTITION tenthousands VALUES LESS THAN (20000) (SUBPARTITION tenthousandssp0 TABLESPACE = s1 ENGINE = InnoDB, SUBPARTITION tenthousandssp1 TABLESPACE = s1 ENGINE = InnoDB), PARTITION twentythousands VALUES LESS THAN (30000) (SUBPARTITION twentythousandssp0 TABLESPACE = innodb_system ENGINE = InnoDB, SUBPARTITION twentythousandssp1 TABLESPACE = innodb_system ENGINE = InnoDB), PARTITION thirtythousands VALUES LESS THAN (40000) (SUBPARTITION thirtythousandssp0 ENGINE = InnoDB, SUBPARTITION thirtythousandssp1 ENGINE = InnoDB), PARTITION fortythousands VALUES LESS THAN (50000) (SUBPARTITION p40k_1 TABLESPACE = innodb_system ENGINE = InnoDB, SUBPARTITION p40k_2 DATA DIRECTORY = 'MYSQL_TMP_DIR' ENGINE = InnoDB), PARTITION fiftythousands VALUES LESS THAN (60000) (SUBPARTITION fiftythousandssp0 TABLESPACE = s1 ENGINE = InnoDB, SUBPARTITION fiftythousandssp1 TABLESPACE = s1 ENGINE = InnoDB), PARTITION sixtythousands VALUES LESS THAN (70000) (SUBPARTITION sixtythousandssp0 TABLESPACE = innodb_system ENGINE = InnoDB, SUBPARTITION sixtythousandssp1 TABLESPACE = innodb_system ENGINE = InnoDB), PARTITION seventythousands VALUES LESS THAN (80000) (SUBPARTITION seventythousandssp0 ENGINE = InnoDB, SUBPARTITION seventythousandssp1 ENGINE = InnoDB), PARTITION ninetythousands VALUES LESS THAN (100000) (SUBPARTITION p90k_1 ENGINE = InnoDB, SUBPARTITION p90k_2 TABLESPACE = innodb_system ENGINE = InnoDB)) */; Warnings: Warning 1681 'InnoDB : A table partition in a shared tablespace' is deprecated and will be removed in a future release. CREATE TABLE `t2` ( `a` int(11) DEFAULT NULL, `b` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (a) SUBPARTITION BY KEY (b) (PARTITION tens VALUES LESS THAN (100) (SUBPARTITION subpart11 TABLESPACE = s1 ENGINE = InnoDB, SUBPARTITION subpart12 TABLESPACE = s1 ENGINE = InnoDB), PARTITION hundreds VALUES LESS THAN (1000) (SUBPARTITION subpart21 ENGINE = InnoDB, SUBPARTITION subpart22 TABLESPACE = `s``1` ENGINE = InnoDB), PARTITION thousands VALUES LESS THAN (10000) (SUBPARTITION subpart31 ENGINE = InnoDB, SUBPARTITION subpart32 ENGINE = InnoDB)) */; Warnings: Warning 1681 'InnoDB : A table partition in a shared tablespace' is deprecated and will be removed in a future release. === information_schema.innodb_sys_tables and innodb_sys_tablespaces === Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type test/t1#p#fiftythousands#sp#fiftythousandssp0 s1 161 5 Dynamic 0 General test/t1#p#fiftythousands#sp#fiftythousandssp1 s1 161 5 Dynamic 0 General test/t1#p#fortythousands#sp#p40k_1 innodb_system 161 5 Dynamic 0 System test/t1#p#fortythousands#sp#p40k_2 test/t1#p#fortythousands#sp#p40k_2 97 5 Dynamic 0 Single test/t1#p#hundreds#sp#subpart21 s1 161 5 Dynamic 0 General test/t1#p#hundreds#sp#subpart22 s1 161 5 Dynamic 0 General test/t1#p#ninetythousands#sp#p90k_1 s1 161 5 Dynamic 0 General test/t1#p#ninetythousands#sp#p90k_2 innodb_system 161 5 Dynamic 0 System test/t1#p#onethousands#sp#subpart23 s1 161 5 Dynamic 0 General test/t1#p#onethousands#sp#subpart24 s1 161 5 Dynamic 0 General test/t1#p#seventythousands#sp#seventythousandssp0 s1 161 5 Dynamic 0 General test/t1#p#seventythousands#sp#seventythousandssp1 s1 161 5 Dynamic 0 General test/t1#p#sixtythousands#sp#sixtythousandssp0 innodb_system 161 5 Dynamic 0 System test/t1#p#sixtythousands#sp#sixtythousandssp1 innodb_system 161 5 Dynamic 0 System test/t1#p#tens#sp#subpart11 s1 161 5 Dynamic 0 General test/t1#p#tens#sp#subpart12 s1 161 5 Dynamic 0 General test/t1#p#tenthousands#sp#tenthousandssp0 s1 161 5 Dynamic 0 General test/t1#p#tenthousands#sp#tenthousandssp1 s1 161 5 Dynamic 0 General test/t1#p#thirtythousands#sp#thirtythousandssp0 s1 161 5 Dynamic 0 General test/t1#p#thirtythousands#sp#thirtythousandssp1 s1 161 5 Dynamic 0 General test/t1#p#thousands#sp#subpart31 s1 161 5 Dynamic 0 General test/t1#p#thousands#sp#subpart32 s1 161 5 Dynamic 0 General test/t1#p#twentythousands#sp#twentythousandssp0 innodb_system 161 5 Dynamic 0 System test/t1#p#twentythousands#sp#twentythousandssp1 innodb_system 161 5 Dynamic 0 System test/t2#p#hundreds#sp#subpart21 test/t2#p#hundreds#sp#subpart21 33 5 Dynamic 0 Single test/t2#p#hundreds#sp#subpart22 s`1 161 5 Dynamic 0 General test/t2#p#tens#sp#subpart11 s1 161 5 Dynamic 0 General test/t2#p#tens#sp#subpart12 s1 161 5 Dynamic 0 General test/t2#p#thousands#sp#subpart31 test/t2#p#thousands#sp#subpart31 33 5 Dynamic 0 Single test/t2#p#thousands#sp#subpart32 test/t2#p#thousands#sp#subpart32 33 5 Dynamic 0 Single test/t3 test/t3 97 4 Dynamic 0 Single === information_schema.innodb_sys_tablespaces and innodb_sys_datafiles === Space_Name Space_Type Page_Size Zip_Size Formats_Permitted Path s1 General DEFAULT 0 Any MYSQLD_DATADIR/s1.ibd s`1 General DEFAULT 0 Any MYSQLD_DATADIR/s-1.ibd test/t3 Single DEFAULT 0 Dynamic MYSQL_TMP_DIR/test/t3.ibd test/t1#p#fortythousands#sp#p40k_2 Single DEFAULT 0 Dynamic MYSQL_TMP_DIR/test/t1#p#fortythousands#sp#p40k_2.ibd test/t2#p#hundreds#sp#subpart21 Single DEFAULT 0 Dynamic MYSQLD_DATADIR/test/t2#p#hundreds#sp#subpart21.ibd test/t2#p#thousands#sp#subpart31 Single DEFAULT 0 Dynamic MYSQLD_DATADIR/test/t2#p#thousands#sp#subpart31.ibd test/t2#p#thousands#sp#subpart32 Single DEFAULT 0 Dynamic MYSQLD_DATADIR/test/t2#p#thousands#sp#subpart32.ibd === information_schema.files === Space_Name File_Type Engine Status Tablespace_Name Path s1 TABLESPACE InnoDB NORMAL s1 MYSQLD_DATADIR/s1.ibd s`1 TABLESPACE InnoDB NORMAL s`1 MYSQLD_DATADIR/s-1.ibd test/t3 TABLESPACE InnoDB NORMAL innodb_file_per_table.## MYSQL_TMP_DIR/test/t3.ibd test/t1#p#fortythousands#sp#p40k_2 TABLESPACE InnoDB NORMAL innodb_file_per_table.## MYSQL_TMP_DIR/test/t1#p#fortythousands#sp#p40k_2.ibd test/t2#p#hundreds#sp#subpart21 TABLESPACE InnoDB NORMAL innodb_file_per_table.## MYSQLD_DATADIR/test/t2#p#hundreds#sp#subpart21.ibd test/t2#p#thousands#sp#subpart31 TABLESPACE InnoDB NORMAL innodb_file_per_table.## MYSQLD_DATADIR/test/t2#p#thousands#sp#subpart31.ibd test/t2#p#thousands#sp#subpart32 TABLESPACE InnoDB NORMAL innodb_file_per_table.## MYSQLD_DATADIR/test/t2#p#thousands#sp#subpart32.ibd SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) DEFAULT NULL, `b` int(11) DEFAULT NULL ) /*!50100 TABLESPACE `s1` */ ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (a) SUBPARTITION BY KEY (b) (PARTITION tens VALUES LESS THAN (100) (SUBPARTITION subpart11 TABLESPACE = `s1` ENGINE = InnoDB, SUBPARTITION subpart12 TABLESPACE = `s1` ENGINE = InnoDB), PARTITION hundreds VALUES LESS THAN (1000) (SUBPARTITION subpart21 TABLESPACE = `s1` ENGINE = InnoDB, SUBPARTITION subpart22 TABLESPACE = `s1` ENGINE = InnoDB), PARTITION onethousands VALUES LESS THAN (2000) (SUBPARTITION subpart23 TABLESPACE = `s1` ENGINE = InnoDB, SUBPARTITION subpart24 TABLESPACE = `s1` ENGINE = InnoDB), PARTITION thousands VALUES LESS THAN (10000) (SUBPARTITION subpart31 TABLESPACE = `s1` ENGINE = InnoDB, SUBPARTITION subpart32 TABLESPACE = `s1` ENGINE = InnoDB), PARTITION tenthousands VALUES LESS THAN (20000) (SUBPARTITION tenthousandssp0 TABLESPACE = `s1` ENGINE = InnoDB, SUBPARTITION tenthousandssp1 TABLESPACE = `s1` ENGINE = InnoDB), PARTITION twentythousands VALUES LESS THAN (30000) (SUBPARTITION twentythousandssp0 TABLESPACE = `innodb_system` ENGINE = InnoDB, SUBPARTITION twentythousandssp1 TABLESPACE = `innodb_system` ENGINE = InnoDB), PARTITION thirtythousands VALUES LESS THAN (40000) (SUBPARTITION thirtythousandssp0 TABLESPACE = `s1` ENGINE = InnoDB, SUBPARTITION thirtythousandssp1 TABLESPACE = `s1` ENGINE = InnoDB), PARTITION fortythousands VALUES LESS THAN (50000) (SUBPARTITION p40k_1 TABLESPACE = `innodb_system` ENGINE = InnoDB, SUBPARTITION p40k_2 DATA DIRECTORY = 'MYSQL_TMP_DIR/' ENGINE = InnoDB), PARTITION fiftythousands VALUES LESS THAN (60000) (SUBPARTITION fiftythousandssp0 TABLESPACE = `s1` ENGINE = InnoDB, SUBPARTITION fiftythousandssp1 TABLESPACE = `s1` ENGINE = InnoDB), PARTITION sixtythousands VALUES LESS THAN (70000) (SUBPARTITION sixtythousandssp0 TABLESPACE = `innodb_system` ENGINE = InnoDB, SUBPARTITION sixtythousandssp1 TABLESPACE = `innodb_system` ENGINE = InnoDB), PARTITION seventythousands VALUES LESS THAN (80000) (SUBPARTITION seventythousandssp0 TABLESPACE = `s1` ENGINE = InnoDB, SUBPARTITION seventythousandssp1 TABLESPACE = `s1` ENGINE = InnoDB), PARTITION ninetythousands VALUES LESS THAN (100000) (SUBPARTITION p90k_1 TABLESPACE = `s1` ENGINE = InnoDB, SUBPARTITION p90k_2 TABLESPACE = `innodb_system` ENGINE = InnoDB)) */ SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `a` int(11) DEFAULT NULL, `b` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (a) SUBPARTITION BY KEY (b) (PARTITION tens VALUES LESS THAN (100) (SUBPARTITION subpart11 TABLESPACE = `s1` ENGINE = InnoDB, SUBPARTITION subpart12 TABLESPACE = `s1` ENGINE = InnoDB), PARTITION hundreds VALUES LESS THAN (1000) (SUBPARTITION subpart21 ENGINE = InnoDB, SUBPARTITION subpart22 TABLESPACE = `s``1` ENGINE = InnoDB), PARTITION thousands VALUES LESS THAN (10000) (SUBPARTITION subpart31 ENGINE = InnoDB, SUBPARTITION subpart32 ENGINE = InnoDB)) */ SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `a` int(11) DEFAULT NULL ) /*!50100 TABLESPACE `innodb_file_per_table` */ ENGINE=InnoDB DEFAULT CHARSET=latin1 DATA DIRECTORY='MYSQL_TMP_DIR/' ALTER TABLE t3 DISCARD TABLESPACE; DROP TABLE t1, t2, t3; DROP TABLESPACE s1; DROP TABLESPACE `s``1`; CREATE TABLESPACE `ts1` ADD DATAFILE 'ts1.ibd' Engine=InnoDB; CREATE TABLE t1 (c1 INT PRIMARY KEY) TABLESPACE ts1 ROW_FORMAT=COMPACT; CREATE TABLE ti (id INT, amount DECIMAL(7,2), tr_date DATE) TABLESPACE ts1 ENGINE=INNODB PARTITION BY HASH( MONTH(tr_date) ) PARTITIONS 6; Warnings: Warning 1681 'InnoDB : A table partition in a shared tablespace' is deprecated and will be removed in a future release. DROP TABLE t1,ti; DROP TABLESPACE ts1; # # Clean-up. # SET @@global.innodb_file_per_table=@old_innodb_file_per_table;
Close