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.224.70.193
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 : table_compress.result
# # Test support for the COMPRESSION syntax on any system by # making InnoDB ignore the actual Punch Hole and setting the # file system punch hole size (block_size or compression unit) # to half the UNIV_PAGE_SIZE so that punch hole seems to work # even though no space on the FS is being released. # SET DEFAULT_STORAGE_ENGINE=InnoDB; SET GLOBAL innodb_file_per_table = ON; SELECT @@innodb_file_per_table; @@innodb_file_per_table 1 CREATE TABLESPACE s1 ADD DATAFILE 's1.ibd'; # # Try to create a table with ZLib compression with strict mode OFF. # If there is an error about Punch Hole not supported, make InnoDB # think that Punch Hole is working but actually ignore the calls. # SET SESSION innodb_strict_mode = OFF; SELECT @@innodb_strict_mode; @@innodb_strict_mode 0 CREATE TABLE t1(c1 INT PRIMARY KEY) COMPRESSION="ZLIB"; DROP TABLE t1; # # Test acceptable DDL with innodb_strict_mode=ON. # SET SESSION innodb_strict_mode = ON; SELECT @@innodb_strict_mode; @@innodb_strict_mode 1 CREATE TABLE t1(c1 INT PRIMARY KEY) COMPRESSION="ZLIB"; SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` int(11) NOT NULL, PRIMARY KEY (`c1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMPRESSION='ZLIB' INSERT INTO t1 VALUES(1),(2),(3),(4); FLUSH TABLES t1 WITH READ LOCK; UNLOCK TABLES; SELECT * FROM t1; c1 1 2 3 4 CREATE TABLE t2(c1 INT PRIMARY KEY) COMPRESSION="LZ4"; SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` int(11) NOT NULL, PRIMARY KEY (`c1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMPRESSION='LZ4' INSERT INTO t2 VALUES(1),(2),(3),(4); FLUSH TABLES t2 WITH READ LOCK; UNLOCK TABLES; SELECT * FROM t2; c1 1 2 3 4 SELECT TABLE_NAME, CREATE_OPTIONS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1' OR TABLE_NAME = 't2' ORDER BY TABLE_NAME; TABLE_NAME CREATE_OPTIONS t1 COMPRESSION="ZLIB" t2 COMPRESSION="LZ4" SELECT NAME,ROW_FORMAT,SPACE_TYPE FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES WHERE NAME LIKE 'test/t%' ORDER BY NAME; NAME ROW_FORMAT SPACE_TYPE test/t1 Dynamic Single test/t2 Dynamic Single # # Bug#21687636 COMPRESSION COLUMN IN INNODB_SYS_TABLESPACES IS NOT CORRECT # # restart SET GLOBAL innodb_file_per_table = ON; SET SESSION innodb_strict_mode = ON; SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` int(11) NOT NULL, PRIMARY KEY (`c1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMPRESSION='ZLIB' SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` int(11) NOT NULL, PRIMARY KEY (`c1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMPRESSION='LZ4' # # Bug#21557723 Create table from the SHOW CREATE TABLE output # DROP TABLE t1, t2; CREATE TABLE `t1` ( `c1` int(11) NOT NULL, PRIMARY KEY (`c1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMPRESSION='ZLIB'; CREATE TABLE `t2` ( `c1` int(11) NOT NULL, PRIMARY KEY (`c1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMPRESSION='LZ4'; SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` int(11) NOT NULL, PRIMARY KEY (`c1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMPRESSION='ZLIB' SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` int(11) NOT NULL, PRIMARY KEY (`c1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMPRESSION='LZ4' SELECT TABLE_NAME, CREATE_OPTIONS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1' OR TABLE_NAME = 't2' ORDER BY TABLE_NAME; TABLE_NAME CREATE_OPTIONS t1 COMPRESSION="ZLIB" t2 COMPRESSION="LZ4" SELECT NAME,ROW_FORMAT,SPACE_TYPE FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES WHERE NAME LIKE 'test/t%' ORDER BY NAME; NAME ROW_FORMAT SPACE_TYPE test/t1 Dynamic Single test/t2 Dynamic Single INSERT INTO t1 VALUES(1),(2),(3),(4); FLUSH TABLES t1 WITH READ LOCK; UNLOCK TABLES; SELECT * FROM t1; c1 1 2 3 4 INSERT INTO t2 VALUES(1),(2),(3),(4); FLUSH TABLES t2 WITH READ LOCK; UNLOCK TABLES; SELECT * FROM t2; c1 1 2 3 4 DROP TABLE t2; # # Create a second table using CREATE TABLE LIKE and CREATE TABLE AS SELECT * # starting with a table that really has Page Compression # CREATE TABLE t2 LIKE t1; INSERT INTO t2 SELECT * FROM t1; CREATE TABLE t3 AS SELECT * FROM t1; CREATE DATABASE test2; CREATE TABLE test2.t2 LIKE t1; INSERT INTO test2.t2 SELECT * FROM t1; CREATE TABLE test2.t3 AS SELECT * FROM t1; SELECT TABLE_SCHEMA, TABLE_NAME, CREATE_OPTIONS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't2' OR TABLE_NAME = 't3' ORDER BY TABLE_SCHEMA, TABLE_NAME; TABLE_SCHEMA TABLE_NAME CREATE_OPTIONS test t2 COMPRESSION="ZLIB" test t3 test2 t2 COMPRESSION="ZLIB" test2 t3 SELECT NAME,ROW_FORMAT,SPACE_TYPE FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES WHERE NAME LIKE 'test%/t%' ORDER BY NAME; NAME ROW_FORMAT SPACE_TYPE test/t1 Dynamic Single test/t2 Dynamic Single test/t3 Dynamic Single test2/t2 Dynamic Single test2/t3 Dynamic Single SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` int(11) NOT NULL, PRIMARY KEY (`c1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMPRESSION='ZLIB' SHOW CREATE TABLE t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 SHOW CREATE TABLE test2.t2; Table Create Table t2 CREATE TABLE `t2` ( `c1` int(11) NOT NULL, PRIMARY KEY (`c1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMPRESSION='ZLIB' SHOW CREATE TABLE test2.t3; Table Create Table t3 CREATE TABLE `t3` ( `c1` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 DROP TABLE t2; DROP TABLE t3; DROP TABLE test2.t2; DROP TABLE test2.t3; DROP DATABASE test2; # # Change compression with ALTER TABLE # ALTER TABLE t1 COMPRESSION=''; INSERT INTO t1 VALUES(5); FLUSH TABLES t1 WITH READ LOCK; UNLOCK TABLES; SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` int(11) NOT NULL, PRIMARY KEY (`c1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 SELECT TABLE_NAME, CREATE_OPTIONS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1'; TABLE_NAME CREATE_OPTIONS t1 SELECT NAME,ROW_FORMAT,SPACE_TYPE FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES WHERE NAME = 'test/t1'; NAME ROW_FORMAT SPACE_TYPE test/t1 Dynamic Single ALTER TABLE t1 COMPRESSION='LZ4'; INSERT INTO t1 VALUES(6); FLUSH TABLES t1 WITH READ LOCK; UNLOCK TABLES; SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` int(11) NOT NULL, PRIMARY KEY (`c1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMPRESSION='LZ4' SELECT TABLE_NAME, CREATE_OPTIONS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1'; TABLE_NAME CREATE_OPTIONS t1 COMPRESSION="LZ4" SELECT NAME,ROW_FORMAT,SPACE_TYPE FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES WHERE NAME = 'test/t1'; NAME ROW_FORMAT SPACE_TYPE test/t1 Dynamic Single ALTER TABLE t1 COMPRESSION='NONE'; INSERT INTO t1 VALUES(7); FLUSH TABLES t1 WITH READ LOCK; UNLOCK TABLES; SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` int(11) NOT NULL, PRIMARY KEY (`c1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMPRESSION='NONE' SELECT TABLE_NAME, CREATE_OPTIONS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1'; TABLE_NAME CREATE_OPTIONS t1 COMPRESSION="NONE" SELECT NAME,ROW_FORMAT,SPACE_TYPE FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES WHERE NAME = 'test/t1'; NAME ROW_FORMAT SPACE_TYPE test/t1 Dynamic Single OPTIMIZE TABLE t1; Table Op Msg_type Msg_text test.t1 optimize note Table does not support optimize, doing recreate + analyze instead test.t1 optimize status OK SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` int(11) NOT NULL, PRIMARY KEY (`c1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMPRESSION='NONE' SELECT TABLE_NAME, CREATE_OPTIONS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1'; TABLE_NAME CREATE_OPTIONS t1 COMPRESSION="NONE" SELECT NAME,ROW_FORMAT,SPACE_TYPE FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES WHERE NAME = 'test/t1'; NAME ROW_FORMAT SPACE_TYPE test/t1 Dynamic Single DROP TABLE t1; # # Test various BAD DDL with innodb_strict_mode=ON. # CREATE TABLE t1(c1 INT PRIMARY KEY) COMPRESSION="zlibX"; ERROR HY000: Table storage engine for 't1' doesn't have this option SHOW WARNINGS; Level Code Message Warning 1112 InnoDB: Unsupported compression algorithm 'zlibX' Error 1031 Table storage engine for 't1' doesn't have this option SHOW CREATE TABLE t1; ERROR 42S02: Table 'test.t1' doesn't exist # # Check for too long string # SET @long_str = REPEAT('ZLIB', 32768); SET @s = CONCAT('CREATE TABLE t1(c1 INT) ENGINE=InnoDB, COMPRESSION="', @long_str, '"'); PREPARE stmt from @s; EXECUTE stmt; ERROR HY000: String 'ZLIBZLIBZLIBZLIBZLIBZLIBZLIBZLIBZLIBZLIBZLIBZLIBZLIBZLIBZLIBZLIBZLIBZL' is too long for COMPRESSION (should be no longer than 2048) SHOW WARNINGS; Level Code Message Error 1470 String 'ZLIBZLIBZLIBZLIBZLIBZLIBZLIBZLIBZLIBZLIBZLIBZLIBZLIBZLIBZLIBZLIBZLIBZL' is too long for COMPRESSION (should be no longer than 2048) DEALLOCATE PREPARE stmt; SHOW CREATE TABLE t1; ERROR 42S02: Table 'test.t1' doesn't exist # # Compression cannot be used with ROW_FORMAT=COMPRESSED, TEMPORARY # or Shared tablespaces, either general or system. # # CREATE TABLE: COMPRESSION + TEMPORARY CREATE TEMPORARY TABLE t1(c1 INT PRIMARY KEY) COMPRESSION="ZLIB"; ERROR HY000: Table storage engine for 't1' doesn't have this option SHOW WARNINGS; Level Code Message Warning 138 InnoDB: Page Compression is not supported for temporary tables Error 1031 Table storage engine for 't1' doesn't have this option # CREATE TABLE: COMPRESSION + TABLESPACE CREATE TABLE t1(c1 INT PRIMARY KEY) COMPRESSION="ZLIB" TABLESPACE=s1; ERROR HY000: Table storage engine for 't1' doesn't have this option SHOW WARNINGS; Level Code Message Warning 138 InnoDB: Page Compression is not supported for shared general tablespaces Error 1031 Table storage engine for 't1' doesn't have this option # CREATE TABLE: COMPRESSION + TABLESPACE=innodb_system CREATE TABLE t1(c1 INT PRIMARY KEY) COMPRESSION="ZLIB" TABLESPACE=innodb_system; ERROR HY000: Table storage engine for 't1' doesn't have this option SHOW WARNINGS; Level Code Message Warning 138 InnoDB: Page Compression is not supported for the system tablespace Error 1031 Table storage engine for 't1' doesn't have this option # CREATE TABLE: COMPRESSION + TABLESPACE=innodb_temporary CREATE TABLE t1(c1 INT PRIMARY KEY) COMPRESSION="ZLIB" TABLESPACE=innodb_temporary; ERROR HY000: InnoDB: Tablespace `innodb_temporary` can only contain TEMPORARY tables. SHOW WARNINGS; Level Code Message Error 1478 InnoDB: Tablespace `innodb_temporary` can only contain TEMPORARY tables. Error 1031 Table storage engine for 't1' doesn't have this option # CREATE TABLE: COMPRESSION + TEMPORARY + TABLESPACE=innodb_temporary CREATE TEMPORARY TABLE t1(c1 INT PRIMARY KEY) COMPRESSION="ZLIB" TABLESPACE=innodb_temporary; ERROR HY000: Table storage engine for 't1' doesn't have this option SHOW WARNINGS; Level Code Message Warning 138 InnoDB: Page Compression is not supported for temporary tables Error 1031 Table storage engine for 't1' doesn't have this option # CREATE TABLE: COMPRESSION + implicit System Tablespace SET GLOBAL INNODB_FILE_PER_TABLE = OFF; CREATE TABLE t1(C1 INT) ENGINE=InnoDB COMPRESSION="zlib"; ERROR HY000: Table storage engine for 't1' doesn't have this option SHOW WARNINGS; Level Code Message Warning 138 InnoDB: Page Compression is not supported for the system tablespace Error 1031 Table storage engine for 't1' doesn't have this option CREATE TABLE t1(C1 INT) ENGINE=InnoDB COMPRESSION="blah"; ERROR HY000: Table storage engine for 't1' doesn't have this option SHOW WARNINGS; Level Code Message Warning 1112 InnoDB: Unsupported compression algorithm 'blah' Error 1031 Table storage engine for 't1' doesn't have this option SET GLOBAL INNODB_FILE_PER_TABLE = ON; # CREATE TABLE: COMPRESSION + ROW_FORMAT=COMPRESSED CREATE TABLE t1(c1 INT PRIMARY KEY) COMPRESSION="ZLIB" ROW_FORMAT=COMPRESSED; ERROR HY000: Table storage engine for 't1' doesn't have this option SHOW WARNINGS; Level Code Message Warning 1112 InnoDB: Page Compression is not supported with row_format=compressed or key_block_size > 0 Error 1031 Table storage engine for 't1' doesn't have this option # CREATE TABLE: COMPRESSION + KEY_BLOCK_SIZE CREATE TABLE t1(c1 INT PRIMARY KEY) COMPRESSION="ZLIB" KEY_BLOCK_SIZE=2; ERROR HY000: Table storage engine for 't1' doesn't have this option SHOW WARNINGS; Level Code Message Warning 1112 InnoDB: Page Compression is not supported with row_format=compressed or key_block_size > 0 Error 1031 Table storage engine for 't1' doesn't have this option # ALTER TABLE: implicit COMPRESSION + TABLESPACE CREATE TABLE t1(c1 INT PRIMARY KEY) COMPRESSION="ZLIB"; ALTER TABLE t1 TABLESPACE=s1; ERROR HY000: Table storage engine 'InnoDB' does not support the create option 'COMPRESSION' SHOW WARNINGS; Level Code Message Warning 138 InnoDB: Page Compression is not supported for shared general tablespaces Error 1478 Table storage engine 'InnoDB' does not support the create option 'COMPRESSION' # ALTER TABLE: COMPRESSION + TABLESPACE ALTER TABLE t1 COMPRESSION="LZ4" TABLESPACE=s1; ERROR HY000: Table storage engine 'InnoDB' does not support the create option 'COMPRESSION' SHOW WARNINGS; Level Code Message Warning 138 InnoDB: Page Compression is not supported for shared general tablespaces Error 1478 Table storage engine 'InnoDB' does not support the create option 'COMPRESSION' # ALTER TABLE: implicit COMPRESSION + ROW_FORMAT=COMPRESSED ALTER TABLE t1 ROW_FORMAT=COMPRESSED; ERROR HY000: Table storage engine 'InnoDB' does not support the create option 'COMPRESSION' SHOW WARNINGS; Level Code Message Warning 1112 InnoDB: Page Compression is not supported with row_format=compressed or key_block_size > 0 Error 1478 Table storage engine 'InnoDB' does not support the create option 'COMPRESSION' # ALTER TABLE: COMPRESSION + ROW_FORMAT=COMPRESSED ALTER TABLE t1 COMPRESSION="ZLIB" ROW_FORMAT=COMPRESSED; ERROR HY000: Table storage engine 'InnoDB' does not support the create option 'COMPRESSION' SHOW WARNINGS; Level Code Message Warning 1112 InnoDB: Page Compression is not supported with row_format=compressed or key_block_size > 0 Error 1478 Table storage engine 'InnoDB' does not support the create option 'COMPRESSION' # ALTER TABLE: COMPRESSION + KEY_BLOCK_SIZE ALTER TABLE t1 COMPRESSION="ZLIB" KEY_BLOCK_SIZE=2; ERROR HY000: Table storage engine 'InnoDB' does not support the create option 'COMPRESSION' SHOW WARNINGS; Level Code Message Warning 1112 InnoDB: Page Compression is not supported with row_format=compressed or key_block_size > 0 Error 1478 Table storage engine 'InnoDB' does not support the create option 'COMPRESSION' # ALTER TABLE: COMPRESSION='abcdefghijklmnopqrstuvwxyz' ALTER TABLE t1 COMPRESSION='abcdefghijklmnopqrstuvwxyz'; ERROR HY000: Table storage engine 'InnoDB' does not support the create option 'COMPRESSION' SHOW WARNINGS; Level Code Message Warning 1112 InnoDB: Unsupported compression algorithm 'abcdefghijklmnopqrstuvwxyz' Error 1478 Table storage engine 'InnoDB' does not support the create option 'COMPRESSION' DROP TABLE t1; # # Test the bad combinations above with innodb_strict_mode=OFF. # SET SESSION innodb_strict_mode = OFF; SELECT @@innodb_strict_mode; @@innodb_strict_mode 0 CREATE TABLE t1(c1 INT PRIMARY KEY) COMPRESSION="zlibX"; Warnings: Warning 1112 InnoDB: Unsupported compression algorithm 'zlibX' SHOW WARNINGS; Level Code Message Warning 1112 InnoDB: Unsupported compression algorithm 'zlibX' SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` int(11) NOT NULL, PRIMARY KEY (`c1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMPRESSION='zlibX' SELECT TABLE_NAME, CREATE_OPTIONS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1'; TABLE_NAME CREATE_OPTIONS t1 COMPRESSION="zlibX" SELECT NAME, ROW_FORMAT, SPACE_TYPE FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES WHERE NAME = 'test/t1'; NAME ROW_FORMAT SPACE_TYPE test/t1 Dynamic Single DROP TABLE t1; # # Check for too long string # SET @long_str = REPEAT('ZLIB', 32768); SET @s = CONCAT('CREATE TABLE t1(c1 INT) ENGINE=InnoDB, COMPRESSION="', @long_str, '"'); PREPARE stmt from @s; EXECUTE stmt; ERROR HY000: String 'ZLIBZLIBZLIBZLIBZLIBZLIBZLIBZLIBZLIBZLIBZLIBZLIBZLIBZLIBZLIBZLIBZLIBZL' is too long for COMPRESSION (should be no longer than 2048) SHOW WARNINGS; Level Code Message Error 1470 String 'ZLIBZLIBZLIBZLIBZLIBZLIBZLIBZLIBZLIBZLIBZLIBZLIBZLIBZLIBZLIBZLIBZLIBZL' is too long for COMPRESSION (should be no longer than 2048) DEALLOCATE PREPARE stmt; SHOW CREATE TABLE t1; ERROR 42S02: Table 'test.t1' doesn't exist # # Compression cannot be used with ROW_FORMAT=COMPRESSED, TEMPORARY # or Shared tablespaces, either general or system. # # CREATE TABLE: COMPRESSION + TEMPORARY CREATE TEMPORARY TABLE t1(c1 INT PRIMARY KEY) COMPRESSION="ZLIB"; ERROR 42000: Table 't1' uses an extension that doesn't exist in this MySQL version SHOW WARNINGS; Level Code Message Warning 138 InnoDB: Page Compression is not supported for temporary tables Warning 138 InnoDB: Compression not supported for temporary tables Error 1112 Table 't1' uses an extension that doesn't exist in this MySQL version # CREATE TABLE: COMPRESSION + TABLESPACE CREATE TABLE t1(c1 INT PRIMARY KEY) COMPRESSION="ZLIB" TABLESPACE=s1; ERROR HY000: Table storage engine for 't1' doesn't have this option SHOW WARNINGS; Level Code Message Warning 138 InnoDB: Page Compression is not supported for shared general tablespaces Error 1031 Table storage engine for 't1' doesn't have this option # CREATE TABLE: COMPRESSION + TABLESPACE=innodb_system CREATE TABLE t1(c1 INT PRIMARY KEY) COMPRESSION="ZLIB" TABLESPACE=innodb_system; ERROR HY000: Table storage engine for 't1' doesn't have this option SHOW WARNINGS; Level Code Message Warning 138 InnoDB: Page Compression is not supported for the system tablespace Error 1031 Table storage engine for 't1' doesn't have this option # CREATE TABLE: COMPRESSION + TABLESPACE=innodb_temporary CREATE TABLE t1(c1 INT PRIMARY KEY) COMPRESSION="ZLIB" TABLESPACE=innodb_temporary; ERROR HY000: InnoDB: Tablespace `innodb_temporary` can only contain TEMPORARY tables. SHOW WARNINGS; Level Code Message Error 1478 InnoDB: Tablespace `innodb_temporary` can only contain TEMPORARY tables. Error 1031 Table storage engine for 't1' doesn't have this option # CREATE TABLE: COMPRESSION + TEMPORARY + TABLESPACE=innodb_temporary CREATE TEMPORARY TABLE t1(c1 INT PRIMARY KEY) COMPRESSION="ZLIB" TABLESPACE=innodb_temporary; ERROR HY000: Table storage engine for 't1' doesn't have this option SHOW WARNINGS; Level Code Message Warning 138 InnoDB: Page Compression is not supported for temporary tables Error 1031 Table storage engine for 't1' doesn't have this option # CREATE TABLE: COMPRESSION + implicit System Tablespace SET GLOBAL INNODB_FILE_PER_TABLE = OFF; CREATE TABLE t1(C1 INT) ENGINE=InnoDB COMPRESSION="zlib"; ERROR 42000: Table 't1' uses an extension that doesn't exist in this MySQL version SHOW WARNINGS; Level Code Message Warning 138 InnoDB: Page Compression is not supported for the system tablespace Warning 138 InnoDB: Compression not supported for shared tablespaces Error 1112 Table 't1' uses an extension that doesn't exist in this MySQL version CREATE TABLE t1(C1 INT) ENGINE=InnoDB COMPRESSION="blah"; ERROR 42000: Table 't1' uses an extension that doesn't exist in this MySQL version SHOW WARNINGS; Level Code Message Warning 1112 InnoDB: Unsupported compression algorithm 'blah' Warning 138 InnoDB: Compression not supported for shared tablespaces Error 1112 Table 't1' uses an extension that doesn't exist in this MySQL version SET GLOBAL INNODB_FILE_PER_TABLE = ON; # CREATE TABLE: COMPRESSION + ROW_FORMAT=COMPRESSED CREATE TABLE t1(c1 INT PRIMARY KEY) COMPRESSION="ZLIB" ROW_FORMAT=COMPRESSED; Warnings: Warning 1112 InnoDB: Page Compression is not supported with row_format=compressed or key_block_size > 0 SHOW WARNINGS; Level Code Message Warning 1112 InnoDB: Page Compression is not supported with row_format=compressed or key_block_size > 0 SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` int(11) NOT NULL, PRIMARY KEY (`c1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED COMPRESSION='ZLIB' SELECT TABLE_NAME, CREATE_OPTIONS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1'; TABLE_NAME CREATE_OPTIONS t1 row_format=COMPRESSED COMPRESSION="ZLIB" SELECT NAME,ROW_FORMAT,SPACE_TYPE FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES WHERE NAME = 'test/t1'; NAME ROW_FORMAT SPACE_TYPE test/t1 Compressed Single INSERT INTO t1 VALUES(1),(2),(3),(4); FLUSH TABLES t1 WITH READ LOCK; UNLOCK TABLES; SELECT * FROM t1; c1 1 2 3 4 DROP TABLE t1; # CREATE TABLE: COMPRESSION + KEY_BLOCK_SIZE CREATE TABLE t1(c1 INT PRIMARY KEY) COMPRESSION="ZLIB" KEY_BLOCK_SIZE=2; Warnings: Warning 1112 InnoDB: Page Compression is not supported with row_format=compressed or key_block_size > 0 SHOW WARNINGS; Level Code Message Warning 1112 InnoDB: Page Compression is not supported with row_format=compressed or key_block_size > 0 SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` int(11) NOT NULL, PRIMARY KEY (`c1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 KEY_BLOCK_SIZE=2 COMPRESSION='ZLIB' SELECT TABLE_NAME, CREATE_OPTIONS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1'; TABLE_NAME CREATE_OPTIONS t1 KEY_BLOCK_SIZE=2 COMPRESSION="ZLIB" SELECT NAME,ROW_FORMAT,SPACE_TYPE FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES WHERE NAME = 'test/t1'; NAME ROW_FORMAT SPACE_TYPE test/t1 Compressed Single INSERT INTO t1 VALUES(1),(2),(3),(4); FLUSH TABLES t1 WITH READ LOCK; UNLOCK TABLES; SELECT * FROM t1; c1 1 2 3 4 DROP TABLE t1; # ALTER TABLE: implicit COMPRESSION + TABLESPACE CREATE TABLE t1(c1 INT PRIMARY KEY) COMPRESSION="ZLIB"; ALTER TABLE t1 TABLESPACE=s1; ERROR HY000: Table storage engine 'InnoDB' does not support the create option 'COMPRESSION' SHOW WARNINGS; Level Code Message Warning 138 InnoDB: Page Compression is not supported for shared general tablespaces Error 1478 Table storage engine 'InnoDB' does not support the create option 'COMPRESSION' # ALTER TABLE: COMPRESSION + TABLESPACE ALTER TABLE t1 COMPRESSION="LZ4" TABLESPACE=s1; ERROR HY000: Table storage engine 'InnoDB' does not support the create option 'COMPRESSION' SHOW WARNINGS; Level Code Message Warning 138 InnoDB: Page Compression is not supported for shared general tablespaces Error 1478 Table storage engine 'InnoDB' does not support the create option 'COMPRESSION' # ALTER TABLE: implicit COMPRESSION + ROW_FORMAT=COMPRESSED ALTER TABLE t1 ROW_FORMAT=COMPRESSED; Warnings: Warning 1112 InnoDB: Page Compression is not supported with row_format=compressed or key_block_size > 0 SHOW WARNINGS; Level Code Message Warning 1112 InnoDB: Page Compression is not supported with row_format=compressed or key_block_size > 0 SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` int(11) NOT NULL, PRIMARY KEY (`c1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED COMPRESSION='ZLIB' SELECT TABLE_NAME, CREATE_OPTIONS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1'; TABLE_NAME CREATE_OPTIONS t1 row_format=COMPRESSED COMPRESSION="ZLIB" SELECT NAME, ROW_FORMAT, SPACE_TYPE FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES WHERE NAME = 'test/t1'; NAME ROW_FORMAT SPACE_TYPE test/t1 Compressed Single # ALTER TABLE: COMPRESSION + ROW_FORMAT=COMPRESSED ALTER TABLE t1 COMPRESSION="ZLIB" ROW_FORMAT=COMPRESSED; Warnings: Warning 1112 InnoDB: Page Compression is not supported with row_format=compressed or key_block_size > 0 SHOW WARNINGS; Level Code Message Warning 1112 InnoDB: Page Compression is not supported with row_format=compressed or key_block_size > 0 SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` int(11) NOT NULL, PRIMARY KEY (`c1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED COMPRESSION='ZLIB' SELECT TABLE_NAME, CREATE_OPTIONS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1'; TABLE_NAME CREATE_OPTIONS t1 row_format=COMPRESSED COMPRESSION="ZLIB" SELECT NAME, ROW_FORMAT, SPACE_TYPE FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES WHERE NAME = 'test/t1'; NAME ROW_FORMAT SPACE_TYPE test/t1 Compressed Single # ALTER TABLE: COMPRESSION + KEY_BLOCK_SIZE ALTER TABLE t1 COMPRESSION="ZLIB" KEY_BLOCK_SIZE=2; Warnings: Warning 1112 InnoDB: Page Compression is not supported with row_format=compressed or key_block_size > 0 SHOW WARNINGS; Level Code Message Warning 1112 InnoDB: Page Compression is not supported with row_format=compressed or key_block_size > 0 SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` int(11) NOT NULL, PRIMARY KEY (`c1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2 COMPRESSION='ZLIB' SELECT TABLE_NAME, CREATE_OPTIONS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1'; TABLE_NAME CREATE_OPTIONS t1 row_format=COMPRESSED KEY_BLOCK_SIZE=2 COMPRESSION="ZLIB" SELECT NAME, ROW_FORMAT, SPACE_TYPE FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES WHERE NAME = 'test/t1'; NAME ROW_FORMAT SPACE_TYPE test/t1 Compressed Single # ALTER TABLE: COMPRESSION='abcdefghijklmnopqrstuvwxyz' ALTER TABLE t1 COMPRESSION='abcdefghijklmnopqrstuvwxyz'; Warnings: Warning 1112 InnoDB: Unsupported compression algorithm 'abcdefghijklmnopqrstuvwxyz' SHOW WARNINGS; Level Code Message Warning 1112 InnoDB: Unsupported compression algorithm 'abcdefghijklmnopqrstuvwxyz' SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` int(11) NOT NULL, PRIMARY KEY (`c1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2 COMPRESSION='abcdefghijklmnopqrstuvwxyz' SELECT TABLE_NAME, CREATE_OPTIONS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1'; TABLE_NAME CREATE_OPTIONS t1 row_format=COMPRESSED KEY_BLOCK_SIZE=2 COMPRESSION="abcdefg" SELECT NAME,ROW_FORMAT,SPACE_TYPE FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES WHERE NAME = 'test/t1'; NAME ROW_FORMAT SPACE_TYPE test/t1 Compressed Single DROP TABLE t1; # # Cleanup # DROP TABLESPACE s1; SET GLOBAL INNODB_FILE_PER_TABLE=1; SET GLOBAL INNODB_FILE_PER_TABLE=1; SET DEBUG='-d,ignore_punch_hole'; SET DEBUG='-d,ignore_punch_hole_size';
Close