Originally Posted by Web31337
Personally, I can't be more of help on this topic, just want to clear some things.
Do you have large amounts of data?
"it hangs": it loads CPU or just silently goes down and doesn't respond: not accepts connections, not replies with anything if accepts, etc? What is your MySQL server version?
Did you ever had same problem on other system(if you previously used that scheme)?
If I connect with the mysql client and type flush logs, it just takes forever to get back at the mysql prompt.
It just seems like this is doing nothing.
If I open a new terminal and connect again, this just works.
The database is 1.5 GB data in its whole(mysqldump).
I did a dump and imported it on another system and I got the same problem. Maybe a deadlock? I have no idea how to find this out.