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-compression-tuning-monitoring.html
The information in these tables is system-wide: it summarizes the compression statistics across all compressed tables in your database. Based on the information in the INNODB_CMP and INNODB_CMP_PER_INDEX tables and overall application performance ...
https://dev.mysql.com/doc/refman/5.7/en/events-syntax.html
An event can be dropped by any user having the EVENT privilege for the database on which the event is defined. MySQL provides several SQL statements for working with scheduled events: New events are defined using the CREATE EVENT statement. The ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-turning-off.html
Oracle recommends InnoDB as the preferred storage engine for typical database applications, from single-user wikis and blogs running on a local system, to high-end applications pushing the limits of performance. In MySQL 5.7, InnoDB is the default ...The --skip-innodb option is deprecated and has no effect, and its use results in a ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines-privileges.html
Also, the default SQL SECURITY characteristic for a routine is DEFINER, which enables users who have access to the database with which the routine is associated to execute the routine. The creator of a routine is the account used to execute the ...
https://dev.mysql.com/doc/refman/5.7/en/file-permissions.html
For example, setting UMASK=0600 is equivalent to UMASK=384 because 0600 octal is 384 decimal. If you have problems with file permissions, the UMASK or UMASK_DIR environment variable might be set incorrectly when mysqld starts. For example, mysqld ...If this is unsuitable, create the error file manually with the desired access mode prior to executing ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-summary.html
All servers therefore receive the same set of transactions in the same order, and a global total order is established for the transactions. The replication group is a set of servers that each have their own entire copy of the data (a shared-nothing ... Group Replication is a technique that can be used to implement fault-tolerant ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-acid.html
The ACID model is a set of database design principles that emphasize aspects of reliability that are important for business data and mission-critical applications. In cases where you have additional software safeguards, ultra-reliable hardware, or ...Because of the many possibilities depending on the capabilities of your CPU, network, and storage devices, this aspect is the most complicated to provide concrete guidelines ...MySQL includes components such as the InnoDB storage ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-files-table.html
TABLESPACE is the file type for any system, general, or file-per-table tablespace file that holds tables, indexes, or other forms of user data. The FILES table provides information about the files in which MySQL tablespace data is stored. In NDB ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-optimizer-trace-table.html
INSUFFICIENT_PRIVILEGES If a traced query uses views or stored routines that have SQL SECURITY with a value of DEFINER, it may be that a user other than the definer is denied from seeing the trace of the query. The OPTIMIZER_TRACE table provides ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-deadlocks.html
To view the last deadlock in an InnoDB user transaction, use SHOW ENGINE INNODB STATUS. Because all transactions involved are waiting for the same resource to become available, none of them ever releases the lock it holds. For a deadlock example, ...