how can i speed up my database

How can I speed up my database so things load quicker?
LVL 3
Computer GuyAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
you have  to double-check the slow-running queries, with their EXPLAIN plan, if you are missing indexes eventually.
http://dev.mysql.com/doc/refman/5.0/en/explain.html

it might that some server parameter tuning can help:
http://dev.mysql.com/doc/refman/5.0/en/server-parameters.html
0
 
Aaron TomoskySD-WAN SimplifiedCommented:
If you give us a slow query we can give specific advice. Otherwise you will just get general info
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.