⚝
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_undo
/
r
/
View File Name :
i_s_files_4k.result
# # WL7943 Implement INFORMATION_SCHEMA.FILES # SET default_storage_engine=InnoDB; CREATE TABLE t1 (a serial, b text, c text); ==I_S.FILES== ==I_S.FILES== FILE_ID 0 TABLESPACE_NAME innodb_system FILE_NAME MYSQLD_DATADIR/ibdata1 FILE_TYPE TABLESPACE STATUS NORMAL ENGINE InnoDB EXTENT_SIZE 1048576 MAXIMUM_SIZE NULL AUTOEXTEND_SIZE 67108864 ==I_S.FILES== ==I_S.FILES== FILE_ID 1 TABLESPACE_NAME innodb_undo001 FILE_NAME MYSQLD_DATADIR//undo001 FILE_TYPE UNDO LOG STATUS NORMAL ENGINE InnoDB EXTENT_SIZE 1048576 MAXIMUM_SIZE NULL ==I_S.FILES== ==I_S.FILES== FILE_ID 2 TABLESPACE_NAME innodb_undo002 FILE_NAME MYSQLD_DATADIR//undo002 FILE_TYPE UNDO LOG STATUS NORMAL ENGINE InnoDB EXTENT_SIZE 1048576 MAXIMUM_SIZE NULL ==I_S.FILES== ==I_S.FILES== TABLESPACE_NAME innodb_temporary FILE_NAME MYSQLD_DATADIR/ibtmp1 FILE_TYPE TEMPORARY STATUS NORMAL ENGINE InnoDB EXTENT_SIZE 1048576 INITIAL_SIZE 12582912 MAXIMUM_SIZE NULL AUTOEXTEND_SIZE 67108864 ==I_S.FILES== ==I_S.FILES== TABLESPACE_NAME innodb_file_per_table_## FILE_NAME MYSQLD_DATADIR/test/t1.ibd FILE_TYPE TABLESPACE STATUS NORMAL ENGINE InnoDB DATA_FREE 0 FREE_EXTENTS 0 TOTAL_EXTENTS 0 EXTENT_SIZE 1048576 INITIAL_SIZE 16384 MAXIMUM_SIZE NULL AUTOEXTEND_SIZE 1048576 # # Populate t1 with about 3MB of data # CREATE PROCEDURE populate_t1() BEGIN DECLARE i INT DEFAULT 1; while (i <= 6000) DO INSERT INTO t1 (b,c) VALUES (repeat('b', 250), repeat('c', 250)); SET i = i + 1; END WHILE; END | BEGIN; CALL populate_t1(); FLUSH TABLE t1; ==I_S.FILES== ==I_S.FILES== TABLESPACE_NAME innodb_file_per_table_## FILE_NAME MYSQLD_DATADIR/test/t1.ibd FILE_TYPE TABLESPACE STATUS NORMAL ENGINE InnoDB DATA_FREE 4194304 FREE_EXTENTS 1 TOTAL_EXTENTS 12 EXTENT_SIZE 1048576 INITIAL_SIZE 16384 MAXIMUM_SIZE NULL AUTOEXTEND_SIZE 1048576 # # Populate t1 with another 3MB of data # CALL populate_t1(); FLUSH TABLE t1; ==I_S.FILES== ==I_S.FILES== TABLESPACE_NAME innodb_file_per_table_## FILE_NAME MYSQLD_DATADIR/test/t1.ibd FILE_TYPE TABLESPACE STATUS NORMAL ENGINE InnoDB DATA_FREE 4194304 FREE_EXTENTS 1 TOTAL_EXTENTS 16 EXTENT_SIZE 1048576 INITIAL_SIZE 16384 MAXIMUM_SIZE NULL AUTOEXTEND_SIZE 4194304 # # Delete the half of the records. # DELETE FROM t1 WHERE a % 2 = 1; FLUSH TABLE t1; ==I_S.FILES== ==I_S.FILES== TABLESPACE_NAME innodb_file_per_table_## FILE_NAME MYSQLD_DATADIR/test/t1.ibd FILE_TYPE TABLESPACE STATUS NORMAL ENGINE InnoDB DATA_FREE 4194304 FREE_EXTENTS 1 TOTAL_EXTENTS 16 EXTENT_SIZE 1048576 INITIAL_SIZE 16384 MAXIMUM_SIZE NULL AUTOEXTEND_SIZE 4194304 # # Cleanup # DROP TABLE t1; DROP PROCEDURE populate_t1;