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-security-networking-issues.html
We show an example of an NDB Cluster setup using such a physically segregated network here: Figure 21.9 NDB Cluster with Hardware Firewall This setup has two networks, one private (solid box) for the Cluster management servers and data nodes, and ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-installer-setup.html
As the following figure shows, the initial setup is a one-time activity in the overall process. Figure 2.8 Check Requirements Description of Check Requirements Elements Shows the current step in the initial setup. Choosing a Setup Type Path ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-tips.html
This enables use of EXPLAIN plus SHOW WARNINGS to see why an index is not used, which can be helpful in cases such as when a range_optimizer_max_mem_size violation or type conversion occurs and the optimizer does not use an index even though a key ... This section provides information about techniques for more effective use of mysql and about mysql operational ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlpump.html
mysqlpump Invocation Syntax mysqlpump Option Summary mysqlpump Option Descriptions mysqlpump Object Selection mysqlpump Parallel Processing mysqlpump Restrictions The mysqlpump client utility performs logical backups, producing a set of SQL ...
https://dev.mysql.com/doc/refman/5.7/en/no-login-pluggable-authentication.html
To verify plugin installation, examine the Information Schema PLUGINS table or use the SHOW PLUGINS statement (see Section 5.5.2, “Obtaining Server Plugin Information”). The mysql_no_login server-side authentication plugin prevents all client ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-diskio.html
If the Unix top tool or the Windows Task Manager shows that the CPU usage percentage with your workload is less than 70%, your workload is probably disk-bound. In a typical scenario where you could lower the option value, you might see a combination ... If you follow best practices for database design and tuning techniques for SQL operations, but your database is still slow due to heavy disk I/O activity, consider these disk I/O ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-queries-myisam.html
You can check the result from the table analysis by using SHOW INDEX FROM tbl_name and examining the Cardinality value. Some general tips for speeding up queries on MyISAM tables: To help MySQL better optimize queries, use ANALYZE TABLE or run ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations-partitioning-keys-unique-keys.html
This section discusses the relationship of partitioning keys with primary keys and unique keys. The rule governing this relationship can be expressed as follows: All columns used in the partitioning expression for a partitioned table must be part ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-exchange.html
In addition, both tables must use the same storage engine: mysql> CREATE TABLE es3 LIKE e; Query OK, 0 rows affected (1.31 sec) mysql> ALTER TABLE es3 REMOVE PARTITIONING; Query OK, 0 rows affected (0.53 sec) Records: 0 Duplicates: 0 Warnings: 0 ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning.html
Note As of MySQL 5.7.17, the generic partitioning handler in the MySQL server is deprecated, and is removed in MySQL 8.0, when the storage engine used for a given table is expected to provide its own (“native”) partitioning handler. Use of ...