Search Results
https://dev.mysql.com/doc/refman/8.4/en/identifier-length.html
Values such as user name and host names in MySQL account names are strings rather than identifiers. The following table describes the maximum length for each type of identifier. For constraint definitions that include no constraint name, the server ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-ft-config-table.html
The VALUE column is empty if there is no user-defined stopword table. use_stopword: Indicates whether a stopword table is used, which is defined when the FULLTEXT index is created. The INNODB_FT_CONFIG table provides metadata about the FULLTEXT ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locking-reads.html
Here, FOR SHARE is not a good solution because if two users read the counter at the same time, at least one of them ends up in deadlock when it attempts to update the counter. If you query data and then insert or update related data within the same ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-purge-configuration.html
Too many active purge threads in this scenario can cause contention with user threads, so manage the innodb_purge_threads setting accordingly. The reason that a long running transaction can cause the History list length to increase is that under a ... InnoDB does not physically remove a row from the database immediately when you delete it with an SQL ...
https://dev.mysql.com/doc/refman/8.4/en/my-print-defaults.html
To see what options are present in those groups in the standard option files, invoke my_print_defaults like this: $> my_print_defaults mysqlcheck client --user=myusername --password=password --host=localhost The output consists of options, one per ... my_print_defaults displays the options that are present in option groups of option ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-basics.html
For more information about the files and directories created by local checkpoints and global checkpoints, see NDB Cluster Data Node File System Directory. Because it is ubiquitous, most users employ TCP/IP over Ethernet for NDB Cluster. NDBCLUSTER ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning.html
An attempt to create a partitioned tables using a storage engine that does not supply native partitioning support fails with ER_CHECK_NOT_IMPLEMENTED. Other sources of information about user-defined partitioning in MySQL include the following: MySQL ...Note Table partitioning differs from partitioning as used by window ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-connection-attribute-tables.html
Attribute names that begin with an underscore (_) are reserved for internal use and should not be created by application programs. Some MySQL client programs define additional attributes: mysql: os_user: The name of the operating system user running ... Connection attributes are key-value pairs that application programs can pass to the server at connect ...
https://dev.mysql.com/doc/refman/8.4/en/perl-installation.html
These tests attempt to connect to the local MySQL server using the default user name and password. (The default user name is your login name on Unix, and ODBC on Windows. For example, to unpack and build a DBI distribution, use a procedure such as ... MySQL Perl support requires that you have installed MySQL client programming support (libraries and header ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-errors.html
For example, you might need to create a nonexistent table before you can start the replica again. This means that the replica can accept only that part of the database to which a given user has been granted access (as long as any updates to this ...