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/myisam-start.html
myisam_recover_options=mode Set the mode for automatic recovery of crashed MyISAM tables. Note This is a limit per thread! delay_key_write=ALL Don't flush key buffers between writes for any MyISAM table. myisam_sort_buffer_size Set the size of the ... The following options to mysqld can be used to change the behavior of MyISAM ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-cmp-per-index-table.html
The INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET tables provide status information on operations related to compressed InnoDB tables and indexes, with separate statistics for each combination of database, table, and index, to help you ...The ...For a compressed InnoDB table, both the table data and all the secondary indexes are ...In this context, the table data is ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-online-add-node-example.html
This should be similar to what is shown here, where password is the MySQL root password for a given MySQL server instance: $> mysqladmin -uroot -ppassword shutdown 081208 20:19:56 mysqld_safe mysqld from pid file /usr/local/mysql/var/tonfisk.pid ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions.html
For information on using replication in a backup environment, including notes on the setup, backup procedure, and files to back up, see Section 16.3.1, “Using Replication for Backups”. For performance or data distribution reasons, you may want ... Replication can be used in many different environments for a range of ...Using replication as a scale-out solution requires ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-index-table-table.html
Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that contains the FULLTEXT index; for example test/articles. Before querying it, set the value of the ... The ...The ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema.html
It is implemented using the PERFORMANCE_SCHEMA storage engine and the performance_schema database. Performance Schema configuration can be modified dynamically by updating tables in the performance_schema database through SQL statements. Note The ...
https://dev.mysql.com/doc/refman/5.7/en/generated-column-index-optimizations.html
For example: CREATE TABLE t1 (f1 INT, gc INT AS (f1 + 1) STORED, INDEX (gc)); The generated column, gc, is defined as the expression f1 + 1. That is also apparent in the rewritten query available in the extended EXPLAIN information displayed by SHOW ...The column is also indexed and the optimizer can take that index into account during execution plan ...
https://dev.mysql.com/doc/refman/5.7/en/subquery-optimization-with-exists.html
A very useful optimization is to “inform” the subquery that the only rows of interest are those where the inner expression inner_expr is equal to outer_expr. AND oe_N = ie_N) For simplicity, the following discussion assumes a single pair of ...
https://dev.mysql.com/doc/refman/5.7/en/semijoins.html
A semijoin is a preparation-time transformation that enables multiple execution strategies such as table pullout, duplicate weedout, first match, loose scan, and materialization. For an inner join between two tables, the join returns a row from one ...The optimizer uses semijoin strategies to improve subquery execution, as described in this ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-benefits.html
If you split up related data into different tables, you can set up foreign keys that enforce referential integrity. When you design a database with appropriate primary key columns for each table, operations involving those columns are automatically ... InnoDB tables have the following benefits: If the server unexpectedly exits because of a hardware or software issue, regardless of what was happening in the database at the time, you don't need to do anything special after restarting the ...