PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/connection-control-plugin-installation.html
To be usable by the server, the plugin library file must be located in the MySQL plugin directory (the directory named by the plugin_dir system variable). The file name suffix differs per platform (for example, .so for Unix and Unix-like systems, ...
https://dev.mysql.com/doc/refman/8.0/en/string-literals.html
When writing application programs, any string that might contain any of these special characters must be properly escaped before the string is used as a data value in an SQL statement that is sent to the MySQL server. Backslash (\) and the quote ...
https://dev.mysql.com/doc/refman/8.0/en/large-page-support.html
In the event sysctl returns an error relating to the file name, check the name of the corresponding file in /proc/sys/vm and use that instead. Check any configuration files such as my.cnf used by the server, and make sure that ...Before large pages ... Some hardware and operating system architectures support memory pages greater than the default (usually ...Applications that perform a lot of memory accesses may ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-dict-obj-info.html
The dict_obj_info table provides information about NDB data dictionary (DICT) objects such as tables and indexes. (The dict_obj_types table can be queried for a list of all the types.) This information includes the object's type, state, parent ...
https://dev.mysql.com/doc/refman/8.0/en/general-thread-states.html
This state is used even if the table could not be created due to some error. closing tables The thread is flushing the changed table data to disk and closing the used tables. Actions taken by the server in this state include flushing the binary log ... The following list describes thread State values that are associated with general query processing and not more specialized activities such as ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rbr-safe-unsafe.html
If a large number of such statements were executed on the source, this could lead to excessively large error log files. When activated, this causes such warnings not to be written to the error log; instead, for each 50 warnings of this type, a note ... The “safeness” of a statement in MySQL replication refers to whether the statement and its effects can be replicated correctly using statement-based ...
https://dev.mysql.com/doc/refman/8.0/en/install-component.html
Example: INSTALL COMPONENT 'file://component1', 'file://component2'; A component is named using a URN that begins with file:// and indicates the base name of the library file that implements the component, located in the directory named by the ...A ...[SET variable = expr [, variable = expr] ...] variable: { {GLOBAL | @@GLOBAL.} [component_prefix.]system_var_name | {PERSIST | @@PERSIST.} [component_prefix.]system_var_name } This statement installs one or more components, which become active ...
https://dev.mysql.com/doc/refman/8.0/en/storage-engine-setting.html
MySQL may store a table's index and data in one or more other files, depending on the storage engine. When you create a new table, you can specify which storage engine to use by adding an ENGINE table option to the CREATE TABLE statement: -- ...
https://dev.mysql.com/doc/refman/8.0/en/sys-diagnostics.html
Parameters in_max_runtime INT UNSIGNED: The maximum data collection time in seconds. Use NULL to collect data for the default of 60 seconds. in_interval INT UNSIGNED: The sleep time between data collections in seconds. Creates a report of the ...
https://dev.mysql.com/doc/refman/8.0/en/connecting.html
For a client program to connect to the MySQL server, it must use the proper connection parameters, such as the name of the host where the server is running and the user name and password of your MySQL account. Each connection parameter has a default ... This section describes use of command-line options to specify how to establish connections to the MySQL server, for clients such as mysql or ...