Sort buffer (MySQL): verschil tussen versies
Naar navigatie springen
Naar zoeken springen
(Nieuwe pagina aangemaakt met 'Foutmelding, januari 2021: <pre> Error Code: 1038. Out of sort memory, consider increasing server sort buffer size </pre> Meer info via de MySQl client: <pre> >...') |
|||
Regel 35: | Regel 35: | ||
* [[Configuratiebestanden (MySQL)]] | * [[Configuratiebestanden (MySQL)]] | ||
+ | * [[Systeemvariabelen (MySQL)]] | ||
== Bronnen == | == Bronnen == | ||
* https://stackoverflow.com/questions/29575835/error-1038-out-of-sort-memory-consider-increasing-sort-buffer-size | * https://stackoverflow.com/questions/29575835/error-1038-out-of-sort-memory-consider-increasing-sort-buffer-size |
Huidige versie van 19 jan 2021 om 14:13
Foutmelding, januari 2021:
Error Code: 1038. Out of sort memory, consider increasing server sort buffer size
Meer info via de MySQl client:
> mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 12 Server version: 8.0.22-0ubuntu0.20.04.3 (Ubuntu) Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show variables where Variable_name like "%sort\_buffer\_size%"; +-------------------------+---------+ | Variable_name | Value | +-------------------------+---------+ | innodb_sort_buffer_size | 1048576 | | myisam_sort_buffer_size | 8388608 | | sort_buffer_size | 262144 | = 256KB +-------------------------+---------+ 3 rows in set (0.00 sec)