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/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/performance-schema-event-tables.html
For wait, stage, statement, and transaction events, the Performance Schema can monitor and store current events. In addition, when events end, the Performance Schema can store them in history tables. For each event type, the Performance Schema uses ...events_xxx_history: The “recent history” table stores the most recent events that have ended per thread (up to a maximum number of rows per ...
https://dev.mysql.com/doc/refman/5.7/en/replication-semisync.html
When one user is too busy, this slows it down, which can be useful in some deployment situations. For statements that do not occur in transactional context (that is, when no transaction has been started with START TRANSACTION or SET autocommit = 0), ...With fully synchronous replication, when a source commits a transaction, all replicas must also have committed the transaction before the source returns to the session that performed the ...
https://dev.mysql.com/doc/refman/5.7/en/blob.html
For security and other reasons, it is usually preferable to do so using application code rather than giving application users the FILE privilege. They have the binary character set and collation, and comparison and sorting are based on the numeric ... A BLOB is a binary large object that can hold a variable amount of ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-purge-configuration.html
If DML action is concentrated on a few tables, keep the innodb_purge_threads setting low so that the threads do not contend with each other for access to the busy tables. InnoDB does not physically remove a row from the database immediately when ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-per-table-tablespaces.html
As a result, there are possible performance improvements when using file-per-table tablespaces in conjunction with this setting. The innodb_autoextend_increment variable, which defines the increment size for extending the size of an auto-extending ... A file-per-table tablespace contains data and indexes for a single InnoDB table, and is stored on the file system in a single data ...File-per-table tablespace characteristics are described under the following topics in this section: File-Per-Table Tablespace Configuration File-Per-Table Tablespace Data Files File-Per-Table Tablespace Advantages ...
https://dev.mysql.com/doc/refman/5.7/en/general-tablespaces.html
As with file-per-table tablespaces, the ability to place data files outside of the MySQL data directory allows you to manage performance of critical tables separately, setup RAID or DRBD for specific tables, or bind tables to particular disks, for ...The server keeps tablespace metadata in memory for the lifetime of a ... A general tablespace is ...
https://dev.mysql.com/doc/refman/5.7/en/show-slave-hosts.html
User: The replica server user name as, specified on the replica with the --report-user option. Password: The replica server password as, specified on the replica with the --report-password option. A zero in this column means that the replica port ...
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/sys-processlist.html
The MySQL process list indicates the operations currently being performed by the set of threads executing within the server. db The default database for the thread, or NULL if there is none. They provide more complete information than the SHOW ...