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/memory-storage-engine.html
To replicate this effect to replicas, the first time that the source uses a given MEMORY table after startup, it logs an event that notifies replicas that the table must be emptied by writing a DELETE or (from MySQL 8.0.22) TRUNCATE TABLE statement ...When the MySQL server halts or restarts, the data in MEMORY tables is ... The MEMORY storage engine (formerly known as ...
https://dev.mysql.com/doc/refman/8.0/en/load-data.html
The mysqlimport utility provides another way to load data files; it operates by sending a LOAD DATA statement to the server. For example, if mysqld was started with the local_infile system variable disabled, LOCAL produces an error. For example, if ...The file can be read from the server host or the client host, depending on whether the LOCAL modifier is ...
https://dev.mysql.com/doc/refman/8.0/en/replication-delayed.html
MySQL supports delayed replication such that a replica server deliberately executes transactions later than the source by at least a specified amount of time. In MySQL 8.0, the method of delaying replication depends on two timestamps, ...This ...
https://dev.mysql.com/doc/refman/8.0/en/alter-database.html
Encryption Option The ENCRYPTION option, introduced in MySQL 8.0.16, defines the default database encryption, which is inherited by tables created in the database. The existing tables within it are part of the general mysql tablespace, which may be ...alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name | [DEFAULT] ENCRYPTION [=] {'Y' | 'N'} | READ ONLY [=] {DEFAULT | 0 | 1} } ALTER DATABASE enables you to change the overall characteristics of a ...
https://dev.mysql.com/doc/refman/8.0/en/bnl-bka-optimization.html
In MySQL, a Batched Key Access (BKA) Join algorithm is available that uses both index access to the joined table and a join buffer. Incremental buffers also provide a savings in processing time due to the reduction in copying time. In MySQL 8.0, ...
https://dev.mysql.com/doc/refman/8.0/en/timestamp-lookups.html
Temporal values are stored in TIMESTAMP columns as UTC values, and values inserted into and retrieved from TIMESTAMP columns are converted between the session time zone and UTC. If the session time zone is UTC, there is effectively no time zone ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-backup.html
In conjunction with the MySQL binary log, users can perform point-in-time recovery. Hot and cold backups are physical backups that copy actual data files, which can be used directly by the mysqld server for faster restore. Using MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.0/en/assigning-passwords.html
Required credentials for clients that connect to the MySQL server can include a password. MySQL stores credentials in the user table in the mysql system database. Operations that assign or modify passwords are permitted only to users with the ...If ...
https://dev.mysql.com/doc/refman/8.0/en/case-sensitivity.html
This example shows that VERSION() returns a string that has a case-insensitive collation, so comparisons are case-insensitive: mysql> SELECT COLLATION(VERSION()); +----------------------+ | COLLATION(VERSION()) | +----------------------+ | ... For ...
https://dev.mysql.com/doc/refman/8.0/en/create-spatial-reference-system.html
For example: mysql> CREATE OR REPLACE SPATIAL REFERENCE SYSTEM 4326 ...; ERROR 3716 (SR005): Can't modify SRID 4326. Reserved ranges are [0, 32767] (reserved by EPSG), [60,000,000, 69,999,999] (reserved by EPSG), and [2,000,000,000, 2,147,483,647] ...srs_attribute: { NAME 'srs_name' | DEFINITION 'definition' | ORGANIZATION 'org_name' IDENTIFIED BY org_id | DESCRIPTION 'description' } srid, org_id: 32-bit unsigned integer This statement creates a spatial reference system (SRS) definition and stores it in the data ...