I was able to reproduce the same with 79000 tables on PS 5.6.20
mysql> SELECT COUNT(*) FROM information_schema.tables where table_schema = 'bugtest';
+----------+
| COUNT(*) |
+----------+
| 79723 |
+----------+
1 row in set (0.25 sec)
If performance_schema=off and open_files_limit = 66000, then server will be started within 2 seconds.
root@Dell-XPS:/var/lib/mysql# date && /etc/init.d/mysql start && date
Thu Sep 18 15:09:37 IST 2014
* Starting MySQL (Percona Server) database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.
Thu Sep 18 15:09:39 IST 2014
root@Dell-XPS:/var/lib/mysql#
But If performance_schema=on and open_files_limit = 66000, then server will take 16-20 seconds. (tried 2-3 times)
root@Dell-XPS:/var/lib/mysql# vim /etc/mysql/my.cnf
root@Dell-XPS:/var/lib/mysql#
root@Dell-XPS:/var/lib/mysql# date && /etc/init.d/mysql start && date
Thu Sep 18 15:10:01 IST 2014
* Starting MySQL (Percona Server) database server mysqld [ OK ]
Thu Sep 18 15:10:19 IST 2014
root@Dell-XPS:/var/lib/mysql#
I was able to reproduce the same with 79000 tables on PS 5.6.20
mysql> SELECT COUNT(*) FROM information_ schema. tables where table_schema = 'bugtest';
+----------+
| COUNT(*) |
+----------+
| 79723 |
+----------+
1 row in set (0.25 sec)
If performance_ schema= off and open_files_limit = 66000, then server will be started within 2 seconds.
root@Dell- XPS:/var/ lib/mysql# date && /etc/init.d/mysql start && date XPS:/var/ lib/mysql#
Thu Sep 18 15:09:37 IST 2014
* Starting MySQL (Percona Server) database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.
Thu Sep 18 15:09:39 IST 2014
root@Dell-
But If performance_ schema= on and open_files_limit = 66000, then server will take 16-20 seconds. (tried 2-3 times) XPS:/var/ lib/mysql# vim /etc/mysql/my.cnf XPS:/var/ lib/mysql# XPS:/var/ lib/mysql# date && /etc/init.d/mysql start && date XPS:/var/ lib/mysql#
root@Dell-
root@Dell-
root@Dell-
Thu Sep 18 15:10:01 IST 2014
* Starting MySQL (Percona Server) database server mysqld [ OK ]
Thu Sep 18 15:10:19 IST 2014
root@Dell-