EmergencyEMERGENCY? Get 24/7 Help Now!

Webinar Wednesday, October 11, 2017: Percona Monitoring and Management (PMM) Demonstration

 | October 10, 2017 |  Posted In: MongoDB, MyRocks, MySQL, Percona Monitoring and Management, Technical Webinars

Percona Monitoring and Management

Join Percona’s Product Manager Michael Coburn as he presents a Percona Monitoring and Management (PMM) Demonstration on Wednesday, October 11, 2017, at 10:00 am PDT / 1:00 pm EDT (UTC-7). Register Now How can you optimize database performance if you can’t see what’s happening? Percona Monitoring and Management (PMM) is a free, open source database troubleshooting […]

Read More

MySQL, Percona Server for MySQL and MariaDB Default Configuration Differences

 | October 9, 2017 |  Posted In: InnoDB, Insight for DBAs, MariaDB, MySQL

MySQL and MariaDB Default Configuration

In this blog post, I’ll discuss some of the MySQL and MariaDB default configuration differences, focusing on MySQL 5.7 and MariaDB 10.2. Percona Server for MySQL uses the same defaults as MySQL, so I will not list them separately. MariaDB Server is a general purpose open source database, created by the founders of MySQL. MariaDB […]

Read More

This Week in Data with Colin Charles 9: Oracle OpenWorld and Percona Live Europe Post Mortem

 | October 6, 2017 |  Posted In: Events and Announcements, MariaDB, MongoDB, MySQL, open source databases, Percona Live

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. This week: a quick roundup of releases, a summary of my thoughts about Percona Live Europe 2017 Dublin, links to look at and upcoming appearances. Oracle OpenWorld happened in San Francisco this past week, and […]

Read More

Graph Descriptions for Metrics Monitor in Percona Monitoring and Management 1.3.0

 | October 5, 2017 |  Posted In: Database Monitoring, MariaDB, MongoDB, MySQL, Percona Monitoring and Management

PMM 1.3.0

The Metrics Monitor of Percona Monitoring and Management 1.3.0 (PMM) provides graph descriptions to display more information about the monitored data without cluttering the interface. Percona Monitoring and Management 1.3.0 is a free and open-source platform for managing and monitoring MySQL®, MariaDB® and MongoDB® performance. You can run PMM in your own environment for maximum security and […]

Read More

Percona Live Europe Social

 | October 4, 2017 |  Posted In: MongoDB, MySQL, MySQL 8.0, Percona Live

Percona Live Europe Social

One for the road… The social events at Percona Live Europe provide the community with more time to catch up with old friends and make new contacts. The formal sessions provided lots of opportunities for exchanging notes, experiences and ideas. Lunches and coffee breaks proved to be busy too. Even so, what’s better than chilling […]

Read More

ClickHouse MySQL Silicon Valley Meetup Wednesday, October 25 at Uber Engineering with Percona’s CTO Vadim Tkachenko

 | October 4, 2017 |  Posted In: MySQL, Yandex ClickHouse

ClickHouse MySQL

I will be presenting at the ClickHouse MySQL Silicon Valley Meetup on Wednesday, October 25, 2017, at 6:30 PM. ClickHouse is a real-time analytical database system. Even though they’re only celebrating one year as open source software, it has already proved itself ready for the serious workloads. We will talk about ClickHouse in general, some internals […]

Read More

MyRocks Metrics Now in PMM 1.3.0

 | October 3, 2017 |  Posted In: MyRocks, MySQL, Percona Monitoring and Management

MyRocks

One of the most exciting features shipped in the Percona Monitoring and Management 1.3.0 (PMM) release is support for MyRocks metrics via a new Metrics Monitor dashboard titled MySQL MyRocks Metrics. The support in PMM follows the recent Percona Server for MySQL release 5.7.19 from September 6, where Percona delivered an EXPERIMENTAL version of MyRocks for non-Production usage. […]

Read More

Webinar October 4, 2017: Databases in the Hosted Cloud

 | October 3, 2017 |  Posted In: Aurora RDS, Cloud and MySQL, Cloud and NoSQL, MySQL

Databases in the Hosted Cloud 1

Join Percona’s Chief Evangelist, Colin Charles as he presents Databases in the Hosted Cloud on Wednesday, October 4, 2017, at 7:00 am PDT / 10:00 am EDT (UTC-7). Register Now Today you can use hosted MySQL/MariaDB/Percona Server for MySQL/PostgreSQL in several “cloud providers” as a database as a service (DBaaS). Learn the differences, the access […]

Read More

Big Dataset: All Reddit Comments – Analyzing with ClickHouse

 | October 2, 2017 |  Posted In: Database Monitoring, MongoDB, MySQL, MySQL 8.0, PostgreSQL, Yandex ClickHouse

ClickHouse

In this blog, I’ll use ClickHouse and Tabix to look at a new very large dataset for research. It is hard to come across interesting datasets, especially a big one (and by big I mean one billion rows or more). Before, I’ve used on-time airline performance available from BUREAU OF TRANSPORTATION STATISTICS. Another recent example is NYC […]

Read More

One Million Tables in MySQL 8.0

 | October 1, 2017 |  Posted In: InnoDB, Insight for DBAs, MySQL, MySQL 8.0

MySQL 8.0

In my previous blog post, I talked about new general tablespaces in MySQL 8.0. Recently MySQL 8.0.3-rc was released, which includes a new data dictionary. My goal is to create one million tables in MySQL and test the performance. Background questions Q: Why million tables in MySQL? Is it even realistic? How does this happen? Usually, millions […]

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.