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/innodb-consistent-read.html
A consistent read means that InnoDB uses multi-versioning to present to a query a snapshot of the database at a point in time. If other sessions simultaneously update the same table, the anomaly means that you might see the table in a state that ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format-compatibility-checking-table-access.html
Versions of MySQL older than 5.0.21 cannot reliably use database files created by newer versions if a new file format was used when a table was created. Versions of InnoDB prior to MySQL 4.1 did not include table format identifiers in the database ... When a table is first accessed, InnoDB (including some releases prior to InnoDB 1.0) checks that the file format of the tablespace in which the table is stored is fully ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-benefits.html
Data is stored in a MySQL database to protect against crashes, outages, and corruption. The direct, low-level database access path used by the daemon_memcached plugin is much more efficient for key-value lookups than equivalent SQL queries. The ...
https://dev.mysql.com/doc/refman/5.7/en/linux-installation-native.html
The database tables are automatically created for you, if they do not already exist. 2013-09-24T13:03:10.857032Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1566036 * Starting MySQL database server mysqld ...done. During installation, ... Many Linux distributions include a version of the MySQL server, client tools, and development components in their native software repositories and can be installed with the platforms' standard package management ...
https://dev.mysql.com/doc/refman/5.7/en/lock-tables.html
Another use for UNLOCK TABLES is to release the global read lock acquired with the FLUSH TABLES WITH READ LOCK statement, which enables you to lock all tables in all databases. (See Section 8.11.3, “Concurrent Inserts”.) However, READ LOCAL ...
https://dev.mysql.com/doc/refman/5.7/en/miscellaneous-optimization-tips.html
This section lists a number of miscellaneous tips for improving query processing speed: If your application makes several database requests to perform related updates, combining the statements into a stored routine can help performance. The ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-ftdump.html
If you do not invoke myisam_ftdump in the directory where the table files are located, the table or index file name must be preceded by the path name to the table's database directory. Example: Suppose that the test database contains a table named ...It reads the MyISAM index file directly, so it must be run on the server host where the table is ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-repair.html
Before you begin, you should change location to the database directory and check the permissions of the table files. If you do not have a backup but know exactly how the table was created, create a copy of the table in another database. Remove the ... The discussion in this section describes how to use myisamchk on MyISAM tables (extensions .MYI and ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-backup-concepts.html
A backup is a snapshot of the database at a given time. The data actually stored in the database tables at the time that the backup was made Transaction log. A sequential record telling how and when data was stored in the database Each of these ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-params-ndbd.html
MaxNoOfAttributes: Suggests total number of attributes stored in database (sum over all tables). TimeBetweenLocalCheckpoints: Time between taking snapshots of database (expressed in base-2 logarithm of bytes). The listings in this section provide ...