Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-disabling-tablespace-path-validation.html
Disabling path validation improves startup time on systems with a large number of tablespace files. If log_error_verbosity is set to 3, the following message is printed at startup when tablespace path validation is disabled: [InnoDB] Skipping InnoDB ... At startup, InnoDB scans directories defined by the innodb_directories variable for tablespace ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-disabling.html
The audit_log_disable variable permits disabling audit logging for all connecting and connected sessions. The audit_log_disable variable can be set in a MySQL Server option file, in a command-line startup string, or at runtime using a SET ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-disabling.html
The X Plugin can be disabled at startup by either setting mysqlx=0 in your MySQL configuration file, or by passing in either --mysqlx=0 or --skip-mysqlx when starting the MySQL server. Alternatively, use the -DWITH_MYSQLX=OFF CMake option to ...
https://dev.mysql.com/doc/refman/8.4/en/string-functions.html
Also, if strict SQL mode is enabled, the result from CHAR() becomes NULL. You can disable this behavior by setting the value of the --binary-as-hex to 0 when starting the mysql client. mysql> SELECT INSERT('Quadratic', 3, 4, 'What'); -> 'QuWhattic' ...For functions that operate on string positions, the first position is numbered ...
https://dev.mysql.com/doc/refman/8.4/en/mysqld-safe.html
mysqld_safe is the recommended way to start a mysqld server on Unix. mysqld_safe adds some safety features such as restarting the server when an error occurs and logging runtime information to an error log. On these platforms, mysqld_safe is not ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-thread-safe.html
unsigned int mysql_thread_safe(void) Description This function indicates whether the client library is compiled as thread-safe. Return Values 1 if the client library is thread-safe, 0 otherwise.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-shutdown-restart.html
To shut down the cluster, enter the following command in a shell on the machine hosting the management node: $> ndb_mgm -e shutdown The -e option here is used to pass a command to the ndb_mgm client from the shell. The command causes the ndb_mgm, ...
https://dev.mysql.com/doc/refman/8.4/en/stored-programs-logging.html
Binary logging is enabled by default, and is disabled only if you start the server with --skip-log-bin or --disable-log-bin at startup. With mixed format, when a stored function, stored procedure, trigger, event, or prepared statement contains ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-system-variables.html
In single-primary mode, this option must be disabled on all group members. group_replication_flow_control_mode Command-Line Format --group-replication-flow-control-mode=value System Variable group_replication_flow_control_mode Scope Global Dynamic ...For instructions on doing this safely, see Section 20.5.2, “Restarting a ... This ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-special-options.html
--safe-replica-backup-timeout=SECONDS For a replication setup, the option specifies the time (in seconds) mysqlbackup will wait for Replica_open_temp_tables to become “0” (which happens when no temporary tables are open) to complete the backup ... These options are for backing up database servers that play specific roles in replication, or contain certain kinds of data that require special care in backing ...