Tag Archives: MySQL

Speed Up Your Database Using MySQL Query Cache

MySQL 5.1.69 Modern web applications place a massive load on the database. I’ve been working extensively with Magento lately and the demand on the database is enormous. We could argue all day about which language is easier on the database in terms of access routines and read/write cycles. Ruby (Sinatra)? Regardless of the application’s structure, […]

MySQL Dump Script For Database Backups

Mac OS X (10.6.8), CentOS, Linux Do you perform regular database backups? Maybe you take copies of your live database and push that data somewhere else (like, your staging site)? And maybe you’ve accidentally overwritten your live database coz you typed something wrong? Yeah, well I have. And after the second time, I decided to […]