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/mysql-cluster-programs-ndb-waiter.html
SINGLE USER MODE: This is shown for all cluster data nodes when the cluster is in single user mode. --single-user The program waits for the cluster to enter single user mode. --ndb-connectstring Command-Line Format ...By default, it waits for the ...
https://dev.mysql.com/doc/refman/5.7/en/starting-server.html
Start the MySQL server like this if your installation includes mysqld_safe: $> bin/mysqld_safe --user=mysql & Note For Linux systems on which MySQL is installed using RPM packages, server startup and shutdown is managed using systemd rather than ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-options.html
--keyring-migration-user=user_name Command-Line Format --keyring-migration-user=user_name Type String The user name of the MySQL account used for connecting to the running server that is currently using one of the key migration keystores. MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-tables.html
The setup_timers table contains a row with a NAME value of statement that indicates the unit for statement event timing. These tables store statement events: events_statements_current: The current statement event for each thread. There are also ...
https://dev.mysql.com/doc/refman/5.7/en/index-statistics.html
These variables have three possible values, which differ as follows: When the variable is set to nulls_equal, all NULL values are treated as identical (that is, they all form a single value group). Setting the global value affects statistics ...When ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-unexpected-replica-halt.html
As a table, updates to the applier metadata repository are committed together with the transactions, meaning that the replica's progress information recorded in that repository is always consistent with what has been applied to the database, even in ... In order for replication to be resilient to unexpected halts of the server (sometimes described as crash-safe) it must be possible for the replica to recover its state before ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-legacy-filtering.html
Example: To enable audit logging only for the user1 and user2 local host accounts, set the audit_log_include_accounts system variable like this: SET GLOBAL audit_log_include_accounts = 'user1@localhost,user2@localhost'; Only one of ...The value for ...For example, to log all statement events but only failed connection events, use these settings: SET GLOBAL audit_log_statement_policy = ALL; SET GLOBAL audit_log_connection_policy = ERRORS; Another policy system variable, audit_log_policy, is available but does not afford as much control as audit_log_connection_policy and ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-system-tables.html
Traditionally, you would get this type of information using the techniques from Section 14.18, “InnoDB Monitors”, setting up InnoDB monitors and parsing the output from the SHOW ENGINE INNODB STATUS statement. The first index is GEN_CLUST_INDEX, ... You can extract metadata about schema objects managed by InnoDB using InnoDB INFORMATION_SCHEMA system ...
https://dev.mysql.com/doc/refman/5.7/en/index-page-merge-threshold.html
When the “page-full” percentage for an index page falls below 50%, which is the default MERGE_THRESHOLD setting, InnoDB attempts to merge the index page with a neighboring page. Setting MERGE_THRESHOLD for a Table You can set the MERGE_THRESHOLD ...If the “page-full” percentage for an index page falls below the MERGE_THRESHOLD value when a row is deleted or when a row is shortened by an UPDATE operation, InnoDB attempts to merge the index page with a neighboring index ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-undo-logs.html
Undo logs that reside in the temporary tablespace are used for transactions that modify data in user-defined temporary tables. An undo log record contains information about how to undo the latest change by a transaction to a clustered index record.