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/optimize-multi-tables.html
Some techniques for keeping individual queries fast involve splitting data across many tables. When the number of tables runs into the thousands or even millions, the overhead of dealing with all these tables becomes a new performance consideration.
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-stages-history-long-table.html
The events_stages_history_long table contains the N most recent stage events that have ended globally, across all threads. Stage events are not added to the table until they have ended. When the table becomes full, the oldest row is discarded when ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-statements-history-long-table.html
The events_statements_history_long table contains the N most recent statement events that have ended globally, across all threads. Statement events are not added to the table until they have ended. When the table becomes full, the oldest row is ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-transactions-history-long-table.html
The events_transactions_history_long table contains the N most recent transaction events that have ended globally, across all threads. Transaction events are not added to the table until they have ended. When the table becomes full, the oldest row ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-waits-history-long-table.html
The events_waits_history_long table contains N the most recent wait events that have ended globally, across all threads. Wait events are not added to the table until they have ended. When the table becomes full, the oldest row is discarded when a ...
https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source-adding-gtid-master.html
These steps assume you have enabled GTIDs for transactions on the replication source servers using gtid_mode=ON, created a replication user, ensured that the replica is using TABLE based replication metadata repositories, and provisioned the ...
https://dev.mysql.com/doc/refman/5.7/en/retrieving-data.html
The SELECT statement is used to pull information from a table. The general form of the statement is: SELECT what_to_select FROM which_table WHERE conditions_to_satisfy; what_to_select indicates what you want to see. This can be a list of columns, ...
https://dev.mysql.com/doc/refman/5.7/en/security-options.html
The following table shows mysqld options and system variables that affect security. For descriptions of each of these, see Section 5.1.6, “Server Command Options”, and Section 5.1.7, “Server System Variables”.
https://dev.mysql.com/doc/refman/5.7/en/string-types.html
The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. For information about storage requirements of the string data types, see Section 11.7, “Data Type Storage Requirements”. For descriptions of functions that ...
https://dev.mysql.com/doc/refman/5.7/en/sys-format-bytes.html
Given a byte count, converts it to human-readable format and returns a string consisting of a value and a units indicator. Depending on the size of the value, the units part is bytes, KiB (kibibytes), MiB (mebibytes), GiB (gibibytes), TiB ...