PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-ro-txn.html
InnoDB can avoid the overhead associated with setting up the transaction ID (TRX_ID field) for transactions that are known to be read-only. In this case, attempting to make changes to the database (for InnoDB, MyISAM, or other types of tables) ...A ...Eliminating unnecessary transaction IDs reduces the size of internal data structures that are consulted each time a query or data change statement constructs a read ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-storage-engine.html
Table 15.2 MyISAM Storage Engine Features Feature Support B-tree indexes Yes Backup/point-in-time recovery (Implemented in the server, rather than in the storage engine.) Yes Cluster database support No Clustered indexes No Compressed data Yes ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-table-descriptions.html
Tables in the performance_schema database can be grouped as follows: Setup tables. For example, to set the sizes of the wait event history tables, set performance_schema_events_waits_history_size and ...The events_waits_current table contains the ...These tables have the same structure as the current events tables, but contain more ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-security.html
For security reasons, audit log files should be written to a directory accessible only to the MySQL server and to users with a legitimate reason to view the log. By default, contents of audit log files produced by the audit log plugin are not ...
https://dev.mysql.com/doc/refman/5.7/en/too-many-connections.html
By granting the privilege to administrators and not to normal users (who should not need it), an administrator who also has the PROCESS privilege can connect to the server and use SHOW PROCESSLIST to diagnose problems even if the maximum number of ...The extra connection is reserved for use by accounts that have the SUPER ... If clients encounter Too many connections errors when attempting to ...
https://dev.mysql.com/doc/refman/5.7/en/views.html
Additional Resources You may find the MySQL User Forums helpful when working with views. Views are stored queries that when invoked produce a result set. The following discussion describes the syntax for creating and dropping views, and shows some ...There are some restrictions on the use of views; see Section 23.9, “Restrictions on ...
https://dev.mysql.com/doc/refman/5.7/en/data-directory.html
All MySQL installations have certain standard databases: The mysql directory corresponds to the mysql system database, which contains information required by the MySQL server as it runs. The sys directory corresponds to the sys schema, which ...Some ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-sql-format.html
With --all-databases or --databases, mysqldump writes CREATE DATABASE and USE statements prior to the dump output for each database. If you want to cause the dump file to force a drop of each database before recreating it, use the ... This section ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema.html
It is implemented using the PERFORMANCE_SCHEMA storage engine and the performance_schema database. Performance Schema configuration can be modified dynamically by updating tables in the performance_schema database through SQL statements. Note The ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlbinlog-backup.html
Along with --read-from-remote-server, it is common to specify other options: --host indicates where the server is running, and you may also need to specify connection options such as --user and --password. By default, mysqlbinlog reads binary log ...mysqlbinlog can read log files directly from the local file system, or, with the --read-from-remote-server option, it can connect to a server and request binary log contents from that ...