PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/error-log-rule-based-filtering.html
This rule set drops information events, and, for other events, removes the source_line field: SET GLOBAL dragnet.log_error_filter_rules = 'IF prio>=INFORMATION THEN drop. For example: SET GLOBAL dragnet.log_error_filter_rules = ' IF ... The ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-what-is-new.html
NDB 8.0 removes the previous 63-byte limit on identifiers for databases and tables. Previously, the only NDB objects synchronized on connection of a new SQL node were databases and tables; MySQL NDB Cluster 8.0 also implements schema synchronization ... The following sections describe changes in the implementation of MySQL NDB Cluster in NDB Cluster 8.0 through 8.0.44, as compared to earlier release ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-mgm-client-commands.html
DROP NODEGROUP nodegroup_id Drops the NDB Cluster node group with the given nodegroup_id. This command can be used to drop a node group from an NDB Cluster. DROP NODEGROUP takes as its sole argument the node group ID of the node group to be dropped.
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-disk-data-objects.html
It is also possible to drop data files from a tablespace (see example later in this section). This is also true for dropping these objects, subject to the following constraints: A log file group cannot be dropped as long as any tablespaces use it. A ... NDB Cluster Disk Data storage is implemented using the following objects: Tablespace: Acts as containers for other Disk Data ...
https://dev.mysql.com/doc/refman/8.0/en/extensions-to-ansi.html
See Section 15.1.12, “CREATE DATABASE Statement”, Section 15.1.24, “DROP DATABASE Statement”, and Section 15.1.2, “ALTER DATABASE Statement”. Organization of data on disk MySQL Server maps each database to a directory under the MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html
Table creation and drop operations for any storage engine modify data dictionary tables in the mysql system database, but those tables use the InnoDB storage engine and cannot be modified when innodb_read_only is enabled. Some options, which you ...
https://dev.mysql.com/doc/refman/8.0/en/analyze-table.html
DROP DATABASE removes histograms for any table in the dropped database because the statement drops all tables in the database. [WITH N BUCKETS] ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [USING DATA 'json_data'] ...ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [, col_name] ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-online-operations.html
Tells the data nodes to drop the original table and then to rename the copy. Operations that add and drop indexes on variable-width columns of NDB tables occur online. ALGORITHM=INPLACE can be used to perform online ADD COLUMN, ADD INDEX (including ... MySQL NDB Cluster 8.0 supports online table schema changes using ALTER TABLE ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlcheck.html
If you use the --databases or --all-databases option to process all tables in one or more databases, an invocation of mysqlcheck might take a long time. There are three general ways to invoke mysqlcheck: mysqlcheck [options] db_name [tbl_name ...] ... The mysqlcheck client performs table maintenance: It checks, repairs, optimizes, or analyzes ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html
Only those statements are written to the binary log where the default database (that is, the one selected by USE) is db_name. To specify more than one database, use this option multiple times, once for each database; however, doing so does not cause ... Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which statements are written to the binary ...