Post Profile

Hands-On Look at ZFS with MySQL

This post is a hands-on look at ZFS with MySQL. In my previous post, I highlighted the similarities between MySQL and ZFS. Before going any further, I’d like you to be able to play and experiment with ZFS. This post shows you how to configure ZFS with MySQL in a minimalistic way on either Ubuntu […]
read more


Related Posts

Upcoming Webinar Tuesday September 12: Differences between MariaDB and MySQL

Programming / Database Development : MySQL Performance Blog

Join Percona’s Chief Evangelist, Colin Charles (@bytebot) as he presents Differences Between MariaDB and MySQL on Tuesday, September 12, 2017, at 7:00 am PDT / 10:00 am EDT (UTC-7). Reserve Your Spot   Are they syntactically similar...

Clarification on MySQL security vulnerability

Programming / Database Development : MySQL Performance Blog

Contrary to initial reports here and here, further investigation has revealed that under some specific and limited circumstances, Percona Server and Percona XtraDB Cluster binaries, similar to other MySQL variants, are susceptible t...

ZFS on Linux and MySQL

Programming / Database Development : MySQL Performance Blog

I am currently working with a large customer and I am involved with servers located in two data centers, one with Solaris servers and the other one with Linux servers. The Solaris side is cleverly setup using zones and ZFS and this ...

Revisiting the hidden MySQL 8.0 data dictionary tables

Programming / Database Development : The Data Charmer

A few months ago I wrote about showing the hidden tables in MySQL 8 data dictionary. What I presented there was a naïve solution, which I am now able to improve with a few (bold) moves. In the solution given in my previous article, ...

Fixing MySQL scalability problems with ProxySQL or thread pool

Programming / Database Development : MySQL Performance Blog

In this blog post, we’ll discuss fixing MySQL scalability problems using either ProxySQL or thread pool. In the previous post I showed that even MySQL 5.7 in read-write workloads is not able to maintain throughput. Oracle’s recommen...


Copyright © 2016 Regator, LLC