← Back to branch summary

~percona-toolkit-dev/percona-toolkit/fix-empty-table-bug-987393

« back to all changes in this revision

Viewing changes to t/pt-mysql-summary/samples/expected_output_temp003.txt

  • Committer: Daniel Nichter
  • Date: 2012-04-03 16:14:55 UTC
  • mfrom: (217.6.22 2.0.3)
  • Revision ID: daniel@percona.com-20120403161455-ntv33vju9o6njtqv
Merge summary-tools-2.1.

Show diffs side-by-side

added added

removed removed

Lines of Context:
t/pt-mysql-summary/samples/expected_output_temp003.txt
 
1
# Instances ##################################################
 
2
  Port  Data Directory             Nice OOM Socket
 
3
  ===== ========================== ==== === ======
 
4
  12345 /tmp/12345/data            0    0   /tmp/12345/mysql_sandbox12345.sock
 
5
# Report On Port 12345 #######################################
 
6
                     User | msandbox@%
 
7
                     Time | 2012-03-27 16:33:46 (BST)
 
8
                 Hostname | vagrant-debian-squeeze
 
9
                  Version | 5.1.49-log MySQL Community Server (GPL)
 
10
                 Built On | pc-linux-gnu i686
 
11
                  Started | 2012-03-27 16:15 (up 0+00:18:12)
 
12
                Databases | 2
 
13
                  Datadir | /tmp/12345/data/
 
14
                Processes | 1 connected, 1 running
 
15
              Replication | Is not a slave, has 0 slaves connected
 
16
                  Pidfile | /tmp/12345/data/mysql_sandbox12345.pid (exists)
 
17
# Processlist ################################################
 
18
 
 
19
  Command                        COUNT(*) Working SUM(Time) MAX(Time)
 
20
  ------------------------------ -------- ------- --------- ---------
 
21
  Query                                 1       1         0         0
 
22
 
 
23
  User                           COUNT(*) Working SUM(Time) MAX(Time)
 
24
  ------------------------------ -------- ------- --------- ---------
 
25
  msandbox                              1       1         0         0
 
26
 
 
27
  Host                           COUNT(*) Working SUM(Time) MAX(Time)
 
28
  ------------------------------ -------- ------- --------- ---------
 
29
  localhost                             1       1         0         0
 
30
 
 
31
  db                             COUNT(*) Working SUM(Time) MAX(Time)
 
32
  ------------------------------ -------- ------- --------- ---------
 
33
  NULL                                  1       1         0         0
 
34
 
 
35
  State                          COUNT(*) Working SUM(Time) MAX(Time)
 
36
  ------------------------------ -------- ------- --------- ---------
 
37
  NULL                                  1       1         0         0
 
38
 
 
39
# Status Counters (Wait 10 Seconds) ##########################
 
40
Variable                                Per day  Per second     10 secs
 
41
Bytes_received                           250000           2         200
 
42
Bytes_sent                              3500000          40        1500
 
43
Com_admin_commands                           80                        
 
44
Com_select                                 2250                       1
 
45
Com_show_binlogs                             80                        
 
46
Com_show_databases                           80                        
 
47
Com_show_engine_status                      150                        
 
48
Com_show_master_status                       80                        
 
49
Com_show_plugins                             80                        
 
50
Com_show_processlist                         80                        
 
51
Com_show_slave_status                        80                        
 
52
Com_show_status                             225                        
 
53
Com_show_variables                          150                        
 
54
Connections                                1750                       1
 
55
Created_tmp_disk_tables                     800                       1
 
56
Created_tmp_files                           400                        
 
57
Created_tmp_tables                         3000                       3
 
58
Flush_commands                               80                        
 
59
Handler_read_first                          225                        
 
60
Handler_read_rnd_next                     90000           1          30
 
61
Handler_write                             90000           1          30
 
62
Innodb_buffer_pool_pages_flushed          15000                        
 
63
Innodb_buffer_pool_read_requests         100000           1            
 
64
Innodb_buffer_pool_write_requests         90000           1            
 
65
Innodb_data_fsyncs                         1250                        
 
66
Innodb_data_writes                         3000                        
 
67
Innodb_data_written                   250000000        3000            
 
68
Innodb_dblwr_pages_written                 1250                        
 
69
Innodb_dblwr_writes                          80                        
 
70
Innodb_log_write_requests                  6000                        
 
71
Innodb_log_writes                           300                        
 
72
Innodb_os_log_fsyncs                        800                        
 
73
Innodb_os_log_written                   3000000          35            
 
74
Innodb_pages_created                      15000                        
 
75
Innodb_pages_written                      15000                        
 
76
Open_table_definitions                     1750                        
 
77
Opened_files                              10000                       4
 
78
Opened_table_definitions                   1750                        
 
79
Opened_tables                              2250                        
 
80
Queries                                    5000                       4
 
81
Questions                                  5000                       4
 
82
Select_scan                                 700                        
 
83
Table_locks_immediate                      1500                        
 
84
Threads_created                            1750                       1
 
85
Uptime                                    90000           1           1
 
86
# Table cache ################################################
 
87
                     Size | 64
 
88
                    Usage | 35%
 
89
# Key Percona Server features ################################
 
90
      Table & Index Stats | Not Supported
 
91
     Multiple I/O Threads | Not Supported
 
92
     Corruption Resilient | Not Supported
 
93
      Durable Replication | Not Supported
 
94
     Import InnoDB Tables | Not Supported
 
95
     Fast Server Restarts | Not Supported
 
96
         Enhanced Logging | Not Supported
 
97
     Replica Perf Logging | Not Supported
 
98
      Response Time Hist. | Not Supported
 
99
          Smooth Flushing | Not Supported
 
100
      HandlerSocket NoSQL | Not Supported
 
101
           Fast Hash UDFs | Unknown
 
102
# Plugins ####################################################
 
103
       InnoDB compression | Not found
 
104
# Query cache ################################################
 
105
         query_cache_type | ON
 
106
                     Size | 0.0
 
107
                    Usage | 0%
 
108
         HitToInsertRatio | 0%
 
109
# Schema #####################################################
 
110
Skipping schema analysis
 
111
# Noteworthy Technologies ####################################
 
112
                      SSL | No
 
113
     Explicit LOCK TABLES | No
 
114
           Delayed Insert | No
 
115
          XA Transactions | No
 
116
              NDB Cluster | No
 
117
      Prepared Statements | No
 
118
 Prepared statement count | 0
 
119
# InnoDB #####################################################
 
120
                  Version | default
 
121
         Buffer Pool Size | 16.0M
 
122
         Buffer Pool Fill | 15%
 
123
        Buffer Pool Dirty | 0%
 
124
           File Per Table | OFF
 
125
                Page Size | 16k
 
126
            Log File Size | 2 * 5.0M = 10.0M
 
127
          Log Buffer Size | 1M
 
128
             Flush Method | 
 
129
      Flush Log At Commit | 1
 
130
               XA Support | ON
 
131
                Checksums | ON
 
132
              Doublewrite | ON
 
133
          R/W I/O Threads |  
 
134
             I/O Capacity | 
 
135
       Thread Concurrency | 8
 
136
      Concurrency Tickets | 500
 
137
       Commit Concurrency | 0
 
138
      Txn Isolation Level | REPEATABLE-READ
 
139
        Adaptive Flushing | 
 
140
      Adaptive Checkpoint | 
 
141
           Checkpoint Age | 0
 
142
             InnoDB Queue | 0 queries inside InnoDB, 0 queries in queue
 
143
       Oldest Transaction | 0 Seconds
 
144
         History List Len | 0
 
145
               Read Views | 1
 
146
         Undo Log Entries | 0 transactions, 0 total undo, 0 max undo
 
147
        Pending I/O Reads | 0 buf pool reads, 0 normal AIO, 0 ibuf AIO, 0 preads
 
148
       Pending I/O Writes | 0 buf pool (0 LRU, 0 flush list, 0 page); 0 AIO, 0 sync, 0 log IO (0 log, 0 chkp); 0 pwrites
 
149
      Pending I/O Flushes | 0 buf pool, 0 log
 
150
       Transaction States | 1xnot started
 
151
# MyISAM #####################################################
 
152
                Key Cache | 16.0M
 
153
                 Pct Used | 10%
 
154
                Unflushed | 0%
 
155
# Security ###################################################
 
156
                    Users | 2 users, 0 anon, 0 w/o pw, 0 old pw
 
157
            Old Passwords | OFF
 
158
# Binary Logging #############################################
 
159
                  Binlogs | 1
 
160
               Zero-Sized | 0
 
161
               Total Size | 106.0
 
162
            binlog_format | STATEMENT
 
163
         expire_logs_days | 0
 
164
              sync_binlog | 0
 
165
                server_id | 12345
 
166
             binlog_do_db | 
 
167
         binlog_ignore_db | 
 
168
# Noteworthy Variables #######################################
 
169
     Auto-Inc Incr/Offset | 1/1
 
170
   default_storage_engine | 
 
171
               flush_time | 0
 
172
             init_connect | 
 
173
                init_file | 
 
174
                 sql_mode | 
 
175
         join_buffer_size | 128k
 
176
         sort_buffer_size | 2M
 
177
         read_buffer_size | 128k
 
178
     read_rnd_buffer_size | 256k
 
179
       bulk_insert_buffer | 0.00
 
180
      max_heap_table_size | 16M
 
181
           tmp_table_size | 16M
 
182
       max_allowed_packet | 1M
 
183
             thread_stack | 192k
 
184
                      log | OFF
 
185
                log_error | /tmp/12345/data/mysqld.log
 
186
             log_warnings | 1
 
187
         log_slow_queries | OFF
 
188
log_queries_not_using_indexes | OFF
 
189
        log_slave_updates | ON
 
190
# Configuration File #########################################
 
191
              Config File | /tmp/12345/my.sandbox.cnf
 
192
 
 
193
[client]
 
194
user                                = msandbox
 
195
password                            = msandbox
 
196
port                                = 12345
 
197
socket                              = /tmp/12345/mysql_sandbox12345.sock
 
198
 
 
199
[mysqld]
 
200
port                                = 12345
 
201
socket                              = /tmp/12345/mysql_sandbox12345.sock
 
202
pid-file                            = /tmp/12345/data/mysql_sandbox12345.pid
 
203
basedir                             = /home/hugmeir/mysql5/mysqlbrew/mysqls/Percona-Server-5.1/
 
204
datadir                             = /tmp/12345/data
 
205
key_buffer_size                     = 16M
 
206
innodb_buffer_pool_size             = 16M
 
207
innodb_data_home_dir                = /tmp/12345/data
 
208
innodb_log_group_home_dir           = /tmp/12345/data
 
209
innodb_data_file_path               = ibdata1:10M:autoextend
 
210
innodb_log_file_size                = 5M
 
211
log-bin                             = mysql-bin
 
212
relay_log                           = mysql-relay-bin
 
213
log_slave_updates
 
214
server-id                           = 12345
 
215
report-host                         = 127.0.0.1
 
216
report-port                         = 12345
 
217
log-error                           = mysqld.log
 
218
innodb_lock_wait_timeout            = 3
 
219
# The End ####################################################