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/mysql-installation-windows-path.html
Warning You must exercise great care when editing your system PATH by hand; accidental deletion or modification of any portion of the existing PATH value can leave you with a malfunctioning or even unusable system. To make it easier to invoke MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-installer-catalog-dashboard.html
With the Manual option selected, new URLs can be added and all URLs in the list can be moved or deleted. This section describes the MySQL Installer product catalog, the dashboard, and other actions related to product selection and upgrades. Product ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-plugin.html
Depending on whether mysql_plugin is invoked to enable or disable plugins, it inserts or deletes rows in the mysql.plugin table that serves as a plugin registry. Note mysql_plugin is deprecated as of MySQL 5.7.11 and removed in MySQL 8.0.
https://dev.mysql.com/doc/refman/5.7/en/mysqladmin.html
drop db_name Delete the database named db_name and all its tables. You can use it to check the server's configuration and current status, to create and drop databases, and more. Invoke mysqladmin like this: mysqladmin [options] command [command-arg] ...
https://dev.mysql.com/doc/refman/5.7/en/optimization-indexes.html
Indexes also add to the cost of inserts, updates, and deletes because each index must be updated. The best way to improve the performance of SELECT operations is to create indexes on one or more of the columns that are tested in the query. The ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-logging.html
Thus, if you have transactions that update, insert, or delete many rows, making the log buffer larger saves disk I/O. Consider the following guidelines for optimizing redo logging: Make your redo log files big, even as big as the buffer pool. When ...
https://dev.mysql.com/doc/refman/5.7/en/option-files.html
Leading and trailing spaces are automatically deleted from option names and values. Most MySQL programs can read startup options from option files (sometimes called configuration files). Option files provide a convenient way to specify commonly ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-handling-nulls.html
Partitioning in MySQL does nothing to disallow NULL as the value of a partitioning expression, whether it is a column value or the value of a user-supplied expression. Even though it is permitted to use NULL as the value of an expression that must ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management.html
In MySQL 5.7, it is possible to delete all rows from one or more selected partitions using ALTER TABLE ... MySQL 5.7 provides a number of ways to modify partitioned tables. It is possible to add, drop, redefine, merge, or split existing partitions.
https://dev.mysql.com/doc/refman/5.7/en/partitioning-overview.html
Partition selection is also supported for the data modification statements DELETE, INSERT, REPLACE, UPDATE, and LOAD DATA, LOAD XML. This section provides a conceptual overview of partitioning in MySQL 5.7. For information on partitioning ...