Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-info.html
row *************************** id: 1 select_type: SIMPLE table: trb1 partitions: p0,p1,p2,p3 type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 10 Extra: Using filesort In this case, all four partitions are searched. row ... This ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-instruments-table.html
row *************************** NAME: wait/synch/mutex/pfs/LOCK_pfs_share_list ENABLED: NO TIMED: NO PROPERTIES: singleton FLAGS: NULL VOLATILITY: 1 DOCUMENTATION: Components can provide their own performance_schema tables. row ... The ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/server-plugin-descriptors.html
init: A once-only initialization function, or NULL if there is no such function. deinit: A once-only deinitialization function, or NULL if there is no such function. status_vars: A pointer to a structure for status variables associated with the ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-authentication-plugins-server-side.html
A value of NULL means “any plugin.” In the latter case, whatever plugin the client uses will do. The value is represented as a string at most MYSQL_USER_NAME_LENGTH bytes long, plus a terminating null. external_user: The server sets this to the ... Declare the server-side plugin with the usual general descriptor format that is used for all server plugin types (see Section 4.4.2.1, “Server Plugin Library and Plugin ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-timestamp2.html
The file timestamp2.cpp reproduced in this section provides an example of working in NDB API applications with the “new” MySQL temporal data types supporting fractional seconds. For more information working with MySQL temporal and other data ...
https://dev.mysql.com/doc/refman/8.4/en/enterprise-encryption-functions.html
If the arguments are not suitable to permit a function to perform the requested operation, it returns NULL or 0 as appropriate. When the variable is set to OFF, content encrypted by the legacy functions cannot be decrypted, and the function returns ... MySQL Enterprise Encryption functions have these general characteristics: For arguments of the wrong type or an incorrect number of arguments, each function returns an ...
https://dev.mysql.com/doc/refman/8.4/en/enum.html
Creating and Using ENUM Columns Index Values for Enumeration Literals Handling of Enumeration Literals Empty or NULL Enumeration Values Enumeration Sorting Enumeration Limitations Creating and Using ENUM Columns An enumeration value must be a quoted ... An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-reference.html
The value is NULL, or a non-NULL account that has the format user_name@host_name: If the value is NULL, the firewall records allowlist rules for statements received from any account that is a member of the group. If the value is non-NULL, the ...
https://dev.mysql.com/doc/refman/8.4/en/json-creation-functions.html
mysql> SELECT JSON_ARRAY(1, "abc", NULL, TRUE, CURTIME()); +---------------------------------------------+ | JSON_ARRAY(1, "abc", NULL, TRUE, CURTIME()) | +---------------------------------------------+ | [1, "abc", null, true, "11:30:24.000000"] | ... The functions listed in this section compose JSON values from component ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-data-locks-table.html
row *************************** ENGINE: INNODB ENGINE_LOCK_ID: 139664434886512:1059:139664350547912 ENGINE_TRANSACTION_ID: 2569 THREAD_ID: 46 EVENT_ID: 12 OBJECT_SCHEMA: test OBJECT_NAME: t1 PARTITION_NAME: NULL SUBPARTITION_NAME: NULL INDEX_NAME: ...For information about which lock requests are blocked by which held locks, see Section 29.12.13.2, “The data_lock_waits ...