Ok, so what it looks like is connections waiting on your searches to finish, so they pile up behind that. You really don't have that much data, so it shouldn't be taking that long to search.

The odd thing is the search has been this way since 7.0, but you said you're just starting to see issues recently.

You might have answered this before, but are you on a shared server, virtual private, dedicated? You could probably see some improvements on this if MySQL was tuned properly.

I'd also suggest turning off searches for guest users if it isn't already. We will be making some major changes to the search for 8.0 to help, but from those screenshots, your searches are taking well over 10 minutes to complete, which isn't normal at all for the amount of data that you have.

We are on a shared server. But I am beginning the move to a virtual private this weekend. Will move the web pages now and save the db until next week.

I'll see where searches for guests is located.. but I don't think that applies to me. ALL of our users are required to register.

Shared server means the MySQL server can't be tuned for you, normally. VPS means it probably can be. You going Linux or Windows, Bill?

I'm moving FROM Windows to a Linux VPS. Decided to make as many changes as I can to get better performance.

As of a couple of minutes ago, all of my web pages and 5 MySQL databases are moved and running good in the new location.

I have two "virtual" links that I need to fix.

Then, if I don't find any other problems, I might try to get a copy of the Threads database moved over to the new location tomorrow. That will be the Big Test.

Oh good, then we can do some tuning on MySQL and get it to sing

Everything is fine for me here. Please check your configurations guys

Just watch out for the CASE sensitive differences between Doze and Nix regards DB table names..

that is a bugga boo at times..

Rick should really go all lower case for v8.0 and this will go away as an issue..