PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations-locking.html
REPLACE and INSERT lock only those partitions having rows to be inserted or replaced. In MySQL 5.7, partition lock pruning eliminates unneeded locks in many cases, and most statements reading from or updating a partitioned MyISAM table cause only ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations.html
Be aware that, if your application uses REPLACE statements and you do this, the results of these statements can be drastically altered. See Section 13.2.8, “REPLACE Statement”, for more information and an example. This section discusses current ...
https://dev.mysql.com/doc/refman/5.7/en/range-optimization.html
The correct way to remove them is to replace them with TRUE, so that we do not miss any matching rows when doing the range scan. The range access method uses a single index to retrieve a subset of table rows that are contained within one or several ...
https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html
Replace the password with the password that you want to use. Replace the password with the password that you want to use. Replace the password with the password that you want to use. If you have never assigned a root password for MySQL, the server ...
https://dev.mysql.com/doc/refman/5.7/en/information-functions.html
DATABASE() Returns the default (current) database name as a string in the utf8 character set. Within a stored routine, the default database is the database that the routine is associated with, which is not necessarily the same as the database that ...It may be used to time how quickly MySQL processes the ...
https://dev.mysql.com/doc/refman/5.7/en/version-tokens-usage.html
Suppose that a management application communicates with a set of servers that are queried by clients to access employee and product databases (named emp and prod, respectively). All servers are permitted to process data retrieval statements, but ...
https://dev.mysql.com/doc/refman/5.7/en/server-options.html
--ignore-db-dir=dir_name Command-Line Format --ignore-db-dir=dir_name Deprecated Yes Type Directory name This option tells the server to ignore the given directory name for purposes of the SHOW DATABASES statement or INFORMATION_SCHEMA tables. When ...
https://dev.mysql.com/doc/refman/5.7/en/symbolic-links-to-tables.html
The data file and index file can be moved elsewhere and replaced in the data directory by symlinks. (Bug #32167) myisamchk does not replace a symlink with the data file or index file. This is an extremely good reason not to run mysqld as the root ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html
Some options, which you might not use initially, help tune InnoDB performance characteristics based on machine capacity and your database workload. On a dedicated database server, you might set the buffer pool size to 80% of the machine's physical ... System variables that are true or false can be enabled at server startup by naming them, or disabled by using a --skip- ...
https://dev.mysql.com/doc/refman/5.7/en/downgrade-binary-package.html
In-Place Downgrade Logical Downgrade In-Place Downgrade In-place downgrade involves shutting down the new MySQL version, replacing the new MySQL binaries or packages with the old ones, and restarting the old MySQL version on the existing data ...