Rechercher dans le manuel MySQL

Displaying 21 to 30 of 160 total results
https://dev.mysql.com/storage-requirements.html
Although an individual BIT column is not 4-byte aligned, NDB reserves 4 bytes (32 bits) per row for the first 1-32 bits needed for BIT columns, then another 4 bytes for bits 33-64, and so on. InnoDB Table Storage Requirements NDB Table Storage ...
https://dev.mysql.com/innodb-locking.html
Gap locks in InnoDB are “purely inhibitive”, which means that their only purpose is to prevent other transactions from inserting to the gap. Shared and Exclusive Locks Intention Locks Record Locks Gap Locks Next-Key Locks Insert Intention Locks ...
https://dev.mysql.com/mysqlbinlog.html
--server-id-bits=N Use only the first N bits of the server_id to identify the server. If the binary log was written by a mysqld with server-id-bits set to less than 32 and user data stored in the most significant bit, running mysqlbinlog with ...
https://dev.mysql.com/charset-collation-implementations.html
MySQL implements several types of collations: Simple collations for 8-bit character sets This kind of collation is implemented using an array of 256 weights that defines a one-to-one mapping from character codes to weights. Complex collations for ...It is a case-insensitive collation, so the uppercase and lowercase versions of a character have the same weights and they compare as ...
https://dev.mysql.com/group-replication-options.html
group_replication_gtid_assignment_block_size Property Value Command-Line Format --group-replication-gtid-assignment-block-size=# System Variable group_replication_gtid_assignment_block_size Scope Global Dynamic Yes SET_VAR Hint Applies No Type ...
https://dev.mysql.com/myisampack.html
When the table is used later, the server reads into memory the information needed to decompress columns. This results in much better performance when accessing individual rows, because you only have to uncompress exactly one row. MySQL uses mmap() ...
https://dev.mysql.com/numeric-type-overview.html
M indicates the number of bits per value, from 1 to 64. p represents the precision in bits, but MySQL uses this value only to determine whether to use FLOAT or DOUBLE for the resulting data type. For additional information about properties and ...
https://dev.mysql.com/server-options.html
--exit-info[=flags], -T [flags] Property Value Command-Line Format --exit-info[=flags] Type Integer This is a bitmask of different flags that you can use for debugging the mysqld server. --log-tc-size=size Property Value Command-Line Format ... When ...
https://dev.mysql.com/innodb-standard-monitor.html
The Lock Monitor is the same as the Standard Monitor except that it includes additional lock information. Enabling either monitor for periodic output turns on the same output stream, but the stream includes extra information if the Lock Monitor is ...
https://dev.mysql.com/load-data.html
This modifier affects the performance of LOAD DATA a bit, even if no other thread is using the table at the same time. Using LOCAL is a bit slower than letting the server access the files directly, because the file contents must be sent over the ...
Displaying 21 to 30 of 160 total results

Find a PHP function

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-bit-p-3.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

  1. View the html document Language of the document:en Manuel MySQL : https://dev.mysql.com/

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.

Contents Haut