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/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: ...
https://dev.mysql.com/doc/refman/5.7/en/macos-installation-notes.html
You may need (or want) to create a specific mysql user to own the MySQL directory and data. You can do this through the Directory Utility, and the mysql user should already exist. For use in single user mode, an entry for _mysql (note the underscore ... You should keep the following issues and notes in mind: As of macOS 10.14 (Majave), the macOS MySQL 5.7 Installer application requires permission to control System Events so it can display a generated (temporary) MySQL root ...
https://dev.mysql.com/doc/refman/5.7/en/memory-storage-engine.html
User-Created and Temporary Tables MEMORY table contents are stored in memory, which is a property that MEMORY tables share with internal temporary tables that the server creates on the fly while processing queries. The MEMORY storage engine ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-general-info.html
Instead, users of NDB Cluster binaries from Oracle should upgrade to the most recent binary release of NDB Cluster for supported platforms—these include RPMs that should work with most Linux distributions. NDB Cluster users who build from source ... MySQL NDB Cluster uses the MySQL server with the NDB storage ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-example-data.html
If no primary key is defined by the user when a table is created, the NDBCLUSTER storage engine automatically generates a hidden one. Setting or changing MySQL user accounts (including the root account) effects only applications that access the SQL ... Note The information in this section applies to NDB Cluster running on both Unix and Windows ...