asked on

MySQL performance

Hi,

I'm running a copy of MySQL database on our web server - this is not a dedicated MySQL server, but the one web application that pulls data from this db has really poor performance.

I inherited this whole mess from another developer. I can understand large, complex connections on a shared server could be problematic, but I'm talking like 15 seconds to load 700 records.

I know next to nothing about this database, but was wondering what are the general things I should look at to "compact-repair" the db, recommended cache settings, etc.

Can anyone suggest what might be going on here? Or some remedies?

This is on a Windows Server 2003 box with all the latest updates. MySQL database has approximately 20 tables, most of them holding only a few columns and a few records.

I've also confirmed on the old website that performance was slow, and now our new code for their new website is sluggish too, so I do think it's the db.

Thanks

Bill

ASKER CERTIFIED SOLUTION

Ioannis Anifantakis

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

carsRST

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Ioannis Anifantakis

I almost forgot, one thing you should do first before anything else, is check-optimize-repair your tables.
go to the directory of mysql\bin and type the following:

mysqlcheck -u root -p --auto-repair --check --optimize --all-databases

Open in new window

Ioannis Anifantakis

Finally, a very good article written by a member here in Experts-Exchange will help you alot.

https://www.experts-exchange.com/articles/Database/MySQL/3-Ways-to-Speed-Up-MySQL.html

Bill Henderson

ASKER

Sorry for the delay! Thanks for the suggestions...