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-installation.html
This section covers hardware and software requirements; networking issues; installation of NDB Cluster; basic configuration issues; starting, stopping, and restarting the cluster; loading of a sample database; and performing queries. A common ...The ...
https://dev.mysql.com/doc/refman/5.7/en/data-type-defaults.html
This means, for example, that you cannot set the default for a date column to be the value of a function such as NOW() or CURRENT_DATE. If strict mode is not enabled, MySQL sets the column to the implicit default value for the column data type.
https://dev.mysql.com/doc/refman/5.7/en/character-arrays.html
For a character set named MYSYS, the file is named MYSET.xml. For a complex character set as implemented in a ctype-MYSET.c file in the strings directory, there are corresponding arrays: ctype_MYSET[], to_lower_MYSET[], and so forth. See the ...
https://dev.mysql.com/doc/refman/5.7/en/sys-memory-by-thread-by-current-bytes.html
current_count_used The current number of allocated memory blocks that have not been freed yet for the thread. current_allocated The current number of allocated bytes that have not been freed yet for the thread. current_avg_alloc The current number ...By default, rows are sorted by descending amount of memory ...
https://dev.mysql.com/doc/refman/5.7/en/linux-installation-yum-repo.html
A password for the superuser is set and stored in the error log file. For more information on the postinstallation procedures, see Section 2.9, “Postinstallation Setup and Testing”. Before You Start As a popular, open-source software, MySQL, in ...Follow these steps: Go to the Download MySQL Yum Repository page (https://dev.mysql.com/downloads/repo/yum/) in the MySQL Developer ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool-flushing.html
For table data stored on SSD, seek time is not a significant factor and you can disable this setting to spread out write operations. A setting smaller than the default is generally suitable for most workloads. The ideal settings depend on your ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-handling-nulls.html
Partitioning in MySQL does nothing to disallow NULL as the value of a partitioning expression, whether it is a column value or the value of a user-supplied expression. This means that treatment of NULL varies between partitioning of different ...
https://dev.mysql.com/doc/refman/5.7/en/json-utility-functions.html
JSON_PRETTY() prints out a JSON value in a format that is easy to read. JSON_PRETTY(json_val) Provides pretty-printing of JSON values similar to that implemented in PHP and by other languages and database systems. Formatting of the output from this ... This section documents utility functions that act on JSON values, or strings that can be parsed as JSON ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-table-statistics-with-buffer.html
fetch_latency The total wait time of timed read I/O events for the table. insert_latency The total wait time of timed insert I/O events for the table. update_latency The total wait time of timed update I/O events for the table. delete_latency The ...
https://dev.mysql.com/doc/refman/5.7/en/transport-protocols.html
However, the named_pipe_full_access_group system variable is available to control which MySQL users are permitted to use named-pipe connections. For programs that use the MySQL client library (for example, mysql and mysqldump), MySQL supports ...