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/date-and-time-type-conversion.html
For example, although DATE, DATETIME, and TIMESTAMP values all can be specified using the same set of formats, the types do not all have the same range of values. TIMESTAMP values cannot be earlier than 1970 UTC or later than '2038-01-19 03:14:07' ... To some extent, you can convert a value from one temporal type to ...
https://dev.mysql.com/doc/refman/8.0/en/point-in-time-recovery.html
Point-in-time recovery refers to recovery of data changes up to a given point in time. Typically, this type of recovery is performed after restoring a full backup that brings the server to its state as of the time the backup was made. (The full ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html
MySQL Server now supports SSL session reuse by default with a timeout setting to control how long the server maintains a session cache that establishes the period during which a client is permitted to request session reuse for new connections. MySQL ... This section summarizes what has been added to, deprecated in, and removed from MySQL ...An atomic DDL statement combines the data dictionary updates, storage engine ...
https://dev.mysql.com/doc/refman/8.0/en/glossary.html
In a sense, the adaptive hash index configures MySQL at runtime to take advantage of ample main memory, coming closer to the architecture of main-memory databases. availability The ability to cope with, and if necessary recover from, failures on the ... These terms are commonly used in information about the MySQL database ...These properties are all desirable ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-tzinfo-to-sql.html
The mysql_tzinfo_to_sql program loads the time zone tables in the mysql database. If your system does not have a zoneinfo database, you can use the downloadable package described in Section 7.1.15, “MySQL Server Time Zone Support”. For example: ...It is used on systems that have a zoneinfo database (the set of files describing time ...One likely ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-pitr.html
Performing point-in-time recovery of NDB Cluster tables with NDB Cluster and NDB Cluster Replication can be accomplished using a native NDB data backup (taken by issuing CREATE BACKUP in the ndb_mgm client) and restoring the ndb_binlog_index table ... Point-in-time recovery—that is, recovery of data changes made since a given point in time—is performed after restoring a full backup that returns the server to its state when the backup was ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-pgman-time-track-stats.html
Log wait latency (log_waits column) is the length of time a page write must wait for the undo log to be flushed, which must be done prior to each page write. This table provides information regarding the latency of disk operations for NDB Cluster ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-tc-time-track-stats.html
The tc_time_track_stats table provides time-tracking information obtained from the DBTC block (TC) instances in the data nodes, through API nodes access NDB. tc_time_track_stats presents this information as rows, with a row for each instance of the ...Each TC instance tracks latencies for a set of activities it undertakes on behalf of API nodes or other data nodes; these activities include transactions, transaction errors, key reads, key writes, unique index operations, failed key operations of any type, scans, failed scans, fragment scans, and failed fragment ...
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html
This comes into play when the main MySQL thread gets very many connection requests in a very short time. The back_log value indicates how many requests can be stacked during this short time before MySQL momentarily stops answering new requests. The ...Most system variables can be set at server startup using options on the command line or in an option ...
https://dev.mysql.com/doc/refman/8.0/en/windows-server-first-start.html
This section gives a general overview of starting the MySQL server. The following sections provide more specific information for starting the MySQL server from the command line or as a Windows service. The information here applies primarily if you ...They can use TCP/IP, or they can use a named pipe if the server supports named-pipe ...