← 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/format_status_variables.sh

  • 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/format_status_variables.sh
1
 
#!/bin/bash
2
 
 
3
 
TESTS=1
4
 
TMPDIR=$TEST_TMPDIR
5
 
 
6
 
cat <<EOF > $TMPDIR/expected
7
 
Variable                                Per day  Per second      5 secs
8
 
Bytes_received                          8000000         100            
9
 
Bytes_sent                             35000000         400            
10
 
Com_admin_commands                           20                        
11
 
Com_change_db                              1000                        
12
 
Com_delete                                 8000                        
13
 
Com_insert                                 8000                        
14
 
Com_lock_tables                             200                        
15
 
Com_replace                                1250                        
16
 
Com_select                                22500                        
17
 
Com_set_option                            22500                        
18
 
Com_show_binlogs                             10                        
19
 
Com_show_create_db                          400                        
20
 
Com_show_create_table                      7000                        
21
 
Com_show_databases                          125                        
22
 
Com_show_fields                            7000                        
23
 
Com_show_innodb_status                      300                        
24
 
Com_show_open_tables                         10                        
25
 
Com_show_processlist                        300                        
26
 
Com_show_slave_status                       300                        
27
 
Com_show_status                             350                        
28
 
Com_show_storage_engines                     10                        
29
 
Com_show_tables                             400                        
30
 
Com_show_triggers                          7000                        
31
 
Com_show_variables                          450                        
32
 
Com_truncate                                300                        
33
 
Com_unlock_tables                           250                        
34
 
Com_update                                  900                        
35
 
Connections                                2500                        
36
 
Created_tmp_disk_tables                   15000                        
37
 
Created_tmp_files                            60                        
38
 
Created_tmp_tables                        22500                        
39
 
Flush_commands                               10                        
40
 
Handler_delete                             8000                        
41
 
Handler_read_first                         2250                        
42
 
Handler_read_key                          30000                        
43
 
Handler_read_next                         15000                        
44
 
Handler_read_rnd                           9000                        
45
 
Handler_read_rnd_next                    300000           3            
46
 
Handler_update                            17500                        
47
 
Handler_write                            250000           2            
48
 
Innodb_buffer_pool_pages_data               225                        
49
 
Innodb_buffer_pool_pages_free              5000                        
50
 
Innodb_buffer_pool_pages_total             6000                        
51
 
Innodb_buffer_pool_read_ahead_rnd            10                        
52
 
Innodb_buffer_pool_read_requests           2250                        
53
 
Innodb_buffer_pool_reads                    150                        
54
 
Innodb_data_fsyncs                           35                        
55
 
Innodb_data_read                       30000000         350            
56
 
Innodb_data_reads                           300                        
57
 
Innodb_data_writes                           35                        
58
 
Innodb_data_written                       17500                        
59
 
Innodb_log_writes                            10                        
60
 
Innodb_os_log_fsyncs                         35                        
61
 
Innodb_os_log_written                      6000                        
62
 
Innodb_page_size                         175000           2            
63
 
Innodb_pages_read                           225                        
64
 
Key_blocks_unused                        150000           1            
65
 
Key_blocks_used                             175                        
66
 
Key_read_requests                        100000           1            
67
 
Key_reads                                   600                        
68
 
Key_write_requests                        70000                        
69
 
Key_writes                                17500                        
70
 
Max_used_connections                         45                        
71
 
Open_files                                 1500                        
72
 
Open_tables                                 700                        
73
 
Opened_tables                             15000                        
74
 
Qcache_free_blocks                           80                        
75
 
Qcache_free_memory                    175000000        2250            
76
 
Qcache_hits                                8000                        
77
 
Qcache_inserts                            20000                        
78
 
Qcache_not_cached                         10000                        
79
 
Qcache_queries_in_cache                     225                        
80
 
Qcache_total_blocks                         600                        
81
 
Questions                                100000           1            
82
 
Select_scan                               25000                        
83
 
Sort_rows                                  8000                        
84
 
Sort_scan                                   300                        
85
 
Table_locks_immediate                     50000                   17500
86
 
Table_locks_waited                           10                       1
87
 
Threads_cached                               35                        
88
 
Threads_connected                            10                        
89
 
Threads_created                              45                        
90
 
Threads_running                              10                        
91
 
Uptime                                    90000           1           1
92
 
Uptime_since_flush_status                 90000           1            
93
 
EOF
94
 
 
95
 
join samples/mysql-status-00{1,2}.txt > $TMPDIR/in
96
 
format_status_variables $TMPDIR/in > $TMPDIR/got
97
 
no_diff $TMPDIR/got $TMPDIR/expected