I've ran a simple test to see the performance impact of TLS on
MySQL connections with MySQL Connector/Python
The test results are in this Jupyter notebook.
TL;DR:
Not tested:
Testing functionalities and options for a database can be challenging at times, as a live production environment might be required. As I was looking for different options, I was directed by Derek Downey to this post in the Percona blog.
The blog discussed an interesting and fun tool from Percona, tpcc-mysql. I was interested in testing the tool so I decided to play around with it in an AWS EC2 server.
In this post I will expand on the Percona blog post, since the tool lacks documentation, as well as explain how I used it to create a MySQL Benchmark in AWS.
Why tpcc-mysql?
There are various reasons why tpcc-mysql could be a good …
[Read more]Too often developers and DBAs struggle to pinpoint the root cause of MySQL database performance issues, and then spend too much time in trying to fix them. Wouldn’t it be great to bypass wasted guesswork and get right to the issue?
In our upcoming webinar Tired of MySQL Making You Wait? we’re going to help you discover how to significantly increase the performance of your applications and reduce database response time.
In this webinar, Principal Architect Alexander Rubin and Database Evangelist Janis Griffin will provide the key steps needed to identify, prioritize, and improve query performance.
They will discuss the following topics:
What better to do during the holiday season than to read the Log Buffer? This log buffer edition is here to add some sparkle to Oracle, MySQL and SQL Server on your days off.
Oracle:
Another post in the EXPLAIN FORMAT=JSON is Cool! series! In this post, we’ll discuss how the EXPLAIN FORMAT=JSON provides optimization details for
ORDER BY
and
GROUP BY
operations in conjunction with
order_by_subqueries
and
group_by_subqueries
.
EXPLAIN FORMAT=JSON
can print details on how a subquery in
ORDER BY
is optimized:
mysql> explain format=json select emp_no, concat(first_name, ' ', last_name) f2 from employees order by (select emp_no limit 1)G
*************************** 1. row ***************************
EXPLAIN: { …[Read more]
One of the most common engagements I do is working with firms in and around the NYC startup sector. I evaluate AWS infrastructures & applications built in the Amazon cloud. Join 32,000 others and follow Sean Hull on twitter @hullsean. I’ve seen some patterns in customers usage of Amazon. Below is a laundry list of … Continue reading 5 core pieces of the Amazon Cloud puzzle to get your project off the ground → …
[Read more]
InnoDB and the Thread
Sanitizer do not work well together in MySQL 5.7. There are hundreds of possible
data races reported by the Thread Sanitizer in the InnoDB code
for the simplest case of initializing the MySQL server and
shutting it down. Luckily, most of these data races are
benign. The problem of finding an interesting data race in
the InnoDB software is similar to finding evidence of a
sub-atomic particle in a particle accelerator; many Thread
Sanitizer events must be analyzed before something interesting is
found.
One example of a benign data race is InnoDB's implementation of
fuzzy counters. A …
MySQL 5.7 comes with enhancements which makes a deployment secure by default. These features try to minimize attack surface as much as possible without hampering usability aspect. They are useful for novice user because they help close common security loopholes which can be leveraged by an attacker.…
Ahoi, I made three proposals for Percona Live. (Even I know being
a lonely (sniff) freelancer with no backup). At least I'm
for sure an early adopter about the three topics I submitted and
know for sure what I'm talking about *g*
Even being Puppet certified. Ansible is my love. Never been that
fast in doing automation \o/
This is a tutorial about Docker and Galera/MySQL.
The previous post in the EXPLAIN FORMAT=JSON is Cool! series showed an example of the query
select dept_name from departments where dept_no in (select dept_no from dept_manager where to_date is not null)
, where the subquery was materialized into a temporary table and then joined with the outer query. This is known as a semi-join optimization. But what happens if we turn off this optimization?
EXPLAIN FORMAT=JSON
can help us with this investigation too. …
[Read more]