Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-transaction-isolation-levels.html
A user can change the isolation level for a single session or for all subsequent connections with the SET TRANSACTION statement. This is because a non-locking SELECT statement presents the state of the database from a read view which consists of ...
https://dev.mysql.com/doc/refman/8.4/en/ipv6-brokers.html
Create an account at Freenet6 by visiting this URL and signing up: http://gogonet.gogo6.com After creating the account, go to this URL, sign in, and create a user ID and password for the IPv6 broker: ...If so, any accounts you create that name the ... If you do not have a public IPv6 address that enables your system to communicate over IPv6 outside your local network, you can obtain one from an IPv6 ...
https://dev.mysql.com/doc/refman/8.4/en/keywords.html
Reserved words are permitted as identifiers if you quote them as described in Section 11.2, “Schema Object Names”: mysql> CREATE TABLE interval (begin INT, end INT); ERROR 1064 (42000): You have an error in your SQL syntax ... Certain keywords, ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-repair.html
In this case, you must use ALTER TABLE to increase the MAX_ROWS and AVG_ROW_LENGTH table option values: ALTER TABLE tbl_name MAX_ROWS=xxx AVG_ROW_LENGTH=yyy; If you do not know the current table option values, use SHOW CREATE TABLE. On Unix, make ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-diskio.html
For example, creating a new MySQL instance and its associated data files could cause large surges of disk write activity, impeding the performance of other MySQL instances that use the same storage devices. (It is necessary to use the mount option ... If you follow best practices for database design and tuning techniques for SQL operations, but your database is still slow due to heavy disk I/O activity, consider these disk I/O ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-quick-start.html
| events_stages_current | | events_stages_history | | events_stages_history_long | | events_stages_summary_by_account_by_event_name | | events_stages_summary_by_host_by_event_name | | events_stages_summary_by_thread_by_event_name | | ... This ...
https://dev.mysql.com/doc/refman/8.4/en/replication-channels.html
This channel is always present; it cannot be created or destroyed by the user. The maximum number of channels that can be created on one replica server in a multi-source replication topology is 256. To provide compatibility with previous versions, ... In MySQL multi-source replication, a replica opens multiple replication channels, one for each source ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto-additionalslaves.html
To do this, you can set up the new replica by copying the data directory of an existing replica, and giving the new replica a different server ID (which is user-specified) and server UUID (which is generated at startup). Note If the replication ...
https://dev.mysql.com/doc/refman/8.4/en/show-index.html
These two statements are equivalent: SHOW INDEX FROM mytable FROM mydb; SHOW INDEX FROM mydb.mytable; The optional EXTENDED keyword causes the output to include information about hidden indexes that MySQL uses internally and are not accessible by ...
https://dev.mysql.com/doc/refman/8.4/en/switchable-optimizations.html
The parent query does not set a user variable, since rewriting it may affect the order of execution, which could lead to unexpected results if the variable is accessed more than once in the same query. Its value is a set of flags, each of which has ...