MySQL tip: UPDATE LIMIT 1
Here's one I picked this up a while ago, for those that rock mysql at the command line all day like I do:
master/wp> UPDATE user SET ad_id='fb' WHERE user_id = 1337 LIMIT 1;
It's a good way to ensure that if you seriously fcuk the query up, you only update 1 record. For multiple records, there's another good practice to get used to: do a SELECT first, using the same exact WHERE criteria you plan to use in your UPDATE statement. This verifies the set you will be affecting when you do run the UPDATE is indeed what you want to update, and you can plug the row count you get from it into your UPDATE's LIMIT clause.
Google Analytics hours of day
Here's a quick way to use Google Analytics to view your site's traffic by hours of day. Among other things, this can be useful when planning scheduled maintenance on a high-traffic website -- by checking traffic by hour, you can identify when your site experiences its lightest loads and plan accordingly (and, conversely, avoid the time with the heaviest loads!).
It's actually pretty simple to have Analytics display your traffic by hour, over any period of time:
- Select Visitor Tracking | Visits from the menu on left
- On the right, locate and click the clock icon
That's it! As hinted above, it will display the traffic for the currently selected date range, so if you want to see if just for the past week, or just for yesterday, just play with the date range. This can be especially useful when performing a post-mortem on some event that occurred during a particular day, or range of days. Enjoy!