Search Results
https://dev.mysql.com/doc/refman/9.7/en/binary-log.html
The binary log contains “events” that describe database changes such as table creation operations or changes to table data. MySQL binary log files and relay log files can be encrypted, helping to protect these files and the potentially ...It ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-information-schema-temp-table-info.html
INNODB_TEMP_TABLE_INFO provides information about user-created InnoDB temporary tables that are active in the InnoDB instance. Create a simple InnoDB temporary table: mysql> CREATE TEMPORARY TABLE t1 (c1 INT PRIMARY KEY) ENGINE=INNODB; Query ...It ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-standard-monitor.html
The Lock Monitor is the same as the Standard Monitor except that it includes additional lock information. Enabling either monitor for periodic output turns on the same output stream, but the stream includes extra information if the Lock Monitor is ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-config-file.html
When --initial is used, the global configuration file is re-read, any existing cache files are deleted, and the management server creates a new configuration cache. If they differ, the management server creates a new configuration cache; any ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndb-mgmd.html
This file is created by the user and read by the management server. Otherwise—that is, if you wish to disable configuration caching for a management server that has already created a configuration cache—you must stop the management server, ...
https://dev.mysql.com/doc/refman/9.7/en/show-privileges.html
row *************************** Privilege: Create Context: Databases,Tables,Indexes Comment: To create new databases and tables *************************** 4. row *************************** Privilege: Create routine Context: Databases Comment: To ... SHOW PRIVILEGES SHOW PRIVILEGES shows the list of system privileges that the MySQL server ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/stored-routines-privileges.html
The MySQL grant system takes stored routines into account as follows: The CREATE ROUTINE privilege is needed to create stored routines. This privilege is granted automatically to the creator of a routine if necessary, and dropped from the creator ...The ALTER ROUTINE privilege is needed to alter or drop stored ...
https://dev.mysql.com/doc/refman/9.7/en/using-systemd.html
This script assists in creating the error log file only if the log location matches a pattern (/var/log/mysql*.log for RPM platforms, /var/log/mysql/*.log for Debian platforms). In other cases, the error log directory must be writable or the error ...If you install MySQL from a source distribution on a platform that uses systemd, obtain systemd support for MySQL by configuring the distribution using the -DWITH_SYSTEMD=1 CMake ...
https://dev.mysql.com/doc/mysql-router/9.7/en/mysql-router-deploying-bootstrapping.html
This example creates a standalone MySQL Router instance using the --directory option, enables sockets, uses --account to customize Router's MySQL username, and sets --account-create to always to only bootstrap if the account does not already exist.