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/show-engine.html
An internal buffer that is exposed as a table in the performance_schema database is named after the table, without parentheses. The Status information is in the form of comma-delimited set of name/value pairs. SHOW ENGINE engine_name {STATUS | ...
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/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/mysql-cluster-mgm-definition.html
(NDB 7.5.0) This refers to the Id set for one of the computers defined in a [computer] section of the config.ini file. Normally, the management server should be configured as an arbitrator by setting its ArbitrationRank to 1 (the default for ... The ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-shm-definition.html
For optimum performance, you can define a spin time for the SHM transporter (ShmSpinTime parameter); this affects both the data node receiver thread and the poll owner (receive thread or user thread) in NDB. You can enable a shared memory connection ...The shared-memory transporter (SHM) can improve performance by negating up to 20% of the overhead required by a TCP connection when running an API node (usually an SQL node) and a data node together on the same ...
https://dev.mysql.com/doc/refman/5.7/en/using-systemd.html
In other cases, the error log directory must be writable or the error log must be present and writable for the user running the mysqld process. Arrange for systemd to set environment variables for the MySQL server process. For example: [Service] ...
https://dev.mysql.com/doc/refman/5.7/en/table-locking.html
The automatic row-level locking makes these tables suitable for your busiest databases with your most important data, while also simplifying application logic since you do not need to lock and unlock tables. For this storage engine, avoid using the ... InnoDB tables use row-level locking so that multiple sessions and applications can read from and write to the same table simultaneously, without making each other wait or producing inconsistent ...
https://dev.mysql.com/doc/refman/5.7/en/function-optimization.html
This UPDATE statement uses a nondeterministic function to select rows to be modified: UPDATE t SET col_a = some_expr WHERE id = FLOOR(1 + RAND() * 49); Presumably the intent is to update at most a single row for which the primary key matches the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format-compatibility.html
The ib-file set includes the following files: The system tablespace (one or more ibdata files) that contain internal system information (including internal catalogs and undo information) and may include user data and indexes. To minimize the chance ... InnoDB incorporates several checks to guard against the possible crashes and data corruptions that might occur if you run an old release of the MySQL server on InnoDB data files that use a newer file ...
https://dev.mysql.com/doc/refman/5.7/en/ipv6-brokers.html
Create an account at Freenet6 by visiting this URL and signing up: http://gogonet.gogo6.com After creating the account, go to this URL, sign in, and create a user ID and password for the IPv6 broker: ...For example: userid=gogouser passwd=gogopass ...After configuring your server host to use a broker-supplied IPv6 address, start the MySQL server with an appropriate bind_address setting to permit the server to accept IPv6 ...