← Back to branch summary

~ubuntu-branches/ubuntu/trusty/mysql-5.6/trusty

« back to all changes in this revision

Viewing changes to mysql-test/suite/innodb/r/innodb_information_schema_buffer.result

  • Committer: Package Import Robot
  • Author(s): James Page
  • Date: 2014-02-12 11:54:27 UTC
  • Revision ID: package-import@ubuntu.com-20140212115427-oq6tfsqxl1wuwehi
Tags: upstream-5.6.15
Import upstream version 5.6.15

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/innodb/r/innodb_information_schema_buffer.result
 
1
SELECT * FROM INFORMATION_SCHEMA.INNODB_BUFFER_POOL_STATS;
 
2
SELECT count(*) FROM INFORMATION_SCHEMA.INNODB_BUFFER_POOL_STATS;
 
3
SELECT * FROM INFORMATION_SCHEMA.INNODB_BUFFER_PAGE;
 
4
SELECT COUNT(*) FROM INFORMATION_SCHEMA.INNODB_BUFFER_PAGE;
 
5
CREATE TABLE infoschema_buffer_test (col1 INT) ENGINE = INNODB;
 
6
INSERT INTO infoschema_buffer_test VALUES(9);
 
7
SELECT TABLE_NAME, INDEX_NAME, NUMBER_RECORDS, DATA_SIZE, PAGE_STATE, PAGE_TYPE
 
8
FROM INFORMATION_SCHEMA.INNODB_BUFFER_PAGE
 
9
WHERE TABLE_NAME like "%infoschema_buffer_test%"
 
10
        and PAGE_STATE="file_page" and PAGE_TYPE="index";
 
11
TABLE_NAME      INDEX_NAME      NUMBER_RECORDS  DATA_SIZE       PAGE_STATE      PAGE_TYPE
 
12
`test`.`infoschema_buffer_test` GEN_CLUST_INDEX 1       29      FILE_PAGE       INDEX
 
13
INSERT INTO infoschema_buffer_test VALUES(19);
 
14
SELECT TABLE_NAME, INDEX_NAME, NUMBER_RECORDS, DATA_SIZE, PAGE_STATE, PAGE_TYPE
 
15
FROM INFORMATION_SCHEMA.INNODB_BUFFER_PAGE
 
16
WHERE TABLE_NAME like "%infoschema_buffer_test%"
 
17
and PAGE_STATE="file_page" and PAGE_TYPE="index";
 
18
TABLE_NAME      INDEX_NAME      NUMBER_RECORDS  DATA_SIZE       PAGE_STATE      PAGE_TYPE
 
19
`test`.`infoschema_buffer_test` GEN_CLUST_INDEX 2       58      FILE_PAGE       INDEX
 
20
CREATE INDEX idx ON infoschema_buffer_test(col1);
 
21
SELECT TABLE_NAME, INDEX_NAME, NUMBER_RECORDS, DATA_SIZE, PAGE_STATE, PAGE_TYPE
 
22
FROM INFORMATION_SCHEMA.INNODB_BUFFER_PAGE
 
23
WHERE TABLE_NAME like "%infoschema_buffer_test%"
 
24
and PAGE_STATE="file_page" and INDEX_NAME = "idx" and PAGE_TYPE="index";
 
25
TABLE_NAME      INDEX_NAME      NUMBER_RECORDS  DATA_SIZE       PAGE_STATE      PAGE_TYPE
 
26
`test`.`infoschema_buffer_test` idx     2       32      FILE_PAGE       INDEX
 
27
DROP TABLE infoschema_buffer_test;
 
28
SELECT TABLE_NAME, INDEX_NAME, NUMBER_RECORDS, DATA_SIZE, PAGE_STATE, PAGE_TYPE
 
29
FROM INFORMATION_SCHEMA.INNODB_BUFFER_PAGE
 
30
WHERE TABLE_NAME like "%infoschema_buffer_test%";
 
31
TABLE_NAME      INDEX_NAME      NUMBER_RECORDS  DATA_SIZE       PAGE_STATE      PAGE_TYPE
 
32
CREATE TABLE infoschema_parent (id INT NOT NULL, PRIMARY KEY (id))
 
33
ENGINE=INNODB;
 
34
CREATE TABLE infoschema_child (id INT, parent_id INT, INDEX par_ind (parent_id),
 
35
FOREIGN KEY (parent_id)
 
36
REFERENCES infoschema_parent(id)
 
37
ON DELETE CASCADE)
 
38
ENGINE=INNODB;
 
39
SELECT count(*)
 
40
FROM INFORMATION_SCHEMA.INNODB_BUFFER_PAGE
 
41
WHERE TABLE_NAME like "%infoschema_child%" and PAGE_STATE="file_page"
 
42
and PAGE_TYPE="index";
 
43
count(*)
 
44
2
 
45
DROP TABLE infoschema_child;
 
46
DROP TABLE infoschema_parent;