Search Results
https://dev.mysql.com/doc/refman/9.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/9.7/en/using-log-files.html
If you find the text mysqld restarted in the error log (normally a file named host_name.err) you probably have found a query that causes mysqld to fail. Note that before starting mysqld with the general query log enabled, you should check all your ...
https://dev.mysql.com/doc/refman/9.7/en/using-mysqldump.html
The server writes one file as tab-delimited text, one line per table row. Tip Consider using the MySQL Shell dump utilities, which provide parallel dumping with multiple threads, file compression, and progress information display, as well as cloud ...
https://dev.mysql.com/doc/refman/9.7/en/verifying-md5-checksum.html
On Linux, it is part of the GNU Text Utilities package, which is available for a wide range of platforms. After you have downloaded a MySQL package, you should make sure that its MD5 checksum matches the one provided on the MySQL download pages.
https://dev.mysql.com/doc/refman/9.7/en/view-algorithms.html
For MERGE, the text of a statement that refers to the view and the view definition are merged such that parts of the view definition replace corresponding parts of the statement. The optional ALGORITHM clause for CREATE VIEW or ALTER VIEW is a ...
https://dev.mysql.com/doc/refman/9.7/en/view-restrictions.html
If a column is created from an expression, the default alias is the expression text, which can be quite long. The maximum number of tables that can be referenced in the definition of a view is 61. View processing is not optimized: It is not ...
https://dev.mysql.com/doc/refman/9.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 ...
https://dev.mysql.com/doc/refman/9.7/en/windows-troubleshooting.html
To determine its exact location from the value of the WINDIR environment variable, issue the following command from the command prompt: C:\> echo %WINDIR% You can create or modify an option file with any text editor, such as Notepad. When ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/backup-performance.html
Always check that mysqlbackup has completed successfully, either by verifying that mysqlbackup returned exit code 0, or by observing that mysqlbackup has printed the text “mysqlbackup completed OK!”. This section describes the performance ...
https://dev.mysql.com/doc/mysql-router/9.7/en/mysqlrouter.html
“User” in this context refers to a system login account, not a MySQL user listed in the grant tables. mysqlrouter Option Summaries mysqlrouter Option Descriptions MySQL Router accepts command line options that are passed into mysqlrouter to ...