PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-functions.html
Example 16.2 Backup and restore scenario The stored functions GTID_IS_EQUAL(), GTID_IS_DISJOINT(), and GTID_IS_DISJOINT_UNION() can be used to verify backup and restore operations involving multiple databases and servers. In this example scenario, ... This section provides examples of stored functions (see Chapter 23, Stored Objects) which you can create using some of the built-in functions provided by MySQL for use with GTID-based replication, listed here: GTID_SUBSET(): Shows whether one GTID set is a subset of ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-reference.html
replicate-do-db: Tells replication SQL thread to restrict replication to specified database. replicate-ignore-db: Tells replication SQL thread not to replicate to specified database. slave_parallel_type: Tells replica to use timestamp information ...
https://dev.mysql.com/doc/refman/5.7/en/secure-client-programming.html
Be sure that your application remains secure if a user tries to perform SQL injection by entering something like ; DROP DATABASE mysql; into a form. Sometimes people think that if a database contains only publicly available data, it need not be ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines.html
Stored routines can be particularly useful in certain situations: When multiple client applications are written in different languages or work on different platforms, but need to perform the same database operations. In such a setup, applications ...
https://dev.mysql.com/doc/refman/5.7/en/create-temporary-table.html
Dropping a database does not automatically drop any TEMPORARY tables created within that database. Also, you can create a TEMPORARY table in a nonexistent database if you qualify the table name with the database name in the CREATE TABLE statement.
https://dev.mysql.com/doc/refman/5.7/en/creating-tables.html
How about age? That might be of interest, but it is not a good thing to store in a database. Storing birth date rather than age has other advantages, too: You can use the database for tasks such as generating reminders for upcoming pet birthdays.
https://dev.mysql.com/doc/refman/5.7/en/firewall-usage.html
The example account, fwuser@localhost, is presumed for use by an application that accesses tables in the sakila database (available at https://dev.mysql.com/doc/index-other.html). For statements executed using this account, the default database ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-adding-instances.html
At this point, the group has one member in it, server s1, which has some data in it. It is now time to expand the group by adding the other two servers configured previously. 17.2.1.6.1 Adding a Second Instance In order to add a second instance, ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool.html
As the database operates, pages in the buffer pool that are not accessed “age” by moving toward the tail of the list. The larger the buffer pool, the more InnoDB acts like an in-memory database, reading data from disk once and then accessing the ... The buffer pool is an area in main memory where InnoDB caches table and index data as it is ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format-compatibility.html
To minimize the chance of compatibility issues, you can standardize on the InnoDB Plugin for all your MySQL 5.1 and earlier database servers. InnoDB includes a mechanism to guard against these conditions, and to help preserve compatibility among ...