Bug #41580 opt_threads option is not used anywhere at all
Submitted: 18 Dec 2008 5:32 Modified: 18 Feb 2009 20:20
Reporter: Mikiya Okuno Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: General Severity:S3 (Non-critical)
Version:any OS:Any
Assigned to: Staale Smedseng CPU Architecture:Any

[18 Dec 2008 5:32] Mikiya Okuno
Description:
opt_threads option is not used at all anywhere in sql-bench.

shell> cd /path/to/sql-bench
shell> grep opt_threads *
bench-init.pl:$opt_threads=5;

So, the --thread option is not effective at all.

However, the output for "./run-all-tests --help" explains about "--thread" option, this is very misleading.

How to repeat:
Execute any tests with --threads=10 option. You can see tests do not make use of multi-threading.

Suggested fix:
--threads=# (Default 5)
  Number of threads for multi-user benchmarks.

Remove this option?
[18 Dec 2008 7:23] Valeriy Kravchuk
Verified just as described with latest 5.0 from bzr.
[28 Jan 2009 14:57] 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/64309

2731 Staale Smedseng	2009-01-28
      Bug #41580 opt_threads option is not used anywhere at all
      
      All references to opt_threads removed from bench-init.pl.sh.
[3 Feb 2009 12:46] 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/64997

2768 Staale Smedseng	2009-02-03
      Bug #41580 opt_threads option is not used anywhere at all
      
      Option opt_threads is deprecated in 5.1, and a warning is
      printed when used. Will remove in 6.0.
[3 Feb 2009 12:59] 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/65000

3010 Staale Smedseng	2009-02-03 [merge]
      Bug #41580 opt_threads option is not used anywhere at all
      
      Option opt_threads was deprecated in 5.1, and is removed 
      in 6.0.
[4 Feb 2009 12:23] 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/65139

3013 Staale Smedseng	2009-02-04 [merge]
      Bug#41580 recommit for pushing
[9 Feb 2009 22:34] Bugs System
Pushed into 5.1.32 (revid:davi.arnaut@sun.com-20090209214102-gj3sb3ujpnvpiy4c) (version source revid:davi.arnaut@sun.com-20090209214102-gj3sb3ujpnvpiy4c) (merge vers: 5.1.32) (pib:6)
[14 Feb 2009 13:02] Bugs System
Pushed into 6.0.10-alpha (revid:matthias.leich@sun.com-20090212211028-y72faag15q3z3szy) (version source revid:sergey.glukhov@sun.com-20090204124101-bbsb4d40mg7rzrma) (merge vers: 6.0.10-alpha) (pib:6)
[17 Feb 2009 14:59] Bugs System
Pushed into 5.1.32-ndb-6.3.23 (revid:tomas.ulin@sun.com-20090217131017-6u8qz1edkjfiobef) (version source revid:tomas.ulin@sun.com-20090216083408-rmvyaxjt6mk8sg1y) (merge vers: 5.1.32-ndb-6.3.23) (pib:6)
[17 Feb 2009 16:47] Bugs System
Pushed into 5.1.32-ndb-6.4.3 (revid:tomas.ulin@sun.com-20090217134419-5ha6xg4dpedrbmau) (version source revid:tomas.ulin@sun.com-20090216083646-m8st11oj1hhfuuh5) (merge vers: 5.1.32-ndb-6.4.3) (pib:6)
[17 Feb 2009 18:23] Bugs System
Pushed into 5.1.32-ndb-6.2.17 (revid:tomas.ulin@sun.com-20090217134216-5699eq74ws4oxa0j) (version source revid:tomas.ulin@sun.com-20090211111208-wf0acl7c1vl5653e) (merge vers: 5.1.32-ndb-6.2.17) (pib:6)
[18 Feb 2009 20:20] Paul DuBois
Test suite change. No changelog entry needed.