database

The biggest free music database

looks useful for a DBA

Quoted: Use this SQL Server SP to generate a report of all SQL Server jobs.

Those plucky penguins--already passé. Whales and polar bears--just fads. But dinosaurs have kept their scaly grip our imaginations. The new DinoBase from the University of Bristol in the U.K. offers plenty of information for everyone from dino dabblers to devotees who want to check whether there's such an animal as "Elvisaurus." (There isn't.) A database holds vital statistics--such as length, weight, and time span--for several hundred dinosaur species, including Stygimoloch spinifer (above), a 3-meter-long herbivore from what is now Montana. Its elaborate headgear might have served as a weapon or as a lure for mates. Visitors can tour a gallery of dino art or dig into the site's forum for announcements of fresh finds and the latest on current debates, such as whether commercial fossil hunters hurt or help paleontology.

Volume 316, Number 5828, Issue of 25 May 2007

We inadvertently provisioned a few database machines with MyISAM instead of InnoDB, and it has been a nightmare. I strongly advice against using MyISAM -- ever.

With MyISAM, we periodically get these incorrect "duplicate key" errors that don't go away until you run the lenghty "repair table" command that somehow fixes everything.

Quoted: Use MyISAM when: The data isn't too critical ( "unreliable and slow, related to table size, table repair process" )
...
Use InnoDB for tables when: The table will be big (100Mb+ - "For reliability and performance, we use InnoDB for almost everything at Wikipedia - we just can't afford the downtime implied by MyISAM use and check table for 400GB of data when we get a crash." )

Quoted: Wed, 11/14/2007 - 10:04 — Todd Hoff * Flickr Architecture (3559) Update: Flickr hits 2 Billion photos served. That's a lot of hamburgers. Flickr is ...

Sprout Core Javascript library data storage interfaces.

EveryHit.com is a website for fans of The British music scene from the beginning of the rock 'n' roll era right the way through to the present day.

Looks like a great set of tools for MySql.

Quoted: Essential command-line utilities for MySQL (formerly MySQL Toolkit)