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/can-not-connect-to-server.html
Locate the following key in the registry: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters On the Edit menu, click Add Value, and then add the following registry value: Value Name: MaxUserPort Data Type: REG_DWORD Value: 65534 ...If the server was started with the bind_address system variable set to 127.0.0.1, it listens for TCP/IP connections only locally on the loopback interface and does not accept remote ... A MySQL client on Unix can connect to the mysqld ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-thread_concurrency.html
When InnoDB receives a new request from a user session, if the number of threads concurrently executing is at a pre-defined limit, the new request sleeps for a short time before it tries again. InnoDB uses operating system threads to process ...
https://dev.mysql.com/doc/refman/5.7/en/x-plugin-status-variables.html
Mysqlx_ssl_cipher_list A list of possible SSL ciphers (empty for non-SSL connections). Mysqlx_ssl_server_not_after The last date for which the SSL certificate is valid. Mysqlx_ssl_server_not_before The first date for which the SSL certificate is ...
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/innodb-and-mysql-replication.html
For information about setting up a replica, see Section 16.1.2.5, “Setting Up Replicas”, and Section 16.1.2.4, “Choosing a Method for Data Snapshots”. For example, you can replicate modifications to an InnoDB table on the source to a MyISAM ... It is possible to use replication in a way where the storage engine on the replica is not the same as the storage engine on the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-midpoint_insertion.html
Because the effects of these parameters can vary widely based on your hardware configuration, your data, and the details of your workload, always benchmark to verify the effectiveness before changing these settings in any performance-critical or ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-security.html
Explicitly specify which version to use, either in mysql.cnf (or mysql.ini) or by using SET PERSIST, for example: --tls-version=TLSv12. Where can I find documentation that addresses security issues for MySQL? A.9.2. Does MySQL include support for ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-tablespaces-table.html
The INNODB_SYS_TABLESPACES table provides metadata about InnoDB file-per-table and general tablespaces, equivalent to the information in the SYS_TABLESPACES table in the InnoDB data dictionary. For related usage information and examples, see ...