PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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/federated-create-connection.html
For example: CREATE TABLE federated_table ( id INT(20) NOT NULL AUTO_INCREMENT, name VARCHAR(32) NOT NULL DEFAULT '', other INT(20) NOT NULL DEFAULT '0', PRIMARY KEY (id), INDEX name (name), INDEX other_key (other) ) ENGINE=FEDERATED DEFAULT ... To ...
https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source-provision-replica.html
In a multi-source replication topology, copying the data directory cannot be used to provision the replica with data from all of the sources, and you might also want to replicate only specific databases from each source. In MySQL 5.6 and 5.7, the ...
https://dev.mysql.com/doc/refman/5.7/en/innochecksum.html
In this example, an innodb checksum is rewritten to replace an invalid checksum: innochecksum --no-check --write innodb ../data/test/tab1.ibd --allow-mismatches, -a Command-Line Format --allow-mismatches=# Type Integer Default Value 0 Minimum Value ...This tool reads an InnoDB tablespace file, calculates the checksum for each page, compares the calculated checksum to the stored checksum, and reports mismatches, which indicate damaged ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locks-set.html
FROM is a consistent read, reading a snapshot of the database and setting no locks unless the transaction isolation level is set to SERIALIZABLE. REPLACE is done like an INSERT if there is no collision on a unique key. Otherwise, an exclusive ... A ...
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 ...