[Zaph]

Like I said: after disabling autocomplete the problem has not resurfaced, and I'm not going to re-enable it because I don't want to risk getting angry customers on the phone again.

As far as I'm concerned the problem is resolved by disabling autocomplete (which I don't want or need anyway). In my first post I was looking for this solution, and in my second I let you know I found it. I'm more than happy to explain what happened exactly but I'm not going to test a new release with the risk of it happening again. Sorry.

[Zaph]

Hello Peter,

I had just installed the new version, and was looking at a table in the data-tab (a phpbb_posts table containing 45K records). I wanted to see the most recent posts, so I clicked the id column header (sort asc), and then clicked it again to sort desc – something I do quite frequently, and which has never ever caused any problems. At the moment I did that my client froze with the data still in asc order, and the message “Rebuilding tag files” in the status bar. I waited a minute or so while nothing continued to happen, and then tried to close the client. This didn't work because I got the message that SQLYog couldn't close because a query was being executed.

Being somewhat impatient I opened the old version of the client to be able to check those posts while the new client did what it needed to do, and that's when I found out that the server wasn't responding. I checked my webserver, and the MySQL service processor usage was 0-1%, so the server instance wasn't working like mad.

I then opened one of my websites and noticed it didn't display because it couldn't open any databases.

I tried to restart the MySQL service, but that hung on 'Stopping'. The new client had been disconnected, so it was responsive again. After waiting some more to see if the service would restart whilst answering my customers why their websites weren't responding I decided to reboot the server alltogether, which worked.

So, while not wanting to make assumptions, I do get the very strong impression that the rebuilding of tag files has something to with it – maybe because it started rebuilding at the exact moment I clicked the id column header. After disabling autocomplete this has not happened again, and I'm not going to re-enable it because I don't want anymore downtime on those websites.

[Zaph]

OK, panic mode off…restarting MySQL didn't work, so I rebooted the server. Also found the Autocomplete options in the settings, and turned it off.

Maybe add a dialog to that rebuilding, explaining that it may take a very lnog time on larger databases and that the entire MySQL instance will be doing nothing else during that time -> “Are you sure you want to rebuild the tag files?”

[Author]

Posts