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/insert-optimization.html
This is considerably faster (many times faster in some cases) than using separate single-row INSERT statements. This reduces the parsing that MySQL must do and improves the insert speed. To optimize insert speed, combine many small operations into ...
https://dev.mysql.com/doc/refman/5.7/en/insert-select.html
This means that, when using replication, there is no guarantee that such a SELECT returns rows in the same order on the source and the replica, which can lead to inconsistencies between them. (This does not occur with tables using storage engines ...
https://dev.mysql.com/doc/refman/5.7/en/internal-temporary-tables.html
This includes user-defined variables having a string value because they are treated as BLOB or TEXT columns, depending on whether their value is a binary or nonbinary string, respectively. EXPLAIN and optimizer trace output reflects this execution ... In some cases, the server creates internal temporary tables while processing ...
https://dev.mysql.com/doc/refman/5.7/en/ipv6-brokers.html
To bind to a specific address but avoid this change-of-address problem, you may be able to arrange with the broker for a static IPv6 address. Create an account at Freenet6 by visiting this URL and signing up: http://gogonet.gogo6.com After creating ... If you do not have a public IPv6 address that enables your system to communicate over IPv6 outside your local network, you can obtain one from an IPv6 ...
https://dev.mysql.com/doc/refman/5.7/en/macos-installation-notes.html
Choosing "Don't Allow" means this password won't be visible for use. You can do this through the Directory Utility, and the mysql user should already exist. Because the MySQL package installer installs the MySQL contents into a version and platform ... You should keep the following issues and notes in mind: As of macOS 10.14 (Majave), the macOS MySQL 5.7 Installer application requires permission to control System Events so it can display a generated (temporary) MySQL root ...
https://dev.mysql.com/doc/refman/5.7/en/macos-installation.html
You do not need administrator privileges using this method, as you can install the MySQL server anywhere using this method. For more information on using this method, you can use the generic instructions for using a tarball, Section 2.2, ... For a ...
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. In this ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-maintenance-schedule.html
For example, you can run a cron job to check important tables once a week, using a line like this in a crontab file: 35 0 * * 0 /path/to/myisamchk --fast --silent /path/to/datadir/*/*.MYI This prints out information about crashed tables so that you ... It is a good idea to perform table checks on a regular basis rather than waiting for problems to ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-optimization.html
This improves join performance by enabling the join optimizer to better choose the order in which to join the tables and which indexes it should use. This optimizes seeks and makes table scans that use indexes faster. This makes your data much more ... To coalesce fragmented rows and eliminate wasted space that results from deleting or updating rows, run myisamchk in recovery mode: $> myisamchk -r tbl_name You can optimize a table in the same way by using the OPTIMIZE TABLE SQL ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-configuration-overview.html
It is possible to update cluster configuration parameters marked as node online—that is, without shutting down the cluster—in this fashion. However, decreasing the values of such parameters—whether this is done using a node restart, node ...