~vkolesnikov/pbxt/pbxt-07-diskfull

« back to all changes in this revision

Viewing changes to pbxt/mysql-test-update/mysql-test/r/binlog_stm_innodb_stat.result

  • Committer: paul-mccullagh
  • Date: 2006-10-23 09:14:04 UTC
  • Revision ID: paul-mccullagh-918861e03d351978a9541168a96e58cc826734ee
Initial import

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
show status like "binlog_cache_use";
 
2
Variable_name   Value
 
3
Binlog_cache_use        0
 
4
show status like "binlog_cache_disk_use";
 
5
Variable_name   Value
 
6
Binlog_cache_disk_use   0
 
7
drop table if exists t1;
 
8
create table t1 (a int) engine=innodb;
 
9
show status like "binlog_cache_use";
 
10
Variable_name   Value
 
11
Binlog_cache_use        1
 
12
show status like "binlog_cache_disk_use";
 
13
Variable_name   Value
 
14
Binlog_cache_disk_use   1
 
15
begin;
 
16
delete from t1;
 
17
commit;
 
18
show status like "binlog_cache_use";
 
19
Variable_name   Value
 
20
Binlog_cache_use        2
 
21
show status like "binlog_cache_disk_use";
 
22
Variable_name   Value
 
23
Binlog_cache_disk_use   1
 
24
drop table t1;
 
25
show status like "Innodb_buffer_pool_pages_total";
 
26
Variable_name   Value
 
27
Innodb_buffer_pool_pages_total  512
 
28
show status like "Innodb_page_size";
 
29
Variable_name   Value
 
30
Innodb_page_size        16384
 
31
show status like "Innodb_rows_deleted";
 
32
Variable_name   Value
 
33
Innodb_rows_deleted     2000
 
34
show status like "Innodb_rows_inserted";
 
35
Variable_name   Value
 
36
Innodb_rows_inserted    2000
 
37
show status like "Innodb_rows_updated";
 
38
Variable_name   Value
 
39
Innodb_rows_updated     0