Search Results
https://dev.mysql.com/doc/refman/8.4/en/server-system-variables.html
Note If you set this variable to ALL, you should not use MyISAM tables from within another program (such as another MySQL server or myisamchk) when the tables are in use. To explicitly cause the server to refuse or permit LOAD DATA LOCAL statements ... The MySQL server maintains many system variables that affect its ...Some variables are read-only, and their values are determined by the system environment, by how MySQL is ...
https://dev.mysql.com/doc/mysql-errors/8.4/en/server-error-reference.html
The MySQL server writes some error messages to its error log, and sends others to client programs. Example server-side error messages written to the error log: 2018-10-28T13:01:32.735983Z 0 [Note] [MY-010303] [Server] Skipping generation of SSL ...
https://dev.mysql.com/doc/refman/8.4/en/programs-server.html
This section describes mysqld, the MySQL server, and several programs that are used to start the server.
https://dev.mysql.com/doc/refman/8.4/en/server-options.html
When you start the mysqld server, you can specify program options using any of the methods described in Section 6.2.2, “Specifying Program Options”. However, in most cases it is desirable to make sure that the server uses the same options each ...The most common methods are to provide options in an option file or on the command ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump.html
--comments, -i Command-Line Format --comments Write additional information in the dump file such as program version, server version, and host. It dumps one or more MySQL databases for backup or transfer to another SQL server. Dumps can be easily ...
https://dev.mysql.com/doc/refman/8.4/en/mysqladmin.html
You can use it to check the server's configuration and current status, to create and drop databases, and more. debug Tells the server to write debug information to the error log. This changes the password to new_password for the account that you use ...Invoke mysqladmin like this: mysqladmin [options] command [command-arg] [command [command-arg]] ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-create-alter-drop-server.html
The statements CREATE SERVER, ALTER SERVER, and DROP SERVER are not written to the binary log, regardless of the binary logging format that is in use.
https://dev.mysql.com/doc/refman/8.4/en/programs-overview.html
There is one RPM for the server, another for client programs, and so forth. The MySQL server, mysqld, is the main program that does most of the work in a MySQL installation. To use client programs, mysqld must be running, because clients gain access ...Later sections provide a more detailed description of each one, with the exception of NDB Cluster ...This script is used on systems that ...
https://dev.mysql.com/doc/refman/8.4/en/stored-programs-logging.html
(Binary log events differ from scheduled event stored objects.) The binary log has two important purposes: For replication, the binary log is used on source replication servers as a record of the statements to be sent to replica servers. However, if ... The binary log contains information about SQL statements that modify database ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-server-clients.html
In a C program, you can specify the socket file or port number arguments in the mysql_real_connect() call. You can also have the program read option files by calling mysql_options(). Other programming interfaces may provide similar capabilities for ...Start the client with --protocol=TCP to connect using TCP/IP, --protocol=SOCKET to connect using a Unix socket file, --protocol=PIPE to connect using a named pipe, or --protocol=MEMORY to connect using shared ...