Bug #21023 mysql-stress-test.pl" missing in builds
Submitted: 13 Jul 2006 3:24 Modified: 22 Jul 2007 17:51
Reporter: River Zhang Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Packaging Severity:S2 (Serious)
Version:5.0 OS:Linux (rhel4u2)
Assigned to: Joerg Bruehe CPU Architecture:Any

[13 Jul 2006 3:24] River Zhang
Description:
We installed all the "mysql-pro-cert-5.0.17c-0.rhel4.i386" RPM package and need to run stress testing on linux, but we don't run the same "mysql-stress-test.pl" as mysql's website describes. 

Further, we also can't find it after installing the "mysql-max-5.0.22-linux-i686-glibc23" Tar package.

We get the below info from http://dev.mysql.com/doc/mysqltest/en/mysql-stress-test.html:

mysql-stress-test.pl — Server Stress Test Program
The mysql-stress-test.pl Perl script performs stress-testing of the MySQL server. (MySQL 5.0 and up only) 

mysql-stress-test.pl requires a version of Perl that has been built with threads support. 

Invoke mysql-stress-test.pl like this: 

shell> mysql-stress-test.pl [options]

mysql-stress-test.pl supports the following options: 

How to repeat:
download all 5.0.17c rpm packages and install them as below:
1. rpm -ivh "MySQL*"
2. all installed compotents is below:
MySQL-shared-pro-cert-5.0.17c-0.rhel4
MySQL-devel-pro-cert-5.0.17c-0.rhel4
MySQL-test-pro-cert-5.0.17c-0.rhel4
MySQL-pro-cert-debuginfo-5.0.17c-0.rhel4
MySQL-server-pro-cert-5.0.17c-0.rhel4
MySQL-client-pro-cert-5.0.17c-0.rhel4
3. find the /mysql-stress-test.pl, but its size is 0.

Suggested fix:
Please add mysql-stress-test.pl to 5.0xx version and make it work.
[18 Jul 2006 9:34] Sveta Smirnova
I examined listed in the report packages and did not find mysql-stress-test.pl in any. Also I examined make_binary_distribution script. It looks like any of binary package has not mysql-stress-test.pl included in.
[18 Jan 2007 16:01] [ name withheld ]
This still appears to be missing in 5.0.27.  Is there any reason the docs and or packages haven't been updated appropriately?
[27 Jun 2007 23:29] Adam Dixon
This is still missing in 5.0.42-enterprise-gpl builds.

This bug is similar to existing packaging bug http://bugs.mysql.com/bug.php?id=25486
[17 Jul 2007 14:25] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/31021

ChangeSet@1.2528, 2007-07-17 16:25:32+02:00, joerg@trift2. +2 -0
  Ensure "mysql-stress-test.pl" is included in both "tar.gz" and RPM packages.
  
  Fixing bug#21023:  "mysql-stress-test.pl" missing in builds
[22 Jul 2007 9:40] Bugs System
Pushed into 5.0.48
[22 Jul 2007 9:43] Bugs System
Pushed into 5.1.21-beta
[22 Jul 2007 17:51] Paul DuBois
Noted in 5.0.48, 5.1.21 changelogs.

mysql-stress-test.pl and mysqld_multi.server.sh were missing from
some binary distributions.