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/replication-snapshot-method.html
Employing this method with a table using a storage engine that has complex caching or logging algorithms requires extra steps to produce a perfect “point in time” snapshot: the initial copy command could leave out cache information and logging ... If the database on the source contains existing data it is necessary to copy this data to each ...
https://dev.mysql.com/doc/refman/5.7/en/security-guidelines.html
This information is accessible to everyone who has the time and ability to intercept it and use it for their own purposes. Anyone using MySQL on a computer connected to the Internet should read this section to avoid the most common security ...
https://dev.mysql.com/doc/refman/5.7/en/server-option-variable-reference.html
The following table lists all command-line options, system variables, and status variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-types.html
MySQL spatial extensions enable the generation, storage, and analysis of geographic features: Data types for representing spatial values Functions for manipulating spatial values Spatial indexing for improved access times to spatial columns The ...
https://dev.mysql.com/doc/refman/5.7/en/storage-engines.html
NDB (also known as NDBCLUSTER): This clustered database engine is particularly suited for applications that require the highest possible degree of uptime and availability. Storage engines are MySQL components that handle the SQL operations for ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-setup-show-disabled.html
Displays all currently disabled Performance Schema configuration. Parameters in_show_instruments BOOLEAN: Whether to display disabled instruments. This might be a long list. in_show_threads BOOLEAN: Whether to display disabled threads. Example ...
https://dev.mysql.com/doc/refman/5.7/en/updating-yum-repo.html
Upgrading MySQL Upgrade MySQL and its components by the following command, for platforms that are not dnf-enabled: sudo yum update mysql-server For platforms that are dnf-enabled: sudo dnf upgrade mysql-server Alternatively, you can update MySQL by ... For supported Yum-based platforms (see Section 2.5.1, “Installing MySQL on Linux Using the MySQL Yum Repository”, for a list), you can perform an in-place upgrade for MySQL (that is, replacing the old version and then running the new version using the old data files) with the MySQL Yum ...
https://dev.mysql.com/doc/refman/5.7/en/upgrade-before-you-begin.html
If your MySQL installation contains a large amount of data that might take a long time to convert after an in-place upgrade, it may be useful to create a test instance for assessing the conversions that are required and the work involved to perform ...The backup should include the mysql system database, which contains the MySQL system ...
https://dev.mysql.com/doc/refman/5.7/en/view-updatability.html
It is sometimes possible for a multiple-table view to be updatable, assuming that it can be processed with the MERGE algorithm. They must not be expressions, such as these: 3.14159 col1 + 3 UPPER(col2) col3 / col4 (subquery) MySQL sets a flag, ...
https://dev.mysql.com/doc/refman/5.7/en/using-explain.html
The EXPLAIN statement provides information about how MySQL executes statements: EXPLAIN works with SELECT, DELETE, INSERT, REPLACE, and UPDATE statements. When EXPLAIN is used with an explainable statement, MySQL displays information from the ...