How to DELETE with LIMIT and OFFSET in MySQL

It has been ages since I needed to write MySQL queries. I barely remember the basics. I found myself perplexed after learning DELETE does not allow you to specify a limit. I thought it simply acted as a SELECT but the results instead of being returned where deleted. It seems you need to nest 2 […]

Optimize MySQL turning Off InnoDB

If your MySQL databases uses MyISAM instead of InnoDB you should turn the last one Off. It should free memory and optimize your MySQL performance.