I am on Centos 6 and mysql version is 5.6. –
I have several relatively large tables and when I try to run a command it takes up all the connections to the database so the site gets down and I'll get this error:
SQLSTATE[HY000]  Too many connections ...
Lets say I want to run this command:
CREATE TABLE tbl_new AS SELECT * FROM tbl_old;
Is there anyway that I can limit the number of connection that this command takes to mysql?