Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

how can i speed up my database

Posted on 2011-03-15
2
Medium Priority
?
433 Views
Last Modified: 2012-05-11
How can I speed up my database so things load quicker?
0
Comment
Question by:Computer Guy
2 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 35137961
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
 
LVL 39

Expert Comment

by:Aaron Tomosky
ID: 35138117
If you give us a slow query we can give specific advice. Otherwise you will just get general info
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Creating and Managing Databases with phpMyAdmin in cPanel.
Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question