PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-summary-tables.html
Summary tables provide aggregated information for terminated events over time. The tables in this group summarize event data in different ways. Each summary table has grouping columns that determine how to group the data to be aggregated, and ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-cjk.html
Many Windows users find that a Microsoft character set, such as cp932 for Japanese Windows, is suitable. Why do I get Incorrect string value error messages? To see the problem, create a table with one Unicode (ucs2) column and one Chinese (gb2312) ... This set of Frequently Asked Questions derives from the experience of MySQL's Support and Development groups in handling many inquiries about CJK (Chinese-Japanese-Korean) ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-internals.html
The patterns of values in your data determine how well it compresses, but typical user data often compresses by 50% or more. Unlike compression performed by an application, or compression features of some other database management systems, InnoDB ...
https://dev.mysql.com/doc/refman/5.7/en/entering-queries.html
At this point, it is more important to find out a little about how to issue queries than to jump right in creating tables, loading data into them, and retrieving data from them. If you decide you do not want to execute a query that you are in the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-temporary-tablespace.html
Non-compressed, user-created temporary tables and on-disk internal temporary tables are created in a shared temporary tablespace. Issue a query similar to this one to view temporary tablespace metadata: mysql> SELECT * FROM INFORMATION_SCHEMA.FILES ...If no value is specified for innodb_temp_data_file_path, the default behavior is to create an auto-extending data file named ibtmp1 in the innodb_data_home_dir directory that is slightly larger than ...
https://dev.mysql.com/doc/refman/5.7/en/general-thread-states.html
After create This occurs when the thread creates a table (including internal temporary tables), at the end of the function that creates the table. This state is used even if the table could not be created due to some error. This state occurs after ... The following list describes thread State values that are associated with general query processing and not more specialized activities such as ...
https://dev.mysql.com/doc/refman/5.7/en/processlist-access.html
The sys schema session view presents information about user sessions like the sys schema processlist view, but with background processes filtered out. Privileges Required to Access the Process List For most sources of process information, if you ...
https://dev.mysql.com/doc/refman/5.7/en/system-schema.html
Grant System Tables These system tables contain grant information about user accounts and the privileges held by them: user: User accounts, global privileges, and other nonprivilege columns. Miscellaneous System Tables Other system tables do not ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-waiter.html
SINGLE USER MODE: This is shown for all cluster data nodes when the cluster is in single user mode. --single-user The program waits for the cluster to enter single user mode. ndb_waiter repeatedly (each 100 milliseconds) prints out the status of ...
https://dev.mysql.com/doc/refman/5.7/en/string-functions-charset.html
MySQL has many operators and functions that return a string. This section answers the question: What is the character set and collation of such a string? For simple functions that take string input and return a string result as output, the output's ...