-- 8.0.19 - build cat docs/INFO_SRC commit: 44e4c6bb51cf478596fce21eb5638557244cbafa date: 2019-12-09 20:48:18 +0100 build-date: 2019-12-09 20:53:55 +0100 short: 44e4c6b branch: mysql-8.0.19-release MySQL source 8.0.19 rm -rf 99136/ bin/mysqld --initialize-insecure --basedir=$PWD --datadir=$PWD/99136 --log-error-verbosity=3 bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/99136 --core-file --socket=/tmp/mysql_ushastry.sock --port=3333 --log-error=$PWD/99136/log.err --mysqlx=0 --log-error-verbosity=3 --secure-file-priv="" --performance-schema-instrument='%=COUNTED' --thread-cache-size=100 2>&1 & - terminal 1 bin/mysql -uroot -S /tmp/mysql_ushastry.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 6 Server version: 8.0.19 MySQL Community Server - GPL Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> select * from performance_schema.memory_summary_global_by_event_name where event_name='memory/temptable/physical_ram'\G *************************** 1. row *************************** EVENT_NAME: memory/temptable/physical_ram COUNT_ALLOC: 0 COUNT_FREE: 0 SUM_NUMBER_OF_BYTES_ALLOC: 0 SUM_NUMBER_OF_BYTES_FREE: 0 LOW_COUNT_USED: 0 CURRENT_COUNT_USED: 0 HIGH_COUNT_USED: 0 LOW_NUMBER_OF_BYTES_USED: 0 CURRENT_NUMBER_OF_BYTES_USED: 0 HIGH_NUMBER_OF_BYTES_USED: 0 1 row in set (0.01 sec) mysql> -- run for i in $(seq 80) ; do bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null & done ; wait on second terminal mysql> - terminal 2 for i in $(seq 80) ; do bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null & done ; wait [1] 10774 [2] 10775 [3] 10776 [4] 10777 [5] 10778 [6] 10779 [7] 10780 [8] 10781 [9] 10782 [10] 10783 [11] 10784 [12] 10785 [13] 10786 [14] 10787 [15] 10788 [16] 10789 [17] 10790 [18] 10791 [19] 10792 [20] 10793 [21] 10794 [22] 10795 [23] 10796 [24] 10797 [25] 10798 [26] 10799 [27] 10800 [28] 10801 [29] 10802 [30] 10803 [31] 10804 [32] 10805 [33] 10806 [34] 10809 [35] 10811 [36] 10813 [37] 10814 [38] 10815 [39] 10817 [40] 10818 [41] 10819 [42] 10820 [43] 10822 [44] 10825 [45] 10826 [46] 10827 [47] 10828 [48] 10829 [49] 10830 [50] 10831 [51] 10833 [52] 10834 [53] 10837 [54] 10839 [55] 10840 [56] 10841 [57] 10842 [58] 10843 [59] 10844 [60] 10845 [61] 10846 [62] 10847 [63] 10848 [64] 10849 [65] 10851 [66] 10852 [67] 10853 [68] 10854 [69] 10855 [70] 10859 [71] 10860 [72] 10862 [73] 10863 [74] 10864 [75] 10866 [76] 10868 [77] 10869 [78] 10870 [79] 10871 [80] 10872 [1] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [2] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [4] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [5] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [3] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [6] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [7] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [8] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [9] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [10] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [11] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [12] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [13] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [15] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [16] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [19] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [20] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [14] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [17] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [18] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [22] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [25] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [30] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [21] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [28] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [23] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [24] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [26] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [27] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [31] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [47] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [56] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [58] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [29] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [32] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [53] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [67] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [33] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [39] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [49] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [55] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [59] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [74] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [80]+ Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [34] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [35] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [36] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [37] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [41] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [44] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [45] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [46] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [50] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [60] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [61] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [62] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [64] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [69] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [72] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [73] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [76] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [38] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [42] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [48] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [40] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [43] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [51] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [52] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [54] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [57] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [63] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [66] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [68] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [70] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [71] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [79]+ Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [65] Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [77]- Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [78]+ Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null [75]+ Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null - terminal 1 mysql> show processlist; +----+-----------------+-----------+------+---------+------+------------------------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-----------------+-----------+------+---------+------+------------------------+------------------+ | 4 | event_scheduler | localhost | NULL | Daemon | 148 | Waiting on empty queue | NULL | | 6 | root | localhost | NULL | Query | 0 | starting | show processlist | +----+-----------------+-----------+------+---------+------+------------------------+------------------+ 2 rows in set (0.00 sec) mysql> select * from performance_schema.memory_summary_global_by_event_name where event_name='memory/temptable/physical_ram'\G *************************** 1. row *************************** EVENT_NAME: memory/temptable/physical_ram COUNT_ALLOC: 80 COUNT_FREE: 0 SUM_NUMBER_OF_BYTES_ALLOC: 83886080 SUM_NUMBER_OF_BYTES_FREE: 0 LOW_COUNT_USED: 0 CURRENT_COUNT_USED: 80 HIGH_COUNT_USED: 80 LOW_NUMBER_OF_BYTES_USED: 0 CURRENT_NUMBER_OF_BYTES_USED: 83886080 HIGH_NUMBER_OF_BYTES_USED: 83886080 1 row in set (0.00 sec) mysql> #### Lowest version checked in 8.0 - affected bin/mysql -uroot -S /tmp/mysql_ushastry.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 6 Server version: 8.0.11 MySQL Community Server - GPL Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> select * from performance_schema.memory_summary_global_by_event_name where event_name='memory/temptable/physical_ram'\G *************************** 1. row *************************** EVENT_NAME: memory/temptable/physical_ram COUNT_ALLOC: 0 COUNT_FREE: 0 SUM_NUMBER_OF_BYTES_ALLOC: 0 SUM_NUMBER_OF_BYTES_FREE: 0 LOW_COUNT_USED: 0 CURRENT_COUNT_USED: 0 HIGH_COUNT_USED: 0 LOW_NUMBER_OF_BYTES_USED: 0 CURRENT_NUMBER_OF_BYTES_USED: 0 HIGH_NUMBER_OF_BYTES_USED: 0 1 row in set (0.00 sec) mysql> -- run for i in $(seq 80) ; do bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show variables like '%tmp%';select sleep(10);" &>/dev/null & done ; wait on second terminal mysql> mysql> select * from performance_schema.memory_summary_global_by_event_name where event_name='memory/temptable/physical_ram'\G *************************** 1. row *************************** EVENT_NAME: memory/temptable/physical_ram COUNT_ALLOC: 80 COUNT_FREE: 0 SUM_NUMBER_OF_BYTES_ALLOC: 83886080 SUM_NUMBER_OF_BYTES_FREE: 0 LOW_COUNT_USED: 0 CURRENT_COUNT_USED: 80 HIGH_COUNT_USED: 80 LOW_NUMBER_OF_BYTES_USED: 0 CURRENT_NUMBER_OF_BYTES_USED: 83886080 HIGH_NUMBER_OF_BYTES_USED: 83886080 1 row in set (0.00 sec) mysql> show processlist; +----+-----------------+-----------+------+---------+------+------------------------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-----------------+-----------+------+---------+------+------------------------+------------------+ | 4 | event_scheduler | localhost | NULL | Daemon | 55 | Waiting on empty queue | NULL | | 6 | root | localhost | NULL | Query | 0 | starting | show processlist | +----+-----------------+-----------+------+---------+------+------------------------+------------------+ 2 rows in set (0.00 sec)