Posts Tagged ‘index’

EffectiveMySQL Meetup in NY

Posted: 12th March 2011 by Darren Cassar in MySQL
Tags: , , , , , ,

The first EffectiveMySQL meetup will be held in NY on Tuesday 22nd March 2011 by Ronald Bradford. Details here The title of the talk is “How better indexes save you money”. Saving money? Hey sure thing :) I’m in Ronald. For those of you who do not know Ronald Bradford, he’s an Oracle Ace Director [...]

Warning, the following is quite ugly, but does the job :) A while back I needed to create an archive slave database from a half a terabyte myisam master and had space restrictions. I could not dump the db, load it, then drop keys (archive doesn’t support keys apart from a primary key on one [...]