Rechercher dans le manuel MySQL
Search Results
https://dev.mysql.com/myisam-storage-engine.html
MyISAM is based on the older (and no longer available) ISAM storage engine but has many useful extensions. Table 16.2 MyISAM Storage Engine Features Feature Support B-tree indexes Yes Backup/point-in-time recovery (Implemented in the server, rather ...
https://dev.mysql.com/mysql-cluster-ndb-api-statistics.html
Includes all execute() calls as well as implicit executes for blob operations and auto-increment not visible to clients. This count includes blob-part table operations, implicit unlocking operations, and auto-increment operations, as well as primary ... A number of types of statistical counters relating to actions performed by or affecting Ndb objects are ...
https://dev.mysql.com/mysql-cluster-ndb-innodb-engines.html
The NDB storage engine is implemented using a distributed, shared-nothing architecture, which causes it to behave differently from InnoDB in a number of ways. For those unaccustomed to working with NDB, unexpected behaviors can arise due to its ...
https://dev.mysql.com/mysql-cluster-ndbd-definition.html
The [ndbd] and [ndbd default] sections are used to configure the behavior of the cluster's data nodes. [ndbd] and [ndbd default] are always used as the section names whether you are using ndbd or ndbmtd binaries for the data node processes. There ...
https://dev.mysql.com/mysql-cluster-programs-ndb-import.html
This option limits NDB operations (including blob operations) in a db execution batch. --opbatch=# Property Value Command-Line Format --opbatch=# Type Integer Default Value 256 Minimum Value 1 Maximum Value 4294967295 Set a limit on the number of ...
https://dev.mysql.com/mysql-cluster-replication-conflict-resolution.html
Note If you are replicating tables with very large columns (such as TEXT or BLOB columns), --ndb-log-updated-only can also be useful for reducing the size of the master and slave binary logs and avoiding possible replication failures due to ... When ...
https://dev.mysql.com/optimize-character.html
For column values less than 8KB in size, use binary VARCHAR instead of BLOB. The GROUP BY and ORDER BY clauses can generate temporary tables, and these temporary tables can use the MEMORY storage engine if the original table does not contain any ...
https://dev.mysql.com/packet-too-large.html
You can increase this if the server needs to handle big queries (for example, if you are working with big BLOB columns). You can also get strange problems with large packets if you are using large BLOB values but have not given mysqld access to ...
https://dev.mysql.com/partitioning-limitations.html
There are two exceptions to this restriction: When partitioning by [LINEAR] KEY, it is possible to use columns of any valid MySQL data type other than TEXT or BLOB as partitioning keys, because the internal key-hashing functions produce the correct ... This section discusses current restrictions and limitations on MySQL partitioning ...
https://dev.mysql.com/replication-options-binary-log.html
noblob: Log all columns (same as full), except for BLOB and TEXT columns that are not required to identify rows, or that have not changed. To maximize the amount of space saved, use binlog_row_image=NOBLOB or binlog_row_image=MINIMAL together with ... Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which statements are written to the binary ...
Document created the 26/06/2006, last modified the 26/10/2018
Source of the printed document:https://www.gaudry.be/en/mysql-rf-fct-blob-p-6.html
The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.
References
These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.
