⚝
One Hat Cyber Team
⚝
Your IP:
216.73.216.124
Server IP:
50.28.103.30
Server:
Linux host.jcukjv-lwsites.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
Server Software:
nginx/1.28.0
PHP Version:
8.3.12
Buat File
|
Buat Folder
Eksekusi
Dir :
~
/
www
/
server
/
mysql
/
mysql-test
/
suite
/
innodb
/
r
/
View File Name :
innodb_64k.result
SET GLOBAL innodb_file_per_table=1; SET SESSION innodb_strict_mode=ON; CREATE TABLE t1 (id int, a TEXT) ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4; ERROR HY000: Table storage engine for 't1' doesn't have this option SHOW WARNINGS; Level Code Message Warning 1478 InnoDB: Cannot create a COMPRESSED table when innodb_page_size > 16k. Error 1031 Table storage engine for 't1' doesn't have this option CREATE TABLE t1 (id int, a TEXT) ROW_FORMAT=COMPRESSED; ERROR HY000: Table storage engine for 't1' doesn't have this option SHOW WARNINGS; Level Code Message Warning 1478 InnoDB: Cannot create a COMPRESSED table when innodb_page_size > 16k. Error 1031 Table storage engine for 't1' doesn't have this option CREATE TABLE t1(id int, a TEXT) KEY_BLOCK_SIZE=4; ERROR HY000: Table storage engine for 't1' doesn't have this option SHOW WARNINGS; Level Code Message Warning 1478 InnoDB: Cannot create a COMPRESSED table when innodb_page_size > 16k. Error 1031 Table storage engine for 't1' doesn't have this option CREATE TABLE t1 (id int, a TEXT); SHOW WARNINGS; Level Code Message ALTER TABLE t1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4; ERROR HY000: Table storage engine 'InnoDB' does not support the create option 'KEY_BLOCK_SIZE' SHOW WARNINGS; Level Code Message Warning 1478 InnoDB: Cannot create a COMPRESSED table when innodb_page_size > 16k. Error 1478 Table storage engine 'InnoDB' does not support the create option 'KEY_BLOCK_SIZE' ALTER TABLE t1 ROW_FORMAT=COMPRESSED; ERROR HY000: Table storage engine 'InnoDB' does not support the create option 'ROW_TYPE' SHOW WARNINGS; Level Code Message Warning 1478 InnoDB: Cannot create a COMPRESSED table when innodb_page_size > 16k. Error 1478 Table storage engine 'InnoDB' does not support the create option 'ROW_TYPE' ALTER TABLE t1 KEY_BLOCK_SIZE=4; ERROR HY000: Table storage engine 'InnoDB' does not support the create option 'KEY_BLOCK_SIZE' SHOW WARNINGS; Level Code Message Warning 1478 InnoDB: Cannot create a COMPRESSED table when innodb_page_size > 16k. Error 1478 Table storage engine 'InnoDB' does not support the create option 'KEY_BLOCK_SIZE' DROP TABLE t1; SET SESSION innodb_strict_mode=OFF; CREATE TABLE t1 (id int, a TEXT) ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4; Warnings: Warning 1478 InnoDB: Cannot create a COMPRESSED table when innodb_page_size > 16k. Assuming ROW_FORMAT=DYNAMIC. DROP TABLE t1; CREATE TABLE t1 (id int, a TEXT) ROW_FORMAT=COMPRESSED; Warnings: Warning 1478 InnoDB: Cannot create a COMPRESSED table when innodb_page_size > 16k. Assuming ROW_FORMAT=DYNAMIC. DROP TABLE t1; CREATE TABLE t1 (id int, a TEXT) KEY_BLOCK_SIZE=4; Warnings: Warning 1478 InnoDB: Cannot create a COMPRESSED table when innodb_page_size > 16k. Assuming ROW_FORMAT=DYNAMIC. DROP TABLE t1; CREATE TABLE t1 (id int, a TEXT); ALTER TABLE t1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4; Warnings: Warning 1478 InnoDB: Cannot create a COMPRESSED table when innodb_page_size > 16k. Assuming ROW_FORMAT=DYNAMIC. ALTER TABLE t1 ROW_FORMAT=COMPRESSED; Warnings: Warning 1478 InnoDB: Cannot create a COMPRESSED table when innodb_page_size > 16k. Assuming ROW_FORMAT=DYNAMIC. ALTER TABLE t1 KEY_BLOCK_SIZE=4; Warnings: Warning 1478 InnoDB: Cannot create a COMPRESSED table when innodb_page_size > 16k. Assuming ROW_FORMAT=DYNAMIC. DROP TABLE t1; SET GLOBAL innodb_file_per_table=default; CREATE TABLE t1 (id int, a TEXT) ROW_FORMAT=COMPACT; INSERT INTO t1 VALUES (1, REPEAT('a',2000)), (2, REPEAT('a',2000)); UPDATE t1 SET a=REPEAT('a',31000) WHERE id = 1; INSERT INTO t1 VALUES (1, REPEAT('a',33000)); DROP TABLE t1;