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/partitioning-subpartitions.html
Otherwise, you may set any desired option for the subpartition or allow it to assume its default setting for that option. An exception to this is that SUBPARTITION BY KEY (unlike PARTITION BY KEY) does not currently support a default column, so the ... Subpartitioning—also known as composite partitioning—is the further division of each partition in a partitioned ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-flow-control.html
The writer quota is enforced by the throttling mechanism if the queue size of the certifier or the binary log applier exceeds a user defined threshold. Whenever the size of one of these queues exceeds the user-defined threshold, the throttling ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tp-thread-state-table.html
0 means no statement is executing, 1 means it is in the first 10ms, and so forth. The xxx_WAIT columns of the TP_THREAD_GROUP_STATS table accumulate counts for each wait type. The TP_THREAD_STATE table has one row per thread created by the thread ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-prerequisites.html
Before using the sys schema, the prerequisites described in this section must be satisfied. Because the sys schema provides an alternative means of accessing the Performance Schema, the Performance Schema must be enabled for the sys schema to work.
https://dev.mysql.com/doc/refman/5.7/en/show-triggers.html
row *************************** Trigger: ins_sum Event: INSERT Table: account Statement: SET @sum = @sum + NEW.amount Timing: BEFORE Created: 2018-08-08 10:10:12.61 sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ...
https://dev.mysql.com/doc/refman/5.7/en/hexadecimal-literals.html
For example, a hexadecimal literal assigned to a user-defined variable is a binary string by default. Converted to a number, it produces 0: mysql> SELECT CHARSET(X''), LENGTH(X''); +--------------+-------------+ | CHARSET(X'') | LENGTH(X'') | ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-status-variables.html
Performance_schema_users_lost The number of times a row could not be added to the users table because it was full. If this value is nonzero, you may wish to set performance_schema_session_connect_attrs_size to a larger value. Performance Schema ...
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 ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-message-compression.html
Compression for messages sent in the group happens at the group communication engine level, before the data is handed over to the group communication thread, so it takes place within the context of the mysql user session thread. You could use the ...
https://dev.mysql.com/doc/refman/5.7/en/features.html
This is useful if you want to provide an SQL interface for an in-house database. Support for DELETE, INSERT, REPLACE, and UPDATE to return the number of rows that were changed (affected), or to return the number of rows matched instead by setting a ... This section describes some of the important characteristics of the MySQL Database ...