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/myisam-repair.html
The discussion in this section describes how to use myisamchk on MyISAM tables (extensions .MYI and .MYD). In this case, you must use ALTER TABLE to increase the MAX_ROWS and AVG_ROW_LENGTH table option values: ALTER TABLE tbl_name MAX_ROWS=xxx ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-online-add-node-basics.html
In this section, we list the basic steps required to add new data nodes to an NDB Cluster. This procedure applies whether you are using ndbd or ndbmtd binaries for the data node processes. In the event that you have API nodes using dynamically ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-params-other.html
The listings in this section provide information about parameters used in the [computer], [tcp], and [shm] sections of a config.ini file for configuring NDB Cluster. The following parameters apply to the config.ini file's [computer] section: ...For ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-logging.html
By default, this file is named .mysql_history in your home directory. On Unix, this is syslog; on Windows, it is the Windows Event Log. Consider this input: mysql> SELECT -> 'Today is' -> , -> CURDATE() -> ; In this case, mysql logs the ... The ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-maintenance.html
You can use a number of extensions to ALTER TABLE for performing operations of this type on one or more partitions directly, as described in the following list: Rebuilding partitions. Rebuilds the partition; this has the same effect as dropping all ... A number of table and partition maintenance tasks can be carried out using SQL statements intended for such purposes on partitioned tables in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-consumer-configurations.html
This differs from the event nesting hierarchy, for which wait events nest within stage events, which nest within statement events, which nest within transaction events. +---------------------------+---------+ In this configuration, instrumentation ... The consumer settings in the setup_consumers table form a hierarchy from higher levels to ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-status-variables.html
This can be nonzero if the value of performance_schema_digests_size is too small. This can be nonzero if the value of performance_schema_max_index_stat is too small. Events recorded by the Performance Schema are not recursive, so this variable ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rbr-usage.html
This section describes known issues when using a row-based format log, and describes some best practices using it in replication. Depending on the engine used for the replica's copy of the table, this may or may not be effective. This can ... MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/windows-symbolic-links.html
This enables you to put a database directory at a different location (for example, on a different disk) by setting up a symbolic link to it. To do this, create a symbolic link in the MySQL data directory that points to D:\data\mydb. For this ... On ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-filtering.html
It is possible to use a different database for this purpose, in which case you should query the database_name.audit_log_filter table instead. audit_log_filter_flush(): Flush manual changes to the filter tables to affect ongoing filtering. To grant ... Note As of MySQL 5.7.13, for audit log filtering to work as described here, the audit log plugin and the accompanying audit tables and functions must be ...