PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/bit-value-literals.html
For example, a bit literal assigned to a user-defined variable is a binary string by default. To convert a bit value to printable form, use it in numeric context or use a conversion function such as BIN() or HEX(). A leading 0b is case-sensitive and ...
https://dev.mysql.com/doc/refman/5.7/en/channels-startup-options.html
The values set for the following startup options apply on each channel; since these are mysqld startup options, they are applied on every channel. --slave_net-timeout=N This value is set per channel, so that each channel waits for N seconds to check ...The following startup settings must be configured correctly to use multi-source ... This ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-compared.html
Since both NDB and InnoDB can serve as transactional MySQL storage engines, users of MySQL Server sometimes become interested in NDB Cluster. See Section 21.2.6.3, “NDB and InnoDB Feature Usage Summary”, for a comparison of the relative ...While ... MySQL Server offers a number of choices in storage ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-mgm.html
Advanced users can also employ this API for programming dedicated management processes to perform tasks similar to those performed by ndb_mgm. Its value lies in providing a set of commands for checking the cluster's status, starting backups, and ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-mgmd.html
Otherwise—that is, if you wish to disable configuration caching for a management server that has already created a configuration cache—you must stop the management server, delete any existing configuration cache files manually, then restart the ... The management server is the process that reads the cluster configuration file and distributes this information to all nodes in the cluster that request ...
https://dev.mysql.com/doc/refman/5.7/en/windows-create-option-file.html
You need to tune the server settings, such as memory, cache, or InnoDB configuration information. Note When using the MySQL Installer to install MySQL Server, it creates the my.ini in the default location, and the user executing MySQL Installer is ...For options that are used every time the server starts, you may find it most convenient to use an option file to specify your MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/derived-table-optimization.html
(For an example, see Section 8.2.2.2, “Optimizing Subqueries with Materialization”.) If merging would result in an outer query block that references more than 61 base tables, the optimizer chooses materialization instead. Thus, if an ...The ...
https://dev.mysql.com/doc/refman/5.7/en/sys-io-by-thread-by-latency.html
The io_by_thread_by_latency and x$io_by_thread_by_latency views have these columns: user For foreground threads, the account associated with the thread. These views summarize I/O consumers to display time waiting for I/O, grouped by thread.
https://dev.mysql.com/doc/refman/5.7/en/loadable-function-reference.html
For a table listing built-in functions and operators, see Section 12.1, “Built-In Function and Operator Reference” For general information about loadable functions, see Section 5.6, “MySQL Server Loadable Functions”. The following table ...
https://dev.mysql.com/doc/refman/5.7/en/server-configuration.html
In addition, the MySQL sys schema is a set of objects that provides convenient access to data collected by the Performance Schema; see Chapter 26, MySQL sys Schema. You should first feel confident that you have these set appropriately before trying ... The MySQL server, mysqld, has many command options and system variables that can be set at startup to configure its ...To determine the default command option and system variable values used by the server, execute ...