database
looks useful for a DBA
1 FaverShareViewed: 70 TimesQuoted: 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
1 FaverShareViewed: 11 TimesWe 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.
1 FaverShareViewed: 3 TimesQuoted: 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." )
1 FaverShareViewed: 3 TimesQuoted: 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 ...
Related Content from Around Faves
mysql
-
There are some helpful tips in here, whether or not you use replication. In my experience, the most important thing with database performance is to minimize the time and row range over which you hold write locks -- and that's what this post is essentially about.
1 FaverViewed: 6 TimesQuoted: Piping data through application is the best solution in many cases and is quite easy - it is trivial to write the function which will take SELECT query and the table to which store its result set and use in your application in all cases when you need this functionality.
- mike - May 15 20092 FaversViewed: 2 Times
- guido - Feb 22 20094 FaversViewed: 8 Times
