Technical Insights

Calculating the queries per second average in Mysql

I didn’t find any simple ways to determine how hard our mysql database was working, so I whipped this up. It uses a 10 second delay to figure out the queries per second average.

time=10 orig= …

Helpful SVN Script For Adding all Unknown files to Repository

I use SVN from the command line a lot. I also hate typing things over and over. I wrote this script to add all files to a repository that are not already in there.

svn status | awk '{if ($1 == …

How to use CURL to Hit a Web Api Using HTTP Basic Authentication

Curl is a fantastic application.

The most basic use of curl is very straightforward, just put in a web site’s url:

curl http://twitter.com

If you copy and paste the above code, you’ll get …

MySQL does not support variables with LIMIT in stored procedures

After banging my head against a wall for a while, I finally found this thread from June 2005 in the MySQL support forums regarding using variables in the LIMIT clause. They don’t support it …

'Database tip: Only Counting Certain Values in an Aggregate Query'

Aggregates are awesome. But sometimes you want to do 2 counts in a query, and have one of them be more restrictive than the other. Lets say our database focuses on pictures, and rating them on a …

Manly Diaper Bag

We never get ads that make any sense when developing answerbag, since we’re behind a firewall and the crawler can’t figure out our content.

Edit: This is not happening with our live …

Public / private key set up but not working?

When you set up public key authentication, make sure your authorized_keys2 file has the permissions set to 600. If you don’t, it’s likely that you will still be prompted for your …

How to roll back commits to an earlier version of a repository in SVN

I’ve always wanted to know how to do this, and for some reason I always had a hard time finding out how. I needed to rollback a change I had committed to my SVN repository.

The way you rollback …

Delete from table using a join

MySQL won’t let you delete from a table using a subquery that references itself. Fair enough. To get around this, up till now, I’ve used temporary tables. However, I’ve never …