Comments on: MySQL QA Episode 6: Analyzing and Filtering https://www.percona.com/blog/mysql-qa-episode-6-analyzing-and-filtering/ Fri, 12 May 2023 17:07:42 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: Roel Van de Paar https://www.percona.com/blog/mysql-qa-episode-6-analyzing-and-filtering/#comment-10965618 Thu, 26 Nov 2015 05:57:55 +0000 https://www.percona.com/blog/?p=30481#comment-10965618 All, please note we have moved percona-qa to GitHub:
https://github.com/Percona-QA/percona-qa

To clone it, use:
$ sudo yum install git
$ cd ~
$ git clone https://github.com/Percona-QA/percona-qa.git

reducer.sh was also put directly into this repository (and it is maintained there), so *no* need anymore to separately fetch lp:randgen.

]]> By: Shahriyar Rzayev https://www.percona.com/blog/mysql-qa-episode-6-analyzing-and-filtering/#comment-10923887 Thu, 20 Aug 2015 15:02:45 +0000 https://www.percona.com/blog/?p=30481#comment-10923887 Dear all,
Also you may be hit an error below, first pquery-prep-red.sh
[root@centos-base 362406]# ~/percona-qa/pquery-prep-red.sh
Something is wrong: this script could not read reducer.sh at /sda/randgen/util/reducer/reducer.sh – please set REDUCER variable inside the script correctly.

You must edit pquery-prep-red.sh and give a correct path to find reducer.sh. Default is:
# User variables
REDUCER=”/sda/randgen/util/reducer/reducer.sh

Just change it and it will work correctly.

To get a reducer.sh just do:

bzr branch lp:randgen

]]> By: Shahriyar Rzayev https://www.percona.com/blog/mysql-qa-episode-6-analyzing-and-filtering/#comment-10923560 Thu, 20 Aug 2015 09:26:23 +0000 https://www.percona.com/blog/?p=30481#comment-10923560 @Roel Van de Paar thank you for such wonderful tutorials 🙂 it is pleasure to test and learn.

]]> By: Roel Van de Paar https://www.percona.com/blog/mysql-qa-episode-6-analyzing-and-filtering/#comment-10923506 Thu, 20 Aug 2015 08:48:12 +0000 https://www.percona.com/blog/?p=30481#comment-10923506 @Shahriyar Rzayev Thanks! I’ve added the info above directly in the script to help others in the future. Rev 1514 (use ‘bzr pull’ to get it). Thanks again!

]]> By: Shahriyar Rzayev https://www.percona.com/blog/mysql-qa-episode-6-analyzing-and-filtering/#comment-10922355 Wed, 19 Aug 2015 12:18:10 +0000 https://www.percona.com/blog/?p=30481#comment-10922355 Another issue i have encountered is:
[08:07:25] [0] Copying datadir from template…
ls: cannot access /home/470678/data.template/*: No such file or directory
[08:07:25] [0] Assert: /home/470678/data.template/ is empty? Check /home/470678/log/mysql_install_db.txt to see if the original template creation worked ok. Terminating.

[root@centos-base ~]# cat /home/470678/log/mysql_install_db.txt
FATAL ERROR: please install the following Perl modules before executing /opt/mysql-5.6.19/scripts/mysql_install_db:
Data::Dumper

solution is:
yum install perl-Data-Dumper

]]> By: Shahriyar Rzayev https://www.percona.com/blog/mysql-qa-episode-6-analyzing-and-filtering/#comment-10922340 Wed, 19 Aug 2015 11:46:04 +0000 https://www.percona.com/blog/?p=30481#comment-10922340 If you run pquery-run.sh first time you will likely get an error indicating missing “jemalloc” package:

[root@centos-base percona-qa]# ./pquery-run.sh
[07:40:46] [] Assert! jemalloc not found at /usr/lib64/libjemalloc.so.1, please install it!
./pquery-run.sh: line 31: //home/221554/pquery-run.log: No such file or directory

The solution for CentOS 7 is just activating EPEL and installing:

yum -y install epel-release
yum -y install jemalloc

]]> By: Roel Van de Paar https://www.percona.com/blog/mysql-qa-episode-6-analyzing-and-filtering/#comment-10883631 Thu, 16 Jul 2015 23:50:38 +0000 https://www.percona.com/blog/?p=30481#comment-10883631 For previous/more episodes, see https://www.percona.com/blog/2015/03/17/free-mysql-qa-and-bash-linux-training-series

]]>