⚝
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_zip
/
r
/
View File Name :
cmp_per_index.result
SET GLOBAL innodb_cmp_per_index_enabled=ON; SELECT * FROM information_schema.innodb_cmp_per_index; CREATE TABLE t ( a INT, b VARCHAR(512), c VARCHAR(16), PRIMARY KEY (a), INDEX (b(512)), INDEX (c(16)) ) ENGINE=INNODB KEY_BLOCK_SIZE=2; SELECT database_name, table_name, index_name, compress_ops, compress_ops_ok, uncompress_ops FROM information_schema.innodb_cmp_per_index ORDER BY 1, 2, 3; database_name test table_name t index_name b compress_ops 1 compress_ops_ok 1 uncompress_ops 0 database_name test table_name t index_name c compress_ops 1 compress_ops_ok 1 uncompress_ops 0 database_name test table_name t index_name PRIMARY compress_ops 1 compress_ops_ok 1 uncompress_ops 0 BEGIN; COMMIT; ALTER TABLE t DROP INDEX c; GRANT USAGE ON *.* TO 'tuser01'@'localhost' IDENTIFIED BY 'cDJvI9s_Uq'; Warnings: Level Warning Code 1287 Message Using GRANT for creating new user is deprecated and will be removed in future release. Create new user with CREATE USER statement. FLUSH PRIVILEGES; SELECT * FROM information_schema.innodb_cmp_per_index; ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation DROP USER 'tuser01'@'localhost'; SELECT database_name, table_name, index_name, CASE WHEN compress_ops=47 and @@innodb_compression_level IN (4,8,9) THEN 65 ELSE compress_ops END as compress_ops, CASE WHEN compress_ops_ok=47 and @@innodb_compression_level IN (4,8,9) THEN 65 ELSE compress_ops_ok END as compress_ops_ok, uncompress_ops FROM information_schema.innodb_cmp_per_index ORDER BY 1, 2, 3; database_name test table_name t index_name b compress_ops 43 compress_ops_ok 43 uncompress_ops 0 database_name test table_name t index_name PRIMARY compress_ops 65 compress_ops_ok 65 uncompress_ops 0 # restart SET GLOBAL innodb_cmp_per_index_enabled=ON; CREATE TABLE tmp_table SELECT * FROM t; SELECT database_name, table_name, index_name, compress_ops, compress_ops_ok, CASE WHEN uncompress_ops=6 and @@innodb_compression_level IN (4,8,9) THEN 9 ELSE uncompress_ops END as uncompress_ops FROM information_schema.innodb_cmp_per_index where table_name = 't' ORDER BY 1, 2, 3; database_name test table_name t index_name PRIMARY compress_ops 0 compress_ops_ok 0 uncompress_ops 9 DROP TABLE t,tmp_table; SET GLOBAL innodb_cmp_per_index_enabled=default;