PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/backup-strategy-summary.html
In case of an operating system crash or power failure, InnoDB itself does all the job of recovering data. But to make sure that you can sleep well, observe the following guidelines: Always tun the MySQL server with binary logging enabled (that is ...If you have such safe media, this technique can also be good for disk load balancing (which results in a performance ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-statistics-table.html
Note If the innodb_read_only system variable is enabled, ANALYZE TABLE may fail because it cannot update statistics tables in the data dictionary, which use InnoDB. TABLE_SCHEMA The name of the schema (database) to which the table containing the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations.html
In the sections that follow, we discuss known limitations in current releases of NDB Cluster as compared with the features available when using the MyISAM and InnoDB storage engines. You can report any discrepancies that you encounter to the MySQL ...Any problem which we do not plan to fix in NDB Cluster 8.0, is added to the ...See Section 25.2.7.11, “Previous NDB Cluster Issues Resolved in NDB Cluster 8.0” ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-myisam.html
The MyISAM storage engine performs best with read-mostly data or with low-concurrency operations, because table locks limit the ability to perform simultaneous updates. In MySQL, InnoDB is the default storage engine rather than MyISAM.
https://dev.mysql.com/doc/refman/8.0/en/primary-key-optimization.html
With the InnoDB storage engine, the table data is physically organized to do ultra-fast lookups and sorts based on the primary key column or columns. The primary key for a table represents the column or set of columns that you use in your most ...
https://dev.mysql.com/doc/refman/8.0/en/displaying-traces.html
INTO DUMPFILE is preferable to INTO OUTFILE for this purpose, since the latter escapes newlines. Examining a trace in the mysql command-line client can be made less difficult using the pager less command (or your operating platform's equivalent).
https://dev.mysql.com/doc/refman/8.0/en/key-cache-restructuring.html
Instead, the server directly accesses the table indexes using native file system caching. After the cache has been restructured, it becomes available again for caching indexes assigned to it, and the use of file system caching for the indexes ceases. For example: mysql> SET GLOBAL cold_cache.key_buffer_size=4*1024*1024; If you assign to either the key_buffer_size or key_cache_block_size key cache component a value that differs from the component's current value, the server destroys the cache's old structure and creates a new one based on the new ...
https://dev.mysql.com/doc/refman/8.0/en/mysql.html
You can execute SQL statements in a script file (batch file) like this: mysql db_name < script.sql > output.tab On Unix, the mysql client logs statements executed interactively to a history file. When used noninteractively (for example, as a ...
https://dev.mysql.com/doc/refman/8.0/en/native-pluggable-authentication.html
MySQL includes a mysql_native_password plugin that implements native authentication; that is, authentication based on the password hashing method in use from before the introduction of pluggable authentication. Note The mysql_native_password ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-persisted-variables-table.html
The persisted_variables table provides an SQL interface to the mysqld-auto.cnf file that stores persisted global system variable settings, enabling the file contents to be inspected at runtime using SELECT statements. The table contains a row for ...The SENSITIVE_VARIABLES_OBSERVER privilege is required to view the values of sensitive system variables in this ...Variables are ...