All of this assumes LAMP (specifically CentOS 6, MySQL server 5.5, Apache 2+ with mod-status enabled)
On mysql server:
watch -n 1 "mysql -e 'show processlist';"
Look for sleeping connections that are staying open for a while. Watch for a trend. When you see a connection that you think will stay open for long enough, note it’s port number. Open second shell. Do the following:
netstat -lnap | grep 12345
– where the 12345 is the port number from the mysql process list. If/when you get a result, note the number to the right, next to “ESTABLISHED”. Next – open a web browser. Navigate to http://yourserver.com/server-status and do a search for that number (that’s the PID (process id). The highlighted line is now the process that caused the long-running MySQL thread.
Repeat this process a bunch of times until you have a good overview of what’s causing problems. Viola! Debug success, and it’s time for beers!
( This week, we’re drinking Sam Adams Boston Lager for our friends in Boston )
I’ve got to give the credit of this drink to Tina and her Sister. They concocted this delicious treat a couple weeks ago and I played with the ratios for a few nights to come up with this. Make sure to serve cold and enjoy with friends!
2 oz Orange Juice
1 oz Cherry Pomegranate Juice
1 oz Sprite
2 oz Skyy Vodka
Splash Lime Juice
Combine all ingredients. Mix well. Serve over ice with a wedge of lime.
It seems like yesterday was March 4, the day Rylan was born. Just like that, a month has gone by. What have I been doing? Here’s a rundown of the last month of my life.
I went to New York City for a couple days, on business, to help resolve a major network problem in conjunction with the awesome IT guys from Outbrain. Toured their datacenter in NYC, which is in the same building as Google’s datacenter (pretty cool to see). Ate some Kobe Bacon (O!M!G! it was good) and a $40 hamburger. Thanks NYC. Met some of my New York co-workers face-to-face for the first time.
Next, was the crazy busy work schedule. Launching two new sites and updating a third – all in a month. Building a legitimate DevOps team, building a legitimate company network, and building an array of web servers. All while maintaining a fragile network of super-scaled WordPress sites. Did I mention I hired two people, and am working on a third?
Went to WordCamp Miami today. That was fun. Networked with cool people. ‘Nuff said.
Now we’re finalizing the plans for our wedding. We’re already technically married, now we gotta make it official by saying our vows in front of our family and friends! June 29 it is, aboard the Island Time Cruise boat. We rented a house on the water for the week (in Key Largo), we’ll have our boat there, and of course my parents will have their boat nearby. It’s going to be a week-long party and adventure in Key Largo, for all things that are Collier/Greda and friends.
And I haven’t even mentioned the fact that I am a brand new father. Loving that part of my life. Absolutely loving it. Awesome kid. Awesome new family. Awesome awesome. I worry that my Tina isn’t getting the help she needs from me – doing my best to keep everything organized. She literally just tried to drink a beer after having no alcohol for about a year. She said my Corona Light tastes like old shoes. Oh well, more for me.