Data

Looking just at the data

Ronald Bradford
October 7, 2009

There are many areas you need to review when addressing MySQL performance such as current database load, executed SQL statements, connections, configuration parameters, memory usage, disk to memory ratio, hardware performance & bottlenecks just to name a few.

Databases General MySQL

My favorite MySQL data type – DECIMAL(31,0)

Ronald Bradford
September 18, 2009

It may seem hard to believe, but I have seen DECIMAL(31,0) in action on a production server. Not just in one column, but in 15 columns just in the largest 4 tables of one schema.

Benchmarking Databases Drizzle General Linux MySQL Open Source

Seeking public data for benchmarks

Ronald Bradford
August 28, 2009

I have several side projects when time permits and one is that of benchmarking various MySQL technologies (e.g. MySQL 5.0,5.1,5.4), variants (e.g. MariaDB, Drizzle) and storage engines (e.g. Tokutek, Innodb plugin) and even other products like Tokyo Cabinet which is gaining large implementations.