Server IP : 172.67.216.182 / Your IP : 172.70.147.2 Web Server : Apache System : Linux krdc-ubuntu-s-2vcpu-4gb-amd-blr1-01.localdomain 5.15.0-142-generic #152-Ubuntu SMP Mon May 19 10:54:31 UTC 2025 x86_64 User : www ( 1000) PHP Version : 7.4.33 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /www/server/mysql/src/mysql-test/suite/innodb/t/ |
Upload File : |
# # WL#6737: InnoDB: Enabling InnoDB temp-tables as default internal SE for # MySQL Optimizer # --source include/have_innodb.inc --source include/no_valgrind_without_big.inc --source include/not_embedded.inc # Optimizer plan are printed as part of the test-case and changing page # size will affect the optimizer plan numbers. so enable it only for 16K --source include/have_innodb_16k.inc ################################################################################ # # Workload will run following scenarios # 1. Execute different kind of queries using InnoDB as temp-tables # ################################################################################ #----------------------------------------------------------------------------- # # create test bed. # let $wl6737_auto_inc = auto_increment; --source suite/innodb/include/create_workload_itt.inc #----------------------------------------------------------------------------- # # Workload in non-read-only mode. # let $restart_parameters = restart: --big-tables=1; --source include/restart_mysqld.inc --source suite/innodb/include/query_workload_itt.inc #----------------------------------------------------------------------------- # # Workload in read-only mode. # let $restart_parameters = restart: --innodb-read-only --big-tables=1; --source include/restart_mysqld.inc --source suite/innodb/include/query_workload_itt.inc let $restart_parameters = restart; --source include/restart_mysqld.inc #----------------------------------------------------------------------------- # # Specialized used-cases. # Intrinsic table being used as part of trx workload. # select @@big_tables; let $big_tables = `select @@big_tables`; create table t0 (m int, n int, key(m)) engine=innodb; begin; select count(*) from t0; set @@session.sql_mode = MAXDB; set @@session.tmp_table_size = 0; set @@session.big_tables = 1; select @@big_tables; --disable_result_log select event_name, e.min_timer_wait, min(t.min_timer_wait) from performance_schema.events_waits_summary_global_by_event_name as e JOIN performance_schema.events_waits_summary_by_thread_by_event_name as t USING (event_name) group by event_name; --enable_result_log select * from t0; commit; drop table t0; eval set session big_tables = $big_tables; select @@big_tables; #----------------------------------------------------------------------------- # # remove test bed. # --source suite/innodb/include/drop_workload_itt.inc --echo # --echo # BUG#20762059 - innodb_thread_concurrency=1 and queries using intrinsic --echo # temp tables, causes hang --echo # --echo # Scenario 1: Without timezone tables --echo # CREATE TABLE t1(a INT); INSERT INTO t1 VALUES(1); --echo # On default connection SET @@session.max_heap_table_size=0; SET @@global.innodb_thread_concurrency=1; --echo # Executing I_S query which will create and do index read on --echo # intrinsic temporary tables let $DISCARD_OUTPUT=`SELECT COUNT(*) FROM information_schema.innodb_sys_tables`; --echo # Switch to connection con1 connect (con1, localhost, root); SELECT * FROM t1; --echo # Switch to connection default connection default; DROP TABLE t1; # Cleanup disconnect con1; SET @@session.max_heap_table_size = default; SET @@global.innodb_thread_concurrency = default; SET @@global.innodb_thread_sleep_delay = default; --echo # --echo # Scenario 2: with I_S query and timezone table(uses attachable --echo # transaction) --echo # SET @@session.max_heap_table_size=0; SET @@global.innodb_thread_concurrency=1; --echo # Executing I_S query which will create and do index read on --echo # intrinsic temporary tables let $DISCARD_OUTPUT=`SELECT COUNT(*) FROM information_schema.innodb_sys_tables`; select convert_tz(0,'a','a'); # Cleanup SET @@session.max_heap_table_size = default; SET @@global.innodb_thread_concurrency = default; SET @@global.innodb_thread_sleep_delay = default; --echo # --echo # Scenario 3: with I_S query and help table(uses attachable --echo # transaction) --echo # SET @@global.innodb_thread_concurrency=1; --echo # Executing I_S query which will create and do index read on --echo # intrinsic temporary tables let $DISCARD_OUTPUT = `SELECT table_catalog, table_schema, table_name, column_name FROM information_schema.columns WHERE table_catalog IS NULL OR table_catalog <> 'def'`; HELP '%function_2'; # Cleanup SET @@global.innodb_thread_concurrency = default; SET @@global.innodb_thread_sleep_delay = default; --echo # --echo # Bug#21871451: INNODB: FAILING ASSERTION: !(&BUF_POOL->MUTEX) --echo # SELECT 'SUCCESS_INNODB_CMPMEM' FROM DUAL WHERE EXISTS (SELECT * FROM INFORMATION_SCHEMA.INNODB_CMPMEM); SELECT 'SUCCESS_INNODB_CMP' FROM DUAL WHERE EXISTS (SELECT * FROM INFORMATION_SCHEMA.INNODB_CMPMEM_RESET);