PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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/select-into.html
The reason for this is that the MySQL server cannot create a file that is owned by anyone other than the user under whose account it is running. Note Any file created by INTO OUTFILE or INTO DUMPFILE is writable by all users on the server host. For ...INTO form of SELECT enables a query result to be stored in variables or written to a file: SELECT ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-status-variable-tables.html
There are also summary tables that provide status variable information aggregated by account, host name, and user name. The Performance Schema supports TRUNCATE TABLE for status variable tables as follows: global_status: Resets thread, account, ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-summary-tables.html
Summary tables provide aggregated information for terminated events over time. The tables in this group summarize event data in different ways. Each summary table has grouping columns that determine how to group the data to be aggregated, and ...
https://dev.mysql.com/doc/refman/5.7/en/password-logging.html
Passwords can be written as plain text in SQL statements such as CREATE USER, GRANT, SET PASSWORD, and statements that invoke the PASSWORD() function. Statement logging avoids writing passwords as cleartext for the following statements: CREATE USER ...In particular, INSERT or UPDATE statements for the mysql.user system table that refer to literal passwords are logged as is, so you should avoid such ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-reference.html
log_bin_trust_function_creators: If equal to 0 (default), then when --log-bin is used, stored function creation is allowed only to users having SUPER privilege and only if function created does not break binary logging. report_password: Arbitrary ...
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/audit-log-installation.html
As of MySQL 5.7.23, for new MySQL installations, the USER and HOST columns in the audit_log_user table used by MySQL Enterprise Audit have definitions that better correspond to the definitions of the User and Host columns in the mysql.user system ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-schema.html
User intervention is normally not required to create or maintain either of these tables, since both are maintained by the NDB binary log (binlog) injector thread. Some conflict resolution functions (NDB$OLD(), NDB$EPOCH(), NDB$EPOCH_TRANS()) require ...The ndb_binlog_index and ndb_apply_status tables are created in the mysql ... ndb_apply_status Table ndb_binlog_index Table ndb_replication Table Replication in NDB Cluster makes use of a number of dedicated tables in the mysql database on each MySQL Server ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-linux-binary.html
Some OS distributions create these as part of the operating system installation process. Change location to the directory containing the downloaded file, unpack the archive, and create a symbolic link named mysql to the mysql directory. $> cd ...