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/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/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/sys-schema-progress-reporting.html
The following sys schema views provide progress reporting for long-running transactions: processlist session x$processlist x$session Assuming that the required instruments and consumers are enabled, the progress column of these views shows the ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-check.html
To check a MyISAM table, use the following commands: myisamchk tbl_name This finds 99.99% of all errors. If you want to check a table, you should normally run myisamchk without options or with the -s (silent) option. This may take a long time for a ...What it cannot find is corruption that involves only the data file (which is very ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-blocks.html
The blocks table is a static table which simply contains the names and internal IDs of all NDB kernel blocks (see NDB Kernel Blocks). It is for use by the other ndbinfo tables (most of which are actually views) in mapping block numbers to block ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-cluster-transactions.html
The cluster_transactions table shows information about all ongoing transactions in an NDB Cluster. Together with the block name, this number can be used to look up a given instance in the threadblocks table. You can use this along with the block ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-config-params.html
The config_params table is a static table which provides the names and internal ID numbers of and other information about NDB Cluster configuration parameters. Although this is a static table, its content can vary between NDB Cluster installations, ...The param_description, param_type, param_default, param_min, param_max, param_mandatory, and param_status columns were all added in NDB ...
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 ...