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-what-is-new-7-6.html
This should help resolve issues with page and extent handling that were visible to the user as problems with rapid creating and dropping of Disk Data tables, and for which the old format did not provide a ready means to fix. The new format is now ...
https://dev.mysql.com/doc/refman/5.7/en/flush.html
Reloading the grant tables is necessary to enable updates to MySQL privileges and users only if you make such changes directly to the grant tables; it is not needed for account management statements such as GRANT or REVOKE, which take effect ...| ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-buffer-pool-tables.html
The InnoDB INFORMATION_SCHEMA buffer pool tables provide buffer pool status information and metadata about the pages within the InnoDB buffer pool. The InnoDB INFORMATION_SCHEMA buffer pool tables include those listed below: mysql> SHOW TABLES FROM ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-logging.html
Then use either of the following techniques to prevent it from being created again: Set the MYSQL_HISTFILE environment variable to /dev/null. Create .mysql_history as a symbolic link to /dev/null; this need be done only once: ln -s /dev/null ... The ...
https://dev.mysql.com/doc/refman/5.7/en/upgrade-binary-package.html
For example: mysqld_safe --user=mysql --datadir=/path/to/5.7-datadir & Reset the root password: $> mysql -u root -p Enter password: **** <- enter temporary root password mysql> ALTER USER USER() IDENTIFIED BY 'your new password'; Load the previously ...For example: mysqladmin -u root -p shutdown mysqld_safe --user=mysql --datadir=/path/to/existing-datadir & Logical Upgrade A logical upgrade involves exporting SQL from the old MySQL instance using a backup or export utility such as mysqldump or mysqlpump, installing the new MySQL server, and applying the SQL to your new MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/replication-encrypted-connections.html
If you want to ensure that the source only accepts replicas that connect using encrypted connections, create a replication user account on the source using the REQUIRE SSL option, then grant that user the REPLICATION SLAVE privilege. For example: ...
https://dev.mysql.com/doc/refman/5.7/en/entering-queries.html
At this point, it is more important to find out a little about how to issue queries than to jump right in creating tables, loading data into them, and retrieving data from them. If you decide you do not want to execute a query that you are in the ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-legacy-filtering.html
The value for either variable can be NULL or a string containing one or more comma-separated account names, each in user_name@host_name format. Modifications to audit_log_include_accounts or audit_log_exclude_accounts affect only connections created ...This enables you to control whether audited events are written to the audit log file based on the account from which events originate or event ... Note This section describes legacy audit log filtering, which applies under either of these ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-init-startup-configuration.html
Note InnoDB does not open all user tables and associated data files at startup. InnoDB is a transaction-safe (ACID compliant) storage engine with commit, rollback, and crash-recovery capabilities to protect user data. With regard to InnoDB recovery ... The first decisions to make about InnoDB configuration involve the configuration of data files, log files, page size, and memory buffers, which should be configured before initializing ...
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_waiter repeatedly (each 100 milliseconds) prints out the status of ...