Buy Percona ServicesBuy Now!

ANALYZE TABLE Is No Longer a Blocking Operation

 | March 27, 2018 |  Posted In: InnoDB, Insight for DBAs, MyRocks, MySQL, TokuDB

analyze table

In this post, I’ll discuss the fix for lp:1704195 (migrated to PS-2503), which prevents ANALYZE TABLE from blocking all subsequent queries on the same table. In November 2017, Percona released a fix for lp:1704195 (migrated to PS-2503), created by Laurynas Biveinis. The fix, included with Percona Server for MySQL since versions 5.6.38-83.0 and 5.7.20-18, stops ANALYZE TABLE from invalidating query and […]

Read More

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

The Anatomy of a MongoDB Replica Set

 | March 22, 2018 |  Posted In: Insight for DBAs, Insight for Developers, MongoDB

MongoDB Replica Set

In this blog post, we’re going to break down what constitutes a MongoDB replica set. While replica sets are not a specific environment or solution, understanding what you can do with their sophisticated features helps fit a multitude of situations. With many classical databases, you would need to use services, third party software and scripts to […]

Read More

FLUSH and LOCK Handling in Percona XtraDB Cluster

 | March 21, 2018 |  Posted In: Insight for DBAs, MySQL, Percona XtraDB Cluster

FLUSH and LOCK Handling

In this blog post, we’ll look at how Percona XtraDB Cluster (PXC) executes FLUSH and LOCK handling. Introduction Percona XtraDB Cluster is a multi-master solution that allows parallel execution of the transactions on multiple nodes at the same point in time. Given this semantics, it is important to understand how Percona XtraDB Cluster executes statements regarding FLUSH […]

Read More

How to Speed Up Pattern Matching Queries

 | March 19, 2018 |  Posted In: Insight for DBAs, MySQL

pattern matching queries

From time to time I see pattern matching queries with conditions that look like this: “where fieldname like ‘%something%’ “. MySQL cannot use indexes for these kinds of queries, which means it has to do a table scan every single time. (That’s really only half true — there are the FullText indexes. In another blog […]

Read More

Don’t Get Hit with a Database Disaster: Database Security Compliance

 | March 13, 2018 |  Posted In: Insight for DBAs, Percona Live, Security

Percona Live 2018 security talks

In this post, we discuss database security compliance, what you should be looking at and where to get more information. As Percona’s Chief Customer Officer, I get the opportunity to talk with a lot of customers. Hearing about the problems that both their technical teams face, as well as the business challenges their companies experience […]

Read More

The Multi-Source GTID Replication Maze

 | March 13, 2018 |  Posted In: GTID, Insight for DBAs, MySQL, Replication

Multi-Source GTID Replication

In this blog post, we’ll look at how to navigate some of the complexities of multi-source GTID replication. GTID replication is often a real challenge for DBAs, especially if this has to do with multi-source GTID replication. A while back, I came across a really interesting customer environment with shards where multi-master, multi-source, multi-threaded MySQL 5.6 […]

Read More