Running your own AWS account for testing can lead to unexpected costs. Unless care is taken around securing the account, the account can be hijacked and used for other purposes. Personally I’ve stopped running my own accounts and moved to using the sandbox accounts provided by acloudguru as part of their Personal Plus …

I recently had to set up a lot of Archive storage engine tables for several 100 InnoDB tables. To do this conversion I had to script off all the indexes and in some cases the primary keys. I did a MySQLDUMP and ran the following commands against the dump file. 1sed ‘s/ENGINE=InnoDB/ENGINE=archive/g’ dump.dmp > …

I’ve started to use the Percona Toolkit quite a lot and have recently found pt-archiver useful for 2 things. Purging Large amounts of data 1pt-archiver –source h=$HOST, 2 D=$DB,t=$TABLE,P=$PORT 3 –where “$WHERE” –no-check-charset 4 –skip-foreign-key-checks –progress 1000 –purge the only bit that probably needs …

As part of my migration to MariaDB I wanted to change all the wordpress tables from MyISAM to INNODB. Of course you can do this one table at a time with alter table fred engine=innodb; Personally I prefer to automate where ever possible so I created the following linux shell script to convert all the tables in one …