PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndbd.html
The ndbd binary provides the single-threaded version of the process that is used to handle all the data in tables employing the NDBCLUSTER storage engine. Options that can be used with ndbd are shown in the following table. An initial start erases ...This data node process enables a data node to accomplish distributed transaction handling, node recovery, checkpointing to disk, online backup, and related ...
https://dev.mysql.com/doc/refman/8.0/en/no-login-pluggable-authentication.html
To verify plugin installation, examine the Information Schema PLUGINS table or use the SHOW PLUGINS statement (see Section 7.6.2, “Obtaining Server Plugin Information”). To refer to the no-login authentication plugin in the IDENTIFIED WITH ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-configuring-instances.html
For more information, see Section 6.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”. log_bin=binlog log_slave_updates=ON binlog_format=ROW master_info_repository=TABLE relay_log_info_repository=TABLE ... This section explains the ...
https://dev.mysql.com/doc/refman/8.0/en/charset-applications.html
To create a database such that its tables use a given default character set and collation for data storage, use a CREATE DATABASE statement like this: CREATE DATABASE mydb CHARACTER SET latin1 COLLATE latin1_swedish_ci; Tables created in the ...Note ... For applications that store data using the default MySQL character set and collation (utf8mb4, utf8mb4_0900_ai_ci), no special configuration should be ...
https://dev.mysql.com/doc/refman/8.0/en/cursor-restrictions.html
The same restrictions apply to internal temporary tables created to hold the result set for a cursor as for other uses of internal temporary tables. In MySQL, a server-side cursor is materialized into an internal temporary table. Initially, this is ... Server-side cursors are implemented in the C API using the mysql_stmt_attr_set() ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-modifiers.html
To work around the restriction that prevents using ROLLUP with ORDER BY and achieve a specific sort order of grouped results, generate the grouped result set as a derived table and apply ORDER BY to it. The GROUP BY clause permits a WITH ROLLUP ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-dedicated-server.html
Warning Prior to MySQL 8.0.14, O_DIRECT_NO_FSYNC was not suitable for file systems such as XFS and EXT4, which require an fsync() system call to synchronize file system metadata changes. As of MySQL 8.0.14, fsync() is called after creating a new ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-benefits.html
You can create a new table for data, or use existing tables. The combination of InnoDB tables and memcached offers advantages over using either by themselves. Data written using the memcached protocol is transparently written to an InnoDB table, ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-recovery.html
In some cases of database corruption, it is enough to dump, drop, and re-create one or a few corrupt tables. You can use the CHECK TABLE statement to check whether a table is corrupt, although CHECK TABLE naturally cannot detect every possible kind ...To achieve point-in-time recovery after restoring a backup, you can apply changes from the binary log that occurred after the backup was ...
https://dev.mysql.com/doc/refman/8.0/en/mrr-optimization.html
Reading rows using a range scan on a secondary index can result in many random disk accesses to the base table when the table is large and not stored in the storage engine's cache. Then the keys are sorted and finally the rows are retrieved from ...