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/replication-mode-change-online-concepts.html
To be able to safely configure the replication mode of an online server it is important to understand some key concepts of replication. This section explains these concepts and is essential reading before attempting to modify the replication mode ...
https://dev.mysql.com/doc/refman/5.7/en/user-resources.html
One means of restricting client use of MySQL server resources is to set the global max_user_connections system variable to a nonzero value. This limits the number of simultaneous connections that can be made by any given account, but places no ...
https://dev.mysql.com/doc/refman/5.7/en/thread-pool-operation.html
The thread pool consists of a number of thread groups, each of which manages a set of client connections. As connections are established, the thread pool assigns them to thread groups in round-robin fashion. To configure the number of thread ...The ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-digests.html
Normalization permits statements that are similar to be grouped and summarized to expose information about the types of statements the server is executing and how often they occur. If the table becomes full, the Performance Schema groups statements ... The MySQL server is capable of maintaining statement digest ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-tips.html
Alternatively, create a shortcut that only sets the console font, and set the character set in the [mysql] group of your my.ini file: [mysql] default-character-set=utf8 Displaying Query Results Vertically Some query results are much more readable ...
https://dev.mysql.com/doc/refman/5.7/en/selinux-context-mysql-feature-ports.html
Setting the TCP Port Context for Group Replication If SELinux is enabled, you must set the port context for the Group Replication communication port, which is defined by the group_replication_local_address variable. mysqld must be able to bind to ...
https://dev.mysql.com/doc/refman/5.7/en/data-size.html
Design your tables to minimize their space on the disk. This can result in huge improvements by reducing the amount of data written to and read from disk. Smaller tables normally require less main memory while their contents are being actively ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-functions.html
MySQL Enterprise Encryption functions have these general characteristics: For arguments of the wrong type or an incorrect number of arguments, each function returns an error. If the arguments are not suitable to permit a function to perform the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-consistent-read.html
A consistent read means that InnoDB uses multi-versioning to present to a query a snapshot of the database at a point in time. The query sees the changes made by transactions that committed before that point in time, and no changes made by later or ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-setup.html
This section describes how to set up the daemon_memcached plugin on a MySQL server. Because the memcached daemon is tightly integrated with the MySQL server to avoid network traffic and minimize latency, you perform this process on each MySQL ...