Sam’s random musings

Tools | MySQL Performance Blog

This page contains links to various tools we found helpful to use in practice. Some tools are written by us, others by third parties, yet another ones may be shipped with your operating system you just need to find they are there.

nice little collection of reminders

EXPLAIN Cheatsheet

At the 2008 MySQL Conference and Expo, The Pythian Group gave away EXPLAIN cheatsheets. They were very nice, printed in full color and laminated to ensure you can spill your coffee* on it and it will survive.

If you are thinking of hunting for some query speedups in mysql this might help (now don’t be premature

(Via Planet MySQL.)

Behind The Scenes of Google Scalability

The recent Data-Intensive Computing Symposium brought together experts in system design, programming, parallel algorithms, data management, scientific applications, and information-based applications to better understand existing capabilities in the development and application of large-scale computing systems, and to explore future opportunities.

Always interesting to read and see presentations on how the really big boys do it

(Via High Scalability - Building bigger, faster, more reliable websites..)

<

p>DTerm: give your Mac a little shell love”

DTerm is a utility just released by Decimus Software Inc. It’s a Leopard-only app that provides a hotkey-triggered HUD which allows shell commands to be run from anywhere in OS X. In case you’re wondering why, just imagine what less window switching and screen clutter could mean for productivity on jobs that require both Finder and Terminal. Yes, you can do a lot with Quicksilver, but DTerm provides bash name completion with a dropdown, context sensitivity to your current path and full output with clipboard features. You can also type ⌘-↩ in the HUD to run the command in the Terminal, which will open up to your current path.

This is a very addictive application for the geekiest around you. Well not totally the geekiest, because they might not know what a ui is other then a terminal window….

(Via The Unofficial Apple Weblog (TUAW).)

How to Shoot Yourself in the Foot in Any Programming Language:

fullduplex.org » How to Shoot Yourself in the Foot in Any Programming Language The proliferation of modern programming languages (all of which seem to have stolen countless features from one another) sometimes makes it difficult to remember what language you’re currently using. This guide is offered as a public service to help programmers who [...]

Oh man so true so true

(Via Mind-NOX.)

Giggle of the Day: if Microsoft made vi:

Giggle of the Day: if Microsoft made vi:

As face says not quite safe for work, but funny! (you might have to be really really geeky to find it funny

(Via Mind-NOX.)

Nesting of folders has exceeded the recommended limit of 100:

If Disk Utility reports Nesting of folders has exceeded the recommended limit of 100, you can find the offending folders by opening a Terminal window and typing
sudo find / -maxdepth 100 -mindepth 100
The last few times I had people report this error to me, they turned out to have an old version of Vapor on their machine.”

Good to have this little snip in my pocket

(Via jpb’s Tech Notes.)

Taming Launchd:

Developers, and some power users who are reading this have probably heard of launchd. It’s Apple’s ‘mama process,’ responsible for launching other processes at startup, login, at regular intervals, or on demand. If you open the Activity Monitor application, and view ‘All Processes, Hierarchically,’ you’ll see that there are only two top-level processes: kernel_task, and launchd. The kernel sits there and does its thing, while launchd spawns all the other processes that make up your Macintosh computing experience.

Some good insight into this relative newcomer to Mac OS X as a way or launching and running services of various kinds in the background, some good notes on the things that don’t work quite as expected (bugs) and some ways it is used now. Also some links to two of the editors for launchd files.

(Via Red Sweater Blog.)