Search Results
https://dev.mysql.com/doc/refman/8.4/en/optimizing-server.html
This section discusses optimization techniques for the database server, primarily dealing with system configuration rather than tuning SQL statements. The information in this section is appropriate for DBAs who want to ensure performance and ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-rag.html
To define your natural-language query, set the @query variable: mysql> SET @query="AddYourQuery"; Replace AddYourQuery with your natural-language query. For example: mysql> SET @query="What is AutoML?"; To retrieve the augmented prompt, use the ...
https://dev.mysql.com/doc/refman/8.4/en/select-optimization.html
See Section 10.3.1, “How MySQL Uses Indexes” and Section 10.8.1, “Optimizing Queries with EXPLAIN”. (When you reach a certain level of expertise, reading the EXPLAIN plan might be your first step for every query.) Adjust the size and ...
https://dev.mysql.com/doc/refman/8.4/en/alter-user.html
Important Under some circumstances, ALTER USER may be recorded in server logs or on the client side in a history file such as ~/.mysql_history, which means that cleartext passwords may be read by anyone having read access to that information. ALTER ...In most cases, ALTER USER requires the global CREATE USER privilege, or the UPDATE privilege for the mysql system ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-full-text-plugins.html
MySQL supports server-side full-text parser plugins with MyISAM and InnoDB. #include <mysql/plugin.h> plugin.h defines the MYSQL_FTPARSER_PLUGIN server plugin type and the data structures needed to declare the plugin. In both contexts, the server ...This plugin performs parsing based on simpler rules than those used by the MySQL built-in full-text parser: Words are nonempty runs of whitespace ...
https://dev.mysql.com/doc/refman/8.4/en/version-tokens-reference.html
version_tokens_delete(name_list) Deletes tokens from the server's list of version tokens using the name_list argument and returns a binary string that indicates the outcome of the operation. | +------------------------------+ ...One set of functions ... The following discussion serves as a reference to these Version Tokens elements: Version Tokens Functions Version Tokens System Variables Version Tokens Functions The Version Tokens plugin library includes several ...
https://dev.mysql.com/doc/refman/8.4/en/option-files.html
The following group indicates that the sql_mode setting should be used only by MySQL servers with 8.4.x version numbers: [mysqld-8.4] sql_mode=TRADITIONAL Option File Inclusions It is possible to use !include directives in option files to include ...
https://dev.mysql.com/doc/internals/en/event-header-fields.html
v1 event header: +============================+ | timestamp 0 : 4 | +----------------------------+ | type_code 4 : 1 | +----------------------------+ | server_id 5 : 4 | +----------------------------+ | event_length 9 : 4 | ...The value of this ...
https://dev.mysql.com/doc/workbench/en/workbench-faq.html
These server variables are then reset at the end of the script using the following statements: SET SQL_MODE=@OLD_SQL_MODE; SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS; Workbench Behavior A.1. This sets the ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-special-options.html
For TTS backups for replica servers, use the --replica-info option to have the file backup_gtid_executed.sql generated and included in the backups. For TTS backups for replica servers, use the --slave-info option to have the file ... These options ...The option is an alias of --slave-info, which has been decprecated ...