PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/account-upgrades.html
Notes: The upgrade operation just described is safe to execute at any time because it makes the mysql_native_password plugin explicit only for accounts that already use it implicitly. To upgrade these accounts to use mysql_native_password ... The ...
https://dev.mysql.com/doc/refman/5.7/en/controlling-query-plan-evaluation.html
The task of the query optimizer is to find an optimal plan for executing an SQL query. Because the difference in performance between “good” and “bad” plans can be orders of magnitude (that is, seconds versus hours or even days), most query ...For join queries, the number of possible plans investigated by the MySQL optimizer grows exponentially with the number of tables referenced in a ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-maintenance.html
Example: ALTER TABLE t1 REPAIR PARTITION p0,p1; Normally, REPAIR PARTITION fails when the partition contains duplicate key errors. You can check partitions for errors in much the same way that you can use CHECK TABLE with nonpartitioned tables. A ...
https://dev.mysql.com/doc/refman/5.7/en/connection-interfaces.html
Connection Volume Management To control the maximum number of clients the server permits to connect simultaneously, set the max_connections system variable at server startup or at runtime. It implements a thread pool that increases server ... This ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rbr-usage.html
You can switch from statement-based to row-based binary logging format at runtime even when temporary tables have been created. When executing on the replica, a table lock is taken on all tables involved, and then the rows are applied in batch mode.
https://dev.mysql.com/doc/refman/5.7/en/xa.html
In essence, this extends ACID properties “up a level” so that multiple ACID transactions can be executed in concert as components of a global operation that also has ACID properties. The process for executing a global transaction uses two-phase ... Support for XA transactions is available for the InnoDB storage ...
https://dev.mysql.com/doc/refman/5.7/en/sys-io-global-by-wait-by-latency.html
max_latency The maximum single wait time of timed occurrences of the I/O event. These views summarize global I/O consumers to display amount of I/O and time waiting for I/O, grouped by event. total_latency The total wait time of timed occurrences ...The io_global_by_wait_by_latency and x$io_global_by_wait_by_latency views have these columns: event_name The I/O event name, with the wait/io/file/ prefix ...
https://dev.mysql.com/doc/refman/5.7/en/events-overview.html
When you create an event, you are creating a named database object containing one or more SQL statements to be executed at one or more regular intervals, beginning and ending at a specific date and time. Whereas a trigger is a database object whose ...Scheduled tasks of this type are also sometimes known as “temporal triggers”, implying that these are objects that are triggered by the passage of ...
https://dev.mysql.com/doc/refman/5.7/en/creating-ssl-files-using-openssl.html
A typical error in this case is: ERROR 2026 (HY000): SSL connection error: error:00000001:lib(0):func(0):reason(1) Important If a client connecting to a MySQL server instance uses an SSL certificate with the extendedKeyUsage extension (an X.509 v3 ... This section describes how to use the openssl command to set up SSL certificate and key files for use by MySQL servers and ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-create-table-external.html
Attempting to access a table when the associated data file is missing causes a serious error that requires a server restart. There are different reasons for creating InnoDB tables externally; that is, creating tables outside of the data directory.