Rechercher dans le manuel MySQL
Search Results
https://dev.mysql.com/innodb-performance-midpoint_insertion.html
The pages are moved to the front of the list (the most-recently used end) when they are accessed in the buffer pool for the first time. In these scans, a data page is typically accessed a few times in quick succession and is never touched again. The ... Rather than using a strict LRU algorithm, InnoDB uses a technique to minimize the amount of data that is brought into the buffer pool and never accessed ...
https://dev.mysql.com/innodb-performance-spin_lock_polling.html
On a multi-core system, it can be more efficient for a thread to continuously check if it can acquire a mutex or rw-lock for a period of time before it sleeps. If the mutex or rw-lock becomes available during this period, the thread can continue ...
https://dev.mysql.com/innodb-performance-thread_concurrency.html
In situations where it is helpful to minimize context switching between threads, InnoDB can use a number of techniques to limit the number of concurrently executing operating system threads (and thus the number of requests that are processed at any ... InnoDB uses operating system threads to process requests from user ...
https://dev.mysql.com/innodb-preload-buffer-pool.html
In addition to saving the buffer pool state at shutdown and restoring it at startup, you can save and restore the buffer pool state at any time, while the server is running. If the operation is complete, the completion time is printed (e.g. If the ... To reduce the warmup period after restarting the server, InnoDB saves a percentage of the most recently used pages for each buffer pool at server shutdown and restores these pages at server ...
https://dev.mysql.com/innodb-tablestats-table.html
Statistics are collected again the next time the table is accessed. This column is reset each time table statistics are recalculated AUTOINC The next number to be issued for any auto-increment-based operation. The rate at which the AUTOINC value ...
https://dev.mysql.com/insert.html
This is 0 for numeric types, the empty string ('') for string types, and the “zero” value for date and time types. Inserting a value into a date or time column that is illegal for the data type. It is possible, therefore, for a client that ...
https://dev.mysql.com/kill.html
In most cases, it might take some time for the thread to die because the kill flag is checked only at specific intervals: During SELECT operations, for ORDER BY and GROUP BY loops, the flag is checked after reading a block of rows. The KILL ... KILL ...
https://dev.mysql.com/ldap-pluggable-authentication.html
With this plugin-loading method, the options must be given each time the server starts. After installing the plugins at runtime, their system variables become available and you can add settings for them to your my.cnf file to configure the plugins ... Note LDAP pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/log-status-table.html
binary_log_position The current binary log position at the time the log_status table was accessed. gtid_executed The current value of the global server variable gtid_executed at the time the log_status table was accessed. relay_log_pos The current ... The log_status table provides information that enables an online backup tool to copy the required log files without locking those resources for the duration of the copy ...
https://dev.mysql.com/mathematical-functions.html
One implication of this behavior is that for equal argument values, RAND(N) returns the same value each time, and thus produces a repeatable sequence of column values. Use of a column with RAND() values in an ORDER BY or GROUP BY clause may yield ...
Nederlandse vertaling
U hebt gevraagd om deze site in het Nederlands te bezoeken. Voor nu wordt alleen de interface vertaald, maar nog niet alle inhoud.Als je me wilt helpen met vertalingen, is je bijdrage welkom. Het enige dat u hoeft te doen, is u op de site registreren en mij een bericht sturen waarin u wordt gevraagd om u toe te voegen aan de groep vertalers, zodat u de gewenste pagina's kunt vertalen. Een link onderaan elke vertaalde pagina geeft aan dat u de vertaler bent en heeft een link naar uw profiel.
Bij voorbaat dank.
Document heeft de 26/06/2006 gemaakt, de laatste keer de 26/10/2018 gewijzigd
Bron van het afgedrukte document:https://www.gaudry.be/nl/mysql-rf-fct-time-p-30.html
De infobrol is een persoonlijke site waarvan de inhoud uitsluitend mijn verantwoordelijkheid is. De tekst is beschikbaar onder CreativeCommons-licentie (BY-NC-SA). Meer info op de gebruiksvoorwaarden en de auteur.
Referenties
Deze verwijzingen en links verwijzen naar documenten die geraadpleegd zijn tijdens het schrijven van deze pagina, of die aanvullende informatie kunnen geven, maar de auteurs van deze bronnen kunnen niet verantwoordelijk worden gehouden voor de inhoud van deze pagina.
De auteur Deze site is als enige verantwoordelijk voor de manier waarop de verschillende concepten, en de vrijheden die met de referentiewerken worden genomen, hier worden gepresenteerd. Vergeet niet dat u meerdere broninformatie moet doorgeven om het risico op fouten te verkleinen.
