From: Marc Alff Date: February 2 2011 11:53am Subject: bzr commit into mysql-trunk branch (marc.alff:3591) List-Archive: http://lists.mysql.com/commits/130206 Message-Id: <201102021154.p12Bsu7g015973@rcsinet15.oracle.com> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============4433794417319741886==" --===============4433794417319741886== MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline #At file:///Users/malff/BZR_TREE/mysql-trunk-cleanup/ based on revid:jon.hauglid@stripped 3591 Marc Alff 2011-02-02 Tree cleanup (removal of test script debug_env) removed: mysql-test/suite/perfschema/r/debug_env.result mysql-test/suite/perfschema/t/debug_env.test modified: mysql-test/collections/default.experimental === modified file 'mysql-test/collections/default.experimental' --- a/mysql-test/collections/default.experimental 2011-01-31 04:23:08 +0000 +++ b/mysql-test/collections/default.experimental 2011-02-02 11:52:59 +0000 @@ -42,10 +42,6 @@ main.gis-rtree main.type_float # svoj: due to BUG#38965 main.type_newdecimal # svoj: due to BUG#38965 -# Not a test, utility to troubleshoot test failures -# Flagged as experimental since output will vary -perfschema.debug_env # Bug#59740 2011-02-26 Marc Alff, script needed to investigate the failure - perfschema.ortho_iter # BUG#59740 2011-02-26 Marc Alff Test fails on FreeBSD perfschema.event_aggregate # BUG#59740 2011-02-26 Marc Alff Test fails on FreeBSD perfschema.table_aggregate_off # BUG#59740 2011-02-26 Marc Alff Test fails on FreeBSD === removed file 'mysql-test/suite/perfschema/r/debug_env.result' --- a/mysql-test/suite/perfschema/r/debug_env.result 2011-01-26 14:41:43 +0000 +++ b/mysql-test/suite/perfschema/r/debug_env.result 1970-01-01 00:00:00 +0000 @@ -1,152 +0,0 @@ -"============================================================================" -"This is not a test, it's a debug utility to troubleshoot test suite problems" -"This script is flagged as experimental, as failures are expected" -"============================================================================" -show engines; -Engine Support Comment Transactions XA Savepoints -FEDERATED NO Federated MySQL storage engine NULL NULL NULL -MRG_MYISAM YES Collection of identical MyISAM tables NO NO NO -MyISAM DEFAULT MyISAM storage engine NO NO NO -BLACKHOLE YES /dev/null storage engine (anything you write to it disappears) NO NO NO -CSV YES CSV storage engine NO NO NO -MEMORY YES Hash based, stored in memory, useful for temporary tables NO NO NO -ARCHIVE YES Archive storage engine NO NO NO -InnoDB YES Supports transactions, row-level locking, and foreign keys YES YES YES -PERFORMANCE_SCHEMA YES Performance Schema NO NO NO -show status like "performance_schema%"; -Variable_name Value -Performance_schema_cond_classes_lost 0 -Performance_schema_cond_instances_lost 0 -Performance_schema_file_classes_lost 0 -Performance_schema_file_handles_lost 0 -Performance_schema_file_instances_lost 0 -Performance_schema_locker_lost 0 -Performance_schema_mutex_classes_lost 0 -Performance_schema_mutex_instances_lost 0 -Performance_schema_rwlock_classes_lost 0 -Performance_schema_rwlock_instances_lost 0 -Performance_schema_table_handles_lost 0 -Performance_schema_table_instances_lost 0 -Performance_schema_thread_classes_lost 0 -Performance_schema_thread_instances_lost 0 -show variables like "performance_schema%"; -Variable_name Value -performance_schema ON -performance_schema_events_waits_history_long_size 10000 -performance_schema_events_waits_history_size 10 -performance_schema_max_cond_classes 80 -performance_schema_max_cond_instances 1000 -performance_schema_max_file_classes 50 -performance_schema_max_file_handles 32768 -performance_schema_max_file_instances 10000 -performance_schema_max_mutex_classes 200 -performance_schema_max_mutex_instances 10000 -performance_schema_max_rwlock_classes 30 -performance_schema_max_rwlock_instances 10000 -performance_schema_max_table_handles 1000 -performance_schema_max_table_instances 500 -performance_schema_max_thread_classes 50 -performance_schema_max_thread_instances 1000 -performance_schema_setup_actors_size 100 -performance_schema_setup_objects_size 100 -show engine performance_schema status; -Type Name Status -performance_schema events_waits_current.row_size 136 -performance_schema events_waits_current.row_count 3000 -performance_schema events_waits_history.row_size 136 -performance_schema events_waits_history.row_count 10000 -performance_schema events_waits_history.memory 1360000 -performance_schema events_waits_history_long.row_size 136 -performance_schema events_waits_history_long.row_count 10000 -performance_schema events_waits_history_long.memory 1360000 -performance_schema (pfs_mutex_class).row_size 192 -performance_schema (pfs_mutex_class).row_count 200 -performance_schema (pfs_mutex_class).memory 38400 -performance_schema (pfs_rwlock_class).row_size 224 -performance_schema (pfs_rwlock_class).row_count 30 -performance_schema (pfs_rwlock_class).memory 6720 -performance_schema (pfs_cond_class).row_size 176 -performance_schema (pfs_cond_class).row_count 80 -performance_schema (pfs_cond_class).memory 14080 -performance_schema (pfs_thread_class).row_size 144 -performance_schema (pfs_thread_class).row_count 50 -performance_schema (pfs_thread_class).memory 7200 -performance_schema (pfs_file_class).row_size 200 -performance_schema (pfs_file_class).row_count 50 -performance_schema (pfs_file_class).memory 10000 -performance_schema mutex_instances.row_size 104 -performance_schema mutex_instances.row_count 10000 -performance_schema mutex_instances.memory 1040000 -performance_schema rwlock_instances.row_size 152 -performance_schema rwlock_instances.row_count 10000 -performance_schema rwlock_instances.memory 1520000 -performance_schema cond_instances.row_size 72 -performance_schema cond_instances.row_count 1000 -performance_schema cond_instances.memory 72000 -performance_schema threads.row_size 888 -performance_schema threads.row_count 1000 -performance_schema threads.memory 888000 -performance_schema file_instances.row_size 608 -performance_schema file_instances.row_count 10000 -performance_schema file_instances.memory 6080000 -performance_schema (pfs_file_handle).row_size 8 -performance_schema (pfs_file_handle).row_count 32768 -performance_schema (pfs_file_handle).memory 262144 -performance_schema events_waits_summary_by_thread_by_event_name.row_size 32 -performance_schema events_waits_summary_by_thread_by_event_name.row_count 362000 -performance_schema events_waits_summary_by_thread_by_event_name.memory 11584000 -performance_schema (pfs_table_share).row_size 21664 -performance_schema (pfs_table_share).row_count 500 -performance_schema (pfs_table_share).memory 10832000 -performance_schema (pfs_table).row_size 8704 -performance_schema (pfs_table).row_count 1000 -performance_schema (pfs_table).memory 8704000 -performance_schema setup_actors.row_size 240 -performance_schema setup_actors.row_count 100 -performance_schema setup_actors.memory 24000 -performance_schema setup_objects.row_size 432 -performance_schema setup_objects.row_count 100 -performance_schema setup_objects.memory 43200 -performance_schema events_waits_summary_global_by_event_name.row_size 32 -performance_schema events_waits_summary_global_by_event_name.row_count 362 -performance_schema events_waits_summary_global_by_event_name.memory 11584 -performance_schema performance_schema.memory 43857328 -use performance_schema; -show tables; -Tables_in_performance_schema -cond_instances -events_waits_current -events_waits_history -events_waits_history_long -events_waits_summary_by_instance -events_waits_summary_by_thread_by_event_name -events_waits_summary_global_by_event_name -file_instances -file_summary_by_event_name -file_summary_by_instance -mutex_instances -objects_summary_global_by_type -performance_timers -rwlock_instances -setup_actors -setup_consumers -setup_instruments -setup_objects -setup_timers -table_io_waits_summary_by_index_usage -table_io_waits_summary_by_table -table_lock_waits_summary_by_table -threads -select * from performance_timers; -TIMER_NAME TIMER_FREQUENCY TIMER_RESOLUTION TIMER_OVERHEAD -select * from setup_timers; -NAME TIMER_NAME -wait CYCLE -select * from threads; -THREAD_ID NAME TYPE PROCESSLIST_ID PROCESSLIST_USER PROCESSLIST_HOST PROCESSLIST_DB PROCESSLIST_COMMAND PROCESSLIST_TIME PROCESSLIST_STATE PROCESSLIST_INFO PARENT_THREAD_ID ROLE INSTRUMENTED -select count(*) from setup_instruments; -count(*) -220 -select count(*) from events_waits_summary_by_thread_by_event_name; -count(*) -3080 === removed file 'mysql-test/suite/perfschema/t/debug_env.test' --- a/mysql-test/suite/perfschema/t/debug_env.test 2011-01-28 18:55:45 +0000 +++ b/mysql-test/suite/perfschema/t/debug_env.test 1970-01-01 00:00:00 +0000 @@ -1,45 +0,0 @@ -# Copyright (c) 2011, Oracle and/or its affiliates. All rights reserved. -# -# This program is free software; you can redistribute it and/or modify -# it under the terms of the GNU General Public License as published by -# the Free Software Foundation; version 2 of the License. -# -# This program is distributed in the hope that it will be useful, -# but WITHOUT ANY WARRANTY; without even the implied warranty of -# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the -# GNU General Public License for more details. -# -# You should have received a copy of the GNU General Public License -# along with this program; if not, write to the Free Software Foundation, -# 51 Franklin Street, Suite 500, Boston, MA 02110-1335 USA - -# Tests for PERFORMANCE_SCHEMA - ---source include/not_embedded.inc ---source include/have_perfschema.inc - --- echo "============================================================================" --- echo "This is not a test, it's a debug utility to troubleshoot test suite problems" --- echo "This script is flagged as experimental, as failures are expected" --- echo "============================================================================" - -show engines; -show status like "performance_schema%"; -show variables like "performance_schema%"; -show engine performance_schema status; - -use performance_schema; -show tables; - -select * from performance_timers; -select * from setup_timers; - -# Investigating bug#59740 -select * from threads; -select count(*) from threads; -select count(*) from setup_instruments; - -show status like "%handler%"; -select count(*) from events_waits_summary_by_thread_by_event_name; -show status like "%handler%"; - --===============4433794417319741886== MIME-Version: 1.0 Content-Type: text/bzr-bundle; charset="us-ascii"; name="bzr/marc.alff@stripped" Content-Transfer-Encoding: 7bit Content-Disposition: inline # Bazaar merge directive format 2 (Bazaar 0.90) # revision_id: marc.alff@stripped # target_branch: file:///Users/malff/BZR_TREE/mysql-trunk-cleanup/ # testament_sha1: 51f96c94d080142f976508f82c8583e0d4ea3c7d # timestamp: 2011-02-02 12:53:12 +0100 # base_revision_id: jon.hauglid@stripped\ # y9rsy95eujvyjx4u # # Begin bundle IyBCYXphYXIgcmV2aXNpb24gYnVuZGxlIHY0CiMKQlpoOTFBWSZTWehH4E4AAXvfgAAQUGP/93IC BAC////wUANep1Qo0ABppU0PQaTR6nqZGmQyGgAAMBoDQAAaaDQDQBoGimjyjJGjCYIBkaAAAwGg NAABpoNANAGgSSBABqYjQEyTJ6mjUz1T1Hkt0P1biNgxfZlUQlU9EBn4unL3v7WMMy9/weIUVtdh AUFDAFuiuhPP7xxdfCphhUOkwGR62BSEpE3suE/qIeRGW037PHIW6mU1sjvSq3iK1+3rLR1stkUM ysbiqGEPLGQOQWSgowiluIXw9TBUqhUn8IP9CFpJgzNgSErcIQQYSOMTjVrxAg1QUkqK5XKmcP86 SObRXULJiffQ8+esi1zbJ6Y4df91z4IUkD8Kk9ImmT4UWoUEgJkWRZWo+BXYG03IFbCI1eRhNcgm mqdAIssgtgEpPkqKB6fYUTpDMi4fRwfQRK1A2G55Z8q+tjOioWtZgRWhElfO1LiKpWLPQXwTxcrs dSeZPnNVU7b9lhmyfmUPLH3/JdV5W4TWcXPvtUR8qbXj6WgQ23lMKsisdQVVFgneUFt5bXGnA6qZ bg3sKChlYOuoFT88ZqAqsCIwjU0CAKh8BZfRSZtver6YMKkiubFYyY8O3nle+5g9vaAyLNy6fXP1 9RFdbg72LzSyvfHGkr+NqVqGU1NfaYuIdDyG06nSWGHAUwIza4rHfWekmYRy/PXekX8cDB3nX30L lAknRFoXW+be2PI9qe83ABI37TZOIG5naRvG61tcZWWUC1Qw069XavKaGJU9rGh/HFamu6cvmsoz z84ByqgxuVQfZQUNeZL0elPFe483gWnx9/vqx1Ii4+iOzll7i2+fY3bwkrP3gRM6uBP16LROo6HI WqpUDd4C744Tf1FmFNXYJ9oz41rMXFeFwqbcH+dA+uId7wveWsdqxDDEPmpLsm3c5hJyR+z3Gz47 1VcoNg2tWMpGo0o3MLpKAPbs+MKQIsoDOTHVwraZfgWiFH/ky6s1Bt+RHYLFk5WZY+jtgscmZPI9 D1VPs14rerRoq2eVGuq2isEvEAPru5FfbIq9GXKtaw2flSjFl93TqjZvYryBqFw70KQc26LZjdf6 qDuAyhU+3FUYUzstMrAtDZFypn7rWxYrq5V1VDm8bDB6pDioHk5c4LFlI7FisUV+VC7YMKn9f0Xc kU4UJDoR+BOA --===============4433794417319741886==--