Rechercher dans le manuel MySQL
Search Results
https://dev.mysql.com/mysql-stmt-fetch.html
CR_SERVER_LOST The connection to the server was lost during the query. (This example expects to retrieve the two rows inserted by the example shown in Section 28.7.10.10, “mysql_stmt_execute()”.) The mysql variable is assumed to be a valid ...
https://dev.mysql.com/ndb-restore-different-number-nodes.html
The original cluster has four data nodes, with the node IDs and host names shown in the following extract from the management server's config.ini file: [ndbd]NodeId=2 HostName=host2 [ndbd] NodeId=4 HostName=host4 [ndbd] NodeId=6 HostName=host6 ...
https://dev.mysql.com/packet-too-large.html
When a MySQL client or the mysqld server receives a packet bigger than max_allowed_packet bytes, it issues an ER_NET_PACKET_TOO_LARGE error and closes the connection. With some clients, you may also get a Lost connection to MySQL server during query ... A communication packet is a single SQL statement sent to the MySQL server, a single row that is sent to the client, or a binary log event sent from a master replication server to a ...
https://dev.mysql.com/password-security-user.html
When you run a client program to connect to the MySQL server, it is inadvisable to specify your password in a way that exposes it to discovery by other users. The file can be read later by MySQL client programs to obtain authentication credentials ... MySQL users should use the following guidelines to keep passwords ...
https://dev.mysql.com/performance-schema-instance-tables.html
They provide event names and explanatory notes or status information: cond_instances: Condition synchronization object instances file_instances: File instances mutex_instances: Mutex synchronization object instances rwlock_instances: Lock ...There ...
https://dev.mysql.com/perl-installation.html
These tests attempt to connect to the local MySQL server using the default user name and password. The default password is “no password.”) If you cannot connect to the server with those values (for example, if your account has a password), the ... MySQL Perl support requires that you have installed MySQL client programming support (libraries and header ...
https://dev.mysql.com/persisted-system-variables.html
Examples: SET PERSIST max_connections = 1000; SET @@PERSIST.max_connections = 1000; SET PERSIST_ONLY back_log = 100; SET @@PERSIST_ONLY.back_log = 100; MySQL also provides a RESET PERSIST statement for removing persisted system variables from ...
https://dev.mysql.com/plugin-types.html
Plugins on the server side implement authentication methods for use by clients when they connect to the server. A server-side authentication plugin can return to the server the name of the user whose identity the connecting user should have. The ...
https://dev.mysql.com/range-optimization.html
For EXPLAIN FOR CONNECTION, the output changes as follows if index dives are skipped: For traditional output, the rows and filtered values are NULL. Without FOR CONNECTION, EXPLAIN output does not change when index dives are skipped. The range ...
https://dev.mysql.com/replicasets-working-with-router.html
You can use MySQL Router 8.0.19 and later to bootstrap against a replica set, in the same way that InnoDB cluster can be bootstrapped. The only difference in the generated MySQL Router configuration file is the addition of the cluster_type option.
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-connection-p-45.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.
