Search Results
https://dev.mysql.com/doc/mysql-ai/9.5/en/myai-installation-clean.html
Run the MySQL AI installer to install and configure MySQL AI server and tools. You can replace the default port number (8000) with another number for MySQL Shell GUI web server to listen for connections. You can replace the default HTTPS port number ... Installing MySQL AI requires the following steps: Install the MySQL AI ...
https://dev.mysql.com/doc/refman/8.4/en/windows-testing.html
If you have set a password for the root account, deleted the anonymous account, or created a new user account, then to connect to the MySQL server you must use the appropriate -u and -p options with the commands shown previously. See Section 6.2.4, ...In this case, start mysqld with the skip_name_resolve system variable enabled and use only localhost and IP addresses in the Host column of the MySQL grant ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-performanceschema-category.html
At server startup, you can specify this variable with no value or a value of 1 to enable it, or with a value of 0 to disable it. The value of performance_schema_max_file_handles should be greater than the value of open_files_limit: open_files_limit ... Lists the Performance Schema configuration metrics and provides a brief description of ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-install.html
Data directory initialization and subsequent server startup steps fail if this library is not installed locally. It is also used to run the mysqld server process, as defined in the systemd mysqld.service file (see Starting the Server using systemd).
https://dev.mysql.com/doc/refman/8.4/en/backup-methods.html
To get a consistent backup, stop the server or lock and flush the relevant tables: FLUSH TABLES tbl_list WITH READ LOCK; You need only a read lock; this enables other clients to continue to query the tables while you are making a copy of the files ...Making a Hot Backup with MySQL Enterprise Backup Customers of MySQL Enterprise Edition can use the MySQL Enterprise Backup product to do physical backups of entire instances or selected databases, tables, or ...
https://dev.mysql.com/doc/refman/8.4/en/binary-installation.html
Data directory initialization and subsequent server startup steps fail if this library is not installed locally. $> groupadd mysql $> useradd -r -g mysql -s /bin/false mysql Note Because the user is required only for ownership purposes, not login ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-statements-current-table.html
To change this value, set the performance_schema_max_sql_text_length system variable at server startup. OBJECT_SCHEMA, OBJECT_NAME, OBJECT_TYPE For nested statements (stored programs), these columns contain information about the parent statement.
https://dev.mysql.com/doc/refman/8.4/en/stored-routines.html
A stored routine is a set of SQL statements that can be stored in the server. Stored routines can provide improved performance because less information needs to be sent between the server and the client. The tradeoff is that this does increase the ...Once this has been done, clients don't need to keep reissuing the individual statements but can refer to the stored routine ...
https://dev.mysql.com/doc/refman/8.4/en/windows-choosing-package.html
The package formats described in this section are: MySQL Installation MSI MySQL noinstall ZIP Archives MySQL Docker Images MySQL Installation MSI This package has a file name similar to mysql-community-8.4.6.msi or mysql-commercial-8.4.6.msi, and ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-configuration-commands.html
MySQL Cluster Manager simplifies this configuration scheme by treating all 3 types of configuration data as attributes, where the term “attribute” refers to a MySQL NDB Cluster configuration parameter, a MySQL Server variable, or a command-line ...We begin with a discussion of what we mean by the term “configuration attribute”, and how this relates to the manual configuration of a MySQL NDB Cluster using MySQL NDB Cluster configuration parameters and MySQL Server options and variables that you may already be familiar ...