-
One factor that contributes to query execution time is the number of rows involved. Now, does all of the data on our hottest tables really needs to be there? Is there an escalable and secure way to move stale/invalid rows out of the way? That’s what today’s post is all about.
-
One factor that contributes to query execution time is the number of rows involved. Now, does all of the data on our hottest tables really needs to be there? Is there an escalable and secure way to move stale/invalid rows out of the way? That’s what today’s post is all about.
-
In this post we are going to focus on views/CTEs/subqueries in the FROM. We will discuss how the database server deals with them and how they can be optimized
-
Second part of a blog about optimizing queries involving low cardinality columns
-
Part I of a blog series exploring what else can be done aside from creating an index when optimizing MySQL queries
-
You can now use Python to send the slow queries captured by MySQL to our tuningwizard service MySQL / MariaDB / Percona Server for MySQL has this cool feature called slow query log, which captures any SQL running for more than X seconds. That threshold is determined by the long_query_time parameter. If you have the…