PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/common-errors.html
This section lists some errors that users frequently encounter when running MySQL programs. Although the problems show up when you try to run client programs, the solutions to many of the problems involves changing the configuration of the MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/compiler-characteristics.html
The notes in this section apply for binary distributions provided by Oracle Corporation or that you compile yourself from source. In some cases, the compiler used to build MySQL affects the features available for use. icc (Intel C++ Compiler) ...
https://dev.mysql.com/doc/refman/5.7/en/compressed-format.html
This minimizes disk usage, which is helpful when using slow disks (such as CD-ROMs). Compressed storage format is a read-only format that is generated with the myisampack tool. Compressed tables have the following characteristics: Compressed tables ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-like.html
This means that, if the current SQL mode is different from the mode in effect when the original table was created, the table definition might be considered invalid for the new mode, and the statement fails. LIKE to create an empty table based on the ...
https://dev.mysql.com/doc/refman/5.7/en/creating-many-tables.html
You can reduce this overhead by increasing the number of entries permitted in the table cache. If you have many MyISAM tables in the same database directory, open, close, and create operations are slow. If you execute SELECT statements on many ...
https://dev.mysql.com/doc/refman/5.7/en/creating-rsa-files-using-openssl.html
This section describes how to use the openssl command to set up the RSA key files that enable MySQL to support secure password exchange over unencrypted connections for accounts authenticated by the sha256_password plugin. Note There are easier ...
https://dev.mysql.com/doc/refman/5.7/en/creating-spatial-indexes.html
For InnoDB and MyISAM tables, MySQL can create spatial indexes using syntax similar to that for creating regular indexes, but using the SPATIAL keyword. For storage engines that support nonspatial indexing of spatial columns, the engine creates a ...
https://dev.mysql.com/doc/refman/5.7/en/custom-benchmarks.html
To avoid problems like this, benchmark your whole application under the worst possible load: The mysqlslap program can be helpful for simulating a high load produced by multiple clients issuing queries simultaneously. Benchmark your application and ...
https://dev.mysql.com/doc/refman/5.7/en/data-change-optimization.html
This section explains how to speed up data change statements: INSERT, UPDATE, and DELETE. Traditional OLTP applications and modern web applications typically do many small data change operations, where concurrency is vital. Data analysis and ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking-installation.html
This section describes how to install or uninstall MySQL Enterprise Data Masking and De-Identification, which is implemented as a plugin library file containing a plugin and several loadable functions. For general information about installing or ...