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;

  1. reducer.sh introduction/concepts
  2. Basic configurable variables & their default reducer.sh settings
    1. INPUTFILE options
    2. MODE=x
    3. TEXT=”text”
    4. WORKDIR_LOCATION & WORKDIR_M3_DIRECTORY
    5. MYEXTRA
    6. MYBASE
    7. PQUERY_MOD & PQUERY_LOC
    8. MODE5_COUNTTEXT, MODE5_ADDITIONAL_TEXT & MODE5_ADDITIONAL_COUNTTEXT
    9. How to learn more about each of the settings
  3. Manual example
  4. Introduction to the script’s self-recursion concept – subreducer
  5. Quick setup re-cap, details of an already executed QA run
  6. Examples from pquery-prep-red.sh (including some issue reviews)
  7. Gotcha’s
  8. QUERYTIMEOUT & STAGE1_LINES Variables

Full-screen viewing @ 720p resolution recommended.

If the speed is too slow for you, consider setting YouTube to 1.25 playback speed.

6 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
Shahriyar Rzayev

The problems you may encounter using reducerXXX.sh after running pquery-prep_red.sh:
1. dependency issue:
[[email protected] 362406]# ./reducer26.sh
./reducer26.sh: line 899: netstat: command not found

To solve run following:
yum install net-tools

2. ‘/dev/shm/’ free space issue:
[[email protected] 362406]# ./reducer26.sh
Error: /dev/shm/ does not have enough free space (3.5Gb free space required)

You can increase size as following:
For eg, give 8G:
mount -o remount,size=8G /dev/shm

Also you should update ‘/etc/fstab’ for reflectiong after server reboots, so add following to ‘/etc/fstab’ file:
none /dev/shm tmpfs defaults,size=8G 0 0

Shahriyar Rzayev

I love finding BUGs, it is my life art 🙂 especially with MySQL.
I am doing all tedious things manually everyday. But you have created a tool for simplifying life of hunter. it is pleasure to play and find some interesting things with these tools. Thank you for a great job!