EmergencyEMERGENCY? Get 24/7 Help Now!

Massive Parallel Log Processing with ClickHouse

 | September 13, 2017 |  Posted In: Database Monitoring, Insight for DBAs, MySQL, Yandex ClickHouse

ClickHouse

In this blog, I’ll look at how to use ClickHouse for parallel log processing. Percona is seen primarily for our expertise in MySQL and MongoDB (at this time), but neither is quite suitable to perform heavy analytical workloads. There is a need to analyze data sets, and a very popular task is crunching log files. Below […]

Read More

Upcoming Webinar September 14, 2017: Supercharge Your Analytics with ClickHouse

 | September 12, 2017 |  Posted In: Database Monitoring, Insight for DBAs, Insight for Developers, MySQL, Technical Webinars, Yandex ClickHouse

ClickHouse

Join Percona’s CTO Vadim Tkachenko @VadimTk and Altinity’s Co-Founder, Alexander Zaitsev as they present Supercharge Your Analytics with ClickHouse on Thursday, September 14, 2017, at 10:00 am PDT / 1:00 pm EDT (UTC-7). Reserve Your Spot   ClickHouse is a real-time analytical database system. Even though they’re only celebrating one year as open source software, it has […]

Read More

Updating InnoDB Table Statistics Manually

 | September 11, 2017 |  Posted In: Database Monitoring, InnoDB, Insight for DBAs, Insight for Developers, MySQL

InnoDB Tables

In this post, we will discuss how to fix cardinality for InnoDB tables manually. As a support engineer, I often see situations when the cardinality of a table is not correct. When InnoDB calculates the cardinality of an index, it does not scan the full table by default. Instead it looks at random pages, as determined […]

Read More

Upcoming Webinar Thursday, September 7: Using PMM to Troubleshoot MySQL Performance Issues

 | September 6, 2017 |  Posted In: Database Monitoring, Insight for DBAs, Insight for Developers, MySQL, Percona Monitoring and Management, Technical Webinars

Percona Monitoring and Management

Join Percona’s Product Manager, Michael Coburn as he presents Using Percona Monitoring and Management to Troubleshoot MySQL Performance Issues on Thursday, September 7, 2017, at 10:00 am PDT / 1:00 pm EDT (UTC-7). Reserve Your Spot   Successful applications often become limited by MySQL performance. Michael will show you how to get great MySQL performance […]

Read More

Percona Monitoring and Management 1.2.0 is Now Available

 | July 14, 2017 |  Posted In: Database Monitoring, Events and Announcements, Insight for DBAs, MariaDB, MongoDB, MySQL, Orchestrator, Percona Monitoring and Management, Percona Software, PMM, Prometheus, ProxySQL

Percona Monitoring and Management

Percona announces the release of Percona Monitoring and Management 1.2.0 on July 14, 2017. For installation instructions, see the Deployment Guide. Changes in PMM Server PMM Server 1.2.0 introduced the following changes: Updated Components Consul 0.8.5 Grafana 4.3.2 Orchestrator 2.1.5 Prometheus 1.7.1 New Features PMM-737: New graphs in System Overview dashboard: Memory Advanced Details Saturation Metrics PMM-1090: Added ESXi support […]

Read More

Percona Monitoring and Management 1.1.5 is Now Available

 | June 21, 2017 |  Posted In: Database Monitoring, Events and Announcements, Insight for DBAs, MariaDB, MongoDB, MySQL, Orchestrator, Percona Monitoring and Management, Percona Software, PMM, Prometheus, ProxySQL

Percona Monitoring and Management

Percona announces the release of Percona Monitoring and Management 1.1.5 on June 21, 2017. For installation instructions, see the Deployment Guide. Changes in PMM Server PMM-667: Fixed the Latency graph in the ProxySQL Overview dashboard to plot microsecond values instead of milliseconds. PMM-800: Fixed the InnoDB Page Splits graph in the MySQL InnoDB Metrics Advanced dashboard to […]

Read More

Q & A: MySQL In the Cloud – Migration, Best Practices, High Availability, Scaling

 | June 9, 2017 |  Posted In: Cloud and MySQL, Database Monitoring, High-availability, MySQL

MySQL in the Cloud

In this blog, we will provide answers to the Q & A for the MySQL In the Cloud: Migration, Best Practices, High Availability, Scaling webinar. First, we want to thank everybody for attending the June 7, 2017 webinar. The recording and slides for the webinar are available here. Below is the list of your questions that we […]

Read More

Percona Monitoring and Management 1.1.4 is Now Available

 | May 29, 2017 |  Posted In: Database Monitoring, Docker, Events and Announcements, Insight for Developers, MariaDB, MongoDB, MySQL, Orchestrator, Percona Monitoring and Management, Percona Server for MongoDB, Percona Server for MySQL, Percona Software, PMM, Prometheus, ProxySQL

Percona Monitoring and Management

Percona announces the release of Percona Monitoring and Management 1.1.4 on May 29, 2017. For installation instructions, see the Deployment Guide. This release includes experimental support for MongoDB in Query Analytics, including updated QAN interface.

Read More

Webinar May 23, 2017: MongoDB Monitoring and Performance for the Savvy DBA

 | May 22, 2017 |  Posted In: Database Monitoring, MongoDB, Percona Monitoring and Management, Percona Server for MongoDB, Technical Webinars

MongoDB Monitoring

Join Percona’s Senior Technical Services Engineer Bimal Kharel on Tuesday, May 23, 2017, as he presents a webinar on MongoDB monitoring called How to Help Your DBA’s Sleep Better at Night at 10:00 am PDT / 1:00 pm EDT (UTC-7). Register Now Are you trying to stay on top of your database before things turn ugly? Between […]

Read More

Percona Live Open Source Database Conference 2017 Slides and Videos Available

 | May 16, 2017 |  Posted In: Big Data, Cloud and MySQL, Cloud and NoSQL, Column Store Database, Database Monitoring, Docker, Group Replication, InnoDB, MariaDB, MongoDB, MyRocks, MySQL, MySQL 101, Percona Live

Percona Live

The slides and videos from the Percona Live Open Source Database Conference 2017 are available for viewing and download. The videos and slides cover the keynotes, breakout sessions and MySQL and MongoDB 101 sessions. To view slides, go to the Percona Live agenda, and select the talk you want slides for from the schedule, and […]

Read More