You are here

Home

status

MySQL and MariaDB variables inflation

Mon, 2016-12-12 21:43 — Shinguz
Taxonomy upgrade extras: 
mysql
variables
status
mariadb

MySQL is well known and widely spread because of its philosophy of Keep it Simple (KISS).

We recently had the discussion that with newer releases also MySQL and MariaDB relational databases becomes more and more complicated.

Temporary tables and MySQL STATUS information

Fri, 2016-07-08 18:42 — Shinguz
Taxonomy upgrade extras: 
status
temporary table

When analysing MySQL configuration and status information at customers it is always interesting to see how the applications behave. This can partially be seen by the output of the SHOW GLOBAL STATUS command.

InnoDB variables and status explained

InnoDB Buffer Pool

Undefined
tags: 
innodb
status variables
status
variables

The handler_read_* status variables

Because I do a lot of Performance Tuning gigs I get often in contact with these status variables. In the beginning I had a problem to understand them and now I have a problem to memorize the relation of the name and the meaning. Therefore I wrote this little summary:

Prepare the example

To show you the effect I have worked out a little example:

English
tags: 
mysql
handler
handler interface
status variables
status
Subscribe to RSS - status