Search Results
https://dev.mysql.com/doc/refman/9.7/en/mle-component.html
For MySQL installations supporting the uninstallation of the MLE component, you should be aware that it is not possible to perform the uninstallation from within a user session that has created or executed any JavaScript stored procedures. With the ... The Multilingual Engine component (MLE) provides support for languages other than SQL in MySQL stored procedures and ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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 ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/mysqlbackup.full.html
After you have created a full backup, you might perform incremental backups (which are smaller and faster) for the next several backup tasks. This section outlines some of the things to consider when deciding on a strategy for creating full backups.
https://dev.mysql.com/doc/mysql-shell/9.7/en/innodb-clusterset-failover.html
In the case of a network partition, the failover can create a split-brain situation, where the different parts of the topology have divergent transaction sets. To carry out an emergency failover for the primary InnoDB Cluster, follow this procedure: ... An emergency failover makes a selected replica cluster into the primary InnoDB Cluster for the InnoDB ClusterSet ...