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/savepoint.html
SAVEPOINT identifier ROLLBACK [WORK] TO [SAVEPOINT] identifier RELEASE SAVEPOINT identifier InnoDB supports the SQL statements SAVEPOINT, ROLLBACK TO SAVEPOINT, RELEASE SAVEPOINT and the optional WORK keyword for ROLLBACK. The SAVEPOINT statement ...The ROLLBACK TO SAVEPOINT statement rolls back a transaction to the named savepoint without terminating the ...
https://dev.mysql.com/doc/refman/5.7/en/drop-tablespace.html
ENGINE sets the storage engine that uses the tablespace, where engine_name is the name of the storage engine. For an InnoDB tablespace, all tables must be dropped from the tablespace prior to a DROP TABLESPACE operation. As with the InnoDB system ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-blob.html
Since the performance requirements to retrieve and display a BLOB value might be very different from other data types, you could put the BLOB-specific table on a different storage device or even a separate database instance. For a table with several ... When storing a large blob containing textual data, consider compressing it ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-examples.html
Tune a query by writing it differently, Tune the database schema (tables, indexes, and so forth). The Performance Schema is a tool to help a DBA do performance tuning by taking real measurements instead of “wild guesses.” This section ...Then ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-syntax-warnings.html
To import the dump file into a new database, and have the tables re-created as they exist in the original database, ensure the server has the proper settings for the configuration parameters innodb_file_format and innodb_file_per_table. SQL ...ERROR ... This section describes syntax warnings and errors that you may encounter when using the table compression feature with file-per-table tablespaces and general ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-logging-management-commands.html
The following table describes the default setting (for all data nodes) of the cluster log category threshold. For example, a STARTUP event with a priority of 3 is not logged unless the threshold for STARTUP is set to 3 or higher. Note Events are ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking.html
As of MySQL 5.7.24, MySQL Enterprise Edition provides data masking and de-identification capabilities: Transformation of existing data to mask it and remove identifying characteristics, such as changing all digits of a credit card number but the ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-memory.html
myisamchk uses no more memory than its memory-related variables are set to. The default is to use only about 3MB to perform repairs. For example, if you have more than 512MB RAM available, you could use options such as these (in addition to any ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-memory-tables.html
Hash indexes are only fast for queries that look up single values through the = operator, or a restricted set of values through the IN operator. Consider using MEMORY tables for noncritical data that is accessed often, and is read-only or rarely ...
https://dev.mysql.com/doc/refman/5.7/en/row-subqueries.html
If the t2 row col3 and col4 values are not equal the col1 and col2 values of any t1 row, the expression is FALSE and the query returns an empty result set. For information about how each operator works for row comparisons, see Section 12.4.2, ...