Default page

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

Dir : ~/www/server/mysql/mysql-test/suite/innodb/t/

View File Name : analyze_table.test

#
# BUG#22385442 - INNODB: DIFFICULT TO FIND FREE BLOCKS IN THE BUFFER POOL
#

--source include/have_innodb.inc
--source include/big_test.inc
# Disable in valgrind because of timeout, cf. Bug#22755816
--source include/not_valgrind.inc

DELIMITER |;
CREATE PROCEDURE populate_t1()
BEGIN
        DECLARE i int DEFAULT 1;

        START TRANSACTION;
        WHILE (i <= 1000000) DO
                INSERT INTO t1 VALUES (i, i, CONCAT('a', i));
                SET i = i + 1;
        END WHILE;
        COMMIT;
END|
DELIMITER ;|

CREATE TABLE t1(
        class   INT,
        id      INT,
        title   VARCHAR(100)
) ENGINE=InnoDB;

-- disable_query_log
CALL populate_t1();
-- enable_query_log

SELECT COUNT(*) FROM t1;

SET GLOBAL innodb_stats_persistent_sample_pages=2000;

ANALYZE TABLE t1;

DROP TABLE t1;

DROP PROCEDURE populate_t1;

SET GLOBAL innodb_stats_persistent_sample_pages=default;