Archive for the “Databases” Category


Google TechTalks presentation by Stewart Smith, MySQL AB (video) on April 28, 2006

Interesting quotes:

  • Variable (really) size VARCHAR
  • Significantly different and faster index add/drop (coming in 5.1)
  • User defined cluster partitioning:
    • by key
    • by range (might not be in 5.1 but in future releases)
    • by list (future, not 5.1)
  • Replicate one cluster to another cluster (note node-to-node replication)
  • much more … really for MySQL powerusersDBAs and large setups.

Comments No Comments »

SQL Tuning is mostly about tuning Oracle SQL.

Comments No Comments »