EmergencyEMERGENCY? Get 24/7 Help Now!

A Mystery with open_files_limit

 | October 12, 2017 |  Posted In: Insight for DBAs, MySQL, Percona Server

open_files_limit

In this blog, we’ll look at a mystery around setting the open_file_limit variable in MySQL and Percona Server for MySQL. MySQL Server needs file descriptors to run. It uses them to open new connections, store tables in the cache, create temporary tables to resolve complicated queries and access persistent ones. If mysqld is not able […]

Read More

Percona Monitoring and Management 1.3.2 Is Now Available

 | October 11, 2017 |  Posted In: Events and Announcements, MongoDB, MySQL, open source databases, Percona Monitoring and Management

Percona announces the release of Percona Monitoring and Management 1.3.2. This release only contains bug fixes related to usability. For install and upgrade instructions, see Deploying Percona Monitoring and Management. Bug fixes PMM-1529: When the user selected “Today”, “This week”, “This month” or “This year” range in Metrics Monitor and clicked the Query Analytics button, the QAN […]

Read More

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