EmergencyEMERGENCY? Get 24/7 Help Now!

Using NVMe Command Line Tools to Check NVMe Flash Health

 | February 9, 2017 |  Posted In: Hardware and Storage, Insight for DBAs, MongoDB, MySQL

NVME

In this blog post, I’ll look at the types of NVMe flash health information you can get from using the NVMe command line tools. Checking SATA-based drive health is easy. Whether it’s an SSD or older spinning drive, you can use the smartctl command to get a wealth of information about the device’s performance and health. […]

Read More

How to Replace MySQL with Percona Server on a CPanel, WHM VPS or Dedicated Server

 | January 11, 2017 |  Posted In: Hardware and Storage, MySQL, Percona Server, Percona Software, Percona Toolkit, Percona XtraBackup

Replace MySQL with Percona Server

In this blog post, we’ll look at how to replace MySQL with Percona Server for MySQL on a CPanel, WHM VPS or dedicated server. In general, CPanel and WHM have been leaning towards support of MariaDB over other flavors. This is partly due to the upstream repos replacing the MySQL package with MariaDB (for example, […]

Read More

Three Things to Consider When Thinking About Containers

 | October 19, 2016 |  Posted In: Docker, Hardware and Storage, MySQL, Solutions Engineering

containers

Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . . How did this happen? From what I understand, containers grew out of Google’s (and others’) […]

Read More

Using Ceph with MySQL

 | July 13, 2016 |  Posted In: Hardware and Storage, High-availability, MySQL, OpenStack

Ceph

Over the last year, the Ceph world drew me in. Partly because of my taste for distributed systems, but also because I think Ceph represents a great opportunity for MySQL specifically and databases in general. The shift from local storage to distributed storage is similar to the shift from bare disks host configuration to LVM-managed […]

Read More

Smallest MySQL Server in the World (under $60) which can even make you toast while fixing MySQL bug #2

 | November 25, 2015 |  Posted In: Hardware and Storage, MySQL, Percona Server

Introduction In my last blog post, Internet of Things, Messaging and MySQL, I have showed how to start your own Internet of Things with Particle Photon board. That implementation is great, but requires constant internet (wi-fi) access as the Particle Photon board does not have any local storage. If you do not have a reliable […]

Read More

The Q&A: Creating best-in-class backup solutions for your MySQL environment

 | July 23, 2015 |  Posted In: Hardware and Storage, Insight for DBAs, MySQL, Technical Webinars

Thank you for attending my July 15 webinar, “Creating Best in Class Backup solutions for your MySQL environment.” Due to the amount of content we discussed and some minor technical difficulties faced near the end of webinar we have decided to cover the final two slides of the presentation along with the questions asked by […]

Read More

Update on the InnoDB double-write buffer and EXT4 transactions

 | June 17, 2015 |  Posted In: Benchmarks, Hardware and Storage, InnoDB, MySQL

IMPORTANT: DON’T TRY THIS IN PRODUCTION. As demonstrated by Marko (see comments), it may corrupt your data. In a post, written a few months ago, I found that using EXT4 transactions with the “data=journal” mount option, improves the write performance significantly, by 55%, without putting data at risk. Many people commented on the post mentioning […]

Read More

How to improve InnoDB performance by 55% for write-bound loads

 | May 23, 2014 |  Posted In: Benchmarks, Hardware and Storage, Insight for DBAs, MySQL, Percona Live

Update: do not do this, this has been proven to corrupt data!   During April’s Percona Live MySQL Conference and Expo 2014, I attended a talk on MySQL 5.7 performance an scalability given by Dimitri Kravtchuk, the Oracle MySQL benchmark specialist. He mentioned at some point that the InnoDB double write buffer was a real […]

Read More

Percona Live London 2013: an insider’s view of the schedule

 | September 18, 2013 |  Posted In: Benchmarks, Events and Announcements, Hardware and Storage, Insight for DBAs, Insight for Developers, MySQL, Percona Live, Percona XtraBackup

With the close of call for papers earlier this month, the Percona Live London conference committee was in full swing this past week reviewing all of the many submissions for November’s Percona Live London MySQL Conference. The submissions are far ranging and cover some really interesting topics, making the lineup for Percona Live London really strong! […]

Read More

Percona’s widely read Percona Database Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.