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

PMM Alerting with Grafana: Working with Templated Dashboards

 | February 2, 2017 |  Posted In: MongoDB, MySQL, Percona Monitoring and Management

PMM Alerting

In this blog post, we will look into more intricate details of PMM alerting. More specifically, we’ll look at how to set up alerting based on templated dashboards. Percona Monitoring and Management (PMM) 1.0.7 includes Grafana 4.0, which comes with the Alerting feature. Barrett Chambers shared how to enable alerting in general. This blog post looks at […]

Read More

MySQL Sharding Models for SaaS Applications

 | January 30, 2017 |  Posted In: Insight for DBAs, MySQL

MySQL Sharding Models

In this blog post, I’ll discuss MySQL sharding models, and how they apply to SaaS application environments. MySQL is one of the most popular database technologies used to build many modern SaaS applications, ranging from simple productivity tools to business-critical applications for the financial and healthcare industries. Pretty much any large scale SaaS application powered […]

Read More

Percona Software News and Roadmap Update with CEO Peter Zaitsev: Q1 2017

 | January 27, 2017 |  Posted In: Docker, Events and Announcements, MongoDB, MySQL, Percona MySQL Consulting, Percona MySQL Support, Percona Software, Percona Support, Percona XtraBackup, Percona XtraDB Cluster, PMM, Technical Webinars, XtraDB Cluster

Percona Software News and Roadmap Update

This blog post is a summary of the webinar Percona Software News and Roadmap Update – Q1 2017 given by Peter Zaitsev on January 12, 2017. Over the last few months, I’ve had the opportunity to meet and talk with many of Percona’s customers. I love these meetings, and I always get a bunch of questions […]

Read More

The Impact of Swapping on MySQL Performance

 | January 13, 2017 |  Posted In: InnoDB, Insight for DBAs, MySQL, PMM

In this blog, I’ll look at the impact of swapping on MySQL performance.  It’s common sense that when you’re running MySQL (or really any other DBMS) you don’t want to see any I/O in your swap space. Scaling the cache size (using innodb_buffer_pool_size in MySQL’s case) is standard practice to make sure there is enough free […]

Read More

Using Percona XtraBackup on a MySQL Instance with a Large Number of Tables

 | December 28, 2016 |  Posted In: Insight for DBAs, MySQL, Percona XtraBackup

Percona XtraBackup 2.4.7-2

In this blog post, we’ll find out how to use Percona XtraBackup on a MySQL instance with a large number of tables. As of Percona Xtrabackup 2.4.5, you are required to have enough open files to open every single InnoDB tablespace in the instance you’re trying to back up. So if you’re running innodb_file_per_table=1, and […]

Read More

Percona Poll Results: What Database Technologies Are You Using?

 | December 21, 2016 |  Posted In: Database Poll, MongoDB, MySQL

This blog shows the results from Percona’s poll on what database technologies our readers use in their environment. We design different databases for different scenarios. Using one database technology for every situation doesn’t make sense, and can lead to non-optimal solutions for common issues. Big data and IoT applications, high availability, secure backups, security, cloud vs. on-premises deployment: each […]

Read More

Make MySQL 8.0 Better Through Better Benchmarking

 | December 2, 2016 |  Posted In: Benchmarks, MySQL

MySQL 8.0.1

This blog post discusses how better MySQL 8.0 benchmarks can improve MySQL in general. Like many in MySQL community, I’m very excited about what MySQL 8.0 offers. There are a lot of great features and architecture improvements. Also like many in the MySQL community, I would like to see MySQL 8.0 perform better. Better performance […]

Read More

Using the InnoDB Buffer Pool Pre-Load Feature in MySQL 5.7

 | November 30, 2016 |  Posted In: MySQL

InnoBD Buffer Pool Pre-Load Feature

In this blog post, I’ll discuss how to use the InnoDB buffer pool pre-load feature in MySQL 5.7 Starting MySQL 5.6, you can configure MySQL to save the contents of your InnoDB buffer pool and load it on startup. Starting in MySQL 5.7, this is the default behavior. Without any special effort, MySQL saves and […]

Read More