MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 61 to 70 of 80 total results

2.3.4.5 Starting the Server for the First Time

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 ...

14.7 Date and Time Functions

https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html

If you want to subtract UNIX_TIMESTAMP() columns, you might want to cast them to signed integers. This section describes the functions that can be used to manipulate temporal values. See Section 13.2, “Date and Time Data Types”, for a ...

1.2.2 The Main Features of MySQL

https://dev.mysql.com/doc/refman/8.0/en/features.html

Designed to be fully multithreaded using kernel threads, to easily use multiple CPUs if they are available. Designed to make it relatively easy to add other storage engines. Data Types Many data types: signed/unsigned integers 1, 2, 3, 4, and 8 ...

7.4.2.9 Error Log Output Format

https://dev.mysql.com/doc/refman/8.0/en/error-log-format.html

For example: 2020-08-06T14:25:02.835618Z 0 [Note] [MY-012487] [InnoDB] DDL log recovery : begin 2020-08-06T14:25:02.936146Z 0 [Warning] [MY-010068] [Server] CA certificate /var/mysql/sslinfo/cacert.pem is self signed. Timestamps are written using ...

18.2 The MyISAM Storage Engine

https://dev.mysql.com/doc/refman/8.0/en/myisam-storage-engine.html

The only requirements for binary portability are that the machine uses two's-complement signed integers and IEEE floating-point format. There is no significant speed penalty for storing data low byte first; the bytes in a table row normally are ...

8.6 MySQL Enterprise Encryption

https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption.html

Note MySQL Enterprise Encryption is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition includes a set of encryption functions that expose OpenSSL capabilities at the SQL level. From MySQL 8.0.30, they ...

10.12.1 Optimizing Disk I/O

https://dev.mysql.com/doc/refman/8.0/en/disk-issues.html

NFS Version 2 clients can only access the lowest 2GB of a file (signed 32 bit offset). This section describes ways to configure storage devices when you can devote more and faster storage hardware to the database server. For information about ...

25.7.4 NDB Cluster Replication Schema and Tables

https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-schema.html

This information is captured in an NDB online backup, but (by design) it is not restored by ndb_restore. ndb_apply_status Table ndb_binlog_index Table ndb_replication Table Replication in NDB Cluster makes use of a number of dedicated tables in the ...

25.2.4 What is New in MySQL NDB Cluster 8.0

https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-what-is-new.html

System reserved accounts such as mysql.session@localhost or mysql.infoschema@localhost cannot be assigned this privilege. Assigning such a role to a user does not cause the user to be shared; the NDB_STORED_USER privilege must be granted to each ...

6.5.1.1 mysql Client Options

https://dev.mysql.com/doc/refman/8.0/en/mysql-command-options.html

The finish registration step executes this statement: ALTER USER user factor FINISH REGISTRATION SET CHALLENGE_RESPONSE AS 'auth_string' The statement completes the registration and sends the following information to the server as part of the ...

Displaying 61 to 70 of 80 total results