i.justrealized

I haven’t been generous enough to spend money on higher RAM for my blogs. I started to notice slow downs in the blog recent, particularly caused by a particular plugin that does related posts. I found out by checking on slow queries log. Here’s how to get MySQL to log slow queries:

If you are using Ubuntu of Debian-based operating systems, it’s found in /etc/mysql/my.cnf. You may need to use

Press CTRL + W, that’s search in nano. Find “slow” for the section for logging slow queries.

I uncommented “log_slow_queries” and “long_query_time”. I put long_query_time to 8. That requires a bit of experimentation. It depends on your environment.

I run the following command to check the slow queries:

After you change the configuration in my.cnf, you need to restart. You can do so using:

Hope it helps.

This is what happens if you don’t clear your Apache logs:

That’s 210 MB of data I am least interested with. By the way I just realized delete the log actually lowers memory usage significantly.

Okay, I realized this long ago but it annoys me that every time I just forget this. Sometime, when debugging CakePHP, the most direct method is to simply log an error. It’s like ‘trace’ in Actionscript or just a println() in Java. Anyway, here it is:

This can be called from the controller. (more…)