Search Results
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-list-certs.html
list certs [--active|-A] [--all|-a] [--retired|-r] cluster_name The command lists the files created by the create certs command for the MySQL NDB Cluster named cluster_name.
https://dev.mysql.com/doc/refman/9.7/en/ansi-diff-comments.html
Standard SQL uses the C syntax /* this is a comment */ for comments, and MySQL Server supports this syntax as well. MySQL Server supports a variant of the -- comment style; the -- start-comment sequence is accepted as such, but must be followed by ...MySQL also support extensions to this syntax that enable MySQL-specific SQL to be embedded in the comment; see Section 11.7, ...
https://dev.mysql.com/doc/refman/9.7/en/group-by-modifiers.html
The server looks at the columns named in the GROUP BY clause following the leftmost one that has changed value. (For information about nonaggregated columns and GROUP BY, see Section 14.19.3, “MySQL Handling of GROUP BY”.) In this case, the ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-replication-group-members.html
The performance_schema.replication_group_members table is used for monitoring the status of the different server instances that are members of the group. At that point, servers exchange some of their metadata to synchronize themselves and continue ...The information in the table is updated whenever there is a view change, for example when the configuration of the group is dynamically changed when a new member ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-online-ddl-performance.html
Reduced locking and waiting for MySQL server resources leads to greater scalability, even for operations that are not involved in the DDL operation. You might also use this clause if the server is supposed to be idle, to avoid unexpected table ...
https://dev.mysql.com/doc/refman/9.7/en/insert.html
In MySQL 9.7, the DELAYED keyword is accepted but ignored by the server. SELECT statements are handled the same way as multiple-row inserts because the server does not examine the result set from the SELECT to see whether it returns a single row. If ... INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { {VALUES | VALUE} (value_list) [, (value_list)] ...
https://dev.mysql.com/doc/refman/9.7/en/making-trace-files.html
If the mysqld server does not start or it crashes easily, you can try to create a trace file to find the problem. (On Windows, the debugging server is named mysqld-debug rather than mysqld.) Start the mysqld server with a trace log in ...To do ...
https://dev.mysql.com/doc/refman/9.7/en/monitor-innodb-mutex-waits-performance-schema.html
When two or more threads executing in the server need to access the same resource, the threads compete against each other. After adding the performance-schema-instrument rules to your configuration file, restart the server. A mutex is a ...
https://dev.mysql.com/doc/refman/9.7/en/myisam-table-maintenance.html
myisamchk operations that affect indexes can cause MyISAM FULLTEXT indexes to be rebuilt with full-text parameters that are incompatible with the values used by the MySQL server. One advantage of these statements over myisamchk is that the server ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-enterprise-audit.html
MySQL Enterprise Edition includes MySQL Enterprise Audit, implemented using a server plugin. MySQL Enterprise Audit uses the open MySQL Audit API to enable standard, policy-based monitoring and logging of connection and query activity executed on ...Designed to meet the Oracle audit specification, MySQL Enterprise Audit provides an out of box, easy to use auditing and compliance solution for applications that are governed by both internal and external regulatory ...