MySQL

Category to track posts in PlanetMySQL

Checking for a live database connection considered harmful

It is very common for me to look at a customer’s database and notice a lot of overhead from checking whether a database connection is active before sending a query to it. This comes from the following design pattern, written in pseudo-code:

Shell

function query_database(connection, sql)
if !connection.is_alive() and !connection.reconnect() then
[…]

Read more

Goal-Driven Performance Optimization white-paper available

If you were at last month’s MySQL conference, you might have seen a small flyer we were distributing, titled “A brief introduction to Goal-Driven Performance Optimization.” This is a super-compressed technical introduction to one of the methods we use to solve problems as quickly and efficiently as possible. We’ve just posted this […]

Read more

Seeking volunteers for Percona documentation

Percona wants to upgrade our documentation to improve its readability
and to make it more useful for you, our clients and partners. We are
so busy developing software and handling your needs that we have
trouble finishing all the documentation! We think you can help.
Helping us will give you a chance to interact closely with lead Perona
developers […]

Read more

MySQL 5.5.4 in tpcc-like workload

MySQL-5.5.4 ® is the great release with performance improvements, let’s see how it performs in
tpcc-like workload.
The full details are on Wiki page
https://www.percona.com/docs/wiki/benchmark:mysql:554-tpcc:start

I took MySQL-5.5.4 with InnoDB-1.1, tpcc-mysql benchmark with 200W ( about 18GB worth of data),
InnoDB log files are 3.8GB size, and run with different buffer pools from 20GB to 6GB. The storage […]

Read more