Search Results
https://dev.mysql.com/doc/refman/8.4/en/show-engine.html
Statistics for low-level operating system mutexes, which are implemented outside of InnoDB, are not reported. SHOW ENGINE INNODB MUTEX does not list mutexes and rw-locks for each buffer pool block, as the amount of output would be overwhelming on ...
https://dev.mysql.com/doc/refman/8.4/en/binary-installation.html
The mysql-files directory provides a convenient location to use as the value for the secure_file_priv system variable, which limits import and export operations to a specific directory. MySQL compressed tar file binary distributions have names of ...
https://dev.mysql.com/doc/refman/8.4/en/data-directory.html
All MySQL installations have certain standard databases: The mysql directory corresponds to the mysql system schema, which contains information required by the MySQL server as it runs. Information managed by the MySQL server is stored under a ...
https://dev.mysql.com/doc/x-devapi-userguide/en/processing-warnings.html
*/ By default all warnings are sent from the server to the client. session.setFetchWarnings() controls whether warnings are discarded at the server or are sent to the client. Similar to the execution of single statements committing or rolling back ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-config-starting.html
# MANAGEMENT NODE PARAMETERS [ndb_mgmd default] DataDir=path/to/management/server/data/directory # It is possible to use a different data directory for each management # server, but for ease of administration it is preferable to be # consistent.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-security-mysql-privileges.html
As with any other MySQL Server, user and privilege information is stored in the mysql system database. If you need to synchronize mysql system tables between SQL nodes, you can use standard MySQL replication to do so, or employ a script to copy ...
https://dev.mysql.com/doc/refman/8.4/en/windows-start-command-line.html
To start the mysqld server from the command line, you should start a console window (or “DOS window”) and enter this command: C:\> "C:\Program Files\MySQL\MySQL Server 8.4\bin\mysqld" The path to mysqld may vary depending on the install location ... The MySQL server can be started manually from the command ...It is the file with a suffix ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-temporary-tablespace.html
A pool of 10 temporary tablespaces is created when the server is started. Because the pool of session temporary tablespaces is recreated each time the server is started, space IDs for session temporary tablespaces are not persisted when the server ... InnoDB uses session temporary tablespaces and a global temporary ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-issues.html
All SQL nodes acting as sources and replicas are started with the system variable log_replica_updates enabled. However, you must not start any of the SQL nodes with the log_replica_updates system variable enabled. This is equivalent to setting the ...Examples of incidents are server failures, database resynchronization, some software updates, and some hardware changes.) When the replica encounters a gap in the replication log, it stops with an error ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication.html
Section 20.9, “Group Replication Variables” is a reference for the system variables specific to Group Replication. Groups can operate in a single-primary mode with automatic primary election, where only one server accepts updates at a time.