PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/log-destinations.html
To display the current structure of the log tables, use these statements: SHOW CREATE TABLE mysql.general_log; SHOW CREATE TABLE mysql.slow_log; Log contents are accessible through SQL statements. The log table implementation has the following ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-windows-command-line-servers.html
To do this, create an option file for each server and tell the server the file name with a --defaults-file option when you run it. To shut down the servers, connect to each using the appropriate port number: C:\> C:\mysql\bin\mysqladmin --port=3307 ... The procedure for starting a single MySQL server manually from the command line is described in Section 2.3.4.6, “Starting MySQL from the Windows Command ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-prepared-statements-instances-table.html
Instrument Server Command statement/com/Prepare COM_STMT_PREPARE statement/com/Execute COM_STMT_EXECUTE statement/sql/prepare_sql SQLCOM_PREPARE statement/sql/execute_sql SQLCOM_EXECUTE The Performance Schema manages the contents of the ... The ...
https://dev.mysql.com/doc/refman/5.7/en/symbolic-links-to-tables.html
For InnoDB tables, use the alternative technique explained in Section 14.6.1.2, “Creating Tables Externally” instead. To instruct a running MySQL server to perform the symlinking, use the DATA DIRECTORY and INDEX DIRECTORY options to CREATE ...
https://dev.mysql.com/doc/refman/5.7/en/windows-troubleshooting.html
Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist These messages often occur when the MySQL base or data directories are installed in different locations than the default locations (C:\Program Files\MySQL\MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-logging-configuration.html
The audit log plugin can also control which audited events are written to the audit log file, based on event content or the account from which events originate. For best security, write the audit log to a directory accessible only to the MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/installing-mysql-shell-starting.html
You need an account name and password to establish a session using MySQL Shell. On the same system where the server instance is running, open a terminal window (command prompt on Windows) and start MySQL Shell with the following command: mysqlsh ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-consumer-configurations.html
The consumer settings in the setup_consumers table form a hierarchy from higher levels to lower. The following discussion describes how consumers work, showing specific configurations and their effects as consumer settings are enabled progressively ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-data-encryption.html
When an application or authenticated user wants to access encrypted data, InnoDB uses a master encryption key to decrypt the tablespace key. Important Once encrypted tablespaces are created in a MySQL instance, the keyring plugin that was loaded ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statement-performance-analyzer.html
Creates a report of the statements running on the server. Parameters in_action ENUM('snapshot', 'overall', 'delta', 'create_tmp', 'create_table', 'save', 'cleanup'): The action to take. If in_table is NULL and no snapshot exists, a new snapshot is ...The views are calculated based on the overall and/or delta ...