PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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/federated-create-server.html
For reference, the format of the CONNECTION string is as follows: scheme://user_name[:password]@host_name[:port_num]/db_name/tbl_name Description CONNECTION string CREATE SERVER option mysql.servers column Connection scheme scheme wrapper_name ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-query-expansion.html
This is generally useful when a search phrase is too short, which often means that the user is relying on implied knowledge that the full-text search engine lacks. For example, a user searching for “database” may really mean that “MySQL”, ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-launching.html
Otherwise, you must install the plugin manually; to do this, connect to the server using the mysql client, and issue the SQL statement shown here: mysql> INSTALL PLUGIN group_replication SONAME 'group_replication.so'; Important The mysql.session ...
https://dev.mysql.com/doc/refman/5.7/en/gtid-functions.html
WAIT_FOR_EXECUTED_GTID_SET() monitors all the GTIDs that are applied on the server, including transactions that arrive from all replication channels and user clients. In contrast, WAIT_FOR_EXECUTED_GTID_SET() stops after the transactions have been ... The functions described in this section are used with GTID-based ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-events-table.html
DEFINER The account named in the DEFINER clause (often the user who created the event), in 'user_name'@'host_name' format. The EVENTS table provides information about Event Manager events, which are discussed in Section 23.4, “Using the Event ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-internal-data.html
This is not like user tables, where the data changes only when application-initiated updates occur. Because InnoDB must temporarily stall while the transaction and locking data is collected, too frequent queries of these tables can negatively impact ... The data exposed by the transaction and locking tables (INNODB_TRX, INNODB_LOCKS, and INNODB_LOCK_WAITS) represents a glimpse into fast-changing ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-intro.html
You can map multiple columns into the “value” part of the key-value store, with column values delimited by a user-specified separator character. Advanced users can configure the system as a traditional memcached server, with all data cached only ... The InnoDB memcached plugin implements memcached as a MySQL plugin daemon that accesses the InnoDB storage engine directly, bypassing the MySQL SQL ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-temporary-tablespace.html
Non-compressed, user-created temporary tables and on-disk internal temporary tables are created in a shared temporary tablespace. Issue a query similar to this one to view temporary tablespace metadata: mysql> SELECT * FROM INFORMATION_SCHEMA.FILES ...The innodb_temp_data_file_path variable defines the relative path, name, size, and attributes for temporary tablespace data ...
https://dev.mysql.com/doc/refman/5.7/en/macos-installation-launchd.html
macOS uses launch daemons to automatically start, stop, and manage processes and applications such as MySQL. The md5 checksum of a file containing the above snippet is 24710a27dc7a28fb7ee6d825129cd3cf. To enable the launchd service, you can either: ...