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/optimizing-innodb-diskio.html
Review settings for the following configuration options when using non-rotational storage: innodb_checksum_algorithm The crc32 option uses a faster checksum algorithm and is recommended for fast storage systems. This change could cause a performance ... If you follow best practices for database design and tuning techniques for SQL operations, but your database is still slow due to heavy disk I/O activity, consider these disk I/O ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-range-list.html
You can see that this is the case by re-running the previous SELECT query: mysql> SELECT * FROM tr WHERE purchased -> BETWEEN '1995-01-01' AND '1999-12-31'; Empty set (0.00 sec) Note DROP PARTITION is supported by native partitioning in-place APIs ... Adding and dropping of range and list partitions are handled in a similar fashion, so we discuss the management of both sorts of partitioning in this ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-binary-log-transaction-compression-stats-table.html
Compressed transactions are grouped by the compression algorithm used, and uncompressed transactions are grouped together with the compression algorithm stated as NONE, so the compression ratio can be calculated. This table shows statistical ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-convenience-functions.html
mysql> SET @pt1 = ST_GeomFromText('POINT(0 0)'); mysql> SET @pt2 = ST_GeomFromText('POINT(1 1)'); mysql> SELECT ST_AsText(ST_MakeEnvelope(@pt1, @pt2)); +----------------------------------------+ | ST_AsText(ST_MakeEnvelope(@pt1, @pt2)) | ... The ...
https://dev.mysql.com/doc/refman/8.0/en/thread-pool-operation.html
The thread pool exposes system variables that may be used to configure its operation: thread_pool_algorithm: The concurrency algorithm to use for scheduling. If thread_pool_max_active_query_threads is 0, the default algorithm applies as just ... The ...
https://dev.mysql.com/doc/refman/8.0/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/8.0/en/create-spatial-reference-system.html
SRID values must be unique, so if neither OR REPLACE nor IF NOT EXISTS is specified, an error occurs if an SRS definition with the given srid value already exists. With CREATE OR REPLACE syntax, any existing SRS definition with the same SRID value ...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 ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-linux-rpm.html
This section covers the steps necessary to install the correct executables for each type of NDB Cluster 8.0 node using RPM packages supplied by Oracle. As an alternative to the method described in this section, Oracle provides MySQL Repositories ...
https://dev.mysql.com/doc/refman/8.0/en/regexp.html
REGEXP_REPLACE() takes these optional arguments: pos: The position in expr at which to start the search. If omitted, the default is 0 (which means “replace all occurrences”). If you are migrating applications using [[:alpha:]] or [[:digit:]] ...
https://dev.mysql.com/doc/refman/8.0/en/alter-tablespace.html
The INPLACE algorithm is used when altering the ENCRYPTION attribute of a general tablespace or the mysql system tablespace. The INPLACE algorithm permits concurrent DML on tables that reside in the tablespace. It can be used to add a new data file ...