Author: Tibor Korocz

TasksMax: Another Setting That Can Cause MySQL Error Messages

TasksMax setting causing errors MySQLRecently, I encountered a situation where MySQL gave error messages that I had never seen before: [crayon-5c58038ec51c2194069804/] I was thinking maybe we hit some [crayon-5c58038ec51c7496380494-i/] limitations or similar, but all the usual suspects were set high enough, and we were not even close to them. After googling and discussing with the customer, I found they had […]

Maintenance Windows in the Cloud

maintenance windows cloudRecently, I’ve been working with a customer to evaluate the different cloud solutions for MySQL. In this post I am going to focus on maintenance windows and requirements, and what the different cloud platforms offer. Why is this important at all? Maintenance windows are required so that the cloud provider can do the necessary updates, patches, […]

Webinar Tues 8/14: Utilizing ProxySQL for Connection Pooling in PHP

ProxySQL for connection pooling

Please join Percona’s Architect, Tibi Köröcz as he presents Utilizing ProxySQL for Connection Pooling in PHP on Tuesday August 14, 2018, at 8:00 am PDT (UTC-7) / 11:00 am EDT (UTC-4).   Register Now ProxySQL is a very powerful tool, with extended capabilities. This presentation will demonstrate how to use ProxySQL to gain functionality (seamless […]

The post Webinar Tues 8/14: Utilizing ProxySQL for Connection Pooling in PHP appeared first on Percona Database Performance Blog.

Webinar Weds 20/6: Percona XtraDB Cluster 5.7 Tutorial Part 2

webinar Percona XtraDB Cluster

Including setting up Percona XtraDB Cluster with ProxySQL and PMM Please join Percona’s Architect, Tibi Köröcz as he presents Percona XtraDB Cluster 5.7 Tutorial Part 2 on Wednesday, June 20th, 2018, at 7:00 am PDT (UTC-7) / 10:00 am EDT (UTC-4). Register Now   Never used Percona XtraDB Cluster before? This is the webinar for […]

The post Webinar Weds 20/6: Percona XtraDB Cluster 5.7 Tutorial Part 2 appeared first on Percona Database Performance Blog.

Does the Version Number Matter?

ProxySQL

Yes, it does! In this blog post, I am going to share my recent experiences with ProxySQL and how important the database software version number can be. Migration I was working on a migration to Percona XtraDB Cluster (PXC) with ProxySQL, fortunately on a staging environment first so we could catch any issues (like this one). We […]

The post Does the Version Number Matter? appeared first on Percona Database Performance Blog.

Webinar Wednesday, April 18, 2018: Percona XtraDB Cluster 5.7 Tutorial

Percona XtraDB Cluster Tutorial

Please join Percona’s Architect, Tibi Köröcz as he presents Percona XtraDB Cluster 5.7 Tutorial on Wednesday, April 18, 2018, at 7:00 am PDT (UTC-7) / 10:00 am EDT (UTC-4). Never used Percona XtraDB Cluster before? Come join this 45-minute tutorial where we will introduce you to the concepts of a fully functional Percona XtraDB Cluster. In this […]

The post Webinar Wednesday, April 18, 2018: Percona XtraDB Cluster 5.7 Tutorial appeared first on Percona Database Performance Blog.

Pattern Matching Queries vs. Full-Text Indexes

Pattern Matching Queries vs. Full-Text Indexes

In this blog post, we’ll compare the performance of pattern matching queries vs. full-text indexes. In my previous blog post, I looked for a solution on how we can search only a part of the email address and how can we make faster queries where the condition is email LIKE ‘%n.pierre%’. I showed two possible […]

The post Pattern Matching Queries vs. Full-Text Indexes appeared first on Percona Database Performance Blog.

Plot MySQL Data in Real Time Using Percona Monitoring and Management (PMM)

Plot MySQL Data in Real Time

In this blog post, we’ll show that you can plot MySQL data in real time using Percona Monitoring and Management (PMM). In my previous blog post, I showed how we could load into any metrics, benchmarks into MySQL and visualize it with PMM. But that’s not all! We can even visualize most any kind of […]

The post Plot MySQL Data in Real Time Using Percona Monitoring and Management (PMM) appeared first on Percona Database Performance Blog.

How to Speed Up Pattern Matching Queries

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 […]

The post How to Speed Up Pattern Matching Queries appeared first on Percona Database Performance Blog.

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569