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/innodb-buffer-pool-flushing.html
For table data stored on SSD, seek time is not a significant factor and you can disable this setting to spread out write operations. Side effects of limiting page flushing during idle periods may include a longer shutdown time following a lengthy ...
https://dev.mysql.com/doc/refman/8.0/en/events-privileges.html
The EVENT privilege governs the creation, modification, and deletion of events. If you inspect the MySQL error log (hostname.err), you can see that the event is executing, but the action it is attempting to perform fails: 2013-09-24T12:41:31.261992Z ... To enable or disable the execution of scheduled events, it is necessary to set the value of the global event_scheduler system ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-memory.html
Note that the replica still has outdated data in a MEMORY table during the interval between the source's restart and its first use of the table. This causes the replica to be out of synchrony with the source and may lead to other failures or cause ... When a replication source server shuts down and restarts, its MEMORY tables become ...To avoid this interval when a direct query to the replica could return stale data, you can set the init_file system variable to ...
https://dev.mysql.com/doc/refman/8.0/en/access-control.html
The primary function of the MySQL privilege system is to authenticate a user who connects from a given host and to associate that user with privileges on a database such as SELECT, INSERT, UPDATE, and DELETE. MySQL enables the creation of accounts ...Additional functionality includes the ability to grant privileges for administrative ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-generated-columns.html
ALTER TABLE operations permitted for generated columns are ADD, MODIFY, and CHANGE. CREATE TABLE t1 (c1 INT); ALTER TABLE t1 ADD COLUMN c2 INT GENERATED ALWAYS AS (c1 + 1) STORED; The data type and expression of generated columns can be modified.
https://dev.mysql.com/doc/refman/8.0/en/charset-server.html
By default, these are utf8mb4 and utf8mb4_0900_ai_ci, but they can be set explicitly at server startup on the command line or in an option file and changed at runtime. MySQL Server has a server character set and a server collation. Initially, the ...If you don't specify a character set, that is the same as saying ...
https://dev.mysql.com/doc/refman/8.0/en/charset-table.html
Every table has a table character set and a table collation. The CREATE TABLE and ALTER TABLE statements have optional clauses for specifying the table character set and collation: CREATE TABLE tbl_name (column_list) [[DEFAULT] CHARACTER SET ...To ...
https://dev.mysql.com/doc/refman/8.0/en/index-btree-hash.html
Understanding the B-tree and hash data structures can help predict how different queries perform on different storage engines that use these data structures in their indexes, particularly for the MEMORY storage engine that lets you choose B-tree or ...B-Tree Index Characteristics Hash Index Characteristics B-Tree Index Characteristics A B-tree index can be used for column comparisons in expressions that use the =, >, >=, <, <=, or BETWEEN ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-transactions.html
Note This section describes locking information as exposed by the Performance Schema data_locks and data_lock_waits tables, which supersede the INFORMATION_SCHEMA INNODB_LOCKS and INNODB_LOCK_WAITS tables in MySQL 8.0. For similar discussion ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl.html
The online DDL feature provides support for instant and in-place table alterations and concurrent DML. Benefits of this feature include: Improved responsiveness and availability in busy production environments, where making a table unavailable for ...Typically, you do not need to do anything special to enable online ...