| Bug #55576 | Two perfschema tests failed on mysql-next-mr-innodb PB2 tests | ||
|---|---|---|---|
| Submitted: | 27 Jul 2010 2:59 | Modified: | 10 Dec 2010 10:11 |
| Reporter: | Jimmy Yang | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Performance Schema | Severity: | S3 (Non-critical) |
| Version: | 5.6, 5,5 | OS: | Any |
| Assigned to: | Marc ALFF | CPU Architecture: | Any |
[24 Aug 2010 23:22]
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/116697 3192 Marc Alff 2010-08-24 Bug#55576 Two perfschema tests failed on mysql-next-mr-innodb PB2 tests Before this fix, some tests failed due to lack of instrumentation slots in the performance schema, because the default sizing was too low. Now that more code has been instrumented, the default sizing has to be adjusted to match the current instrumentation consumption. This change: - increases the number of rwlock classes from 20 to 30, - increases the number of rwlock and mutex instances to 1 million. Both are to account for the volume of data instrumented when the innodb storage engine is used (because of the innodb buffer pool). Adjusted the test output accordingly.
[27 Aug 2010 17:18]
Christopher Powers
Approved.
[27 Aug 2010 21:03]
Marc ALFF
Pushed into: - mysql-5.5-bugfixing - mysql-trunk-bugfixing - mysql-next-mr-bugfixing
[30 Aug 2010 8:30]
Bugs System
Pushed into mysql-trunk 5.6.1-m4 (revid:alik@sun.com-20100830082732-n2eyijnv86exc5ci) (version source revid:alik@sun.com-20100830082732-n2eyijnv86exc5ci) (merge vers: 5.6.1-m4) (pib:21)
[30 Aug 2010 8:34]
Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100830082745-n6sh01wlwh3itasv) (version source revid:alik@sun.com-20100830082745-n6sh01wlwh3itasv) (pib:21)
[30 Aug 2010 8:36]
Bugs System
Pushed into mysql-5.5 5.5.7-m3 (revid:alik@sun.com-20100830082727-5ac4czrxl61w9wle) (version source revid:alik@sun.com-20100830082727-5ac4czrxl61w9wle) (merge vers: 5.5.7-m3) (pib:21)
[30 Aug 2010 15:05]
Paul DuBois
Noted in 5.5.7, 5.6.1 changelogs. For Performance Schema, the default number of rwlock classes was increased to 30, and the default number of rwlock and mutex instances was increased to 1 million. These changes were made to account for the volume of data instrumented when the InnoDB storage engine is used (because of the InnoDB buffer pool).
[10 Dec 2010 7:49]
Anitha Gopi
Two tests are disabled on the trunk due to this bug. Please enable the tests if the bug is fixed. http://trollheim.norway.sun.com/archive/2653266.disabled_tests.html
Description: There are two perfschema tests failed on our PB2 test run on mysql-next-mr-innodb branches: perfschema.start_server_on perfschema.server_init 1) perfschema.start_server_on [ fail ] Test ended at 2010-07-26 15:32:21 .... -Performance_schema_mutex_instances_lost 0 +Performance_schema_mutex_instances_lost 181 2) perfschema.server_init [ fail ] Test ended at 2010-07-26 17:03:12 CURRENT_TEST: perfschema.server_init --- /export/home2/pb2/test/sb_1-2078845-1280150348.61/mysql-5.6.99-m4-freebsd7.0-i386-test/mysql-test/suite/perfschema/r/server_init.result 2010-07-26 14:12:33.000000000 +0300 +++ /export/home2/pb2/test/sb_1-2078845-1280150348.61/mysql-5.6.99-m4-freebsd7.0-i386-test/mysql-test/suite/perfschema/r/server_init.reject 2010-07-26 18:03:12.000000000 +0300 @@ -126,7 +126,7 @@ select count(name) from MUTEX_INSTANCES where name like "wait/synch/mutex/sql/LOG_INFO::lock"; count(name) -1 +0 select count(name) from MUTEX_INSTANCES where name like "wait/synch/mutex/sql/Query_cache::structure_guard_mutex"; count(name) @@ -134,7 +134,7 @@ select count(name) from MUTEX_INSTANCES where name like "wait/synch/mutex/sql/Event_scheduler::LOCK_scheduler_state"; count(name) -1 +0 More info, please refer to Link: http://pb2.norway.sun.com/?template=show_pushes&branch=mysql-next-mr-innodb-pb2 How to repeat: PB2 tests