Buy Percona ServicesBuy Now!

New MySQL 8.0 innodb_dedicated_server Variable Optimizes InnoDB from the Get-Go

 | March 26, 2018 |  Posted In: InnoDB, Insight for DBAs, MySQL, MySQL 101, MySQL 8.0, Percona Monitoring and Management

MySQL 8.0 innodb_dedicated_server

In this post, we’ll look at the MySQL 8.0 innodb_dedicated_server variable. MySQL 8.0 introduces a new variable called innodb_dedicated_server. When enabled, it auto tunes innodb_buffer_pool_size, innodb_log_file_size and innodb_flush_method at startup (if these variables are not explicitly defined in my.cnf). The new MySQL 8.0 variable automatically sizes the following variables based on the RAM size of […]

Read More

Compare Current and Past Time Series Graphs in Percona Monitoring and Management (PMM)

 | January 12, 2018 |  Posted In: Database Monitoring, MySQL, Percona Monitoring and Management

Percona Monitoring and Management

In this short blog post, I will show you how you can compare current and past time series in Percona Monitoring and Management (PMM). Recently, a support customer shared a graph with us that compared query throughput between today and yesterday as a confirmation that optimizing their server variables improved performance. Do you want to […]

Read More

How to Setup and Troubleshoot Percona PAM with LDAP for External Authentication

 | April 21, 2017 |  Posted In: Insight for DBAs, MySQL, Security

Percona Server for MySQL 5.7.18-15

In this blog, we’ll look at how to setup and troubleshoot the Percona PAM authentication plugin. We occasionally get requests from our support clients on how to get Percona Server for MySQL to authenticate with an external authentication service via LDAP or Active Directory. However, we normally do not have access to client’s infrastructure to […]

Read More

Quickly Troubleshoot Metadata Locks in MySQL 5.7

 | December 28, 2016 |  Posted In: MySQL, Performance Schema

Metadata Locks

In a previous article, Ovais demonstrated how a DDL can render a table blocked from new queries. In another article, Valerii introduced performance_schema.metadata_locks, which is available in MySQL 5.7 and exposes metadata lock details. Given this information, here’s a quick way to troubleshoot metadata locks by creating a stored procedure that can: Find out which […]

Read More

Generating test data for MySQL tables

 | February 10, 2014 |  Posted In: MySQL

One of the common tasks requested by our support customers is to optimize slow queries. We normally ask for the table structure(s), the problematic query and sample data to be able to reproduce the problem and resolve it by modifying the query, table structure, or global/session variables. Sometimes, we are given access to the server […]

Read More

Getting Percona PAM to work with Percona Server & its client apps

 | August 14, 2013 |  Posted In: MySQL

Percona Server is bundled with the PAM plugin which opens a plethora of ways to authenticate to MySQL such as restricting time when users can connect to MySQL, authenticate via a USB key, authenticate to an external authentication system such as LDAP and many, many more PAM compatible mechanisms. If you want to use PAM […]

Read More

Upcoming Webinars

All Webinars »