PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/fulltext-fine-tuning.html
To rebuild FULLTEXT indexes for an InnoDB table, use ALTER TABLE with the DROP INDEX and ADD INDEX options to drop and re-create each index. To rebuild the FULLTEXT indexes for a MyISAM table, it is sufficient to do a QUICK repair operation: mysql> ...Do not alter the MySQL sources unless you know what you are ...You can exert more control over full-text searching behavior if you have a MySQL source ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-queries-myisam.html
Some general tips for speeding up queries on MyISAM tables: To help MySQL better optimize queries, use ANALYZE TABLE or run myisamchk --analyze on a table after it has been loaded with data. (For unique indexes, this is always 1.) MySQL uses this ...This updates a value for each index part that indicates the average number of rows that have the same ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-statistics-table.html
However, prefix lengths for index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements are interpreted as number of characters for nonbinary string types (CHAR, VARCHAR, TEXT) and number of bytes for binary string types (BINARY, ...The STATISTICS table has these columns: TABLE_CATALOG The name of the catalog to which the table containing the index ...
https://dev.mysql.com/doc/refman/5.7/en/tracing-example.html
Next, for every table in the query, we estimate the cost of, and number of records returned by, a table scan or a range access. "resulting_clause_is_simple": true, "resulting_clause": "`test`.`alias1`.`col_int_key`" } /* clause_processing */ }, The ...Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE\G *************************** ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-temptables.html
The discussion in the following paragraphs does not apply when binlog_format=ROW because, in that case, temporary tables are not replicated; this means that there are never any temporary tables on the replica to be lost in the event of an unplanned ...The remainder of this section applies only when using statement-based or mixed-format ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-cmpmem-table.html
The INNODB_CMPMEM and INNODB_CMPMEM_RESET tables provide status information on compressed pages within the InnoDB buffer pool. The INNODB_CMPMEM and INNODB_CMPMEM_RESET tables have these columns: PAGE_SIZE The block size in bytes. row ...PAGES_USED ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-range.html
At some point in the future—when the number of stores has increased to 25, 30, or more—you can use an ALTER TABLE statement to add new partitions for stores 21-25, 26-30, and so on (see Section 22.3, “Partition Management”, for details of ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-transactions.html
When copying an NDB table as part of an ALTER TABLE, the creation of the copy is nontransactional. NDBCLUSTER stores only part of a column value that uses any of MySQL's BLOB or TEXT data types in the table visible to MySQL; the remainder of the ...
https://dev.mysql.com/doc/refman/5.7/en/extensions-to-ansi.html
(Nevertheless, it is preferable to use RENAME TABLE or ALTER TABLE ... Use of CHANGE col_name, DROP col_name, or DROP INDEX, IGNORE or RENAME in ALTER TABLE statements. Use of multiple ADD, ALTER, DROP, or CHANGE clauses in an ALTER TABLE statement.
https://dev.mysql.com/doc/refman/5.7/en/audit-log-file-formats.html
The MySQL server calls the audit log plugin to write an audit record to its log file whenever an auditable event occurs. <AUDIT_RECORD> <TIMESTAMP>2019-10-03T14:09:38 UTC</TIMESTAMP> <RECORD_ID>6_2019-10-03T14:06:33</RECORD_ID> <NAME>Query</NAME> ...Typically the first audit record written after plugin startup contains the server description and startup ...