![background image](http://html1.mh-extra.com/html/oracle/5-0/5-0_reference-manual_16461962661.webp)
Mysqlnd replication and load balancing plugin (
mysqlnd_ms
)
2641
Statistics are aggregated for all connections and all storage handler. It is not possible to tell how much
queries originating from
mysqli
,
PDO_MySQL
or
mysql
API calls have contributed to the aggregated
data values.
Parameters
This function has no parameters.
Return Values
Returns
NULL
if the PHP configuration directive
mysqlnd_ms.enable
has disabled the plugin.
Otherwise, returns array of statistics.
Array of statistics
Statistic Description
Version
use_slave
The semantics of this statistic has changed between 1.0.1 - 1.1.0.
The meaning for version 1.0.1 is as follows. Number of statements
considered as read-only by the built-in query analyzer. Neither
statements which begin with a SQL hint to force use of slave nor
statements directed to a slave by an user-defined callback are
included. The total number of statements sent to the slaves is
use_slave
+
use_slave_sql_hint
+
use_slave_callback
.
PECL/mysqlnd_ms 1.1.0 introduces a new concept of chained filters.
The statistics is now set by the internal load balancing filter. With
version 1.1.0 the load balancing filter is always the last in the filter
chain, if used. In future versions a load balancing filter may be followed
by other filters causing another change in the meaning of the statistic.
If, in the future, a load balancing filter is followed by another filter
it is no longer guaranteed that the statement, which increments
use_slave
, will be executed on the slaves.
The meaning for version 1.1.0 is as follows. Number of statements
sent to the slaves. Statements directed to a slave by the user filter
(an user-defined callback) are not included. The latter are counted by
use_slave_callback
.
Since 1.0.0.
use_master
The semantics of this statistic has changed between 1.0.1 - 1.1.0.
The meaning for version 1.0.1 is as follows. Number of statements
not considered as read-only by the built-in query analyzer. Neither
statements which begin with a SQL hint to force use of master
nor statements directed to a master by an user-defined callback
are included. The total number of statements sent to the master is
use_master
+
use_master_sql_hint
+
use_master_callback
.
PECL/mysqlnd_ms 1.1.0 introduces a new concept of chained filters.
The statictics is now set by the internal load balancing filter. With
version 1.1.0 the load balancing filter is always the last in the filter
chain, if used. In future versions a load balancing filter may be followed
by other filters causing another change in the meaning of the statistic.
If, in the future, a load balancing filter is followed by another filter
it is no longer guaranteed that the statement, which increments
use_master
, will be executed on the slaves.
The meaning for version 1.1.0 is as follows. Number of statements
sent to the masters. Statements directed to a master by the user filter
(an user-defined callback) are not included. The latter are counted by
use_master_callback
.
Since 1.0.0.
Содержание 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 ...