PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.7Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/metadata-locking.html
MySQL uses metadata locking to manage concurrent access to database objects and to ensure data consistency. Metadata locking applies not just to tables, but also to schemas, stored programs (procedures, functions, triggers, scheduled events), ...
https://dev.mysql.com/doc/refman/5.7/en/migrating-from-year2.html
This section describes problems that can occur when using the 2-digit YEAR(2) data type and provides information about converting existing YEAR(2) columns to 4-digit year-valued columns, which can be declared as YEAR with an implicit display width ...
https://dev.mysql.com/doc/refman/5.7/en/miscellaneous-optimization-tips.html
This section lists a number of miscellaneous tips for improving query processing speed: If your application makes several database requests to perform related updates, combining the statements into a stored routine can help performance. Similarly, ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-unix-servers.html
Note The discussion here uses mysqld_safe to launch multiple instances of MySQL. For MySQL installation using an RPM distribution, server startup and shutdown is managed by systemd on several Linux platforms. On these platforms, mysqld_safe is not ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-general-options.html
MySQL release binaries provided by Oracle are not built using this option. The options described in this section can be used for any type of table maintenance operation performed by myisamchk. The sections following this one describe options that ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-repair-options.html
--correct-checksum Command-Line Format --correct-checksum Correct the checksum information for the table. --data-file-length=len, -D len Command-Line Format --data-file-length=len Type Numeric The maximum length of the data file (when re-creating ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-windows-initial-start.html
On the computer designated as the SQL node host, open a console window and navigate to the directory where you unpacked the NDB Cluster binaries (if you are following our example, this is C:\mysql\bin). Once the NDB Cluster executables and needed ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-interconnects.html
This required specialized hardware, software, and MySQL binaries that are no longer available. Even before design of NDBCLUSTER began in 1996, it was evident that one of the major problems to be encountered in building parallel databases would be ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-unsupported.html
A number of features supported by other storage engines are not supported for NDB tables. Trying to use any of these features in NDB Cluster does not cause errors in or of itself; however, errors may occur in applications that expects the features ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-logs-event-buffer.html
NDB uses one or more memory buffers for events received from the data nodes. There is one such buffer for each Ndb object subscribing to table events, which means that there are usually two buffers for each mysqld performing binary logging (one ...