Bug #100601 Not all PFS keys are registered when initializing the mysql server
Submitted: 21 Aug 2020 12:32 Modified: 22 Aug 2020 3:15
Reporter: Cheng Zhou Email Updates:
Status: Unsupported Impact on me:
Category:MySQL Server: InnoDB storage engine Severity:S3 (Non-critical)
Version:8.0.18 OS:Red Hat
Assigned to: CPU Architecture:Any

[21 Aug 2020 12:32] Cheng Zhou
Compiling a debug version without some particular types of Performance Schema instrumentation.
When initialized the mysql server, error occurred and the mysqld process exited.

error log:
[ERROR] [MY-012369] [InnoDB] You have created new InnoDB PFS key(s) but 2 key(s) is/are not registered with PFS. Please register the keys in PFS arrays in ha_innodb.cc.
[ERROR] [MY-010202] [Server] Plugin 'InnoDB' init function returned error.
[ERROR] [MY-010734] [Server] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
[ERROR] [MY-010168] [Server] Failed to initialize builtin plugins.
[ERROR] [MY-013236] [Server] The designated data directory /home/xxx/data/data/ is unusable. You can remove all files that the server added to it.
[ERROR] [MY-010119] [Server] Aborting

How to repeat:
1. Compiled with the CMake options including the following´╝Ü
            -DDISABLE_PSI_COND=1 \
            -DDISABLE_PSI_DATA_LOCK=1 \
            -DDISABLE_PSI_ERROR=1 \
            -DDISABLE_PSI_FILE=1 \
            -DDISABLE_PSI_IDLE=1 \
            -DDISABLE_PSI_MEMORY=1 \
            -DDISABLE_PSI_METADATA=1 \
            -DDISABLE_PSI_MUTEX=1 \
            -DDISABLE_PSI_PS=1 \
            -DDISABLE_PSI_RWLOCK=1 \
            -DDISABLE_PSI_SOCKET=1 \
            -DDISABLE_PSI_SP=1 \
            -DDISABLE_PSI_STAGE=1 \
            -DDISABLE_PSI_TABLE=1 \
            -DDISABLE_PSI_THREAD=1 \

2. make and make install;
3. initialize the mysql server:
~/bin/mysqld --defaults-file=/home/xxx/etc/my.cnf --initialize-insecure --user=xxx

Suggested fix:

--- a/storage/innobase/log/log0meb.cc
+++ b/storage/innobase/log/log0meb.cc
@@ -51,8 +51,14 @@ namespace meb {
 const std::string logmsgpfx("innodb_redo_log_archive: ");
 constexpr size_t QUEUE_BLOCK_SIZE = 4096;
 constexpr size_t QUEUE_SIZE_MAX = 16384;
 mysql_pfs_key_t redo_log_archive_consumer_thread_key;
+#ifdef UNIV_PFS_IO
 mysql_pfs_key_t redo_log_archive_file_key;
[21 Aug 2020 13:02] Cheng Zhou
After fixed the bug as the suggested fix, another error occurred as reported in http://bugs.mysql.com/100602
[21 Aug 2020 13:05] MySQL Verification Team
Hi Mr. Zhou,

Thank you for your bug report.

However, this is not a bug. Simply, some of the keys are necessary in order for InnoDB SE to function properly.

We shall try to find out which keys are those ......
[21 Aug 2020 13:17] MySQL Verification Team
Do try enabling PSI FILE and THREAD keys and see if it helps.
[21 Aug 2020 13:19] MySQL Verification Team
Also, try not disabling RWLOCK index in PFS.
[21 Aug 2020 13:19] MySQL Verification Team
Seems that MUTEX key is also required.
[22 Aug 2020 3:15] Cheng Zhou
Well, <MySQL 8.0 Reference Manual> '2.9.7 MySQL Source-Configuration Options ' mentioned:
It is not possible to compile without Performance Schema support. If it is desired to compile without particular types of instrumentation, that can be done with the following CMake options:

For example, to compile without mutex instrumentation, configure MySQL using the -DDISABLE_PSI_MUTEX=1 option."

Aren't all of DISABLE_PSI_XXXs available?
I just tried to disable any unnecessary functions to improve the test performance as much as possible.
[24 Aug 2020 12:18] MySQL Verification Team
Hi Mr. Zhou,

We had an internal discussion and concluded that our documentation is clear enough.

Performance Schema indexes are predefined and cannot be dropped, added, or altered. 


Hence, what you are attempting is not supported.