PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 255.5Kb
Man Pages (Zip)
- 360.4Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/binary-log.html
The binary log contains “events” that describe database changes such as table creation operations or changes to table data. Updates to nontransactional tables are stored in the binary log immediately after execution. Within an uncommitted ...It ...
https://dev.mysql.com/doc/refman/5.7/en/creating-accounts.html
Account-management statements cause the server to make appropriate modifications to the underlying grant tables, which are discussed in Section 6.2.3, “Grant Tables”. Note Direct modification of grant tables using statements such as INSERT, ...
https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization.html
After MySQL is installed, the data directory must be initialized, including the tables in the mysql system database: For some MySQL installation methods, data directory initialization is automatic, as described in Section 2.9, “Postinstallation ...For other installation methods, you must initialize the data directory ...
https://dev.mysql.com/doc/refman/5.7/en/drop-index.html
algorithm_option: ALGORITHM [=] {DEFAULT | INPLACE | COPY} lock_option: LOCK [=] {DEFAULT | NONE | SHARED | EXCLUSIVE} DROP INDEX drops the index named index_name from the table tbl_name. This statement is mapped to an ALTER TABLE statement to drop ...This is done automatically by the server whenever it determines that it is possible to do so; you do not have to use any special SQL syntax or server options to cause it to ...
https://dev.mysql.com/doc/refman/5.7/en/enum.html
An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation time. (The practical limit is less than 3000.) A table can have no more than 255 unique ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-migration.html
How has storage engine (table type) support changed in MySQL 5.7 from previous versions? A.8.1. How has storage engine (table type) support changed in MySQL 5.7 from previous versions? Storage engine support has changed as follows: Support for ISAM ...Where can I find information on how to upgrde or downgrde MySQL? ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-search-mecab.html
For InnoDB tables, minimum token size is defined by the innodb_ft_min_token_size configuration option, which has a default value of 3. For MyISAM tables, minimum token size is defined by ft_min_word_len, which has a default value of 4. Creating a ...
https://dev.mysql.com/doc/refman/5.7/en/group-by-optimization.html
The most general way to satisfy a GROUP BY clause is to scan the whole table and create a new temporary table where all rows from each group are consecutive, and then use this temporary table to discover groups and apply aggregate functions (if ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool.html
The buffer pool is an area in main memory where InnoDB caches table and index data as it is accessed. A table scan, performed for a mysqldump operation or a SELECT statement with no WHERE clause, for example, can bring a large amount of data into ...The buffer pool permits frequently used data to be accessed directly from memory, which speeds up ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-understanding-innodb-locking.html
When a transaction updates a row in a table, or locks it with SELECT FOR UPDATE, InnoDB establishes a list or queue of locks on that row. Similarly, InnoDB maintains a list of locks on a table for table-level locks. If a second transaction wants to ...At any given time, a transaction may request a lock that is held by another transaction, in which case it is blocked by that other ...