In this blog post, we’ll look at some tips on
how to configure Aurora RDS parameters.

I was recently deploying a few Aurora RDS instances, a process
very similar to configuring a regular RDS instance. I noticed a
few minor differences in the way you configure Aurora RDS
parameters, and very few articles on how the commands should be
structured (for RDS as well as Aurora). The only real literature
available is the official Amazon RDS documentation.

This blog provides a concise “how-to” guide to quickly change
Aurora RDS parameters using the AWS CLI. Aurora retains the
parameter group model introduced with RDS, with new instances
having the default read only parameter groups. For a new
instance, you need to create and allocate a new parameter group
(this requires a DB reboot). After that, you can apply changes to …

Usually I make notes while working on customer issues, reading
the Slack channels or even scrolling across my Facebook news
feed. Some of them are of "ToDo" kind, and this week while
watching how my colleagues work on a very complicated crash/bug I
noted that one of the problems they were discussing was how to
find out from the core dump if the session behind the crashing
thread had mrr=ON in the optimizer_switch.

I had already written more than once how to check MySQL threads one by one in
gdb, depending on version and your real goal. For this
post I decided to concentrate on checking the values of session
variables and, specifically, individual switchable optimizations.
This is actually …

This is the final installment of a five part blog series to
explore InnoDB internals by looking at the related tunable system
variables. In this section we’re going to cover variables that
relate to enforcing data consistency, and how index statistics
are handled and stored.

Just like previous sections, I would like to emphasize something
that was written in part one of this blog post series.

“I should note that while tuning recommendations are
provided, this objective of this blog post series was NOT meant
to be a tuning primer, but instead to explore the mechanics that
each variable interacts with. As such I would like to advise
against reading this guide and trying to fine tune all of the
available InnoDB variables. System variable tuning is an exercise
in diminishing returns, the most benefit you’ll get out of tuning
your MySQL server will occur within the first 15 minutes of
configuration. In …

This is part four of a five part blog series to explore InnoDB
internals by looking at the related tunable system variables. In
this section we’re going to explore the mechanics that impact CPU
resourcing and how InnoDB handles concurrent threads. You’ll
notice that a lot of the variables covered in section relate to
features that are now disabled but were a lot more prevalent in
previous versions of MySQL, particularly those that were released
at a time where system context switching had a greater cost than
it does today. These variables are still worth discussing as you
may run into older systems that utilize these mechanics, and
there are even modern systems I’ve worked with that have
implemented these features to tune performance to its highest
potential.

Just like previous sections, I would like to emphasize something
that was written in part one of this blog post series.

A couple of months ago I decided to give myself a refresher on
the mechanics of InnoDB. Having a high level understanding of
what’s going on under the hood can help provide the context
needed in order to resolve issues you may encounter as well as
assist you in ensuring that your MySQL instance is running
efficiently. Everyone can stand to go back to basics every now
and then, as it can help you pick up concepts that you may have
missed the last time you researched the topic.

This time around I decided to give myself a refresher by
re-reading the MySQL 5.6 reference manual, chapter 14, which
covers the InnoDB engine. Despite having a wealth of documented
knowledge and insights, I found that a lot of the points in the
documentations were unclear, leading me to do more research and
experimentation in order to get a bit of clarity on some of the
specifics that I felt were missing. In order to help make the
information …

With MySQL 5.6 just gone GA, I thought it would be
good to take a look at the changes in options and variables that
comes with the new release.

First of all, several of the existing options have get new
default values. As James Day already have written a good post about that in his blog, I will
refer to that instead of going through the changes. For a general
overview of the new features and improvements, the recent blogs
by Rob Young and Peter Saitsev are good starting points
together with the …

In relation to these two posts from Justin Swanhart and Anders Karlsson about transaction isolation
levels, I thought it was interesting to do a little survey
to get an idea of the most commonly used isolation levels.

Note: There is a poll embedded within this post, please visit the
site to participate in this post's poll. Related Posts :

When I have discovered MySQL User-defined variables at the
first time, I didn’t pay much attention to them and didn’t
realize their strength. At first, one can think that they are
just one of the many unnoticed MySQL features. Well, I was wrong.
Here, I will try to summarize their strength, though I think
there is […]

Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.