mysql> select version(), count(*) from information_schema.tables;
+-----------+----------+
| version() | count(*) |
+-----------+----------+
| 5.7.9 | 50282 |
+-----------+----------+
1 row in set (0,52 sec)
mysql> show variables like 'table_d%';
+------------------------+-------+
| Variable_name | Value |
+------------------------+-------+
| table_definition_cache | 50000 |
+------------------------+-------+
1 row in set (0,00 sec)
...
*************************** 229. row ***************************
Type: performance_schema
Name: performance_schema.memory
Status: 163510080
229 rows in set (0,03 sec)
Upstream 5.7.9 does NOT seem to be affected in the same way, it starts fast enough:
2015-11- 19T11:44: 17.462034Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 19T11:44: 19.136225Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 19T11:44: 19.136346Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 19T11:44: 19.454677Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 19T11:44: 19.462071Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 19T11:44: 19.462110Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 19T11:44: 19.463178Z 0 [Note] InnoDB: Waiting for purge to start 19T11:44: 19.513508Z 0 [Note] InnoDB: 5.7.9 started; log sequence number 352871785 19T11:44: 19.514378Z 0 [Note] InnoDB: not started 19T11:44: 19.514467Z 0 [Note] Plugin 'FEDERATED' is disabled. 19T11:44: 19.518168Z 0 [Note] InnoDB: Loading buffer pool(s) from /home/openxs/ dbs/5.7/ data/ib_ buffer_ pool 19T11:44: 19.518421Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 19T11:44: 19.518937Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 19T11:44: 19.518984Z 0 [Note] IPv6 is available. 19T11:44: 19.519002Z 0 [Note] - '::' resolves to '::'; 19T11:44: 19.519013Z 0 [Note] Server socket created on IP: '::'. 19T11:44: 19.519291Z 0 [Note] InnoDB: Buffer pool(s) load completed at 151119 13:44:19 19T11:44: 19.636511Z 0 [Note] Event Scheduler: Loaded 0 events 19T11:44: 19.636793Z 0 [Note] /home/openxs/ dbs/5.7/ bin/mysqld: ready for connections.
2015-11-
2015-11-
2015-11-
2015-11-
2015-11-
2015-11-
2015-11-
2015-11-
2015-11-
2015-11-
2015-11-
2015-11-
2015-11-
2015-11-
2015-11-
2015-11-
2015-11-
2015-11-
Version: '5.7.9' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL)
The delay is less than 2 seconds for this command:
bin/mysqld_safe --no-defaults --table_ definition_ cache=50000 --table_ open_cache= 10000 &
and I do have 50K tables:
mysql> select version(), count(*) from information_ schema. tables; -----+- ------- --+ -----+- ------- --+ -----+- ------- --+
+------
| version() | count(*) |
+------
| 5.7.9 | 50282 |
+------
1 row in set (0,52 sec)
mysql> show variables like 'table_d%'; ------- ------- ----+-- -----+ ------- ------- ----+-- -----+ n_cache | 50000 | ------- ------- ----+-- -----+
+------
| Variable_name | Value |
+------
| table_definitio
+------
1 row in set (0,00 sec)
... ******* ******* ****** 229. row ******* ******* ******* ****** schema. memory
*******
Type: performance_schema
Name: performance_
Status: 163510080
229 rows in set (0,03 sec)