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/myisam-table-maintenance.html
myisamchk operations that affect indexes can cause MyISAM FULLTEXT indexes to be rebuilt with full-text parameters that are incompatible with the values used by the MySQL server. This section discusses how to use myisamchk to check or repair MyISAM ...
https://dev.mysql.com/doc/refman/5.7/en/mysqladmin.html
If the --verbose option is given, the output is like that of SHOW FULL PROCESSLIST. --enable-cleartext-plugin Command-Line Format --enable-cleartext-plugin Type Boolean Default Value FALSE Enable the mysql_clear_password cleartext authentication ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlshow.html
--enable-cleartext-plugin Command-Line Format --enable-cleartext-plugin Introduced 5.7.10 Type Boolean Default Value FALSE Enable the mysql_clear_password cleartext authentication plugin. (See Section 6.4.1.6, “Client-Side Cleartext Pluggable ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-table.html
After doing substantial insert, update, or delete operations on columns that are part of a FULLTEXT index in an InnoDB table. OPTIMIZE TABLE using online DDL is not supported for InnoDB tables that contain FULLTEXT indexes. To keep the index ...
https://dev.mysql.com/doc/refman/5.7/en/password-security-user.html
For example: $> chmod 600 .my.cnf To name from the command line a specific option file containing the password, use the --defaults-file=file_name option, where file_name is the full path name to the file. Passwords can be written as plain text in ...
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. For a full explanation ... 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/replication-snapshot-method.html
This method also does not work reliably if the source and replica have different values for ft_stopword_file, ft_min_word_len, or ft_max_word_len and you are copying tables having full-text indexes. If the database on the source contains existing ...
https://dev.mysql.com/doc/refman/5.7/en/server-plugins.html
The plugins supported by this interface include, but are not limited to, storage engines, INFORMATION_SCHEMA tables, full-text parser plugins, partitioning support, and server extensions. MySQL supports an plugin API that enables creation of server ...
https://dev.mysql.com/doc/refman/5.7/en/uninstall-plugin.html
For example, if a full-text parser plugin is associated with a FULLTEXT index on the table, uninstalling the plugin makes the table unusable. UNINSTALL PLUGIN plugin_name This statement removes an installed server plugin. It requires the DELETE ...
https://dev.mysql.com/doc/refman/5.7/en/windows-symbolic-links.html
On Windows, symbolic links can be used for database directories. This enables you to put a database directory at a different location (for example, on a different disk) by setting up a symbolic link to it. Use of database symlinks on Windows is ...