- CentOS7 yum install centos-release-scl yum install devtoolset-7-gcc* yum install devtoolset-7-libasan* [root@BugCentOS7 bld]# cat /etc/*release CentOS Linux release 7.6.1810 (Core) NAME="CentOS Linux" VERSION="7 (Core)" ID="centos" ID_LIKE="rhel fedora" VERSION_ID="7" PRETTY_NAME="CentOS Linux 7 (Core)" ANSI_COLOR="0;31" CPE_NAME="cpe:/o:centos:centos:7" HOME_URL="https://www.centos.org/" BUG_REPORT_URL="https://bugs.centos.org/" CENTOS_MANTISBT_PROJECT="CentOS-7" CENTOS_MANTISBT_PROJECT_VERSION="7" REDHAT_SUPPORT_PRODUCT="centos" REDHAT_SUPPORT_PRODUCT_VERSION="7" CentOS Linux release 7.6.1810 (Core) CentOS Linux release 7.6.1810 (Core) [root@BugCentOS7 bld]# rpm -qa|grep devtool devtoolset-7-libquadmath-devel-7.3.1-5.15.el7.x86_64 devtoolset-7-binutils-2.28-11.el7.x86_64 devtoolset-7-libasan-devel-7.3.1-5.15.el7.x86_64 devtoolset-7-gcc-plugin-devel-7.3.1-5.15.el7.x86_64 devtoolset-7-libstdc++-devel-7.3.1-5.15.el7.x86_64 devtoolset-7-gcc-c++-7.3.1-5.15.el7.x86_64 devtoolset-7-gcc-gfortran-7.3.1-5.15.el7.x86_64 devtoolset-7-gcc-gdb-plugin-7.3.1-5.15.el7.x86_64 devtoolset-7-gcc-7.3.1-5.15.el7.x86_64 devtoolset-7-make-4.2.1-3.el7.x86_64 devtoolset-7-runtime-7.1-4.el7.x86_64 /usr/local/bin/cmake --version cmake version 3.14.1 CMake suite maintained and supported by Kitware (kitware.com/cmake). scl enable devtoolset-7 bash build_type="RelWithDebInfo" debug=0 gcov=0 asan=1 tsan=0 dest_dir=/home/ushastry/Downloads/mysql-8.0-build-export-15099047/bld rm -rf bld/ mkdir bld && cd bld rm -rf CMakeCache.txt make clean -- Only thing changed from cmake options was from -DWITH_SSL=openssl to -DWITH_SSL=system and boost_1_70_0 since it is required for 8.0.18 /usr/local/bin/cmake .. \ -DFORCE_INSOURCE_BUILD=ON \ -DCMAKE_BUILD_TYPE="$build_type" \ -DSYSCONFDIR="$dest_dir" \ -DCMAKE_INSTALL_PREFIX="$dest_dir" \ -DMYSQL_DATADIR="$dest_dir/data" \ -DWITH_DEBUG=$debug \ -DENABLE_GCOV=$gcov \ -DINSTALL_LAYOUT=STANDALONE \ -DMYSQL_MAINTAINER_MODE=0 \ -DWITH_EMBEDDED_SERVER=0 \ -DWITH_EXTRA_CHARSETS=all \ -DWITH_SSL=system \ -DWITH_ZLIB=bundled \ -DWITH_MYISAM_STORAGE_ENGINE=1 \ -DWITH_INNOBASE_STORAGE_ENGINE=1 \ -DWITH_CSV_STORAGE_ENGINE=1 \ -DWITH_ARCHIVE_STORAGE_ENGINE=1 \ -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \ -DWITH_FEDERATED_STORAGE_ENGINE=1 \ -DWITH_PERFSCHEMA_STORAGE_ENGINE=1 \ -DWITH_EXAMPLE_STORAGE_ENGINE=0 \ -DWITH_TEMPTABLE_STORAGE_ENGINE=1 \ -DENABLED_PROFILING=1 \ -DENABLED_LOCAL_INFILE=1 \ -DWITH_ASAN=$asan \ -DWITH_TSAN=$tsan \ -DWITH_BOOST="/home/ushastry/Downloads/boost_1_70_0.tar.gz" - rm -rf 96217/ bin/mysqld --initialize-insecure --basedir=$PWD --datadir=$PWD/96217 --log-error-verbosity=3 bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/96217 --core-file --socket=/tmp/mysql_ushastry.sock --port=3333 --log-error=$PWD/96217/log.err --mysqlx-port=33330 --mysqlx-socket=/tmp/mysql_x_ushastry.sock --log-error-verbosity=3 --secure-file-priv=/tmp/ --plugin-load-add=thread_pool.so --plugin-dir=$PWD/plugin_output_directory/ --server-id=1 --user=root 2>&1 & bin/mysql -uroot -S /tmp/mysql_ushastry.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 Server version: 8.0.18-asan Source distribution Copyright (c) 2000, 2019, 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 PLUGIN_NAME, PLUGIN_STATUS -> FROM INFORMATION_SCHEMA.PLUGINS -> WHERE PLUGIN_NAME LIKE 'thread%'; +-------------+---------------+ | PLUGIN_NAME | PLUGIN_STATUS | +-------------+---------------+ | thread_pool | ACTIVE | +-------------+---------------+ 1 row in set (0.01 sec) mysql> SELECT TABLE_NAME -> FROM INFORMATION_SCHEMA.TABLES -> WHERE TABLE_SCHEMA = 'performance_schema' -> AND TABLE_NAME LIKE 'tp%'; +-----------------------+ | TABLE_NAME | +-----------------------+ | tp_thread_group_state | | tp_thread_group_stats | | tp_thread_state | +-----------------------+ 3 rows in set (0.07 sec) mysql> CREATE RESOURCE GROUP Batch -> TYPE = USER -> VCPU = 2-3 -- assumes a system with at least 4 CPUs -> THREAD_PRIORITY = 10; ERROR 3658 (HY000): Feature Resource Groups is unsupported (Thread pool plugin enabled). mysql> mysql> show variables like '%version%'; +--------------------------+-----------------------+ | Variable_name | Value | +--------------------------+-----------------------+ | immediate_server_version | 999999 | | innodb_version | 8.0.18 | | original_server_version | 999999 | | protocol_version | 10 | | slave_type_conversions | | | tls_version | TLSv1,TLSv1.1,TLSv1.2 | | version | 8.0.18-asan | | version_comment | Source distribution | | version_compile_machine | x86_64 | | version_compile_os | Linux | | version_compile_zlib | 1.2.11 | +--------------------------+-----------------------+ 11 rows in set (0.04 sec) mysql> [root@BugCentOS7 bld]# bin/mysql -uroot -S /tmp/mysql_ushastry.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 9 Server version: 8.0.18-asan Source distribution Copyright (c) 2000, 2019, 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> shutdown; Query OK, 0 rows affected (0.01 sec) mysql> \q Bye [1]+ Done bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/96217 --core-file --socket=/tmp/mysql_ushastry.sock --port=3333 --log-error=$PWD/96217/log.err --mysqlx-port=33330 --mysqlx-socket=/tmp/mysql_x_ushastry.sock --log-error-verbosity=3 --secure-file-priv=/tmp/ --plugin-load-add=thread_pool.so --plugin-dir=$PWD/plugin_output_directory/ --server-id=1 --user=root 2>&1 -- except from error log [root@BugCentOS7 bld]# cat 96217/log.err 2019-07-30T10:35:32.441519Z 0 [Warning] [MY-010101] [Server] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory. 2019-07-30T10:35:32.441982Z 0 [Note] [MY-010949] [Server] Basedir set to /home/ushastry/Downloads/mysql-8.0-build-export-15099047/bld/. 2019-07-30T10:35:32.442076Z 0 [System] [MY-010116] [Server] /home/ushastry/Downloads/mysql-8.0-build-export-15099047/bld/runtime_output_directory/mysqld (mysqld 8.0.18-asan) starting as process 27623 2019-07-30T10:35:32.480207Z 0 [Note] [MY-010747] [Server] Plugin 'FEDERATED' is disabled. 2019-07-30T10:35:32.504650Z 1 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available 2019-07-30T10:35:32.505177Z 1 [Note] [MY-012943] [InnoDB] Mutexes and rw_locks use GCC atomic builtins 2019-07-30T10:35:32.505423Z 1 [Note] [MY-012944] [InnoDB] Uses event mutexes 2019-07-30T10:35:32.505754Z 1 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier 2019-07-30T10:35:32.506131Z 1 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.11 2019-07-30T10:35:32.508722Z 1 [Note] [MY-013251] [InnoDB] Number of pools: 1 2019-07-30T10:35:32.509787Z 1 [Note] [MY-012951] [InnoDB] Using CPU crc32 instructions 2019-07-30T10:35:32.513654Z 1 [Note] [MY-012203] [InnoDB] Directories to scan './;./;./' 2019-07-30T10:35:32.514528Z 1 [Note] [MY-012204] [InnoDB] Scanning './' 2019-07-30T10:35:32.519925Z 1 [Note] [MY-012208] [InnoDB] Completed space ID check of 4 files. 2019-07-30T10:35:32.521733Z 1 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 128.000000M, instances = 1, chunk size =128.000000M 2019-07-30T10:35:32.559764Z 1 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool 2019-07-30T10:35:32.571581Z 0 [Note] [MY-011951] [InnoDB] page_cleaner coordinator priority: -20 2019-07-30T10:35:32.656736Z 1 [Note] [MY-013086] [InnoDB] Starting to parse redo log at lsn = 19446818, whereas checkpoint_lsn = 19447160 2019-07-30T10:35:32.663012Z 1 [Note] [MY-013083] [InnoDB] Log background threads are being started... 2019-07-30T10:35:32.667266Z 1 [Note] [MY-012532] [InnoDB] Applying a batch of 0 redo log records ... 2019-07-30T10:35:32.668410Z 1 [Note] [MY-012535] [InnoDB] Apply batch completed! 2019-07-30T10:35:32.670293Z 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_001'. 2019-07-30T10:35:32.671955Z 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_002'. 2019-07-30T10:35:32.693983Z 1 [Note] [MY-012910] [InnoDB] Opened 2 existing undo tablespaces. 2019-07-30T10:35:32.694717Z 1 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 1236 2019-07-30T10:35:32.753103Z 1 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables 2019-07-30T10:35:32.754178Z 1 [Note] [MY-012265] [InnoDB] Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-07-30T10:35:32.933458Z 1 [Note] [MY-012266] [InnoDB] File './ibtmp1' size is now 12 MB. 2019-07-30T10:35:32.935270Z 1 [Note] [MY-011825] [InnoDB] Scanning temp tablespace dir:'./#innodb_temp/' 2019-07-30T10:35:33.202291Z 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active. 2019-07-30T10:35:33.210301Z 1 [Note] [MY-012976] [InnoDB] 8.0.18 started; log sequence number 19447160 2019-07-30T10:35:33.275733Z 1 [Note] [MY-011089] [Server] Data dictionary restarting version '80017'. 2019-07-30T10:35:34.898941Z 1 [Note] [MY-012357] [InnoDB] Reading DD tablespace files 2019-07-30T10:35:34.911967Z 1 [Note] [MY-012356] [InnoDB] Validated 6/6 tablespaces 2019-07-30T10:35:34.918092Z 0 [Note] [MY-011946] [InnoDB] Loading buffer pool(s) from /home/ushastry/Downloads/mysql-8.0-build-export-15099047/bld/96217/ib_buffer_pool 2019-07-30T10:35:34.928279Z 0 [Note] [MY-011946] [InnoDB] Buffer pool(s) load completed at 190730 6:35:34 2019-07-30T10:35:35.135703Z 1 [Note] [MY-010006] [Server] Using data dictionary with version '80017'. 2019-07-30T10:35:35.268897Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001681 - Integer display width is deprecated and will be removed in a future release. 2019-07-30T10:35:35.271387Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001681 - Integer display width is deprecated and will be removed in a future release. 2019-07-30T10:35:35.273350Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001681 - Integer display width is deprecated and will be removed in a future release. 2019-07-30T10:35:35.277702Z 0 [Note] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-003502 - This storage engine does not support the HASH index algorithm, storage engine default was used instead. 2019-07-30T10:35:35.289032Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001681 - Integer display width is deprecated and will be removed in a future release. 2019-07-30T10:35:35.290721Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001681 - Integer display width is deprecated and will be removed in a future release. 2019-07-30T10:35:35.292655Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001681 - Integer display width is deprecated and will be removed in a future release. 2019-07-30T10:35:35.296539Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001681 - Integer display width is deprecated and will be removed in a future release. 2019-07-30T10:35:35.298423Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001681 - Integer display width is deprecated and will be removed in a future release. 2019-07-30T10:35:35.300300Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001681 - Integer display width is deprecated and will be removed in a future release. 2019-07-30T10:35:35.302359Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001681 - Integer display width is deprecated and will be removed in a future release. 2019-07-30T10:35:35.304419Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001681 - Integer display width is deprecated and will be removed in a future release. 2019-07-30T10:35:35.307483Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001681 - Integer display width is deprecated and will be removed in a future release. 2019-07-30T10:35:35.309458Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001681 - Integer display width is deprecated and will be removed in a future release. 2019-07-30T10:35:35.311537Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001681 - Integer display width is deprecated and will be removed in a future release. 2019-07-30T10:35:35.313904Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001681 - Integer display width is deprecated and will be removed in a future release. 2019-07-30T10:35:35.316522Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001681 - Integer display width is deprecated and will be removed in a future release. 2019-07-30T10:35:35.318555Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001681 - Integer display width is deprecated and will be removed in a future release. 2019-07-30T10:35:35.321317Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001681 - Integer display width is deprecated and will be removed in a future release. 2019-07-30T10:35:35.327657Z 0 [Note] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-003502 - This storage engine does not support the HASH index algorithm, storage engine default was used instead. 2019-07-30T10:35:35.347599Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001681 - Integer display width is deprecated and will be removed in a future release. 2019-07-30T10:35:35.350515Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001681 - Integer display width is deprecated and will be removed in a future release. 2019-07-30T10:35:35.352993Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001681 - Integer display width is deprecated and will be removed in a future release. 2019-07-30T10:35:35.355657Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001681 - Integer display width is deprecated and will be removed in a future release. 2019-07-30T10:35:35.358557Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001681 - Integer display width is deprecated and will be removed in a future release. 2019-07-30T10:35:35.361592Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001681 - Integer display width is deprecated and will be removed in a future release. 2019-07-30T10:35:35.364003Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001681 - Integer display width is deprecated and will be removed in a future release. 2019-07-30T10:35:35.366524Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001681 - Integer display width is deprecated and will be removed in a future release. 2019-07-30T10:35:35.368700Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001681 - Integer display width is deprecated and will be removed in a future release. 2019-07-30T10:35:35.371310Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001681 - Integer display width is deprecated and will be removed in a future release. 2019-07-30T10:35:35.373725Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001681 - Integer display width is deprecated and will be removed in a future release. 2019-07-30T10:35:35.376483Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001681 - Integer display width is deprecated and will be removed in a future release. 2019-07-30T10:35:35.379182Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001681 - Integer display width is deprecated and will be removed in a future release. 2019-07-30T10:35:35.381634Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001681 - Integer display width is deprecated and will be removed in a future release. 2019-07-30T10:35:35.384537Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001681 - Integer display width is deprecated and will be removed in a future release. 2019-07-30T10:35:35.387128Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001681 - Integer display width is deprecated and will be removed in a future release. 2019-07-30T10:35:35.389928Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001681 - Integer display width is deprecated and will be removed in a future release. 2019-07-30T10:35:35.393050Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001681 - Integer display width is deprecated and will be removed in a future release. 2019-07-30T10:35:35.395557Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001681 - Integer display width is deprecated and will be removed in a future release. 2019-07-30T10:35:35.398562Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001681 - Integer display width is deprecated and will be removed in a future release. 2019-07-30T10:35:35.401547Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001681 - Integer display width is deprecated and will be removed in a future release. 2019-07-30T10:35:35.404130Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001681 - Integer display width is deprecated and will be removed in a future release. 2019-07-30T10:35:35.410931Z 0 [Note] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-003502 - This storage engine does not support the HASH index algorithm, storage engine default was used instead. 2019-07-30T10:35:35.432127Z 0 [Note] [MY-011106] [Server] Thread pool plugin started successfully with parameters: thread_pool_size = 16, thread_pool_algorithm = Low Concurrency Algorithm, thread_pool_stall_limit = 6, thread_pool_prio_kickup_timer = 1000, thread_pool_max_unused_threads = 0, thread_pool_high_priority_connection = 0. 2019-07-30T10:35:35.453479Z 0 [Note] [MY-010990] [Server] Resource group feature shall not be available. Incompatible thread handling option. 2019-07-30T10:35:36.812644Z 0 [Note] [MY-012487] [InnoDB] DDL log recovery : begin 2019-07-30T10:35:36.816561Z 0 [Note] [MY-012488] [InnoDB] DDL log recovery : end 2019-07-30T10:35:36.891770Z 0 [Note] [MY-012922] [InnoDB] Waiting for purge to start 2019-07-30T10:35:36.975193Z 0 [Note] [MY-010182] [Server] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2019-07-30T10:35:36.979091Z 0 [Note] [MY-010304] [Server] Skipping generation of SSL certificates as certificate files are present in data directory. 2019-07-30T10:35:36.989394Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2019-07-30T10:35:36.993056Z 0 [Note] [MY-010308] [Server] Skipping generation of RSA key pair through --sha256_password_auto_generate_rsa_keys as key files are present in data directory. 2019-07-30T10:35:36.997860Z 0 [Note] [MY-010308] [Server] Skipping generation of RSA key pair through --caching_sha2_password_auto_generate_rsa_keys as key files are present in data directory. 2019-07-30T10:35:37.002618Z 0 [Note] [MY-010252] [Server] Server hostname (bind-address): '*'; port: 3333 2019-07-30T10:35:37.006609Z 0 [Note] [MY-010253] [Server] IPv6 is available. 2019-07-30T10:35:37.009733Z 0 [Note] [MY-010264] [Server] - '::' resolves to '::'; 2019-07-30T10:35:37.013477Z 0 [Note] [MY-010251] [Server] Server socket created on IP: '::'. 2019-07-30T10:35:37.319258Z 0 [Note] [MY-011025] [Repl] Failed to start slave threads for channel ''. 2019-07-30T10:35:37.347591Z 4 [Note] [MY-010051] [Server] Event Scheduler: scheduler thread started with id 4 2019-07-30T10:35:37.355341Z 0 [System] [MY-010931] [Server] /home/ushastry/Downloads/mysql-8.0-build-export-15099047/bld/runtime_output_directory/mysqld: ready for connections. Version: '8.0.18-asan' socket: '/tmp/mysql_ushastry.sock' port: 3333 Source distribution. 2019-07-30T10:35:37.508029Z 0 [Note] [MY-011240] [Server] Plugin mysqlx reported: 'Using SSL configuration from MySQL Server' 2019-07-30T10:35:37.510270Z 0 [Note] [MY-011243] [Server] Plugin mysqlx reported: 'Using OpenSSL for TLS connections' 2019-07-30T10:35:37.510676Z 0 [Note] [MY-011332] [Server] Plugin mysqlx reported: 'IPv6 is available' 2019-07-30T10:35:37.516132Z 0 [Note] [MY-011323] [Server] Plugin mysqlx reported: 'X Plugin ready for connections. bind-address: '::' port: 33330' 2019-07-30T10:35:37.516266Z 0 [Note] [MY-011323] [Server] Plugin mysqlx reported: 'X Plugin ready for connections. socket: '/tmp/mysql_x_ushastry.sock'' 2019-07-30T10:35:37.516422Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/tmp/mysql_x_ushastry.sock' bind-address: '::' port: 33330 2019-07-30T10:38:30.604820Z 9 [System] [MY-013172] [Server] Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.0.18-asan). 2019-07-30T10:38:30.857260Z 0 [Note] [MY-010067] [Server] Giving 1 client threads a chance to die gracefully 2019-07-30T10:38:30.857663Z 0 [Note] [MY-010117] [Server] Shutting down slave threads 2019-07-30T10:38:30.857758Z 0 [Note] [MY-010054] [Server] Event Scheduler: Killing the scheduler thread, thread id 4 2019-07-30T10:38:30.857825Z 0 [Note] [MY-010050] [Server] Event Scheduler: Waiting for the scheduler thread to reply 2019-07-30T10:38:30.859020Z 0 [Note] [MY-010048] [Server] Event Scheduler: Stopped 2019-07-30T10:38:30.859161Z 0 [Note] [MY-010118] [Server] Forcefully disconnecting 0 remaining clients 2019-07-30T10:38:30.859227Z 0 [Note] [MY-010043] [Server] Event Scheduler: Purging the queue. 0 events 2019-07-30T10:38:30.863838Z 0 [Note] [MY-012330] [InnoDB] FTS optimize thread exiting. 2019-07-30T10:38:30.878787Z 0 [Note] [MY-010120] [Server] Binlog end 2019-07-30T10:38:30.888402Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'TP_THREAD_GROUP_STATS' 2019-07-30T10:38:30.888515Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'TP_THREAD_GROUP_STATE' 2019-07-30T10:38:30.888577Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'TP_THREAD_STATE' 2019-07-30T10:38:30.888635Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'thread_pool' 2019-07-30T10:38:30.894296Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysqlx_cache_cleaner' 2019-07-30T10:38:30.896117Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysqlx' 2019-07-30T10:38:30.897219Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'ngram' 2019-07-30T10:38:30.897279Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'BLACKHOLE' 2019-07-30T10:38:30.897338Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'ARCHIVE' 2019-07-30T10:38:30.897473Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'TempTable' 2019-07-30T10:38:30.897533Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'PERFORMANCE_SCHEMA' 2019-07-30T10:38:30.897658Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'MRG_MYISAM' 2019-07-30T10:38:30.897719Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'MyISAM' 2019-07-30T10:38:30.897987Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_SESSION_TEMP_TABLESPACES' 2019-07-30T10:38:30.898051Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CACHED_INDEXES' 2019-07-30T10:38:30.898104Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_VIRTUAL' 2019-07-30T10:38:30.898151Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_COLUMNS' 2019-07-30T10:38:30.898204Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLESPACES' 2019-07-30T10:38:30.898259Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_INDEXES' 2019-07-30T10:38:30.898333Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLESTATS' 2019-07-30T10:38:30.898382Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLES' 2019-07-30T10:38:30.898516Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2019-07-30T10:38:30.898569Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2019-07-30T10:38:30.898622Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_CONFIG' 2019-07-30T10:38:30.898669Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2019-07-30T10:38:30.898737Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_DELETED' 2019-07-30T10:38:30.898786Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2019-07-30T10:38:30.898839Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_METRICS' 2019-07-30T10:38:30.898908Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2019-07-30T10:38:30.898996Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2019-07-30T10:38:30.899057Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2019-07-30T10:38:30.899110Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_PAGE' 2019-07-30T10:38:30.899163Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2019-07-30T10:38:30.899225Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2019-07-30T10:38:30.899282Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMPMEM_RESET' 2019-07-30T10:38:30.899335Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMPMEM' 2019-07-30T10:38:30.899388Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_RESET' 2019-07-30T10:38:30.899533Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP' 2019-07-30T10:38:30.899589Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TRX' 2019-07-30T10:38:30.899641Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'InnoDB' 2019-07-30T10:38:30.899778Z 0 [Note] [MY-013072] [InnoDB] Starting shutdown... 2019-07-30T10:38:30.901154Z 0 [Note] [MY-011944] [InnoDB] Dumping buffer pool(s) to /home/ushastry/Downloads/mysql-8.0-build-export-15099047/bld/96217/ib_buffer_pool 2019-07-30T10:38:30.902311Z 0 [Note] [MY-011944] [InnoDB] Buffer pool(s) dump completed at 190730 6:38:30 2019-07-30T10:38:31.196957Z 0 [Note] [MY-013084] [InnoDB] Log background threads are being closed... 2019-07-30T10:38:31.309451Z 0 [Note] [MY-012980] [InnoDB] Shutdown completed; log sequence number 19834028 2019-07-30T10:38:31.314595Z 0 [Note] [MY-012255] [InnoDB] Removed temporary tablespace data file: "ibtmp1" 2019-07-30T10:38:31.314962Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'MEMORY' 2019-07-30T10:38:31.315055Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'CSV' 2019-07-30T10:38:31.315136Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'sha2_cache_cleaner' 2019-07-30T10:38:31.315305Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'caching_sha2_password' 2019-07-30T10:38:31.315404Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'sha256_password' 2019-07-30T10:38:31.315501Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysql_native_password' 2019-07-30T10:38:31.321400Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'binlog' 2019-07-30T10:38:31.329379Z 0 [System] [MY-010910] [Server] /home/ushastry/Downloads/mysql-8.0-build-export-15099047/bld/runtime_output_directory/mysqld: Shutdown complete (mysqld 8.0.18-asan) Source distribution. -- enabled all consumers/instruments in PF [root@BugCentOS7 bld]# bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/96217 --core-file --socket=/tmp/mysql_ushastry.sock --port=3333 --log-error=$PWD/96217/log.err --mysqlx-port=33330 --mysqlx-socket=/tmp/mysql_x_ushastry.sock --log-error-verbosity=3 --secure-file-priv=/tmp/ --plugin-load-add=thread_pool.so --plugin-dir=$PWD/plugin_output_directory/ --server-id=1 --user=root 2>&1 & [1] 27903 [root@BugCentOS7 bld]# 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.18-asan Source distribution Copyright (c) 2000, 2019, 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> update performance_schema.setup_instruments set enabled='yes'; Query OK, 445 rows affected (0.06 sec) Rows matched: 1238 Changed: 445 Warnings: 0 mysql> update performance_schema.setup_consumers set enabled='yes'; Query OK, 8 rows affected (0.01 sec) Rows matched: 15 Changed: 8 Warnings: 0 mysql> update performance_schema.setup_instruments set enabled = 'yes' where name like 'memory/%'; Query OK, 0 rows affected (0.00 sec) Rows matched: 509 Changed: 0 Warnings: 0 mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE 'thread%'; +-------------+---------------+ | PLUGIN_NAME | PLUGIN_STATUS | +-------------+---------------+ | thread_pool | ACTIVE | +-------------+---------------+ 1 row in set (0.01 sec) mysql> CREATE RESOURCE GROUP Batch TYPE = USER VCPU = 2-3 THREAD_PRIORITY = 10; ERROR 3658 (HY000): Feature Resource Groups is unsupported (Thread pool plugin enabled). mysql> CREATE RESOURCE GROUP Batch TYPE = USER VCPU = 2-3 THREAD_PRIORITY = 10; ERROR 3658 (HY000): Feature Resource Groups is unsupported (Thread pool plugin enabled). mysql> CREATE RESOURCE GROUP Batch TYPE = USER VCPU = 2-3 THREAD_PRIORITY = 10; ERROR 3658 (HY000): Feature Resource Groups is unsupported (Thread pool plugin enabled). mysql> CREATE RESOURCE GROUP Batch TYPE = USER VCPU = 2-3 THREAD_PRIORITY = 10; ERROR 3658 (HY000): Feature Resource Groups is unsupported (Thread pool plugin enabled). mysql> \q Bye [root@BugCentOS7 bld]# bin/mysqladmin -uroot -S /tmp/mysql_ushastry.sock shutdown [root@BugCentOS7 bld]# [1]+ Done bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/96217 --core-file --socket=/tmp/mysql_ushastry.sock --port=3333 --log-error=$PWD/96217/log.err --mysqlx-port=33330 --mysqlx-socket=/tmp/mysql_x_ushastry.sock --log-error-verbosity=3 --secure-file-priv=/tmp/ --plugin-load-add=thread_pool.so --plugin-dir=$PWD/plugin_output_directory/ --server-id=1 --user=root 2>&1