MySQL: Changing runtime variables with out restarting MySQL server.

I have run in to the issue where I wanted to change some configuration on our production MySQL server but did not want to restart MySQL since its in production.  One of the parameters we like to change time to time is the “log_slow_queries” so we can see what queries are slow in production environment.  [...]

Read the full article...

What is this “load average” I keep hearing about?

I have been asked numerous times what does “load average” means in top. If you don’t know what top is and you have access to linux machine, go type top now and see what it shows.
load average: 2.05, 2.17, 1.93
Quick answer is: first number (2.05) is 1 minute avg, second number (2.17) is [...]

Read the full article...

Improve page load time and increase server capacity by doing simple DNS and server changes

Problem:
One of the sites I maintain has been getting more and more traffic everyday. A very good thing for the site, not so good for the solo server which is serving those pages. The site is VERY dynamic with LAMP setup. We only have one server serving our web pages to our [...]

Read the full article...