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/audit-log.html
The log contents include when clients connect and disconnect, and what actions they perform while connected, such as which databases and tables they access. By default, MySQL Enterprise Audit uses tables in the mysql system database for persistent ... Note MySQL Enterprise Audit is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-transaction-compression.html
When replica_parallel_type or slave_parallel_type is set to DATABASE, all the databases affected by the transaction are mapped before the transaction is scheduled. The use of binary log transaction compression with the DATABASE policy can reduce ...
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/charset-collation-information-schema.html
However, for values that correspond to objects that are represented in the file system, such as databases and tables, searches in INFORMATION_SCHEMA string columns can be case-sensitive or case-insensitive, depending on the characteristics of the ...
https://dev.mysql.com/doc/refman/8.0/en/charset-examples.html
Example 4: Database, Table, and Column Definition CREATE DATABASE d1 DEFAULT CHARACTER SET latin2 COLLATE latin2_czech_cs; USE d1; CREATE TABLE t1 ( c1 CHAR(10) ); We create a column without specifying its character set and collation. In this ...
https://dev.mysql.com/doc/refman/8.0/en/column-count-limit.html
The maximum row size for an InnoDB table, which applies to data stored locally within a database page, is slightly less than half a page for 4KB, 8KB, 16KB, and 32KB innodb_page_size settings. InnoDB restricts row size (for data stored locally ...
https://dev.mysql.com/doc/refman/8.0/en/creating-ssl-files-using-openssl.html
This section describes how to use the openssl command to set up SSL certificate and key files for use by MySQL servers and clients. The first example shows a simplified procedure such as you might use from the command line. The first two examples ...
https://dev.mysql.com/doc/refman/8.0/en/custom-benchmarks.html
Benchmark your application and database to find out where the bottlenecks are. A free benchmark suite is the Open Source Database Benchmark, available at http://osdb.sourceforge.net/. In most cases, performance problems turn out to be due to issues ...After fixing one bottleneck (or by replacing it with a “dummy” module), you can proceed to identify the next ...
https://dev.mysql.com/doc/refman/8.0/en/document-store.html
Traditionally, relational databases such as MySQL have usually required a schema to be defined before documents can be stored. This differs from working with a relational database and storing products in a table, when all columns of the table must ... This chapter introduces an alternative way of working with MySQL as a document store, sometimes referred to as “using ...
https://dev.mysql.com/doc/refman/8.0/en/error-message-elements.html
These indicate issues of interest to database administrators or that require DBA action. It is MySQL-specific and is not portable to other database systems. This section discusses how error messages originate within MySQL and the elements they ...