Insight for DBAs

Poor man’s query logging

Occasionally there is a need to see what queries reach MySQL. The database provides several ways to share that information with you. One is called general log activated with

Shell

–log

1

–log

(or

Shell

–general-log

1

–general-log

in MySQL 5.1+) start-up parameter. The log writes any query being executed by MySQL to a file with limited amount of additional […]

Read more

A quest for the full InnoDB status

When running InnoDB you are able to dig into the engine internals, look at various gauges and counters, see past deadlocks and the list of all open transactions. This is in your reach with one simple command —

Shell

SHOW ENGINE InnoDB STATUS

1

SHOW ENGINE InnoDB STATUS

. On most occasions it works beautifully. The problems appear […]

Read more