I can not reproduce this with upstream 5.6.24, maybe I am doing something wrong:
[openxs@chief 5.6]$ bin/mysql -uroot test -e"show variables like 'table_defin%'"
+------------------------+-------+
| Variable_name | Value |
+------------------------+-------+
| table_definition_cache | 20000 |
+------------------------+-------+
[openxs@chief 5.6]$ bin/mysql -uroot test -e"select count(*) from information_schema.tables"
+----------+
| count(*) |
+----------+
| 120505 |
+----------+
[openxs@chief 5.6]$ bin/mysql -uroot test -e"show variables like 'performance_schema'"
+--------------------+-------+
| Variable_name | Value |
+--------------------+-------+
| performance_schema | ON |
+--------------------+-------+
[openxs@chief 5.6]$ bin/mysql -uroot test -e"show variables like 'version%'" +-------------------------+------------------------------+
| Variable_name | Value |
+-------------------------+------------------------------+
| version | 5.6.24 |
| version_comment | MySQL Community Server (GPL) |
| version_compile_machine | x86_64 |
| version_compile_os | Linux |
+-------------------------+------------------------------+
[openxs@chief 5.6]$ tail -100 data/chief.err
...
2015-05-27 13:42:23 5229 [Note] /home/openxs/dbs/5.6/bin/mysqld: Shutdown complete
150527 13:42:23 mysqld_safe mysqld from pid file /home/openxs/dbs/5.6/data/chief.pid ended
150527 13:42:26 mysqld_safe Starting mysqld daemon with databases from /home/openxs/dbs/5.6/data
2015-05-27 13:42:27 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-05-27 13:42:27 0 [Note] /home/openxs/dbs/5.6/bin/mysqld (mysqld 5.6.24) starting as process 5333 ...
2015-05-27 13:42:27 5333 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)
I can not reproduce this with upstream 5.6.24, maybe I am doing something wrong:
[openxs@chief 5.6]$ bin/mysql -uroot test -e"show variables like 'table_defin%'" ------- ------- ----+-- -----+ ------- ------- ----+-- -----+ n_cache | 20000 | ------- ------- ----+-- -----+ schema. tables" schema' " ------- ------- +------ -+ ------- ------- +------ -+ ------- ------- +------ -+ ------- ------- -----+- ------- ------- ------- ------- -+ ------- ------- -----+- ------- ------- ------- ------- -+ compile_ machine | x86_64 | ------- ------- -----+- ------- ------- ------- ------- -+ dbs/5.6/ bin/mysqld: Shutdown complete
+------
| Variable_name | Value |
+------
| table_definitio
+------
[openxs@chief 5.6]$ bin/mysql -uroot test -e"select count(*) from information_
+----------+
| count(*) |
+----------+
| 120505 |
+----------+
[openxs@chief 5.6]$ bin/mysql -uroot test -e"show variables like 'performance_
+------
| Variable_name | Value |
+------
| performance_schema | ON |
+------
[openxs@chief 5.6]$ bin/mysql -uroot test -e"show variables like 'version%'" +------
| Variable_name | Value |
+------
| version | 5.6.24 |
| version_comment | MySQL Community Server (GPL) |
| version_
| version_compile_os | Linux |
+------
[openxs@chief 5.6]$ tail -100 data/chief.err
...
2015-05-27 13:42:23 5229 [Note] /home/openxs/
150527 13:42:23 mysqld_safe mysqld from pid file /home/openxs/ dbs/5.6/ data/chief. pid ended dbs/5.6/ data defaults_ for_timestamp server option (see documentation for more details). dbs/5.6/ bin/mysqld (mysqld 5.6.24) starting as process 5333 ...
150527 13:42:26 mysqld_safe Starting mysqld daemon with databases from /home/openxs/
2015-05-27 13:42:27 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_
2015-05-27 13:42:27 0 [Note] /home/openxs/
2015-05-27 13:42:27 5333 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)
2015-05-27 13:42:27 5333 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000)
2015-05-27 13:42:27 5333 [Note] Plugin 'FEDERATED' is disabled. dbs/5.6/ bin/mysqld: ready for connections.
2015-05-27 13:42:27 5333 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-05-27 13:42:27 5333 [Note] InnoDB: The InnoDB memory heap is disabled
2015-05-27 13:42:27 5333 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-05-27 13:42:27 5333 [Note] InnoDB: Memory barrier is not used
2015-05-27 13:42:27 5333 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-05-27 13:42:27 5333 [Note] InnoDB: Using Linux native AIO
2015-05-27 13:42:27 5333 [Note] InnoDB: Not using CPU crc32 instructions
2015-05-27 13:42:27 5333 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-05-27 13:42:27 5333 [Note] InnoDB: Completed initialization of buffer pool
2015-05-27 13:42:27 5333 [Note] InnoDB: Highest supported file format is Barracuda.
2015-05-27 13:42:28 5333 [Note] InnoDB: 128 rollback segment(s) are active.
2015-05-27 13:42:28 5333 [Note] InnoDB: Waiting for purge to start
2015-05-27 13:42:28 5333 [Note] InnoDB: 5.6.24 started; log sequence number 68190540
2015-05-27 13:42:28 5333 [Note] Server hostname (bind-address): '*'; port: 3306
2015-05-27 13:42:28 5333 [Note] IPv6 is available.
2015-05-27 13:42:28 5333 [Note] - '::' resolves to '::';
2015-05-27 13:42:28 5333 [Note] Server socket created on IP: '::'.
2015-05-27 13:42:28 5333 [Note] Event Scheduler: Loaded 0 events
2015-05-27 13:42:28 5333 [Note] /home/openxs/
Version: '5.6.24' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL)
So, it does not take long time to start.