MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 91 to 97 of 97 total results

« Previous
8
9
10
Next »

https://dev.mysql.com/doc/refman/8.0/en/alter-view.html

ALTER [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}] [DEFINER = user] [SQL SECURITY { DEFINER | INVOKER }] VIEW view_name [(column_list)] AS select_statement [WITH [CASCADED | LOCAL] CHECK OPTION] This statement changes the definition of a view, ...

6.5.5 mysqlimport — A Data Import Program

https://dev.mysql.com/doc/refman/8.0/en/mysqlimport.html

This affects only storage engines that use only table-level locking (such as MyISAM, MEMORY, and MERGE). The mysqlimport client provides a command-line interface to the LOAD DATA SQL statement. Most options to mysqlimport correspond directly to ...

17.21.3 Forcing InnoDB Recovery

https://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html

Warning Only set innodb_force_recovery to a value greater than 0 in an emergency situation, so that you can start InnoDB and dump your tables. To investigate database page corruption, you might dump your tables from the database with SELECT ...

10.5.8 Optimizing InnoDB Disk I/O

https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-diskio.html

If you follow best practices for database design and tuning techniques for SQL operations, but your database is still slow due to heavy disk I/O activity, consider these disk I/O optimizations. If the Unix top tool or the Windows Task Manager shows ...

15.2.11 Parenthesized Query Expressions

https://dev.mysql.com/doc/refman/8.0/en/parenthesized-query-expressions.html

The maximum level of nesting supported is 63; this is after any simplifications or merges have been performed by the parser. parenthesized_query_expression: ( query_expression [order_by_clause] [limit_clause] ) [order_by_clause] [limit_clause] ...

26.2.4.1 LINEAR HASH Partitioning

https://dev.mysql.com/doc/refman/8.0/en/partitioning-linear-hash.html

MySQL also supports linear hashing, which differs from regular hashing in that linear hashing utilizes a linear powers-of-two algorithm whereas regular hashing employs the modulus of the hashing function's value. We call this value V; it can be ...

26.3 Partition Management

https://dev.mysql.com/doc/refman/8.0/en/partitioning-management.html

There are a number of ways using SQL statements to modify partitioned tables; it is possible to add, drop, redefine, merge, or split existing partitions using the partitioning extensions to the ALTER TABLE statement. There are also ways to obtain ...