root@MDB1:~# mysql -uroot -pMDB@PassWd2020 -se \"select @@max_connections\"\r\n@@max_connections\r\n697<\/pre>\nWe got only 697 connections, Let’s interpret MySQL error log before proceeding to next steps.. We have copied the same below:<\/p>\n
2020-01-30T19:52:35.136192Z0 [Warning] Changed limits: max_open_files: 5129 (requested 10000)\r\n2020-01-30T19:54:13.241937Z0 [Warning] Changed limits: max_connections: 4152 (requested 10000)\r\n2020-01-30T19:57:47.51617Z0 [Warning] Changed limits: table_open_cache: 533 (requested 15000)<\/pre>\nThis is due to open files limitations for MySQL so let’s increase now the number of allowed open files for MySQL, The following steps we did to fix this resource limit issue:<\/p>\n