This is the second article of the series dedicated to MySQL trending.
As I wrote before, understanding your workload and seeing the evolution of it over time can help anticipating problems and work on solutions before the breakdown.
This article covers MySQL History List Length also known as HLL.
MySQL History List is related to InnoDB Undo Logs.
InnoDB
is a multi-version storage engine (MVCC). It
keeps information about old versions of changed rows to support
transactional features such as concurrency and rollback. This
information is stored in undo tablespaces in a data structure
called a rollback segment.
This means that you can start a transaction and continue to see a consistent snapshot even if the data changed by other transaction. This behavior is related to the …
[Read more]