...more recent posts
Last night I went to my first ever opera, Giuseppe Verdi's La Traviata, at Lincoln Center. Apparently this is a fairly standard "first" opera to see. Very enjoyable. Lincoln Center is beautiful. We ate before hand, and then during the first intermission you go back and sit down at your table for dessert. Nice touch. Not sure if I'm converted to a big fan or anything, but it was a great evening. I'm hoping to give the symphony a shot next (although I've been to that once in the past.)
Here's a horrible phonecam shot I felt like a total dork taking. You can see the screens in front of every seat that translate. They are *highly* directional, so you can only see the LEDs if you are looking directly straight at it - no peripheral vision distraction at all. Pretty cool. I guess these were something of an issue for the real buffs when they first put them in, but it's very helpful if you can't speak Italian.
Looks like my fix yesterday did take care of the problem. I'm still keeping my eye on it, but so far so good. One big help in tracking this down was enabling the MySQL slow query log. This lets you set a threshold for number of seconds, and then any query taking longer than that gets logged to a specific file. Watching that file is then a huge help in spotting where potential problems are hiding.
Here's the official MySQL slow query log page, and here's a nice write up on how to activate it. Basically it just amounts to adding these lines to the my.cnf file and restarting MySQL:
long_query_time = 1 log-slow-queries = /var/log/mysql/mysql-slow.logI had to create the /var/log/mysql/ directory (and chown mysql:mysql) in order to get it to work.
I had a bit of a chase this morning tracking down an issue on the new server (new server = ash, old server = tulip, old old server = elm.) CPU usage was being pegged at 99.9% by mysqld. Turns out - I think - to be a problem with some PHP code I had written (who would have guessed!) Anyway, I ended up learning a bunch about MySQL that I didn't know previously, so these things should be easy to track down in the future. For my own reference I will link here to this excellent Jeremy Zawodny post on tuning MySQL.
Keywords: thread_cache : my.cnf
From the Onion: Apple Unveils New Product-Unveiling Product: iLaunch.