Rechercher dans le manuel MySQL
Search Results
https://dev.mysql.com/mysql-cluster-limitations-syntax.html
There are no prefix indexes; only entire columns can be indexed. A partial fix for this issue improved the error used internally to work in most cases; however, it remains possible for this situation to occur in the event that the parent index is a ... Some SQL statements relating to certain MySQL features produce errors when used with NDB tables, as described in the following list: Temporary ...
https://dev.mysql.com/mysql-cluster-ndbd-definition.html
For those parameters affecting memory usage or buffer sizes, it is possible to use K, M, or G as a suffix to indicate units of 1024, 1024×1024, or 1024×1024×1024. Variable-length records use a fixed-size part with an extra overhead of 4 bytes to ... The [ndbd] and [ndbd default] sections are used to configure the behavior of the cluster's data ...
https://dev.mysql.com/mysql-cluster-option-tables.html
ndb_data_node_neighbour: Specifies cluster data node "closest" to this MySQL Server, for transaction hinting and fully replicated tables ndb_default_column_format: Sets default row format and column format (FIXED or DYNAMIC) used for new NDB tables ... The following table provides a list of the command-line options, server and status variables applicable within mysqld when it is running as an SQL node in an NDB ...
https://dev.mysql.com/mysql-cluster-programs-ndb-size-pl.html
This is a Perl script that can be used to estimate the amount of space that would be required by a MySQL database if it were converted to use the NDBCLUSTER storage engine. Unlike the other utilities discussed in this section, it does not require ...
https://dev.mysql.com/order-by-optimization.html
There is an index on only a prefix of a column named in the ORDER BY clause. To obtain memory for filesort operations, as of MySQL 8.0.12, the optimizer allocates memory buffers incrementally as needed, up to the size indicated by the ... This ...
https://dev.mysql.com/partitioning-management-exchange.html
Table nt contains no foreign key references, and no other table has any foreign keys that refer to nt. There are no rows in nt that lie outside the boundaries of the partition definition for p. To determine the row format of an InnoDB table, query ...
https://dev.mysql.com/performance-schema-connection-attribute-tables.html
FEDERATED storage engine connections: program_name: mysqld _client_role: federated_storage There are limits on the amount of connection attribute data transmitted from client to server: A fixed limit imposed by the client prior to connect time.
https://dev.mysql.com/plugin-data-structures.html
The descriptor begins with a fixed set of members common to all client plugins, followed by any members specific to the plugin type. For example, if a program needs to use a client authentication plugin named auth_xxx on a system that uses .so as ...
https://dev.mysql.com/selecting-all.html
Fix only the erroneous record with an UPDATE statement: mysql> UPDATE pet SET birth = '1989-08-31' WHERE name = 'Bowser'; The UPDATE changes only the record in question and does not require you to reload the table. For example, you may happen to ...
https://dev.mysql.com/upgrading-from-previous-series.html
Several spatial functions were removed in MySQL 8.0.0 due to a spatial function namespace change that implemented an ST_ prefix for functions that perform an exact operation, or an MBR prefix for functions that perform an operation based on minimum ... Before upgrading to MySQL 8.0, review the changes described in this section to identify those that apply to your current MySQL installation and ...
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-fixed-p-5.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.
