PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/string-functions.html
mysql> SELECT ELT(1, 'Aa', 'Bb', 'Cc', 'Dd'); -> 'Aa' mysql> SELECT ELT(4, 'Aa', 'Bb', 'Cc', 'Dd'); -> 'Dd' EXPORT_SET(bits,on,off[,separator[,number_of_bits]]) Returns a string such that for every bit set in the value bits, you get an on string and ...For functions that operate on string positions, the first position is ...
https://dev.mysql.com/doc/refman/5.7/en/thread-pool-tuning.html
If the application has high requirements for the response time, it should most likely throttle users at a higher level itself. This section provides guidelines on setting thread pool system variables for best performance, measured using a metric ...
https://dev.mysql.com/doc/refman/5.7/en/index-statistics.html
These variables have three possible values, which differ as follows: When the variable is set to nulls_equal, all NULL values are treated as identical (that is, they all form a single value group). Setting the global value affects statistics ...When ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-thread-pool.html
It is designed to cache idle connections in the MySQL client for use by other users as they are needed. If you are using the innodb_thread_concurrency to limit the number of concurrently executing statements, you should find that the Thread Pool ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statement-performance-analyzer.html
Configuration Options statement_performance_analyzer() operation can be modified using the following configuration options or their corresponding user-defined variables (see Section 26.4.2.1, “The sys_config Table”): debug, @sys.debug If this ...
https://dev.mysql.com/doc/refman/5.7/en/enum.html
For example, this CREATE TABLE statement does not work because the CONCAT function cannot be used to construct an enumeration value: CREATE TABLE sizes ( size ENUM('small', CONCAT('med','ium'), 'large') ); You also cannot employ a user variable as ...For information about using result set metadata to distinguish them from other strings, see C API Basic Data ... An ENUM is a string object with a value chosen ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-consumer-configurations.html
The consumer settings in the setup_consumers table form a hierarchy from higher levels to lower. If you do not need the information provided by enabling lower-level settings, disable them and the Performance Schema executes less code on your behalf ...The following discussion describes how consumers work, showing specific configurations and their effects as consumer settings are enabled progressively from high to ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-natural-language.html
Stopword processing is controlled by the configuration options innodb_ft_enable_stopword, innodb_ft_server_stopword_table, and innodb_ft_user_stopword_table for InnoDB search indexes, and ft_stopword_file for MyISAM ones. | ... By default or with ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-failover.html
Of course, it is not possible for one mysqld instance to access user variables set on another server instance directly. We have employed a user variable @latest here to represent the value obtained in Step 1. This means that the ndb_apply_status ...
https://dev.mysql.com/doc/refman/5.7/en/ipv6-local-connections.html
As an administrator, connect to the server and create an account for a local user who connects from the ::1 local IPv6 host address: mysql> CREATE USER 'ipv6user'@'::1' IDENTIFIED BY 'ipv6pass'; For the permitted syntax of IPv6 addresses in account ...mysql> SELECT CURRENT_USER(), @@bind_address; +----------------+----------------+ | CURRENT_USER() | @@bind_address | +----------------+----------------+ | ipv6user@::1 | :: | ...