What does "flush tables;" do exactly?
Posted on 2016-11-08
Long story short, I was trying to trouble an error:
User XXXXXXXXXX already has more than 'max_user_connections' active connections...
This user has many different web sites all using one MySQL database, I had already restarted all their sites that I could find across varying web servers, and that didn't fix the error, so I then went on the MySQL server and did a "flush hosts" , that didn't help.
Then I read something along about doing:
So I ran that, it's still running, so far other sites using this db server aren't affected but now I'm second guessing myself and wondering if it was OK to run flush tables in the first place.
As I said, the process is still running so I'm hoping I didn't break anything.
Probably I shoudl have just restarted the MySQL service, but I didn't want to affect other users.
This is a Windows MySQL server and I could not find a command or script to kill a specific user's processes in one swoop (I did find a linux method but it involved grep and awk , so would not have worked on Windows)