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/precision-math-examples.html
That is, for two numbers X1 and X2 that have scale S1 and S2, the scale of the result is S1 + S2: mysql> SELECT .01 * .01; +-----------+ | .01 * .01 | +-----------+ | 0.0001 | +-----------+ Example 3. Rounding behavior for exact-value numbers is ...
https://dev.mysql.com/doc/refman/5.7/en/lock-tables.html
Tables in the performance_schema database cannot be locked with LOCK TABLES, except the setup_xxx tables. For view locking, LOCK TABLES adds all base tables used in the view to the set of tables to be locked and locks them automatically. Another use ...lock_type: { READ [LOCAL] | [LOW_PRIORITY] WRITE } UNLOCK {TABLE | TABLES} MySQL enables client sessions to acquire table locks explicitly for the purpose of cooperating with other sessions for access to tables, or to prevent other sessions from modifying tables during periods when a session requires exclusive access to ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-views-table.html
DEFINER The account of the user who created the view, in 'user_name'@'host_name' format. The flag is set to YES (true) if UPDATE and DELETE (and similar operations) are legal for the view. TABLE_SCHEMA The name of the schema (database) to which the ...You must have the SHOW VIEW privilege to access this ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-issues.html
(A gap event is a type of “incident event,” which indicates an incident that occurs that affects the contents of the database but that cannot easily be represented as a set of changes. For information about implementing this type of setup, see ...If this occurs, it is entirely possible for new data to be inserted into the source cluster without being recorded in the source SQL node's binary ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-mapping.html
For the basic structure, MySQL represents each database as a directory in the data directory, and each table by one or more files in the appropriate database directory. This occurs on all platforms for portability of the corresponding database ...If ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-analyze-table-complexity.html
For the nonunique indexes, the primary key columns (a,b) are counted in addition to the user defined columns. To set the number of pages sampled for an individual table, use the STATS_SAMPLE_PAGES option with CREATE TABLE or ALTER TABLE. With ...The ...
https://dev.mysql.com/doc/refman/5.7/en/introduction.html
The MySQL software delivers a very fast, multithreaded, multi-user, and robust SQL (Structured Query Language) database server. Users can choose to use the MySQL software as an Open Source product under the terms of the GNU General Public License ...MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed ...
https://dev.mysql.com/doc/refman/5.7/en/sys-memory-by-thread-by-current-bytes.html
current_count_used The current number of allocated memory blocks that have not been freed yet for the thread. current_allocated The current number of allocated bytes that have not been freed yet for the thread. current_avg_alloc The current number ...By default, rows are sorted by descending amount of memory ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool-flushing.html
For table data stored on SSD, seek time is not a significant factor and you can disable this setting to spread out write operations. A setting smaller than the default is generally suitable for most workloads. The ideal settings depend on your ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format-compatibility-checking.html
To prevent possible crashes or data corruptions when InnoDB opens an ib-file set, it checks that it can fully support the file formats in use within the ib-file set. Beginning with version InnoDB 1.0.1, the system tablespace records an identifier ...If the system is restarted following a crash, or a “fast shutdown” (i.e., innodb_fast_shutdown is greater than zero), there may be on-disk data structures (such as redo or undo entries, or doublewrite pages) that are in a “too-new” format for the current ...