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-online-add-node-example.html
ALGORITHM=INPLACE, REORGANIZE PARTITION does not work on tables that were created with the MAX_ROWS option. Keep in mind that using MAX_ROWS to set the number of partitions per table is deprecated in NDB 7.5.4 and later, where you should use ... In ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-redo-log-reader.html
-lap Command-Line Format -lap Provide lap info, with max GCI started and completed. Command-Line Format -mbyte # Type Numeric Default Value 0 Minimum Value 0 Maximum Value 15 -mbyte #: Starting megabyte. Command-Line Format -page # Type Integer ...
https://dev.mysql.com/doc/refman/5.7/en/adding-collation-choosing-id.html
To add a collation, you must choose an ID value that is not currently used. The range of IDs from 1024 to 2047 is reserved for user-defined collations. The collation ID that you choose appears in these contexts: The ID column of the Information ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-failover.html
In the event that the primary Cluster replication process fails, it is possible to switch over to the secondary replication channel. This means that the ndb_apply_status table contains information for the replica on this host as well as for any ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-tips.html
Setting max_join_size to 1,000,000 causes multiple-table SELECT statements to produce an error if the server estimates it must examine more than 1,000,000 row combinations. This enables use of EXPLAIN plus SHOW WARNINGS to see why an index is not ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlimport.html
Here is a sample session that demonstrates use of mysqlimport: $> mysql -e 'CREATE TABLE imptest(id INT, n VARCHAR(30))' test $> ed a 100 Max Sydow 101 Count Dracula . The mysqlimport client provides a command-line interface to the LOAD DATA SQL ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-subqueries.html
Development is ongoing, so no optimization tip is reliable for the long term. The following list provides some interesting tricks that you might want to play with. See also Section 8.2.2, “Optimizing Subqueries, Derived Tables, and View ...
https://dev.mysql.com/doc/refman/5.7/en/pluggable-authentication-system-variables.html
authentication_ldap_sasl_init_pool_size Command-Line Format --authentication-ldap-sasl-init-pool-size=# Introduced 5.7.19 System Variable authentication_ldap_sasl_init_pool_size Scope Global Dynamic Yes Type Integer Default Value 10 Minimum Value 0 ...Communication between the authentication plugin and the LDAP server occurs according to this authentication method to ensure password ...
https://dev.mysql.com/doc/refman/5.7/en/preventing-use-of-optimizer-trace.html
If, for some reason, you wish to prevent users from seeing traces of their queries, start the server with the options shown here: --maximum-optimizer-trace-max-mem-size=0 --optimizer-trace-max-mem-size=0 This sets the maximum size to 0 and prevents ...
https://dev.mysql.com/doc/refman/5.7/en/select.html
You can use SET max_seeks_for_key=value as an alternative way to force MySQL to prefer key scans instead of table scans. When you use ORDER BY or GROUP BY to sort a column in a SELECT, the server sorts values using only the initial number of bytes ... SELECT [ALL | DISTINCT | DISTINCTROW ] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT] [SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] select_expr [, select_expr] ...