Press "Enter" to skip to content

Posts published in March 2015

Faster alternative to MySQL Delete Table Contents / Truncate

From time to time you might have some rather big tables that you want to delete all the data quickly and start afresh. You have a few options at this point. The first you’ll probably look at is: DELETE FROM `table_name` The benefit of doing this is DELETE provides the…

Track Javascript Errors on your site Automatically

We have added a new section to Statvoo.com recently. The new section is called Errors and it can be found under any website you have added to your account, from the left hand navigation. Statvoo.com now logs all Javascript errors that occur on your website so that you can find…

ORDER BY RAND() – Faster Alternative

MySQL’s ORDER BY RAND() function can be so useful for returning random items from a table, infact, we have used it a million times over the years. The problem comes when your database tables start getting really big. We found a very nice alternative to using it and thought it…

Moving a MySQL Database without downtime

At Statvoo we found ourselves in the position where we needed to move our master MySQL database without ANY downtime and for anyone who’s tried to do this, you will know how hard this can be if it is not done exactly right. Below I will run through the steps…