MySQL connection websites VERY slugish

The past few days some of the sites I host on a dedicated server have become sluggish, here is an example:

We digged in an as it turns out only sites that are WordPress WITH a MySQL connection are sluggish.
Then I checked a simple ASP page I have that also connects to the same MySQL server and as it turns out it is ALSO super slow.
So its not the Wordpress or the ASP it is the MySQL server.

All sites or pages that connect to it are serving VERY slow, I would say 6-10 times slower than a website/page that is not connected to MySQL.

MySQL has suddenly gotten super SLOW .... what can I do to enhance the connection and make it faster ?  As it was before ?

Help is greatly appreciated.

Example of ASP page connected to the same MySQL:

One other clue: I have DBForge installed on that server, I use it to manage the MySQL and that connection seems fast, so I am guessing may be the drivers ??

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dan CraciunIT ConsultantCommented:
You'll need to test on the server.
We don't have access to the code, so we can't tell if MySQL is the problem.

To debug, you could create a single page, add some code that selects something from a table and then view the page with that code and without.

It it's indeed the MySQL server, start by restarting the service, then check if you're not out of RAM, or have a bad HDD, then check all the tables to see if one has not grown a lot (especially logs).

AleksAuthor Commented:
I have done the following:

I created a PHP page that connects to the same server, it lags tremendously as well.
I created a simple HTML page NOT connected to the MySQL server, it loads immediately.

Clearly it IS the MySQL

RAM is OK on that server, plenty left. and other pages and services run just fine.  HDD looks fine as everything else works properly.

The databases are very small, they are only the backend of wordpress websites that have 5 pages.

Is there any tool to test the MySQL database ?
Dan CraciunIT ConsultantCommented:
Have you restarted the service?

Do you use phpmyadmin? If yes, login and check each table.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
AleksAuthor Commented:
I did restart it, no luck !
I have a MySQL admin, so I can check the tables. What should I look for ?
I use DBForge, its actually pretty good software.
AleksAuthor Commented:
Turn out its an attack on wordpress websites. I opened another ticket for that.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.