PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-mysqld.html
(We often refer to a mysqld process running in this manner as an SQL node.) It is fully aware of all cluster data nodes as well as their status, and establishes connections to all data nodes. If mysqld is started with only the --ndbcluster option, ...To be used with NDB Cluster, mysqld needs to be built with support for the NDB storage engine, as it is in the precompiled binaries available from ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-top.html
This user must be able to read tables in the ndbinfo database (ndb_top uses information from ndbinfo.cpustat and related tables). The following table includes all options that are specific to the NDB Cluster program ndb_top. ndb_top displays ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndbd.html
The ndbd binary provides the single-threaded version of the process that is used to handle all the data in tables employing the NDBCLUSTER storage engine. Options that can be used with ndbd are shown in the following table. Important This option ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-failover.html
This means that the ndb_apply_status table contains information for the replica on this host as well as for any other host which acts as a replica of the replication source server running on this host. Using the information obtained from the query ... In the event that the primary Cluster replication process fails, it is possible to switch over to the secondary replication ...
https://dev.mysql.com/doc/refman/5.7/en/no-login-pluggable-authentication.html
To verify plugin installation, examine the Information Schema PLUGINS table or use the SHOW PLUGINS statement (see Section 5.5.2, “Obtaining Server Plugin Information”). The mysql_no_login server-side authentication plugin prevents all client ...
https://dev.mysql.com/doc/refman/5.7/en/no-matching-rows.html
If you have a complicated query that uses many tables but that returns no rows, you should use the following procedure to find out what is wrong: Test the query with EXPLAIN to check whether you can find something that is obviously wrong. Remove ...
https://dev.mysql.com/doc/refman/5.7/en/out-of-range-and-overflow.html
In strict mode, these statements fail, and some or all the values are not inserted or changed, depending on whether the table is a transactional table and other factors. If no restrictive modes are enabled, MySQL clips the value to the appropriate ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-examples.html
The following example provides one methodology that you can use to analyze a repeatable problem, such as investigating a performance bottleneck. To begin, you should have a repeatable use case where performance is deemed “too slow” and needs ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-instrument-filtering.html
The setup_instruments table lists the available instruments: mysql> SELECT * FROM performance_schema.setup_instruments; +---------------------------------------------------+---------+-------+ | NAME | ENABLED | TIMED | ...| stage/sql/end | NO | NO ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-startup-configuration.html
Consumer names in the setup_consumers table use underscores, but for consumers set at startup, dashes and underscores within the name are equivalent. The other variables indicate table sizes (number of rows) or memory allocation values. For example, ... To use the MySQL Performance Schema, it must be enabled at server startup to enable event collection to ...