PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/explain-for-connection.html
For example, if you are running a statement in one session that is taking a long time to complete, using EXPLAIN FOR CONNECTION in another session may yield useful information about the cause of the delay. To obtain the execution plan for an ...
https://dev.mysql.com/doc/refman/9.7/en/external-locking.html
If the server is run with external locking enabled, you can use myisamchk at any time for read operations such a checking tables. External locking affects server performance because the server must sometimes wait for other processes before it can ...
https://dev.mysql.com/doc/refman/9.7/en/faqs-general.html
Does MySQL have a NOW() function with fractions of seconds? Yes, see Section 13.2.6, “Fractional Seconds in Time Values”. Why did MySQL version numbering skip versions 6 and 7 and go straight to 8.0? A.1.3. Does MySQL have a NOW() function with ...
https://dev.mysql.com/doc/refman/9.7/en/faqs-migration.html
This may seem more complicated, but ultimately saves time and trouble. Where can I find information on how to upgrade or downgrade MySQL? A.8.1. Where can I find information on how to upgrade or downgrade MySQL? For detailed upgrade information, see ...
https://dev.mysql.com/doc/refman/9.7/en/faqs-security.html
Does MySQL include support for Roles Based Access Control (RBAC)? Not at this time. Where can I find documentation that addresses security issues for MySQL? A.9.2. Is SSL support built into MySQL binaries, or must I recompile the binary myself to ...
https://dev.mysql.com/doc/refman/9.7/en/faqs-sql-modes.html
Does strict mode impact performance? The intensive validation of input data that some settings requires more time than if the validation is not done. What is the default server SQL mode when MySQL 9.7 is installed? A.3.1. What are server SQL modes? ...
https://dev.mysql.com/doc/refman/9.7/en/federated-description.html
To read a result set, it uses mysql_store_result() and fetches rows one at a time using mysql_fetch_row(). When you create a table using one of the standard storage engines (such as MyISAM, CSV or InnoDB), the table consists of the table definition ...
https://dev.mysql.com/doc/refman/9.7/en/full-disk.html
The thread is aborted the next time it checks the disk (in one minute). This section describes how MySQL responds to disk-full errors (such as “no space left on device”), and to quota-exceeded errors (such as “write failed” or “user block ...
https://dev.mysql.com/doc/refman/9.7/en/fulltext-restrictions.html
For InnoDB, all DML operations (INSERT, UPDATE, DELETE) involving columns with full-text indexes are processed at transaction commit time. Full-text searches are supported for InnoDB and MyISAM tables only. The exception is that for Unicode, the ...
https://dev.mysql.com/doc/refman/9.7/en/function-optimization.html
For example: SELECT * FROM t WHERE partial_key=5 AND some_column=RAND(); If the optimizer can use partial_key to reduce the set of rows selected, RAND() is executed fewer times, which diminishes the effect of nondeterminism on optimization. A ...