MySQL thousands connections after convert MyISAM to InnoDB on fail-over structure I've acquired a fail-over structure and I migrated my databases to new structure converting all tables of my database from MyISAM to InnoDB engine, but, after import all databases, I have a problem with concurrent connections, with one access to my service, the MySQL are opening thousands connections and growing, the connection number only decreases when I restart the MySQL service, I think that isn't my server hardware because it has 32 cpu cores and 64gb RAM, I don't understand what is happening but I need to solve this quickly. 
All databases and tables are using InnoDB engine, and my application are closing all connections that it opens. 

Anyone had the same problem when migrate databases like this?
If you are using transactions, please ensure that you use either a COMMIT or ROLLBACK statement before closing the connection.

If this is already the case, you probably need to increase the thread_cache_size value in order to reuse as much as possible the existing connection threads instead of creating new ones from start.

Please note the following values:


mysql&gt; SHOW GLOBAL VARIABLES LIKE 'Connections';
mysql&gt; SHOW GLOBAL VARIABLES LIKE 'Thread_created';
mysql&gt; SHOW GLOBAL VARIABLES LIKE 'Max_used_connections';


If Thread_created/Connections> 0.01, you have to increase the value of thread_cache_size.
The upper limit should be the value of Max_used_connections.