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/function-loading.html
It registers the function in the mysql.func system table to make it persistent across server restarts. If the server is started with the --skip-grant-tables option, functions registered in the table are not loaded and are unavailable. With the ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-adding-instances.html
Checking the performance_schema.replication_group_members table again shows that there are now two ONLINE servers in the group. Create the configuration file [mysqld] # # Disable other storage engines # ... At this point, the group has one member in ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-limitations.html
Note For a group in multi-primary mode, unless you rely on REPEATABLE READ semantics in your applications, we recommend using the READ COMMITTED isolation level with Group Replication. The certification process does not take into account table locks ...Note that the limitations and issues described for multi-primary mode groups can also apply in single-primary mode clusters during a failover event, while the newly elected primary flushes out its applier queue from the old ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-requirements.html
Convert any tables in other storage engines to use InnoDB before using the instance with Group Replication. Every table that is to be replicated by the group must have a defined primary key, or primary key equivalent where the equivalent is a ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-benchmarking.html
Since changing the default storage engine only affects newly created tables, run your application installation and setup steps to confirm that everything installs properly, then exercise the application features to make sure the data loading, ... If ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-innodb_cmpmem.html
The INNODB_CMPMEM and INNODB_CMPMEM_RESET tables provide status information about compressed pages that reside in the buffer pool. Please consult Section 14.9, “InnoDB Table and Page Compression” for further information on compressed tables and ...Internal Details InnoDB uses a buddy allocator system to manage memory allocated to pages of various sizes, from 1KB to ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-transactions.html
That blocking lock request is for a row or table lock held by another transaction in an incompatible mode. INNODB_LOCK_WAITS: This table indicates which transactions are waiting for a given lock, or for which lock a given transaction is waiting.
https://dev.mysql.com/doc/refman/5.7/en/innodb-init-startup-configuration.html
Note InnoDB does not open all user tables and associated data files at startup. However, InnoDB does check for the existence of tablespace files referenced in the data dictionary. If a tablespace file is not found, InnoDB logs an error and continues ... The first decisions to make about InnoDB configuration involve the configuration of data files, log files, page size, and memory buffers, which should be configured before initializing ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-preload-buffer-pool.html
For example, you can save the state of the buffer pool after reaching a stable throughput under a steady workload. Only tablespace IDs and page IDs necessary to locate the appropriate pages are saved to disk. By default, tablespace ID and page ID ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-restrictions-limitations.html
You cannot create a table with a column name that matches the name of an internal InnoDB column (including DB_ROW_ID, DB_TRX_ID, and DB_ROLL_PTR. mysql> CREATE TABLE t1 (c1 INT, db_row_id INT) ENGINE=INNODB; ERROR 1166 (42000): Incorrect column name ... This section describes restrictions and limitations of the InnoDB storage ...