Tag - read only

Instrumenting Read Only Transactions in InnoDB

Instrumenting read only transactions MySQL

Probably not well known but quite an important optimization was introduced in MySQL 5.6 – reduced overhead for “read only transactions”. While usually by a “transaction” we mean a query or a group of queries that change data, with transaction engines like InnoDB, every data read or write operation is a transaction.
Now, as a […]

Read more

Better high availability: MySQL and Percona XtraDB Cluster with good application design

High Availability
Have you ever wondered if your application should be able to work in read-only mode? How important is that question?
MySQL seems to be the most popular database solution for web-based products. Most typical Internet application workloads consist of many reads, with usually few writes. There are exceptions of course – MMO games for […]

Read more