Germany
Peter Zaitsev (CEO at Percona) will be presenting his talk “Advanced MySQL Optimization and Troubleshooting Using PMM 2” on November 9th-10th at the Hotel HolidayInn Nuremberg City Centre, Germany.
Optimizing MySQL performance and troubleshooting MySQL problems are two of the most critical and challenging tasks for MySQL DBA’s. The databases powering your applications need to be able to handle changing traffic workloads while remaining responsive and stable so that you can deliver an excellent user experience. Further, DBA’s are also expected to find cost-efficient means of solving these issues. In this presentation, Peter will demonstrate the advanced options of PMM version 2 that enables you to solve these challenges, which is built on free and open-source software. He will look at specific, common MySQL problems and review them.
Also, Denys Kondratenko will present a talk pg_stat_monitor: A cool extension for better database (PostgreSQL) monitoring on November 10th at 9.30 AM
The pg_stat_monitor is the statistics collection tool based on PostgreSQL’s contrib module pg_stat_statements. PostgreSQL’s pg_stat_statements provides only basic statistics, which is sometimes not enough. The major shortcoming in pg_stat_statements is that it accumulates all the queries and statistics, but does not provide aggregated statistics or histogram information. In this case, a user needs to calculate the aggregate, which is quite expensive. Pg_stat_monitor provides the pre-calculated aggregates. pg_stat_monitor collects and aggregates data on a bucket basis. The size and number of buckets should be configured using GUC (Grand Unified Configuration). The buckets are used to collect the statistics and aggregate them in a bucket. The talk will cover the usage of pg_stat_monitor and how it is better than pg_stat_statements.
About the event.
The Open Source Monitoring Conference is the annual meeting of international monitoring experts, where future trends and objectives are set. The three-day event comprises 2 tracks of expert presentations and one day of hackathon scheduled directly following the lecture program on November 11th.
