EmergencyEMERGENCY? Get 24/7 Help Now!

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

 | August 4, 2015 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Quality Assurance

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 […]

Read More

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

 | July 31, 2015 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Quality Assurance

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

 | July 28, 2015 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Quality Assurance

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 […]

Read More

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

 | July 23, 2015 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Quality Assurance

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 7: Reducing Testcases for Beginners – single-threaded reducer.sh!

 | July 21, 2015 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Quality Assurance

Welcome to MySQL QA Episode #7 – Reducing Testcases for Beginners: single-threaded reducer.sh! In this episode we’ll learn how to use reducer.sh. Topics discussed; reducer.sh introduction/concepts Basic configurable variables & their default reducer.sh settings INPUTFILE options MODE=x TEXT=”text” WORKDIR_LOCATION & WORKDIR_M3_DIRECTORY MYEXTRA MYBASE PQUERY_MOD & PQUERY_LOC MODE5_COUNTTEXT, MODE5_ADDITIONAL_TEXT & MODE5_ADDITIONAL_COUNTTEXT How to learn more about each […]

Read More

MySQL QA Episode 6: Analyzing and Filtering

 | July 15, 2015 |  Posted In: Insight for DBAs, Insight for Developers, Percona Server, Percona Software, Quality Assurance

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 […]

Read More

MySQL QA Episode 5: Preparing Your QA Run with pquery

 | July 13, 2015 |  Posted In: Insight for DBAs, Insight for Developers, Percona Server, Percona Software, Quality Assurance

Welcome to MySQL QA Episode #5! In this episode we’ll be setting up and running pquery for the first time… and I’ll also trigger some actual bugs (fun guaranteed)! I’ll also introduce you to mtr_to_sql.sh and pquery-run.sh. pquery-run.sh (the main wrapper around pquery) is capable of generating 80-120 MySQL Server crashes – per hour! See how […]

Read More

MySQL QA Episode 4: QA Framework Setup Time!

 | July 8, 2015 |  Posted In: Insight for DBAs, Insight for Developers, Percona Server, Percona Software, Quality Assurance

Welcome to MySQL QA Episode 4! In this episode we’ll look into setting up our QA Framework: percona-qa, pquery, reducer & more. 1. All about percona-qa 2. pquery

3. reducer.sh

4. Short introduction to pquery framework tools The tools introduced in this episode will be covered further in next two episodes. Full-screen viewing @ […]

Read More

MySQL QA Episode 3: How to use the debugging tool GDB

 | July 7, 2015 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Quality Assurance

Welcome to MySQL QA Episode 3: “Debugging: GDB, Backtraces, Frames and Library Dependencies” In this episode you’ll learn how to use debugging tool GDB. The following debugging topics are covered: 1. GDB Introduction 2. Backtrace, Stack trace 3. Frames 4. Commands & Logging 5. Variables 6. Library dependencies 7. c++filt 8. Handy references – GDB Cheat […]

Read More

Tips for avoiding malware from a lesson learned

 | June 26, 2015 |  Posted In: Security

In a recent article on the Percona blog, I recommended readers to a tool called CamStudio for making technical screen recordings. The blog post was very popular and got 300+ Facebook likes in a short time. Providentially though, a reader commented that the installer (as downloaded from the project website) installed “pretty annoying adware on […]

Read More