Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-analyze-table-complexity.html
To set the number of pages sampled for an individual table, use the STATS_SAMPLE_PAGES option with CREATE TABLE or ALTER TABLE. For the nonunique indexes, the primary key columns (a,b) are counted in addition to the user defined columns. ANALYZE ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locks-set.html
If you have no indexes suitable for your statement and MySQL must scan the entire table to process the statement, every row of the table becomes locked, which in turn blocks all inserts by other users to the table. It is important to create good ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-error-reporter.html
ndb_error_reporter creates an archive from data node and management node log files that can be used to help diagnose bugs or other problems with a cluster. Usage ndb_error_reporter path/to/config-file [username] [options] This utility is intended ...It is highly recommended that you make use of this utility when filing reports of bugs in NDB ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-oci-marketplace-deploy.html
See To create a Linux instance for information on how to complete the fields. By default, the MySQL server listens on port 3306 and is configured with a single user, root. /etc/my.cnf.d/perf-tuning.cnf is created by /usr/bin/mkcnf based on the ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-delimited-text.html
This section describes how to use mysqldump to create delimited-text dump files. The .sql file contains a CREATE TABLE statement for the table. The server sends the CREATE definitions for dumped tables to mysqldump, which writes them to .sql files.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-data-locks-table.html
If the transaction has not yet performed any write operation (is still considered read only), the column contains internal data that users should not try to interpret. THREAD_ID The thread ID of the session that created the lock. THREAD_ID can be ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-transaction-tables.html
CREATE TABLE t2 (a INT) ENGINE = MyISAM; -- Transaction 1 COMMIT -- (implicit; DDL forces commit) 6. COMMIT; -- Transaction 2 COMMIT From the perspective of the server, Transaction 1 ends when table t2 is created. The cost of transaction ...Within ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-assign-anon.html
For a channel on a Group Replication group member, do not specify the Group Replication group name as the UUID for creating the GTIDs. The exception to this is any downstream replicas of the replica where you enabled ... You can set up replication ...
https://dev.mysql.com/doc/refman/8.4/en/server-configuration-defaults.html
On Windows, MySQL Installer interacts with the user and creates a file named my.ini in the base installation directory as the default option file. For non-Windows platforms, no default option file is created during either the server installation or ... The MySQL server has many operating parameters, which you can change at server startup using command-line options or configuration files (option ...
https://dev.mysql.com/doc/refman/8.4/en/show-columns.html
These two statements are equivalent: SHOW COLUMNS FROM mytable FROM mydb; SHOW COLUMNS FROM mydb.mytable; The optional EXTENDED keyword causes the output to include information about hidden columns that MySQL uses internally and are not accessible ... SHOW [EXTENDED] [FULL] {COLUMNS | FIELDS} {FROM | IN} tbl_name [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW COLUMNS displays information about the columns in a given ...