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/upgrading-from-previous-series.html
Implementation of the ONLY_FULL_GROUP_BY SQL mode has been made more sophisticated, to no longer reject deterministic queries that previously were rejected. In consequence, ONLY_FULL_GROUP_BY is now enabled by default, to prohibit nondeterministic ... Before upgrading to MySQL 5.7, review the changes described in this section to identify those that apply to your current MySQL installation and ...
https://dev.mysql.com/doc/refman/5.7/en/grant.html
For example: CREATE USER 'jeffrey'@'localhost' IDENTIFIED BY 'password'; GRANT ALL ON db1.* TO 'jeffrey'@'localhost'; GRANT SELECT ON db2.invoice TO 'jeffrey'@'localhost'; ALTER USER 'jeffrey'@'localhost' WITH MAX_QUERIES_PER_HOUR 90; Note Examples ...[REQUIRE {NONE | tls_option [[AND] tls_option] ...}] [WITH {GRANT OPTION | resource_option} ...] GRANT PROXY ON user TO user [, user] ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-introduction.html
You can filter, sort, concatenate, and transform the results from INFORMATION_SCHEMA queries into whatever format your application needs, such as a data structure or a text representation to parse. Performance Considerations INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-autocommit-commit-rollback.html
If autocommit mode is enabled, each SQL statement forms a single transaction on its own. By default, MySQL starts the session for each new connection with autocommit enabled, so MySQL does a commit after each SQL statement if that statement did not ...
https://dev.mysql.com/doc/refman/5.7/en/insert-on-duplicate.html
SELECT statements, these rules apply regarding acceptable forms of SELECT query expressions that you can refer to in an ON DUPLICATE KEY UPDATE clause: References to columns from queries on a single table, which may be a derived table. References to ... If you specify an ON DUPLICATE KEY UPDATE clause and a row to be inserted would cause a duplicate value in a UNIQUE index or PRIMARY KEY, an UPDATE of the old row ...
https://dev.mysql.com/doc/refman/5.7/en/known-issues.html
With statement-based binary logging, the source server writes the executed queries to the binary log. If and only if the preceding queries have no ORDER BY clause guaranteeing a deterministic order. The easiest way to avoid this problem is to add an ... This section lists known issues in recent versions of ...
https://dev.mysql.com/doc/refman/5.7/en/monitor-innodb-mutex-waits-performance-schema.html
$> ./mysqlslap --auto-generate-sql --concurrency=100 --iterations=10 --number-of-queries=1000 --number-char-cols=6 --number-int-cols=6; Query the wait event data. In this example, wait event data is queried from the ... A mutex is a synchronization ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-column-indexes.html
MySQL can use multiple-column indexes for queries that test all the columns in the index, or queries that test just the first column, the first two columns, the first three columns, and so on. If you specify the columns in the right order in the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-online-operations.html
MySQL NDB Cluster 7.5 and 7.6 support online table schema changes using ALTER TABLE ... NDB Cluster handles COPY and INPLACE as described in the next few paragraphs. For ALGORITHM=COPY, the mysqld NDB Cluster handler performs the following actions: ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-tables.html
It can be used to detect malformed queries sent by clients. Statement events occur at a high level of the event hierarchy. Within the event hierarchy, wait events nest within stage events, which nest within statement events, which nest within ...