Oracle 5.0, Reference Manual

Page: 2662 / 3232

Mysqlnd replication and load balancing plugin (
mysqlnd_ms
)
2642
Statistic Description Version
use_slave_guess
Number of statements the built-in query analyzer recommends sending
to a slave because they contain no SQL hint to force use of a certain
server. The recommendation may be overruled in the following. It is
not guaranteed whether the statement will be executed on a slave or
not. This is how often the internal
is_select
function has guessed
that a slave shall be used. Please, see also the user space function
mysqlnd_ms_query_is_select
.
Since 1.1.0.
use_master_guess
Number of statements the built-in query analyzer recommends sending
to a master because they contain no SQL hint to force use of a certain
server. The recommendation may be overruled in the following. It is
not guaranteed whether the statement will be executed on a slave or
not. This is how often the internal
is_select
function has guessed
that a master shall be used. Please, see also the user space function
mysqlnd_ms_query_is_select
.
Since 1.1.0.
use_slave_sql_hint
Number of statements sent to a slave because statement begins with
the SQL hint to force use of slave. Since 1.0.0.
use_master_sql_hint
Number of statements sent to a master because statement begins with
the SQL hint to force use of master. Since 1.0.0.
use_last_used_sql_hint
Number of statements sent to server which has run the previous
statement, because statement begins with the SQL hint to force use of
previously used server. Since 1.0.0.
use_slave_callback
Number of statements sent to a slave because an user-defined
callback has chosen a slave server for statement execution. Since 1.0.0.
use_master_callback
Number of statements sent to a master because an user-defined
callback has chosen a master server for statement execution. Since 1.0.0.
non_lazy_connections_slave_success
Number of successfully opened slave connections from
configurations not using
lazy connections
. The
total number of successfully opened slave connections
is
non_lazy_connections_slave_success
+
lazy_connections_slave_success
Since 1.0.0.
non_lazy_connections_slave_failure
Number of failed slave connection attempts from configurations
not using
lazy connections
. The total number of failed slave
connection attempts is
non_lazy_connections_slave_failure
+
lazy_connections_slave_failure
Since 1.0.0.
non_lazy_connections_master_success
Number of successfully opened master connections
from configurations not using
lazy connections
. The
total number of successfully opened master connections
is
non_lazy_connections_master_success
+
lazy_connections_master_success
Since 1.0.0.
non_lazy_connections_master_failure
Number of failed master connection attempts from configurations
not using
lazy connections
. The total number of failed master
connection attempts is
non_lazy_connections_master_failure
+
lazy_connections_master_failure
Since 1.0.0.
lazy_connections_slave_success
Number of successfully opened slave connections from configurations
using
lazy connections
.
Since 1.0.0.
lazy_connections_slave_failure
Number of failed slave connection attempts from configurations using
lazy connections
.
Since 1.0.0.
lazy_connections_master_success
Number of successfully opened master connections from
configurations using
lazy connections
.
Since 1.0.0.
lazy_connections_master_failure
Number of failed master connection attempts from configurations using
lazy connections
.
Since 1.0.0.