Tibor Korocz, Author at Percona Database Performance Blog

02 Jan 2019

TasksMax: Another Setting That Can Cause MySQL Error Messages

Recently, I encountered a situation where MySQL gave error messages that I had never seen before:

MySQL

2018-12-12T14:36:45.571440Z 0 [ERROR] Error log throttle: 150 ‘Can’t create thread to handle new connection’ error(s) suppressed
2018-12-12T14:36:45.571456Z 0 [ERROR] Can’t create thread to handle new connection(errno= 11)
2018-12-12T14:37:47.748575Z 0 [ERROR] Error log throttle: 940 ‘Can’t create thread to handle new connection’ […]

02 Nov 2018

Maintenance Windows in the Cloud

By Tibor Korocz Amazon Aurora, Amazon RDS, Cloud and MySQL, CloudSQL, MySQL cloud, maintenance, MySQL 1 Comment

Recently, 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, and […]

17 Oct 2018

Can MySQL Parallel Replication Help My Slave?

By Tibor Korocz MySQL, Performance Schema, Replication MySQL, Replication 4 Comments

InnoDB Row Operations per Hour graph from Percona Monitoring and Management performance monitoring tool

Parallel replication has been around for a few years now but is still not that commonly used. I had a customer where the master had a very large write workload. The slave could not keep up so I recommended to use parallel slave threads. But how can I measure if it really helps and […]

06 Aug 2018

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

By Tibor Korocz MySQL, Percona Monitoring and Management, Percona XtraDB Cluster, PMM, ProxySQL, Technical Webinars HA MySQL, install, MySQL High Availability, MySQL Scalability, Scalability, scaling 0 Comments

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

19 Jun 2018

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

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 you! In this […]

09 May 2018

Does the Version Number Matter?

By Tibor Korocz Insight for DBAs, MySQL, Percona XtraDB Cluster, ProxySQL connectors, Java, jboss, MySQL, ProxySQL 0 Comments

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

17 Apr 2018

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

By Tibor Korocz High-availability, MySQL, Percona XtraDB Cluster, ProxySQL, Technical Webinars, XtraDB Cluster 0 Comments

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

04 Apr 2018

Pattern Matching Queries vs. Full-Text Indexes

By Tibor Korocz Insight for DBAs, Insight for Developers, MySQL 4 Comments

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

02 Apr 2018

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

By Tibor Korocz Database Monitoring, Insight for DBAs, Insight for Developers, MySQL, Percona Monitoring and Management, PMM 1 Comment

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

19 Mar 2018

How to Speed Up Pattern Matching Queries

By Tibor Korocz Insight for DBAs, MySQL MySQL 12 Comments

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

Author - Tibor Korocz

TasksMax: Another Setting That Can Cause MySQL Error Messages

Can MySQL Parallel Replication Help My Slave?

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

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

Does the Version Number Matter?

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

Pattern Matching Queries vs. Full-Text Indexes

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

How to Speed Up Pattern Matching Queries

Upcoming Webinars

Services

Products

Solutions

Resources

More

Contact Us