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-file-space.html
The data files that you define in the configuration file using the innodb_data_file_path configuration option form the InnoDB system tablespace. You cannot define where within the system tablespace your tables are allocated. In a newly created ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-database-objects.html
Some database objects such as tables and indexes have different limitations when using the NDBCLUSTER storage engine: Database and table names. When using the NDB storage engine, the maximum allowed length both for database names and for table ...
https://dev.mysql.com/doc/refman/5.7/en/order-by-optimization.html
Whether the optimizer actually does so depends on whether reading the index is more efficient than a table scan if columns not in the index must also be read. In that case, scanning an entire index and looking up table rows to find columns not in ...
https://dev.mysql.com/doc/refman/5.7/en/outer-join-optimization.html
MySQL implements an A LEFT JOIN B join_specification as follows: Table B is set to depend on table A and all tables on which A depends. Table A is set to depend on all tables (except B) that are used in the LEFT JOIN condition. The LEFT JOIN ...If ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-hash.html
To partition a table using HASH partitioning, it is necessary to append to the CREATE TABLE statement a PARTITION BY HASH (expr) clause, where expr is an expression that returns an integer. In addition, you most likely want to follow this with ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-thread-filtering.html
The threads table contains a row for each server thread. For the Performance Schema to monitor a thread, these things must be true: The thread_instrumentation consumer in the setup_consumers table must be YES. Monitoring occurs only for those ...
https://dev.mysql.com/doc/refman/5.7/en/privilege-changes.html
If the mysqld server is started without the --skip-grant-tables option, it reads all grant table contents into memory during its startup sequence. The in-memory tables become effective for access control at that point. If you modify the grant ...
https://dev.mysql.com/doc/refman/5.7/en/replication-snapshot-method.html
If your database is stored in binary portable files, you can copy the raw data files to a replica. Choose one of these options: Exclude all the tables in the database using --ignore-table option. Employing this method with a table using a storage ...
https://dev.mysql.com/doc/refman/5.7/en/show-slave-status.html
This is similar to the information available from the SHOW SLAVE STATUS statement, but represented in table form. Replicate_Do_Table, Replicate_Ignore_Table, Replicate_Wild_Do_Table, Replicate_Wild_Ignore_Table The lists of tables that were ... SHOW ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-replication-group-member-stats.html
The performance_schema.replication_group_member_stats table provides group-level information related to the certification process, and also statistics for the transactions received and originated by each individual member of the replication group.