PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-table-characteristics.html
Privileges are as for other databases and tables: To retrieve from performance_schema tables, you must have the SELECT privilege. The name of the performance_schema database is lowercase, as are the names of tables within it. Many tables in the ...
https://dev.mysql.com/doc/refman/5.7/en/problems-connecting.html
Check this by executing mysql -u root mysql and issuing this SQL statement: SELECT * FROM user; The result should include a row with the Host and User columns matching your client's host name and your MySQL user name. After trying to connect from ...
https://dev.mysql.com/doc/refman/5.7/en/procedure-analyse.html
To obtain this analysis, append PROCEDURE ANALYSE to the end of a SELECT statement: SELECT ... PROCEDURE ANALYSE([max_elements,[max_memory]]) For example: SELECT col1, col2 FROM table1 PROCEDURE ANALYSE(10, 2000); The results show some statistics ...
https://dev.mysql.com/doc/refman/5.7/en/query-cache-configuration.html
When using the Windows Configuration Wizard, the query cache may be enabled (that is, set to a nonzero value) due to the selected configuration. A value of 1 or ON enables caching except of those statements that begin with SELECT SQL_NO_CACHE. A ...
https://dev.mysql.com/doc/refman/5.7/en/query-log.html
In addition, the query log may contain statements that only select data while such statements are never written to the binary log. To specify the log destination, use the log_output system variable (as described in Section 5.4.1, “Selecting ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-create-if-not-exists.html
Similarly, every CREATE TABLE IF NOT EXISTS statement without a SELECT is replicated, whether or not the table already exists on the source. SELECT follows somewhat different rules; see Section 16.4.1.6, “Replication of CREATE TABLE ... IF NOT ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-gtids.html
SELECT statements CREATE TEMPORARY TABLE or DROP TEMPORARY TABLE statements inside transactions Transactions or statements that update both transactional and nontransactional tables. Using SELECT @@ENFORCE_GTID_CONSISTENCY, SHOW VARIABLES LIKE ...
https://dev.mysql.com/doc/refman/5.7/en/replication-sbr-rbr.html
SELECT requires a greater number of row-level locks than with row-based replication. SELECT, a CREATE statement is generated from the table definition and replicated using statement-based format, while the row insertions are replicated using ...For ...
https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html
For a server that is running as a Windows service, go to the Services manager: From the Start menu, select Control Panel, then Administrative Tools, then Services. Open a console window to get to the command prompt: From the Start menu, select Run, ... If you have never assigned a root password for MySQL, the server does not require a password at all for connecting as ...
https://dev.mysql.com/doc/refman/5.7/en/set-variable.html
For example, you can retrieve system variable values in a SELECT statement like this: SELECT @@GLOBAL.sql_mode, @@SESSION.sql_mode, @@sql_mode; Note A reference to a system variable in an expression as @@var_name (with @@ rather than @@GLOBAL.