Tag: mysql
-
Beyond creating indexes – Part 3B
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.
-
Beyond creating indexes – Part 3A
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.
-
Beyond creating indexes – Part 2
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
-
Beyond creating indexes – Part 1B
Second part of a blog about optimizing queries involving low cardinality columns
-
Beyond creating indexes – Part 1A
Part I of a blog series exploring what else can be done aside from creating an index when optimizing MySQL queries
-
Get all your slow queries reviewed automatically, for free
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…