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/backup-policy.html
For example, for the MyISAM tables in the mysql database, there must be no administrative changes to MySQL accounts during the backup. A full backup (a snapshot of the data at a point in time) can be done in MySQL with several tools. For example, ...
https://dev.mysql.com/doc/refman/5.7/en/charset-metadata.html
Metadata is “the data about the data.” Anything that describes the database—as opposed to being the contents of the database—is metadata. Thus column names, database names, user names, version names, and most of the string results from SHOW ...Representation of metadata must satisfy these requirements: All metadata must be in the same character ...
https://dev.mysql.com/doc/refman/5.7/en/compatibility.html
We continue to support transactional and nontransactional databases to satisfy both mission-critical 24/7 usage and heavy Web or logging usage. MySQL Server was originally designed to work with medium-sized databases (10-100 million rows, or about ... This section describes how MySQL relates to the ANSI/ISO SQL ...
https://dev.mysql.com/doc/refman/5.7/en/converting-tables-to-innodb.html
Converting an Existing Table To convert a non-InnoDB table to use InnoDB use ALTER TABLE: ALTER TABLE table_name ENGINE=InnoDB; Warning Do not convert MySQL system tables in the mysql database from MyISAM to InnoDB tables. In the case of a runaway ... If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips before ...
https://dev.mysql.com/doc/refman/5.7/en/create-server.html
CREATE SERVER server_name FOREIGN DATA WRAPPER wrapper_name OPTIONS (option [, option] ...) option: { HOST character-literal | DATABASE character-literal | USER character-literal | PASSWORD character-literal | SOCKET character-literal | OWNER ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-cjk.html
Does MySQL permit CJK characters to be used in database and table names? A.11.18. Make sure that the database is actually using the desired character set. Does MySQL permit CJK characters to be used in database and table names? Yes. This set of ...