Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-doublewrite-buffer.html
If there is an operating system, storage subsystem, or unexpected mysqld process exit in the middle of a page write, InnoDB can find a good copy of the page from the doublewrite buffer during crash recovery. Data is written to the doublewrite buffer ... The doublewrite buffer is a storage area where InnoDB writes pages flushed from the buffer pool before writing the pages to their proper positions in the InnoDB data ...
https://dev.mysql.com/doc/refman/8.4/en/system-variables-controlling-tracing.html
optimizer_trace_features: Enables or disables selected features of the MySQL Optimizer, using the syntax shown here: SET optimizer_trace_features=option=value[,option=value][,...] option: {greedy_search | range_optimizer | dynamic_range | ... The ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-run-chat.html
By default, GenAI Chat searches for an answer to a query across all ingested documents by automatically discovering available vector stores, and returns the answer along with relevant citations. And, it uses only the name of the embedding model used ... When you run GenAI Chat, it automatically loads the llama3.2-3b-instruct-v1 ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-install-agent-remote.html
Typically, the Agent runs on the same machine as the MySQL servers that it is monitoring. To monitor MySQL servers running on remote hosts, you can install the Agent on a machine other than the one hosting the MySQL server. The process for ...For ...Remote Monitoring Limitations Remote monitoring does not provide operating system level data, such as CPU, file, and network utilization ...
https://dev.mysql.com/doc/refman/8.4/en/mysqld.html
mysqld, also known as MySQL Server, is a single multithreaded program that does most of the work in a MySQL installation. MySQL Server manages access to the MySQL data directory that contains databases and tables. Note Some installation packages ...
https://dev.mysql.com/doc/refman/8.4/en/test-pluggable-authentication.html
MySQL includes a test plugin that checks account credentials and logs success or failure to the server error log. To be usable by the server, the plugin library file must be located in the MySQL plugin directory (the directory named by the ...The ...This is a loadable plugin (not built in) and must be installed prior to ...
https://dev.mysql.com/doc/refman/8.4/en/server-status-variable-reference.html
The following table lists all status variables applicable within mysqld. The last column indicates whether the scope for each variable is Global, Session, or both. Please see the corresponding item descriptions for details on setting and using the ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-logging-configuration.html
For best security, write the audit log to a directory accessible only to the MySQL server and to users with a legitimate reason to view the log. Adding Query Statistics for Outlier Detection In MySQL 8.4, you can extend log files in JSON format with ...Naming Conventions for Audit Log Files To configure the audit log file name, set the audit_log_file system variable at server ... This section describes how to configure audit logging characteristics, such as the file to which the audit ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-view-changes.html
Figure 20.8 Stable Group View Change: a Member Joins Whenever a new member joins the group and therefore a view change is performed, every online server queues a view change log event for execution. This is queued because before the view change, ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-init-startup-configuration.html
Normally, InnoDB is initialized when the MySQL server is started for the first time. You can place InnoDB options in the [mysqld] group of any option file that your server reads when it starts. Also, ensure sure that the MySQL server has the proper ...The locations of MySQL option files are described in Section 6.2.2.2, “Using Option ... The first decisions to make about InnoDB configuration involve the configuration of data files, log ...