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/data-directory.html
Each subdirectory of the data directory is a database directory and corresponds to a database managed by the server. All MySQL installations have certain standard databases: The mysql directory corresponds to the mysql system database, which ...
https://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html
To investigate database page corruption, you might dump your tables from the database with SELECT ... Before doing so, ensure that you have a backup copy of your database in case you need to recreate it. Only use an innodb_force_recovery setting of ...Usually, most of the data obtained in this way is ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-query-expansion.html
For example, a user searching for “database” may really mean that “MySQL”, “Oracle”, “DB2”, and “RDBMS” all are phrases that should match “databases” and should be returned, too. Thus, if one of these documents contains the ... Full-text search supports query expansion (and in particular, its variant “blind query ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk.html
The myisamchk utility gets information about your database tables or checks, repairs, or optimizes them. tbl_name is the database table you want to check or repair. If you run myisamchk somewhere other than in the database directory, you must ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-commands.html
The optional database name and host name arguments may be given to specify the default database or the host where the server is running. rehash, \# Rebuild the completion hash that enables database, table, and column name completion while you are ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-quick-start.html
The PERFORMANCE_SCHEMA storage engine operates on tables in the performance_schema database. You can make performance_schema the default database so that references to its tables need not be qualified with the database name: mysql> USE ... This ...
https://dev.mysql.com/doc/refman/5.7/en/tracing-example.html
Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE\G *************************** 1. row *************************** QUERY: SELECT ...
https://dev.mysql.com/doc/refman/5.7/en/use.html
USE db_name The USE statement tells MySQL to use the named database as the default (current) database for subsequent statements. This statement requires some privilege for the database or some object within it. The named database remains the ...
https://dev.mysql.com/doc/refman/5.7/en/cost-model.html
The optimizer also has a database of cost estimates to use during execution plan construction. These estimates are stored in the server_cost and engine_cost tables in the mysql system database and are configurable at any time. Cost Model General ...
https://dev.mysql.com/doc/refman/5.7/en/creating-accounts.html
The next example creates three accounts and grants them access at lower levels; that is, to specific databases or objects within databases. The 'custom'@'host47.example.com' account has specific database-level privileges to access the expenses ...