PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-config-values.html
The config_values table, implemented in NDB 7.5.0, provides information about the current state of node configuration parameter values. Each row in the table corresponds to the current value of a parameter on a given node. node_id ID of the node in ...You can obtain output that is more specific, more detailed, or both by issuing the proper ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-nodes.html
This table contains information on the status of data nodes. For each data node that is running in the cluster, a corresponding row in this table provides the node's node ID, status, and uptime. The nodes table contains the following columns: ...
https://dev.mysql.com/doc/refman/5.7/en/charset-column.html
If you use ALTER TABLE to convert a column from one character set to another, MySQL attempts to map the data values, but if the character sets are incompatible, there may be data loss. CREATE TABLE t1 ( col1 CHAR(10) CHARACTER SET utf8 COLLATE ...
https://dev.mysql.com/doc/refman/5.7/en/drop-tablespace.html
An NDB tablespace to be dropped must not contain any data files; in other words, before you can drop an NDB tablespace, you must first drop each of its data files using ALTER TABLESPACE ... mysql> CREATE TABLESPACE myts -> ADD DATAFILE ... DROP ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-stored-procs.html
You can manage stored procedures with CREATE [FUNCTION|PROCEDURE], ALTER [FUNCTION|PROCEDURE], DROP [FUNCTION|PROCEDURE], and SHOW CREATE [FUNCTION|PROCEDURE]. You can obtain information about existing stored procedures using the ROUTINES table in ...Where can I find documentation for MySQL stored procedures and stored functions? ...
https://dev.mysql.com/doc/refman/5.7/en/statement-caching.html
Metadata changes occur for DDL statements such as those that create, drop, alter, rename, or truncate tables, or that analyze, optimize, or repair tables. If the set of columns in the table is modified with ALTER TABLE, the prepared statement goes ...Table content changes (for example, with INSERT or UPDATE) do not change metadata, nor do SELECT ... For certain statements that a client might execute multiple times during a session, the server ...
https://dev.mysql.com/doc/refman/5.7/en/user-resources.html
Only statements that modify databases or tables count against the update limit. An “account” in this context corresponds to a row in the mysql.user system table. That is, a connection is assessed against the User and Host values in the user ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-general-options.html
The options described in this section can be used for any type of table maintenance operation performed by myisamchk. The sections following this one describe options that pertain only to specific operations, such as table checking or repairing.
https://dev.mysql.com/doc/refman/5.7/en/replication-options-reference.html
gtid_executed_compression_period: Compress gtid_executed table each time this many transactions have occurred. master_info_repository: Whether to write connection metadata repository, containing source information and replication I/O thread location ... The following two sections provide basic information about the MySQL command-line options and system variables applicable to replication and the binary ...
https://dev.mysql.com/doc/refman/5.7/en/explain-extended.html
The Message value in SHOW WARNINGS output displays how the optimizer qualifies table and column names in the SELECT statement, what the SELECT looks like after the application of rewriting and optimization rules, and possibly other notes about the ... For SELECT statements, the EXPLAIN statement produces extra (“extended”) information that is not part of EXPLAIN output but can be viewed by issuing a SHOW WARNINGS statement following ...