note to self, MySQL query profiler

---

Update The original article mentioned in this post is no longer available, but if you are still interested in query profiling in MySQL, check out this http://dev.mysql.com/doc/refman/5.0/en/show-profiles.html
I will write up an quick start guide to profiling myself here, one day.
 
-- original post
this article is a great way to get started using the mysql query profiler.

If you've never used it before take some time to check it out, it will change the way you think about the database forever.

---

Note to self, how to get the top tens from MySQL slow query log

---

Use these two commands to get the top ten and top ten repeaters from MySQL's slow query log.

mysqldumpslow -t 10 ./slow-log > /home/danny/top_ten_slow_query.txt

mysqldumpslow -a -s c -t 10 ./slow-log > /home/danny/top_ten_repeat_slow_query.txt

---

Quote of the [specify period]

---

This [period]'s quote is from Nicola Morrison, ScottishPower online manager quoted on computerweekly.com, here, in a piece which quite frankly looks like marketing blurb placed by a PR agent on a day when the editor was hungover.

Anyway, Nicola have an award for improving customer service not by answering customers questions but by analysing them!

Working with [tech co][1] has ... given us an unparalleled insight into our customers' requirements through the ability to analyse the questions they are asking.

[1] I'm not going to repeat the name of the company involved, I don't want to draw attention to them!

---

Note to self, how to delete files older than

---

Yes, yet another one that I always have to look up, I think it must be my age!

find /path/to/files* -mtime +5 -exec rm {} \;

---