~posulliv/drizzle/optimizer-style-cleanup

« back to all changes in this revision

Viewing changes to plugin/embedded_innodb/tests/r/status_table_function.result

• browse files at revision 1291
• compare with another revision
• download diff
• download tarball
• view history from revision 1291

Show diffs side-by-side

added

removed

plugin/embedded_innodb/tests/r/status_table_function.result

 

1

SHOW CREATE TABLE DATA_DICTIONARY.INNODB_STATUS;

 

2

Table   Create Table

 

3

INNODB_STATUS   CREATE TABLE `innodb_status` (

 

4

  `NAME` varchar(64) NOT NULL DEFAULT '',

 

5

  `VALUE` bigint NOT NULL DEFAULT '0'

 

6

) ENGINE=FunctionEngine

 

7

SELECT COUNT(NAME) FROM DATA_DICTIONARY.INNODB_STATUS;

 

8

COUNT(NAME)

 

9

41

 

10

SELECT NAME FROM DATA_DICTIONARY.INNODB_STATUS;

 

11

NAME

 

12

read_req_pending

 

13

write_req_pending

 

14

fsync_req_pending

 

15

write_req_done

 

16

read_req_done

 

17

fsync_req_done

 

18

bytes_total_written

 

19

bytes_total_read

 

20

buffer_pool_current_size

 

21

buffer_pool_data_pages

 

22

buffer_pool_dirty_pages

 

23

buffer_pool_misc_pages

 

24

buffer_pool_free_pages

 

25

buffer_pool_read_reqs

 

26

buffer_pool_reads

 

27

buffer_pool_waited_for_free

 

28

buffer_pool_pages_flushed

 

29

buffer_pool_write_reqs

 

30

buffer_pool_total_pages

 

31

buffer_pool_pages_read

 

32

buffer_pool_pages_written

 

33

double_write_pages_written

 

34

double_write_invoked

 

35

log_buffer_slot_waits

 

36

log_write_reqs

 

37

log_write_flush_count

 

38

log_bytes_written

 

39

log_fsync_req_done

 

40

log_write_req_pending

 

41

log_fsync_req_pending

 

42

lock_row_waits

 

43

lock_row_waiting

 

44

lock_total_wait_time_in_secs

 

45

lock_wait_time_avg_in_secs

 

46

lock_max_wait_time_in_secs

 

47

row_total_read

 

48

row_total_inserted

 

49

row_total_updated

 

50

row_total_deleted

 

51

page_size

 

52

have_atomic_builtins

 

53

SELECT * FROM DATA_DICTIONARY.INNODB_STATUS WHERE NAME="page_size";

 

54

NAME    VALUE

 

55

page_size       16384

 

56

SELECT (@fsync_count:= VALUE) AS fsyncs FROM DATA_DICTIONARY.INNODB_STATUS WHERE NAME="fsync_req_done";

 

57

fsyncs

 

58

#

 

59

create table t1 (a int primary key);

 

60

SELECT (value - @fsync_count) AS fsyncs FROM DATA_DICTIONARY.INNODB_STATUS WHERE NAME="fsync_req_done";

 

61

fsyncs

 

62

4

 

63

insert into t1 values (1);

 

64

SELECT (value - @fsync_count) AS fsyncs FROM DATA_DICTIONARY.INNODB_STATUS WHERE NAME="fsync_req_done";

 

65

fsyncs

 

66

5

 

67

insert into t1 values (5),(2),(3),(4);

 

68

SELECT (value - @fsync_count) AS fsyncs FROM DATA_DICTIONARY.INNODB_STATUS WHERE NAME="fsync_req_done";

 

69

fsyncs

 

70

6

 

71

delete from t1;

 

72

SELECT (value - @fsync_count) AS fsyncs FROM DATA_DICTIONARY.INNODB_STATUS WHERE NAME="fsync_req_done";

 

73

fsyncs

 

74

7

 

75

begin;

 

76

insert into t1 values (1);

 

77

insert into t1 values (2);

 

78

insert into t1 values (3);

 

79

insert into t1 values (4);

 

80

commit;

 

81

SELECT (value - @fsync_count) AS fsyncs FROM DATA_DICTIONARY.INNODB_STATUS WHERE NAME="fsync_req_done";

 

82

fsyncs

 

83

8

 

84

DROP TABLE t1;

 

85

SELECT (value - @fsync_count) AS fsyncs FROM DATA_DICTIONARY.INNODB_STATUS WHERE NAME="fsync_req_done";

 

86

fsyncs

 

87

9

• Older »

Loggerhead is a web-based interface for Breezy
Version: 2.0.1