Welcome, Guest. [ Log In ]
'Help!  My server is slow!' Help Folder   Help! My server is slow!
Search KBase


Top 3 in this Area:
1. MySQL Optimization: Slow Query Logs and Indexes
2. Process Accounting (to find and remove the cause of slowness)
3. General MySQL Optimization Tips

 
Help! My server is slow! Description
There are several areas that you can investigate to improve performance of your dedicated server.
There are also often ways to determine exactly what is causing your dedicated server to run slow.

1) MySQL Optimization: Slow Query Logs and Indices
2) Process Accounting (to find and remove the cause of slowness)
3) General MySQL Optimization Tips
4) Key Cache and Data Cache (incomplete at this time)

Number one and two above are your best bets for tracking down resource hogs.

Last updated: Jun 19, 2003.

Sub-Areas of Help! My server is slow!
Question General MySQL Optimization Tips
MySQL has some good tips on optimizing your system.
Question Process Accounting (to find and remove the cause of slowness)
Unix Process Accounting is a tool that literally takes account of every single process on your server, recording how much CPU (processor) and memory (RAM) each process consumes. When summarized, t... (more)
Question MySQL Optimization: Slow Query Logs and Indexes
Alll this should be done over an ssh session (preferable) or a telnet session (less preferable). Check /dh/mysql/logs/mysql.composer.slow (where "composer" is replaced with the composer on y... (more)