There’s not a lot of meat here, but there are some interesting tidbits, especially the mention of “sharding”: A database can be sharded by table, date or range. It is similar to partitioning, says Ellis, but with several key differences. Sharding usually involves divvying up data onto different physical machines. Partitioning, in contrast, typically occurs [...]

In prep for his keynote to the MySQL User Conference, O’Reilly asked a bunch of people running what he calls Web 2.0 sites how they were using databases. Have only read two installments so far, and it’s not very deep, but it’s incredibly insightful. Couple key quotes from Ian Wilkes of Linden Labs: Like everybody [...]

Looks like an awesome site, full of a lot of information on MySQL performance. Both writers, Peter Zaitsev and Vadim Tkachenko, worked with MySQL in their Performance Group. Includes presentations given at various conferences, and results of various tests, including this one showing performance benchmarks between InnoDB, MyISAM and Falcon (MySQL’s new storage engine – [...]

In order to get data from the MySQL command line output to a file, at the MySQL prompt, use:mysql> pager cat > /path/to/file/filenameat the file system, use:$ mysql …

Great article at metalink discussing block corruption. Specifically, how to find them, and options for possible fixes.Includes specific queries which proved very useful.

Link

My first stab:Oracle Data Migration Protocol Turn off archive logging (db bounce – as much as possible, create new tables with: create table … as select … no logging)Verify redo logs are at least 100M each, may want to increase size even more (temp.)Make rollback sigments to auto undo tablespace (and make auto extensible).

This article is pretty basic and not really worth linking on its own, but it is worth watching this series, especially the last two articles, as there may be some interesting stuff there.

There’s a very interesting aside about 3/4′s of the way down that talks about how much more “efficient” PL/SQL is than C, and thus, how much more productive programmers can be programming in that language…. C is purposefully very general; it can be used to work with data as PL/SQL, and/or it could be used for many other things, including the incredibly important need of displaying the data (of which PL/SQL has absolutely no ability)…. I’m sure a person could be a lot more efficient over time making phone calls with a cell phone, but I’d like to see that person, say, edit a file or an image on their phone.

Oracle Database Online Documentation 10g Release 2 (10.2)