PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-digests.html
Once that amount of space is used during digest computation, truncation occurs: no further tokens from a parsed statement are collected or figure into its digest value. This gives the developer insight into which parts of the application need ...
https://dev.mysql.com/doc/refman/5.7/en/perl-installation.html
For example, to unpack and build a DBI distribution, use a procedure such as this: Unpack the distribution into the current directory: $> gunzip < DBI-VERSION.tar.gz | tar xvf - This command creates a directory named DBI-VERSION. Change location ...
https://dev.mysql.com/doc/refman/5.7/en/pluggable-authentication.html
If the plugin is built into libmysqlclient, it is available by default. This enables the connector to support connections though accounts that require client-side plugins now built into libmysqlclient (such as the cleartext plugin needed for PAM ...
https://dev.mysql.com/doc/refman/5.7/en/pluggable-storage.html
MySQL Server uses a pluggable storage engine architecture that enables storage engines to be loaded into and unloaded from a running MySQL server. Plugging in a Storage Engine Before a storage engine can be used, the storage engine plugin shared ...
https://dev.mysql.com/doc/refman/5.7/en/precision-math-decimal-characteristics.html
(There is also a limit on how long the text of DECIMAL literals can be; see Section 12.21.3, “Expression Handling”.) Values for DECIMAL columns are stored using a binary format that packs nine decimal digits into 4 bytes. If you insert +0003.1 ... This section discusses the characteristics of the DECIMAL data type (and its synonyms), with particular regard to the following topics: Maximum number of digits Storage format Storage requirements The nonstandard MySQL extension to the upper range of DECIMAL columns The declaration syntax for a DECIMAL column is ...
https://dev.mysql.com/doc/refman/5.7/en/privilege-changes.html
If the mysqld server is started without the --skip-grant-tables option, it reads all grant table contents into memory during its startup sequence. If you modify the grant tables indirectly using an account-management statement, the server notices ...The in-memory tables become effective for access control at that ...
https://dev.mysql.com/doc/refman/5.7/en/query-cache-operation.html
Note The query cache is deprecated as of MySQL 5.7.20, and is removed in MySQL 8.0. This section describes how the query cache works when it is operational. Section 8.10.3.3, “Query Cache Configuration”, describes how to control whether it is ...
https://dev.mysql.com/doc/refman/5.7/en/rename-table.html
If a table has triggers, attempts to rename the table into a different database fail with a Trigger in wrong schema (ER_TRG_IN_WRONG_SCHEMA) error. RENAME TABLE works for views, except that views cannot be renamed into a different database. RENAME ...
https://dev.mysql.com/doc/refman/5.7/en/repair-table-optimization.html
For key_buffer_size, you must take into account that the buffer is shared with those users. REPAIR TABLE for MyISAM tables is similar to using myisamchk for repair operations, and some of the same performance optimizations apply: myisamchk has ...
https://dev.mysql.com/doc/refman/5.7/en/replication-administration-skip.html
Make sure you do not skip too far forward and go into the next event group or transaction, as this then causes it to be skipped as well. Make sure that you have identified the position accurately, because this statement does not take event groups ...