Search Results
https://dev.mysql.com/doc/refman/8.4/en/security-guidelines.html
Anyone using MySQL on a computer connected to the Internet should read this section to avoid the most common security mistakes. In discussing security, it is necessary to consider fully protecting the entire server host (not just the MySQL server) ...
https://dev.mysql.com/doc/refman/8.4/en/show-columns.html
SHOW [EXTENDED] [FULL] {COLUMNS | FIELDS} {FROM | IN} tbl_name [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW COLUMNS displays information about the columns in a given table. SHOW COLUMNS displays information only for those columns for ...
https://dev.mysql.com/doc/refman/8.4/en/show-profile.html
Note The SHOW PROFILE and SHOW PROFILES statements are deprecated; expect them to be removed in a future MySQL release. Use the Performance Schema instead; see Section 29.19.1, “Query Profiling Using Performance Schema”. To control profiling, ...
https://dev.mysql.com/doc/refman/8.4/en/windows-start-service.html
On Windows, the recommended way to run MySQL is to install it as a Windows service, so that MySQL starts and stops automatically when Windows starts and stops. A MySQL server installed as a service can also be controlled from the command line using ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-system-monitoring.html
For general X Plugin monitoring, use the status variables that it exposes. For information specifically about monitoring the effects of message compression, see Monitoring Connection Compression for X Plugin. Monitoring SQL Generated by X Plugin ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.full.html
Most backup strategies start with a complete backup of the MySQL server, from which you can restore all databases and tables. After you have created a full backup, you might perform incremental backups (which are smaller and faster) for the next ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-add-package.html
add package {--basedir=|-b }path [{--hosts=|-h }host_list] package_name host_list: host[,host[,...]] This command creates a new package, or, if the package named package_name already exists, this command extends the package definition. The ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-backup-restore-fewer-data-nodes.html
Sometimes, you want to transfer data from your cluster to another one that has fewer data nodes—for example, when you want to scale down your cluster or prepare a smaller replica cluster for a replication setup. While the methods described in ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-store-result.html
MYSQL_RES * mysql_store_result(MYSQL *mysql) Description Note mysql_store_result() is a synchronous function. Its asynchronous counterpart is mysql_store_result_nonblocking(), for use by applications that require asynchronous communication with the ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-anomaly-detection-logs.html
Anomaly detection for logs allows you to detect anomalies in log data. To perform anomaly detection on logs, log data is cleaned, segmented, and encoded before running anomaly detection. The input table can only have the following columns: The ...