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/replication-features-create-if-not-exists.html
IF NOT EXISTS statements are replicated: Every CREATE DATABASE IF NOT EXISTS statement is replicated, whether or not the database already exists on the source. Similarly, every CREATE TABLE IF NOT EXISTS statement without a SELECT is replicated, ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-drop-if-exists.html
The DROP DATABASE IF EXISTS, DROP TABLE IF EXISTS, and DROP VIEW IF EXISTS statements are always replicated, even if the database, table, or view to be dropped does not exist on the source. IF EXISTS statements for stored programs (stored ...This ...
https://dev.mysql.com/doc/refman/5.7/en/statement-optimization.html
The core logic of a database application is performed through SQL statements, whether issued directly through an interpreter or submitted behind the scenes through an API. The guidelines cover SQL operations that read and write data, the ...The ...
https://dev.mysql.com/doc/refman/5.7/en/apis-perl.html
The Perl DBI module provides a generic interface for database access. Optionally, the DBD module for any other type of database server you want to access. You can write a DBI script that works with many different database engines without change. To ...
https://dev.mysql.com/doc/refman/5.7/en/perl-support.html
The Perl DBI module provides a generic interface for database access. To use DBI, you must install the DBI module, as well as a DataBase Driver (DBD) module for each type of database server you want to access. You can write a DBI script that works ...The DBI/DBD interface requires Perl 5.6.0, and 5.6.1 or later is ...
https://dev.mysql.com/doc/refman/5.7/en/reproducible-test-case.html
For information about steps to take when encountering InnoDB table corruption, see Section 1.5, “How to Report Bugs or Problems”. The binary log is saved in the MySQL database directory with the name hostname-bin.NNNNNN. FTP the tables and the ...If you encounter corrupted MyISAM tables or if mysqld always fails after some update statements, you can test whether the issue is reproducible by doing the following: Stop the MySQL daemon with mysqladmin ...
https://dev.mysql.com/doc/refman/5.7/en/upgrade-before-you-begin.html
The backup should include the mysql system database, which contains the MySQL system tables. Review Section 2.10.3, “Changes in MySQL 5.7” for changes that you should be aware of before upgrading. Review Section 1.3, “What Is New in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-storage-engines.html
For tables using MyISAM or other non-InnoDB storage engines, it does a “warm” backup, where the database continues to run, but those tables cannot be modified while being backed up. Where can I obtain complete documentation for MySQL storage ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-being-deleted-table.html
Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that contains the FULLTEXT index; for example test/articles. Because the contents of INNODB_FT_BEING_DELETED ... The ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-deleted-table.html
Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that contains the FULLTEXT index; for example test/articles. The INNODB_FT_DELETED table stores rows that are ...The ...