![background image](http://html1.mh-extra.com/html/oracle/5-0/5-0_reference-manual_1646196546.webp)
Server Status Variables
526
•
Handler_rollback
[526]
The number of requests for a storage engine to perform a rollback operation.
•
Handler_savepoint
[526]
The number of requests for a storage engine to place a savepoint. Added in MySQL 5.0.3.
•
Handler_savepoint_rollback
[526]
The number of requests for a storage engine to roll back to a savepoint. Added in MySQL 5.0.3.
•
Handler_update
[526]
The number of requests to update a row in a table.
•
Handler_write
[526]
The number of requests to insert a row in a table.
•
Innodb_buffer_pool_pages_data
[526]
The number of pages containing data (dirty or clean). Added in MySQL 5.0.2.
•
Innodb_buffer_pool_pages_dirty
[526]
The number of pages currently dirty. Added in MySQL 5.0.2.
•
Innodb_buffer_pool_pages_flushed
[526]
The number of buffer pool page-flush requests. Added in MySQL 5.0.2.
•
Innodb_buffer_pool_pages_free
[526]
The number of free pages. Added in MySQL 5.0.2.
•
Innodb_buffer_pool_pages_latched
[526]
The number of latched pages in
InnoDB
buffer pool. These are pages currently being read or written
or that cannot be flushed or removed for some other reason. Added in MySQL 5.0.2. Calculation of
this variable is expensive, so as of MySQL 5.0.68, it is available only when the
UNIV_DEBUG
system
is defined at server build time.
•
Innodb_buffer_pool_pages_misc
[526]
The number of pages that are busy because they have been allocated for administrative
overhead such as row locks or the adaptive hash index. This value can also be calculated as
Innodb_buffer_pool_pages_total
[526]
–
Innodb_buffer_pool_pages_free
[526]
–
Innodb_buffer_pool_pages_data
[526]
. Added in MySQL 5.0.2.
•
Innodb_buffer_pool_pages_total
[526]
The total size of buffer pool, in pages. Added in MySQL 5.0.2.
•
Innodb_buffer_pool_read_ahead_rnd
[526]
The number of “random” read-aheads initiated by
InnoDB
. This happens when a query scans a
large portion of a table but in random order. Added in MySQL 5.0.2.
•
Innodb_buffer_pool_read_ahead_seq
[526]
The number of sequential read-aheads initiated by
InnoDB
. This happens when
InnoDB
does a
sequential full table scan. Added in MySQL 5.0.2.
•
Innodb_buffer_pool_read_requests
[526]
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...