ДЛЕ Скрипт! |
Lina
Как устранить эту ошибку на сайте - DLE ( MySQL error )
При загрузки сайта - изредка вылетает такая ошибка - как исправить ???
MySQL error in file: /engine/modules/functions.php at line 1017
Error Number: 126
The Error returned was:
Incorrect key file for table '/dev/shm/#sql_732b_1.MYI'; try to repair it
SQL query:
SELECT p.id, p.autor, p.date, p.short_story, CHAR_LENGTH(p.full_story) as full_story, p.xfields, p.title, p.category, p.alt_name, p.comm_num, p.allow_comm, p.fixed, p.tags, e.news_read, e.allow_rate, e.rating, e.vote_num, e.votes, e.view_edit, e.editdate, e.editor, e.reason FROM dle_post p LEFT JOIN dle_post_extras e ON (p.id=e.news_id) WHERE approve=1 ORDER BY RAND() LIMIT 0,10
Ответы:
fallen down
Запрос не причем. Такое вылетает когда нет места или рама для временных таблиц. Надо выделить больше места на /tmp/ или задать через настройки самого сервера. Пример:
set global tmp_table_size = 1G;
set global max_heap_table_size = 1G;
Игорь Киселев
It appears that your query is returning a large intermediate result set requiring the creation of a temporary table and that the configured location for mysql temporary disk tables (/tmp) is not large enough for the resulting temporary table.
You could try increasing the tmpfs partition size by remounting it:
mount -t tmpfs -o remount,size=1G tmpfs /tmp
You can make this change permanent by editing /etc/fstab
If you are unable to do this you could try changing the location of disk temporary tables by editing the "tmpdir" entry in your my.cnf file (or add it if it is not already there). Remember that the directory you choose should be writable by the mysql user
You could also try preventing the creation of an on disk temporary table by increasing the values for the mysql configuration options:
tmp_table_size
max_heap_table_size
to larger values. You will need to increase both of the above parameters
Example:
set global tmp_table_size = 1G;
set global max_heap_table_size = 1G;
|