Comment 5 for bug 1370392

Revision history for this message
Nilnandan Joshi (nilnandan-joshi) wrote :

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#