PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysql-enterprise-backup.html
The product is architected for efficient and reliable backups of tables created by the InnoDB storage engine. For completeness, it can also back up tables from MyISAM and other storage engines. MySQL Enterprise Backup does a hot backup of all tables ... MySQL Enterprise Backup performs hot backup operations for MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-character.html
The GROUP BY and ORDER BY clauses can generate temporary tables, and these temporary tables can use the MEMORY storage engine if the original table does not contain any BLOB columns. If a table contains string columns such as name and address, but ... For character and string columns, follow these guidelines: Use binary collation order for fast comparison and sort operations, when you do not need language-specific collation ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-diskio.html
Increase buffer pool size When table data is cached in the InnoDB buffer pool, it can be accessed repeatedly by queries without requiring any disk I/O. Do not place other MySQL data files, such as those for MyISAM tables, on a direct I/O file system. Executables or libraries must not be placed on a direct I/O file ... If you follow best practices for database design and tuning techniques for SQL operations, but your database is still slow ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-columns-list.html
See Section 13.1.18, “CREATE TABLE Statement”, for additional information about PARTITION BY LIST COLUMNS() syntax. This is a variant of LIST partitioning that enables the use of multiple columns as partition keys, and for columns of data types ...
https://dev.mysql.com/doc/refman/5.7/en/precision-math-examples.html
Consider these statements: mysql> CREATE TABLE t (i INT, d DECIMAL, f FLOAT); mysql> INSERT INTO t VALUES(1,1,1); mysql> CREATE TABLE y SELECT AVG(i), AVG(d), AVG(f) FROM t; The result is a double only for the floating-point argument. This section ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-errors.html
For example, you might need to create a nonexistent table before you can start the replica again. For nontransactional storage engines such as MyISAM, it is possible to have a statement that only partially updates a table and returns an error code.
https://dev.mysql.com/doc/refman/5.7/en/replication-features-reserved-words.html
An example of this is using a table column named virtual on a 5.6 source that is replicating to a 5.7 or higher replica because VIRTUAL is a reserved word beginning in MySQL 5.7. Replication can fail in such cases with Error 1064 You have an error ... You can encounter problems when you attempt to replicate from an older source to a newer replica and you make use of identifiers on the source that are reserved words in the newer MySQL version running on the ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rules.html
You should not use these options to control which databases and tables are replicated. If no database-level options are used, option checking proceeds to any table-level options that may be in use (see Section 16.2.5.2, “Evaluation of Table-Level ... If a replication source server does not write a statement to its binary log, the statement is not ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-partitioning.html
Figure 16.2 Replicating Databases to Separate Replicas You can achieve this separation by configuring the source and replicas as normal, and then limiting the binary log statements that each replica processes by using the --replicate-wild-do-table ... There may be situations where you have a single source and want to replicate different databases to different ...
https://dev.mysql.com/doc/refman/5.7/en/secure-client-programming.html
If an application generates a query such as SELECT * FROM table WHERE ID=234 when a user enters the value 234, the user can enter the value 234 OR 1=1 to cause the application to generate the query SELECT * FROM table WHERE ID=234 OR 1=1. As a ...