Author - Peter Zaitsev

18 Things You Can Do to Remove MySQL Bottlenecks Caused by High Traffic (Part Two)

MySQL High Traffic

This is a three-part blog series that focuses on dealing with an unexpected high traffic event as it is happening. Part one can be found here and part three can be found here.
7. Get More Memory
Complexity: Low
Potential Impact: High
If your data does not fit into memory well, your MySQL performance is likely to be […]

Read more

18 Things You Can Do to Remove MySQL Bottlenecks Caused by High Traffic (Part One)

remove MySQL traffic bottlenecks

This is a three-part blog series. Part two is located here, and part three can be found here.
There was no reason to plan for it, but the load on your system increased 100%, 300%, 500%, and your MySQL database has to support it. This is a reality many online systems have to deal with […]

Read more

Advanced Query Analysis in Percona Monitoring and Management with Direct ClickHouse Access

query analysis clickhouse PMM

In my Webinar on Using Percona Monitoring and Management (PMM) for MySQL Troubleshooting, I showed how to use direct queries to ClickHouse for advanced query analysis tasks. In the followup Webinar Q&A, I promised to describe it in more detail and share some queries, so here it goes.
PMM uses ClickHouse to store query performance […]

Read more

MySQL Performance Optimization with Percona Monitoring and Management – Webinar Followup

optimize MySQL with Percona Monitoring and Management

Last week I did a webinar on MySQL Troubleshooting and Performance Optimization with Percona Monitoring And Management v2 (PMM2).
There was a tremendous amount of interest and many more questions than I could answer, so I’m answering them in this blog post instead.
Q: What are the red and white dots on the last column in […]

Read more

ClickHouse Versus MySQL Handling of Double Quotes

ClickHouse MySQL Double Quotes

If you’re a MySQL user trying ClickHouse, one thing which is likely to surprise – and annoy you – is the handling of Double Quotes. In MySQL, you can use both double quotes and single quotes to quote strings, and as an example, these two queries are equivalent:

Shell

mysql> select * from performance_schema.global_variables where variable_name=’max_connections’;
+—————–+—————-+
| […]

Read more