Search Results
https://dev.mysql.com/doc/refman/8.4/en/example-auto-increment.html
This is useful when you want to put data into ordered groups. You can also explicitly assign 0 to the column to generate sequence numbers, unless the NO_AUTO_VALUE_ON_ZERO SQL mode is enabled. For example: INSERT INTO animals (id,name) ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-stored-procs.html
Is it possible to group stored procedures or stored functions into packages? A.4.9. Is it possible to group stored procedures or stored functions into packages? No. Where can I find documentation for MySQL stored procedures and stored functions? ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-thread-pool.html
The Thread Pool then manages client connections within configurable thread groups, where they are prioritized and queued based on the nature of the work they were submitted to accomplish. If you are using the innodb_thread_concurrency to limit the ...What is the Thread Pool and what problem does it solve? ...
https://dev.mysql.com/doc/refman/8.4/en/features.html
For example: mysql> SELECT CONCAT(first_name, ' ', last_name) -> FROM citizen -> WHERE income/dependents > 10000 AND age > 30; Full support for SQL GROUP BY and ORDER BY clauses. Support for group functions (COUNT(), AVG(), STD(), SUM(), MAX(), ...
https://dev.mysql.com/doc/refman/8.4/en/fips-mode.html
This includes replication (source/replica and Group Replication) and X Plugin, which run within the server. FIPS mode on the server side applies to cryptographic operations performed by the server, including those performed by MySQL Replication ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-boolean.html
MySQL can perform boolean full-text searches using the IN BOOLEAN MODE modifier. With this modifier, certain characters have special meaning at the beginning or end of words in the search string. In the following query, the + and - operators ...
https://dev.mysql.com/doc/refman/8.4/en/identifier-case-sensitivity.html
The following statement would not work because it refers to a table both as my_table and as MY_TABLE: mysql> SELECT * FROM my_table WHERE MY_TABLE.col=1; Partition, subpartition, column, index, stored routine, event, and resource group names are not ... In MySQL, databases correspond to directories within the data ...
https://dev.mysql.com/doc/refman/8.4/en/identifier-length.html
The following table describes the maximum length for each type of identifier. For constraint definitions that include no constraint name, the server internally generates a name derived from the associated table name. For example, internally ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-thread-pool-table-reference.html
Table 28.7 INFORMATION_SCHEMA Thread Pool Tables Table Name Description TP_THREAD_GROUP_STATE Thread pool thread group states TP_THREAD_GROUP_STATS Thread pool thread group statistics TP_THREAD_STATE Thread pool thread information .
https://dev.mysql.com/doc/refman/8.4/en/innodb-persistent-stats.html
For example, the following query retrieves index sizes for partitions of table t1: mysql> SELECT SUM(stat_value) pages, index_name, SUM(stat_value)*@@innodb_page_size size FROM mysql.innodb_index_stats WHERE table_name like 't1#P%' AND stat_name = ... The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so that the optimizer is more likely to make consistent choices each time for a given ...