Search Results
https://dev.mysql.com/doc/refman/8.4/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. This table can also be used in conjunction with the config_values table for obtaining ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-timing.html
This section discusses the available timers and their characteristics, and how timing values are represented in events. Events are collected by means of instrumentation added to the server source code. Instruments time events, which is how the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-rules-examples.html
If you use a combination of database-level and table-level replication filtering options, the replica first accepts or ignores events using the database options, then it evaluates all events permitted by those options according to the table options. It is also important to note that the results vary depending on whether the operation is logged using statement-based or row-based binary logging ...
https://dev.mysql.com/doc/refman/8.4/en/testing-server.html
After the data directory is initialized and you have started the server, perform some simple tests to make sure that it works satisfactorily. This section assumes that your current location is the MySQL installation directory and that it has a bin ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-special-options.html
You can also use a combination of --only-innodb and --suspend-at-end to back up only certain InnoDB tables. These options are for backing up database servers that play specific roles in replication, or contain certain kinds of data that require ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-install-tarball.html
Extract the MySQL Cluster Manager 8.4.6 program and other files from the distribution archive. You must install a copy of MySQL Cluster Manager on each computer that you intend to use as a MySQL NDB Cluster host. In other words, you need to install ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-auto-increment-handling.html
To make this clear, consider an example that uses this table: CREATE TABLE t1 ( c1 INT(11) NOT NULL AUTO_INCREMENT, c2 VARCHAR(10) DEFAULT NULL, PRIMARY KEY (c1) ) ENGINE=InnoDB; Suppose that there are two transactions running, each inserting rows ... InnoDB provides a configurable locking mechanism that can significantly improve scalability and performance of SQL statements that add rows to tables with AUTO_INCREMENT ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-tuning.html
Whether to adjust the size of the buffer pool based on run-time performance characteristics, such as the amount of time the system spends compressing and uncompressing data. When to Use Compression In general, compression works best on tables that ... Most often, the internal optimizations described in InnoDB Data Storage and Compression ensure that the system runs well with compressed ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-info.html
const char * mysql_info(MYSQL *mysql) Description Retrieves a string providing information about the most recently executed statement, but only for the statements listed here. Return Values A character string representing additional information ...
https://dev.mysql.com/doc/workbench/en/wb-develop-sql-editor-table-search.html
total matches: [1000] Search columns of all types check box: If checked, non-text column type columns are cast to CHAR to perform the matches, otherwise only text types (CHAR, VARCHAR, and TEXT) are searched. Find data across a MySQL connection by ...