Rechercher dans le manuel MySQL

Displaying 41 to 50 of 139 total 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 ...
Displaying 41 to 50 of 139 total results

Rechercher dans le manuel MySQL

Traduction non disponible

Le manuel MySQL n'est pas encore traduit en français sur l'infobrol. Seule la version anglaise est disponible pour l'instant.

Document créé le 26/06/2006, dernière modification le 26/10/2018
Source du document imprimé : https://www.gaudry.be/mysql-rf-fct-fixed-p-5.html

L'infobrol est un site personnel dont le contenu n'engage que moi. Le texte est mis à disposition sous licence CreativeCommons(BY-NC-SA). Plus d'info sur les conditions d'utilisation et sur l'auteur.

Références

  1. Consulter le document html Langue du document :en Manuel MySQL : https://dev.mysql.com/

Ces références et liens indiquent des documents consultés lors de la rédaction de cette page, ou qui peuvent apporter un complément d'information, mais les auteurs de ces sources ne peuvent être tenus responsables du contenu de cette page.
L'auteur de ce site est seul responsable de la manière dont sont présentés ici les différents concepts, et des libertés qui sont prises avec les ouvrages de référence. N'oubliez pas que vous devez croiser les informations de sources multiples afin de diminuer les risques d'erreurs.

Table des matières Haut