I just annoyed a lady on the phone

I just annoyed a lady on the phone.

Her: Hello?
Me: Hello
Her: Who is this?
Me: The person you called. Who may you be?
Her: You called my phone yesterday evening and I wasn’t able to answer. I need to know who is this.
Me: You can’t. I did not call you. You called a fixed line and it can be from anybody. Give me your name and I will ask around.
Her: -gets angry- Where are you from?
Me: I don’t wish to reveal. Provide me with your name and I’ll check.
Her: -raises voice- What is this?
Me: I don’t need to identify myself.
Her: -officially pissed off- Are you trying to mock me? Why are you doing this to me?
Me: Why would I mock you? I am just asking–

-hangs up-

Not the first time this has happened. I hate to answer phone to ask me to identify myself. I won’t reveal myself before the caller does as I felt it gives a stranger an opportunity to find out more about the phone number’s owner(s). He or she could be someone who tries to use some social engineering skills. I’m mostly a prick at such scenarios. I know I know.

-hangs up-

Nature’s greatest events

In late summer the plankton bloom is at its height. Vast shoals of herring gather to feed on it, diving birds round the fish up into a bait ball and then a humpback whale roars in to scoop up the entire ball of herring in one huge mouthful.

HD: Bait Ball Feast – Nature’s Great Events: The Great Feast – BBC One

The largest mouth wins.

How to log slow MySQL queries

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

[code lang=”bash”]sudo nano /etc/mysql/my.cnf[/code]

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

[code lang=”bash”]# Here you can see queries with especially long duration
#log_slow_queries = /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes[/code]

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:

[code lang=”bash”]sudo cat /var/log/mysql/mysql-slow.log[/code]

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

[code lang=”bash”]sudo /etc/init.d/mysql restart[/code]

Hope it helps.

TED Talk by John Francis: I walk the Earth

For almost three decades, John Francis has been a planetwalker, traveling the globe by foot and sail with a message of environmental respect and responsibility (for 10 of those years without speaking). A funny, thoughtful talk with occasional banjo.

John Francis: I walk the Earth

I found this inspiring.