Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-by-modifiers.html
Or you can use ROLLUP, which provides both levels of analysis with a single query. The GROUP BY clause permits a WITH ROLLUP modifier that causes summary output to include extra rows that represent higher-level (that is, super-aggregate) summary ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-enterprise-backup.html
In this example, we assume the hosts are both Linux servers and use SCP to copy the files between them: s2/backups> scp my.mbi_2206_1429 s3:/backups Restore the backup. In this example we assume the hosts are both Linux servers and use SCP to copy ... MySQL Enterprise Backup is a commercially-licensed backup utility for MySQL Server, available with MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-frequently-asked-questions.html
However, if the network drops packets, leading to re-transmissions and higher end-to-end latency, throughput and latency are both negatively affected. The changes are made and reverted only if auto_increment_increment and auto_increment_offset each ...What is the maximum number of MySQL servers in a group? A group can consist of maximum 9 ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-responses-failure-partition.html
Consider the following points when deciding whether or not to set an unreachable majority timeout: In a symmetric group, for example a group with two or four servers, if both partitions contain an equal number of servers, both groups consider ... By ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-restarting-group.html
For Group Replication, this includes both transactions that have been committed and applied, which are in the gtid_executed GTID set, and transactions that have been certified but not yet applied, which are in the group_replication_applier channel.
https://dev.mysql.com/doc/refman/8.4/en/handler-scope.html
A stored program may include handlers to be invoked when certain conditions occur within the program. The applicability of each handler depends on its location within the program definition and on the condition or conditions that it handles: A ...
https://dev.mysql.com/doc/refman/8.4/en/identifier-case-sensitivity.html
The following statement would not work because it refers to a table both as my_table and as MY_TABLE: mysql> SELECT * FROM my_table WHERE MY_TABLE.col=1; Partition, subpartition, column, index, stored routine, event, and resource group names are not ... In MySQL, databases correspond to directories within the data ...
https://dev.mysql.com/doc/refman/8.4/en/index-statistics.html
However, for a join based on the = operator, NULL is different from non-NULL values: expr1 = expr2 is not true when expr1 or expr2 (or both) are NULL. The innodb_stats_method system variable has a global value; the myisam_stats_method system ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-cmp-per-index-table.html
For a compressed InnoDB table, both the table data and all the secondary indexes are compressed. row *************************** database_name: employees table_name: salaries index_name: emp_no compress_ops: 0 compress_ops_ok: 0 compress_time: 0 ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-and-mysql-replication.html
Cascading actions for InnoDB tables on the source are executed on the replica only if the tables sharing the foreign key relation use InnoDB on both the source and replica. It is possible to use replication in a way where the storage engine on the ...