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/mysql-enterprise-audit.html
MySQL Enterprise Edition includes MySQL Enterprise Audit, implemented using a server plugin. MySQL Enterprise Audit uses the open MySQL Audit API to enable standard, policy-based monitoring and logging of connection and query activity executed on ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-enterprise-firewall.html
MySQL Enterprise Edition includes MySQL Enterprise Firewall, an application-level firewall that enables database administrators to permit or deny SQL statement execution based on matching against allowlists of accepted statement patterns. This ...
https://dev.mysql.com/doc/refman/5.7/en/mysql.html
mysql is a simple SQL shell with input line editing capabilities. When used interactively, query results are presented in an ASCII-table format. When used noninteractively (for example, as a filter), the result is presented in tab-separated format.
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-upgrade-testing.html
On the production server: $> mysqldump --all-databases --no-create-info > dump-data.sql On the upgraded server: $> mysql < dump-data.sql Now check the table contents and run some test queries. When contemplating a MySQL upgrade, it is prudent to ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump.html
If --set-gtid-purged=ON is required, it can be used with --lock-all-tables, but this can prevent parallel queries while mysqldump is being run. The mysqldump client utility performs logical backups, producing a set of SQL statements that can be ...
https://dev.mysql.com/doc/refman/5.7/en/numeric-type-attributes.html
Note The ZEROFILL attribute is ignored for columns involved in expressions or UNION queries. MySQL supports an extension for optionally specifying the display width of integer data types in parentheses following the base keyword for the type. For ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-multi-tables.html
Some techniques for keeping individual queries fast involve splitting data across many tables. When the number of tables runs into the thousands or even millions, the overhead of dealing with all these tables becomes a new performance consideration.
https://dev.mysql.com/doc/refman/5.7/en/optimizer-tracing-typical-usage.html
To examine traces for multiple queries, repeat the previous two steps as needed. To perform optimizer tracing entails the following steps: Enable tracing by executing SET optimizer_trace="enabled=ON". See Section 8.15.3, “Traceable Statements”, ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-configuration-variables.html
When the system has unused I/O capacity, more read-ahead can improve the performance of queries. Different settings work best for servers with light, predictable loads, versus servers that are running near full capacity all the time, or that ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-diskio.html
Increase buffer pool size When table data is cached in the InnoDB buffer pool, it can be accessed repeatedly by queries without requiring any disk I/O. If you follow best practices for database design and tuning techniques for SQL operations, but ...