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/view-restrictions.html
That shortcoming can lead to problems backing up a database with mysqldump, which may fail due to insufficient privileges. To modify the definition, drop and create the view again with DROP VIEW and CREATE VIEW, or replace the definition with CREATE ... The maximum number of tables that can be referenced in the definition of a view is ...
https://dev.mysql.com/doc/refman/5.7/en/creating-ssl-files-using-openssl.html
This section describes how to use the openssl command to set up SSL certificate and key files for use by MySQL servers and clients. The first example shows a simplified procedure such as you might use from the command line. The first two examples ...
https://dev.mysql.com/doc/refman/5.7/en/custom-benchmarks.html
Benchmark your application and database to find out where the bottlenecks are. After fixing one bottleneck (or by replacing it with a “dummy” module), you can proceed to identify the next bottleneck. A free benchmark suite is the Open Source ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-table-import.html
If the table was created in an external directory by specifying the DATA DIRECTORY clause in the CREATE TABLE statement, the table that you replace on the destination instance must be defined with the same DATA DIRECTORY clause. On Windows, InnoDB ... This section describes how to import tables using the Transportable Tablespaces feature, which permits importing tables, partitioned tables, or individual table partitions that reside in file-per-table ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-overview.html
Nonetheless, most advanced database management systems have evolved some means of determining the physical location to be used for storing specific pieces of data in terms of the file system, hardware or even both. In MySQL, the InnoDB storage ...
https://dev.mysql.com/doc/refman/5.7/en/backup-policy.html
For example, for the MyISAM tables in the mysql database, there must be no administrative changes to MySQL accounts during the backup. A full backup (a snapshot of the data at a point in time) can be done in MySQL with several tools. For example, ...
https://dev.mysql.com/doc/refman/5.7/en/charset-metadata.html
Metadata is “the data about the data.” Anything that describes the database—as opposed to being the contents of the database—is metadata. Thus column names, database names, user names, version names, and most of the string results from SHOW ...Representation of metadata must satisfy these requirements: All metadata must be in the same character ...
https://dev.mysql.com/doc/refman/5.7/en/compatibility.html
We continue to support transactional and nontransactional databases to satisfy both mission-critical 24/7 usage and heavy Web or logging usage. MySQL Server was originally designed to work with medium-sized databases (10-100 million rows, or about ... This section describes how MySQL relates to the ANSI/ISO SQL ...
https://dev.mysql.com/doc/refman/5.7/en/converting-tables-to-innodb.html
Converting an Existing Table To convert a non-InnoDB table to use InnoDB use ALTER TABLE: ALTER TABLE table_name ENGINE=InnoDB; Warning Do not convert MySQL system tables in the mysql database from MyISAM to InnoDB tables. In the case of a runaway ... If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips before ...
https://dev.mysql.com/doc/refman/5.7/en/create-server.html
CREATE SERVER server_name FOREIGN DATA WRAPPER wrapper_name OPTIONS (option [, option] ...) option: { HOST character-literal | DATABASE character-literal | USER character-literal | PASSWORD character-literal | SOCKET character-literal | OWNER ...