PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-sql-statements.html
However, you can use LIKE to filter queries against the Information Schema ENGINES table, as discussed in the next item. SELECT * FROM INFORMATION_SCHEMA.ENGINES [WHERE ENGINE LIKE 'NDB%'] This is the equivalent of SHOW ENGINES, but uses the ENGINES ... This section discusses several SQL statements that can prove useful in managing and monitoring a MySQL server that is connected to an NDB Cluster, and in some cases provide information about the cluster ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-install-db.html
--skip-sys-schema Command-Line Format --skip-sys-schema Type Boolean Default Value FALSE mysql_install_db installs the sys schema. Note mysql_install_db is deprecated as of MySQL 5.7.6 because its functionality has been integrated into mysqld, the ...
https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source-monitoring.html
To monitor the status of replication channels the following options exist: Using the replication Performance Schema tables. 16.1.5.8.1 Monitoring Channels Using Performance Schema Tables This section explains how to use the replication Performance ...This enables you to write complex queries based on Channel_Name as a ...
https://dev.mysql.com/doc/refman/5.7/en/server-options.html
--ignore-db-dir=dir_name Command-Line Format --ignore-db-dir=dir_name Deprecated 5.7.16 Type Directory name This option tells the server to ignore the given directory name for purposes of the SHOW DATABASES statement or INFORMATION_SCHEMA tables.
https://dev.mysql.com/doc/refman/5.7/en/sys-create-synonym-db.html
Given a schema name, this procedure creates a synonym schema containing views that refer to all the tables and views in the original schema. This can be used, for example, to create a shorter name by which to refer to a schema with a long name ...
https://dev.mysql.com/doc/refman/5.7/en/create-table.html
Rules for permissible table names are given in Section 9.2, “Schema Object Names”. It is also shown in the COLUMN_COMMENT column of the Information Schema COLUMNS table. The symbol value, if used, must be unique per schema (database), per ...| ...
https://dev.mysql.com/doc/refman/5.7/en/create-tablespace.html
The rounded values are also used by the NDB kernel for calculating Information Schema FILES column values and other purposes. You can verify that the data files were created and obtain information about them by querying the Information Schema FILES ...The precise syntax and semantics depend on the storage engine ...
https://dev.mysql.com/doc/refman/5.7/en/host-cache.html
The Performance Schema host_cache table exposes the contents of the host cache so that it can be examined using SELECT statements. The host_cache_size system variable controls its size, as well as the size of the Performance Schema host_cache table ... The MySQL server maintains an in-memory host cache that contains information about clients: IP address, host name, and error ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-exclusive-to-cluster.html
Schema operations (DDL statements) are rejected while any data node restarts. Schema operations are also not supported while performing an online upgrade or downgrade. The following are limitations specific to the NDB storage engine: Machine ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-log-events.html
Table 21.55 Events relating to NDB Cluster schema operations Event Priority Severity Level Description CreateSchemaObject 8 INFO Schema objected created AlterSchemaObject 8 INFO Schema object updated DropSchemaObject 8 INFO Schema object dropped ...