PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/optimizing-queries-myisam.html
For MyISAM tables that change frequently, try to avoid all variable-length columns (VARCHAR, BLOB, and TEXT). The table uses dynamic row format if it includes even a single variable-length column. The only cases where splitting up a table makes an ... 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 ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-invoked.html
For example, trying to replicate a loadable function with statement-based replication generates this warning because it currently cannot be determined by the MySQL server whether the function is deterministic. The ORIGINATOR column in the ...
https://dev.mysql.com/doc/refman/5.7/en/show-slave-hosts.html
Statement output includes this column only if the source server is started with the --show-slave-auth-info option. Statement output includes this column only if the source server is started with the --show-slave-auth-info option. A zero in this ...
https://dev.mysql.com/doc/refman/5.7/en/subquery-materialization.html
Materialization speeds up query execution by generating a subquery result as a temporary table, normally in memory. Assume that where_condition involves columns only from t2 and not t1 so that the subquery is noncorrelated. The optimizer uses ...
https://dev.mysql.com/doc/refman/5.7/en/subquery-optimization-with-exists.html
Table-condition generator: If the subquery is a join of several tables, the triggered condition is checked as soon as possible. In EXPLAIN output, the fallback shows up as Full scan on NULL key in the Extra column: mysql> EXPLAIN SELECT t1.col1, ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-reference.html
The table has these columns: USER The user name part of an account. The field value is an integer that represents the UNIX timestamp value indicating the date and time when the audit event was generated. Unless those objects are installed, the ...
https://dev.mysql.com/doc/refman/5.7/en/bug-reports.html
If you have a problem with Connector/ODBC (MyODBC), please try to generate a trace file and send it with your report. Before posting a bug report about a problem, please try to verify that it is a bug and that it has not been reported already: ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-like.html
LIKE, the destination table preserves generated column information from the original table. LIKE to create an empty table based on the definition of another table, including any column attributes and indexes defined in the original table: CREATE ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html
When the date argument is a TIMESTAMP column, UNIX_TIMESTAMP() returns the internal timestamp value directly, with no implicit “string-to-Unix-timestamp” conversion. If you want to subtract UNIX_TIMESTAMP() columns, you might want to cast them ... This section describes the functions that can be used to manipulate temporal ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-porting-memcached.html
You might create additional secondary indexes on tables that are frequently used to generate reports using SQL. This is because InnoDB performs best for large-scale insertions if primary key values are added in sorted order (as they are with ...