PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/partitioning-overview.html
There are no plans at this time to introduce vertical partitioning into MySQL. This section provides a conceptual overview of partitioning in MySQL 8.0. The user-selected rule by which the division of data is accomplished is known as a partitioning ...For information on partitioning restrictions and feature limitations, see Section 26.6, “Restrictions and Limitations on ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-storage-engines.html
Where can I obtain complete documentation for MySQL storage engines? A.2.2. Where can I obtain complete documentation for MySQL storage engines? See Chapter 18, Alternative Storage Engines. That chapter contains information about all MySQL storage ...Can I prevent the use of a particular storage engine? ...
https://dev.mysql.com/doc/refman/8.0/en/linux-installation.html
Linux supports a number of different solutions for installing MySQL. You can also use My Oracle Support for the MySQL Enterprise Edition. Documentation Oracle Unbreakable Linux Network Use ULN channels Documentation As an alternative, you can use ...These native packages are often several versions behind the currently available ...
https://dev.mysql.com/doc/refman/8.0/en/windows-testing.html
In this case, start mysqld with the skip_name_resolve system variable enabled and use only localhost and IP addresses in the Host column of the MySQL grant tables. (Be sure that an account exists that specifies an IP address or you may not be able ...Use the --socket option to specify the name of the pipe if you do not want to use the default pipe ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-auto-increment-handling.html
InnoDB assigns new values for the AUTO_INCREMENT column one at a time as each row is processed. As of MySQL 8.0, interleaved lock mode (innodb_autoinc_lock_mode=2) is the default setting. Prior to MySQL 8.0, consecutive lock mode is the default ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-mysql-database.html
The contents of the grant tables in the mysql database can be modified directly (for example, with INSERT or DELETE) or indirectly (for example, with GRANT or CREATE USER). Statements that affect mysql database tables are written to the binary log ...This pertains to statements such as INSERT, UPDATE, DELETE, REPLACE, DO, LOAD DATA, SELECT, and TRUNCATE ...
https://dev.mysql.com/doc/refman/8.0/en/charset-mysql.html
MySQL Server supports multiple character sets, including several Unicode character sets. mysql> SHOW CHARACTER SET; +----------+---------------------------------+---------------------+--------+ | Charset | Description | Default collation | Maxlen | ...To display the available character sets, use the INFORMATION_SCHEMA CHARACTER_SETS table or the SHOW CHARACTER SET ...
https://dev.mysql.com/doc/refman/8.0/en/gis-mysql-specific-functions.html
MySQL provides a set of useful nonstandard functions for creating geometry values. The functions described in this section are MySQL extensions to the OpenGIS specification. Also, functions such as ST_GeomFromText() that accept WKT geometry ...
https://dev.mysql.com/doc/refman/8.0/en/linux-installation-apt-repo.html
The MySQL APT repository provides deb packages for installing and managing the MySQL server, client, and other components on the current Debian and Ubuntu releases. Instructions for using the MySQL APT Repository are available in A Quick Guide to ...
https://dev.mysql.com/doc/refman/8.0/en/linux-installation-sles-repo.html
The MySQL SLES repository provides RPM packages for installing and managing the MySQL server, client, and other components on SUSE Enterprise Linux Server. Instructions for using the MySQL SLES repository are available in A Quick Guide to Using the ...