 |
Linode.com Forum
Linode Community Forums
|
| Author |
Message |
Apreche
Joined: 03 Sep 2005
Posts: 11
Location: Beacon, NY
|
| Posted: Mon Jan 21, 2008 1:32 pm Post subject: Need MySQL to go faster |
|
|
| On my Linode I'm running Ubuntu, Lighttpd, MySQL and PHP5. I've got lots of free RAM. CPU usage is also light. However, I'm having performance issues. I have query_cache and all that other stuff setup, but it's still not fast enough. Part of this is because our forum uses some very inefficient queries. However, I think part of it is just a disk i/o bottleneck. Is there some way to configure MySQL to maybe use more of the free memory to increase performance? |
|
| Back to top |
|
SteveG
Joined: 30 Nov 2003
Posts: 199
|
| Posted: Mon Jan 21, 2008 2:27 pm Post subject: |
|
|
There are all kinds of memory parameters for mysql, and without knowing which ones you're hitting, you don't know which ones to increase.
But even before that, you might set log-slow-queries to see exactly which queries are causing problems, and either fix the queries, or build indices which will help those queries, if not already set. Proper indices can help a *lot*. |
|
| Back to top |
|
| |
|