⚝
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 :
index_length.result
CREATE TABLE abc(a int auto_increment PRIMARY KEY, b varchar(1024), c varchar(1024))ENGINE=INNODB; INSERT INTO abc (b,c) VALUES (repeat('b', 1024), repeat('c', 1024)); INSERT INTO abc (b,c) SELECT b,c FROM abc; INSERT INTO abc (b,c) SELECT b,c FROM abc; INSERT INTO abc (b,c) SELECT b,c FROM abc; INSERT INTO abc (b,c) SELECT b,c FROM abc; INSERT INTO abc (b,c) SELECT b,c FROM abc; INSERT INTO abc (b,c) SELECT b,c FROM abc; INSERT INTO abc (b,c) SELECT b,c FROM abc; INSERT INTO abc (b,c) SELECT b,c FROM abc; INSERT INTO abc (b,c) SELECT b,c FROM abc; INSERT INTO abc (b,c) SELECT b,c FROM abc; INSERT INTO abc (b,c) SELECT b,c FROM abc; INSERT INTO abc (b,c) SELECT b,c FROM abc; INSERT INTO abc (b,c) SELECT b,c FROM abc; INSERT INTO abc (b,c) SELECT b,c FROM abc; SELECT DATA_LENGTH, INDEX_LENGTH from information_schema.TABLES WHERE TABLE_SCHEMA = 'test' AND TABLE_NAME = 'abc'; DATA_LENGTH INDEX_LENGTH # 0 ALTER TABLE abc add INDEX cc (c(800)); SELECT DATA_LENGTH, INDEX_LENGTH from information_schema.TABLES WHERE TABLE_SCHEMA = 'test' AND TABLE_NAME = 'abc'; DATA_LENGTH INDEX_LENGTH # 17809408 ALTER TABLE abc add INDEX bb (b(800)); SELECT DATA_LENGTH, INDEX_LENGTH from information_schema.TABLES WHERE TABLE_SCHEMA = 'test' AND TABLE_NAME = 'abc'; DATA_LENGTH INDEX_LENGTH # 35618816 DROP TABLE abc;