How Do I Optimize an SQL Database?

[hopefire]

Greetings,

I have been advised that it would be in my best interest to optimize and repair my SQL database in order to keep my server load to a minimum.

This is something that I have never done before. I logged into phpmyadmin, however, I did not see anything obvious that would allow me to do this.

How do you optimize an SQL database?

[pureconcepts]

Depends on the question at hand. Normally adding Indexes or Primary key helps. I assume a query is running slow or sucking up server resources... Take some of the queries in question and use the EXPLAIN tab in PHPMyAdmin to see what is taking so long. As always, www.mysql.com can also help on the subject far more than I can. Plenty of articles describing EXPLAIN and Table Optimization.

[Kat]

Greetings,

I have been advised that it would be in my best interest to optimize and repair my SQL database in order to keep my server load to a minimum.

This is something that I have never done before. I logged into phpmyadmin, however, I did not see anything obvious that would allow me to do this.

How do you optimize an SQL database?

start up phpmyadmin. You'll see where to do that in your control panel under the mysql tab . There'll be a database there with your database username and a link to phpmyadmin. Login as the user and you'll get to see your database, probably in split panes/windows. In that left panel is a lising of all your tables and at the very top is the database name. Click that and you'll get all your tables . scroll to the bottom of those tables and you'll see the options to check all etc . Check all. Just next to that is a drop down list and in there you will see the repair tables . choose it and viola. Your tables are repaired. You'll also find te optimise there

kat