EmergencyEMERGENCY? Get 24/7 Help Now!

How to Restore a Single InnoDB Table from a Full Backup After Accidentally Dropping It

 | March 15, 2017 |  Posted In: InnoDB, Insight for DBAs, Percona XtraBackup, Quality Assurance

InnoDB

In this blog post, we’ll look at how to restore a single InnoDB table from a full backup after dropping the table. You can also see an earlier blog post about restoring a single table from a full backup here: How to recover a single InnoDB table from a full backup. The idea behind the actions […]

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

Millions of Queries per Second: PostgreSQL and MySQL’s Peaceful Battle at Today’s Demanding Workloads

and  | January 6, 2017 |  Posted In: Benchmarks, InnoDB, MySQL, open source databases, OpenSource Databases on big machines, Percona Live

PostgreSQL and MySQL

This blog compares how PostgreSQL and MySQL handle millions of queries per second. Anastasia: Can open source databases cope with millions of queries per second? Many open source advocates would answer “yes.” However, assertions aren’t enough for well-grounded proof. That’s why in this blog post, we share the benchmark testing results from Alexander Korotkov (CEO of […]

Read More

Percona Live 2017 Sneak Peek Schedule Up Now! See the Available Sessions!

 | December 16, 2016 |  Posted In: Apache Spark, Big Data, Cloud and MySQL, Cloud and NoSQL, Database Monitoring, Docker, Events and Announcements, Group Replication, High-availability, InnoDB, MariaDB, MongoDB, MySQL, Orchestrator, Percona Live

Percona Live Featured Session

We are excited to announce that the sneak peek schedule for the Percona Live 2017 Open Source Database Conference is up! The Percona Live Open Source Database Conference 2017 is April 24th – 27th, at the Hyatt Regency Santa Clara & The Santa Clara Convention Center. The Percona Live Open Source Database Conference 2017 is […]

Read More

Thoughts About Column Compression, with Optional Predefined Dictionary

 | November 10, 2016 |  Posted In: InnoDB, Quality Assurance

column compression

This blog discusses column compression with an optional predefined dictionary. Compression, more compression with different algorithms, compress again, compress multiple times! 🙂 Compression is a hot topic in our lives. In general, testing new things is great if the processes are well-described and easy to follow. Let’s try to think like a QA engineer: the first […]

Read More

Changing the Tablespace Directory with pt-online-schema-change

and  | November 4, 2016 |  Posted In: InnoDB, MySQL, Percona Toolkit

MariaDB ColumnStore

In this blog, we’ll discuss changing the tablespace directory using pt-online-schema-change. One of the most annoying situations in the life of a DBA is realizing that the disk where the datadir resides is running out of space. If you’re lucky enough to run over an LVM volume or a RAID (depending on the level, though), it […]

Read More

Percona Monitoring and Management (PMM) Information Script

 | November 1, 2016 |  Posted In: InnoDB, MongoDB, MySQL, Percona Monitoring and Management, Percona XtraDB Cluster

Percona Monitoring and Management

This blog post discusses an information script for the Percona Monitoring and Management (PMM) tool. In recent news, we announced the fresh-of-the-press Percona Monitoring and Management (or PMM for short) platform. Given the interaction of the different components that together make up PMM, I developed a script that helps provide you information about the status of your PMM installation. You can use this script yourself, or one of our […]

Read More

Percona Poll: What Database Technologies Are You Using?

 | October 26, 2016 |  Posted In: Database Poll, InnoDB, MariaDB, MongoDB, MySQL

Database Technologies

Take Percona’s poll on what database technologies you use in your environment. Different databases get designed 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 have a set […]

Read More

A Guide to the Percona Monitoring and Management Demo

 | October 19, 2016 |  Posted In: Database Monitoring, InnoDB, MongoDB, MySQL, Percona Monitoring and Management

Percona Monitoring and Management Demo

As part of the release of Percona Monitoring and Management, we set up an extensive online Percona Monitoring and Management demo at pmmdemo.percona.com. The demo is pretty self-explanatory and easy to explore, but you will probably find it a lot more interesting with some explanation. This post provides some guidance. The PMM demo has a […]

Read More