Tag - Q&A

MySQL 8.0 GA: Quality or Not?

MySQL 8.0 GA

What does Anton Ego – a fictional restaurant critic from the Pixar movie Ratatouille – have to do with MySQL 8.0 GA?
When it comes to being a software critic, a lot.
In many ways, the work of a software critic is easy. We risk very little and thrive on negative criticism, which is fun to […]

Read more

Webinar Q&A: Percona XtraDB Cluster 101

InnoDB Performance Optimization

In this blog, we will answer questions from our webinar on Percona XtraDB Cluster 101.
Recently (7 Dec 2017) I presented a webinar about Percona XtraDB Cluster 101. Firstly, thanks to all the attendees: we had a great webinar with quite some interesting questions and feedback.
Through this blog, I’ll answer most of the questions that […]

Read more

Thoughts on MySQL 8.0.3 RC – The First MySQL 8.0 Release Candidate

MySQL 8.0.3 Release Candidate

Percona’s Technical Director of Quality Assurance Roel Van de Paar shares his findings on the quality of MySQL 8.0.3 RC.
On 21 September 2017, our upstream friends at Oracle released MySQL 8.0.3 RC as the first MySQL 8.0 Release Candidate.
I tested the MySQL 8.0.3 Release Candidate branch with selected Percona bugfixes applied and built it […]

Read more

Learning MySQL 5.7: Q & A

MySQL 5.7

In this post I’ll answer questions I received in my Wednesday, July 19, 2017, webinar Learning MySQL 5.7!
First, thank you all who attended the webinar. The link to the slides and the webinar recording can be found here.
I received a number of interesting questions in the webinar that I’ve followed up with below.
Would there […]

Read more

Q & A: MySQL In the Cloud – Migration, Best Practices, High Availability, Scaling

MySQL in the Cloud

In this blog, we will provide answers to the Q & A for the MySQL In the Cloud: Migration, Best Practices, High Availability, Scaling webinar.
First, we want to thank everybody for attending the June 7, 2017 webinar. The recording and slides for the webinar are available here. Below is the list of your questions that we […]

Read more

MySQL QA Episode 11: Valgrind Testing: Pro’s, Con’s, Why and How

MySQL QA Episode 11

Today’s episode is all about Valgrind – from the pro’s to the con’s, from the why to the how! This episode will be of interest to anyone who is or wants to work with Valgrind on a regular or semi-regular basis.

Pro’s/Why
Con’s
How

Using the latest version
sudo [yum/apt-get] install valgrind
#OR#
sudo [yum/apt-get] remove valgrind
sudo [yum/apt-get] install bzip2 glibc*
wget http://valgrind.org/downloads/valgrind-3.10.1.tar.bz2
tar […]

Read more

MySQL QA Episode 10: Reproducing and Simplifying: How to get it Right

MySQL QA Episode 10

Welcome to the 10th episode in the MySQL QA series! Today we’ll talk about reproducing and simplifying: How to get it Right.
Note that unless you are a QA engineer stuck on a remote, and additionally difficult-to-reproduce or difficult-to-reduce bug, this episode will largely be non-interesting for you.
However, what you may like to see – […]

Read more

MySQL QA Episode 9: Reducing Testcases for Experts: multi-threaded reducer.sh

Welcome to MySQL QA Episode 9. This episode will go more in-depth into reducer.sh: Reducing Testcases for Experts: multi-threaded reducer.sh
We will explore how to use reducer.sh to do true multi-threaded testcase reduction – a world’s first.
Topics:

Expert configurable variables & their default reducer.sh settings

PQUERY_MULTI
PQUERY_MULTI_THREADS
PQUERY_MULTI_CLIENT_THREADS
PQUERY_MULTI_QUERIES
PQUERY_REVERSE_NOSHUFFLE_OPT

Full-screen viewing @ 720p resolution recommended.

Read more

MySQL QA Episode 8: Reducing Testcases for Engineers: tuning reducer.sh

Welcome to MySQL QA Episode 8: Reducing Testcases for Engineers: tuning reducer.sh

Advanced configurable variables & their default/vanilla reducer.sh settings

FORCE_SKIPV
FORCE_SPORADIC
TIMEOUT_COMMAND & TIMEOUT_CHECK
MULTI_THREADS
MULTI_THREADS_INCREASE
QUERYTIMEOUT
STAGE1_LINES
SKIPSTAGE
FORCE_KILL

Some examples

FORCE_SKIPV/FORCE_SPORADIC
TIMEOUT_COMMAND/TIMEOUT_CHECK

Full-screen viewing @ 720p resolution recommended.

Read more

MySQL QA Episode 6: Analyzing and Filtering

Welcome to MySQL QA Episode #6!
Today we will look into analyzing and filtering our QA run. We’ll use tools like pquery-prep-red.sh, pquery-clean-known.sh & pquery-results.sh
1. Quick re-cap and QA run setup
2. pquery-prep-red.sh
3. pquery-clean-known.sh
4. pquery-results.sh
5. Bonus: pquery reach – pquery-reach++.sh
We’ll also introduce the text_string.sh tool which extracts a most-specific text string from the error log in order […]

Read more