PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-fields-table.html
The INNODB_SYS_FIELDS table provides metadata about the key columns (fields) of InnoDB indexes, equivalent to the information from the SYS_FIELDS table in the InnoDB data dictionary. For related usage information and examples, see Section 14.16.3, ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-table-privileges-table.html
The TABLE_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format. TABLE_CATALOG The name of the catalog to which the table belongs. TABLE_SCHEMA The name of the schema ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-online-add-node.html
This section describes how to add NDB Cluster data nodes “online”—that is, without needing to shut down the cluster completely and restart it as part of the process. Important Currently, you must add new data nodes to an NDB Cluster as part ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlbinlog-server-id.html
When invoked with the --read-from-remote-server option, mysqlbinlog connects to a MySQL server, specifies a server ID to identify itself, and requests binary log files from the server. You can use mysqlbinlog to request log files from a server in ...
https://dev.mysql.com/doc/refman/5.7/en/replication-semisync-monitoring.html
To check their values, use SHOW STATUS: mysql> SHOW STATUS LIKE 'Rpl_semi_sync%'; When the source switches between asynchronous or semisynchronous replication due to commit-blocking timeout or a replica catching up, it sets the value of the ... The ...
https://dev.mysql.com/doc/refman/5.7/en/symbolic-links.html
You can move databases or tables from the database directory to other locations and replace them with symbolic links to the new locations. You might want to do this, for example, to move a database to a file system with more free space or increase ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-thread-id.html
Returns the Performance Schema thread ID assigned to a given connection ID, or the thread ID for the current connection if the connection ID is NULL. Parameters in_connection_id BIGINT UNSIGNED: The ID of the connection for which to return the ...
https://dev.mysql.com/doc/refman/5.7/en/starting-server-troubleshooting.html
If you have problems starting the server, here are some things to try: Check the error log to see why the server does not start. If mysqld is currently running, you can find out what path settings it is using by executing this command: $> mysqladmin ... This section provides troubleshooting suggestions for problems starting the ...
https://dev.mysql.com/doc/refman/5.7/en/replication-semisync-installation.html
On the source: [mysqld] rpl_semi_sync_master_enabled=1 rpl_semi_sync_master_timeout=1000 # 1 second On each replica: [mysqld] rpl_semi_sync_slave_enabled=1 . For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE ... Semisynchronous replication is implemented using plugins, so the plugins must be installed into the server to make them ...
https://dev.mysql.com/doc/refman/5.7/en/compatibility.html
We use the phrase “the SQL standard” or “standard SQL” to mean the current version of the SQL Standard at any time. We are not targeting real-time support, although MySQL replication capabilities offer significant functionality. This ...