Archive for January 2014

What’s protected from accidental deletion in Active Directory?

Here’s just a little tip I picked up from a presentation by Mark Broadbent (retracement on twitter). I’m the guy who wasn’t listening! Mark stressed the importance of enabling the Protection from accidental deletion property in active directory for your Failover Clusters. Here’s how to check this for Computers with Powershell. This string of commands […]

Move a MySQL / TokuDB database?

I’ve been having a look at TokuDB recently and I’m quite excited about some of its claims. But everything comes with its limitations! If you search Google for “move tokudb database” You’ll be presented with a big page of NO! Aside from moving the entire data directory the advice here is use mysqldump or change to another […]

MySQL Database Maintenance Stored Procedure Update

This is just a quick update of a stored procedure to assist with MySQL Database Maintenance. I originally posted this back in 2012. The Stored Procedure allows you to run OPTIMIZE TABLE or ANALYZE TABLE on all (or most) tables in a MySQL database. In this version I’ve added some simple logging and automatic recognition of partitioned tables to take advantage […]

TokyuDB live query reports

I’ve just started to have a peek at TokuDB for MySQL today. I’m running a few statements to turn some existing MyISAM tables over to the TokuDB storage engine. Here’s what you see with a SHOW PROCESSLIST command. Id: 6 User: root Host: localhost:42944 db: test_db Command: Query Time: 658 State: Loading of data about […]

MySQL Partitioning & OPTIMIZE TABLE

MySQL table Partitioning can be used in various way to improve performance. I wanted to get some idea of how this would affect database maintenance operations like OPTIMIZE TABLE. For these tests I used a default install of MySQL 5.6.15, with a key_buffer_size of 2GB, and executed OPTIMIZE TABLE table_name after a series of actions […]