PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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/apis-perl.html
The Perl DBI module provides a generic interface for database access. You can write a DBI script that works with many different database engines without change. Optionally, the DBD module for any other type of database server you want to access. It ...To use DBI with MySQL, install the following: The DBI ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-internals.html
The cache_policies table, config_options table, and containers table are created by the innodb_memcached_config.sql configuration script in the innodb_memcache database. mysql> USE innodb_memcache; Database changed mysql> SHOW TABLES; ... InnoDB API ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-scaleout.html
You can use replication as a scale-out solution; that is, where you want to split up the load of database queries across multiple database servers, within some reasonable limitations. Figure 16.1 Using Replication to Improve Performance During ...
https://dev.mysql.com/doc/refman/5.7/en/symbolic-links.html
You can move databases or tables from the database directory to other locations and replace them with symbolic links to the new locations. You might want to do this, for example, to move a database to a file system with more free space or increase ...For InnoDB tables, use the DATA DIRECTORY clause of the CREATE TABLE statement instead of symbolic links, as explained in Section 14.6.1.2, “Creating Tables ...
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 ...