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-cluster-replication.html
This thread ensures that all changes in the cluster producing the binary log—and not just those changes that are effected through the MySQL Server—are inserted into the binary log with the correct serialization order. NDB Cluster supports ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-rolling-restart.html
To free memory previously allocated to a table by successive INSERT and DELETE operations, for re-use by other NDB Cluster tables. This section discusses how to perform a rolling restart of an NDB Cluster installation, so called because it involves ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-installer-catalog-dashboard.html
When new products or product versions are available, MySQL Installer adds them to the catalog and then inserts an arrow icon () next to the version number of installed products listed in the dashboard. This section describes the MySQL Installer ...
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/mysql-tips.html
This section provides information about techniques for more effective use of mysql and about mysql operational behavior. Input-Line Editing Disabling Interactive History Unicode Support on Windows Displaying Query Results Vertically Using ...
https://dev.mysql.com/doc/refman/5.7/en/no-matching-rows.html
Open the file in an editor, remove some insert lines (if there are more than needed to demonstrate the problem), and add your SELECT statement at the end of the file. If you have a complicated query that uses many tables but that returns no rows, ...
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/optimize-character.html
When consecutive primary values are physically stored near each other, InnoDB can insert and retrieve them faster. For character and string columns, follow these guidelines: Use binary collation order for fast comparison and sort operations, when ...
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/order-by-optimization.html
For example: INSERT INTO foo SELECT a, COUNT(*) FROM bar GROUP BY a ORDER BY NULL; The optimizer may still choose to use sorting to implement grouping operations. This section describes when MySQL can use an index to satisfy an ORDER BY clause, the ...