Core Dump

Databases MySQL

How to crash mysqld intentionally

Ronald Bradford
March 5, 2010

While some may think I’m daft, I have a legitimate reason for wanting to crash mysqld. However first we need to find a way to crash it. Great thanks to Alan K, Mark L, Harrison and Hartmut on #mysql-dev for several suggestions and a config option I was unaware of.

Databases InnoDB MySQL Storage Engines Uncategorized

Calculating your database size

Ronald Bradford
September 25, 2009

I generally use the following MySQL INFORMATION_SCHEMA (I_S) query to Calculate Your MySQL Database Size . This query and most others that access the MySQL INFORMATION_SCHEMA can be very slow to execute because they are not real tables and are not governed by physical data, memory buffers and indexes for example but rather internal MySQL data structures.