Question

Ошибка
SQL-запрос:

SELECT DISTINCT BE. * , DATE_FORMAT( BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s' ) AS TIMESTAMP_X, DATE_FORMAT( BE.ACTIVE_FROM, '%d.%m.%Y %H:%i:%s' ) AS ACTIVE_FROM, DATE_FORMAT( BE.ACTIVE_TO, '%d.%m.%Y %H:%i:%s' ) AS ACTIVE_TO, L.DIR AS LANG_DIR, B.DETAIL_PAGE_URL, B.LIST_PAGE_URL
FROM b_iblock_element BE, b_lang L, b_iblock B
LEFT JOIN b_iblock_group IBG ON IBG.IBLOCK_ID = B.ID
WHERE BE.IBLOCK_ID = B.ID
AND B.LID = L.LID
AND IBG.GROUP_ID
IN ( 2 )
AND BE.WF_STATUS_ID =1
AND BE.WF_PARENT_ELEMENT_ID IS NULL
AND IBG.PERMISSION >= 'R'
AND (

IBG.PERMISSION = 'X'
OR B.ACTIVE = 'Y'
)
AND (
BE.IBLOCK_ID =1
)
AND (
(
BE.ACTIVE_TO >= now( )
OR BE.ACTIVE_TO IS NULL
)
AND (
BE.ACTIVE_FROM <= now( )
OR BE.ACTIVE_FROM IS NULL
)
)
AND (
BE.ACTIVE = 'Y'
)
AND (
BE.ACTIVE_FROM >= '2006-02-03 13:47:33'
OR BE.ACTIVE_FROM IS NULL
)
ORDER BY BE.ACTIVE_FROM DESC , BE.SORT ASC
LIMIT 0 , 30

Ответ MySQL:

#1037 - Out of memory; restart server and try again (needed 65528 bytes)

Answer 1

Решение простое :)
Увеличить размер памяти в my.cnf

Код
key_buffer            = 32K max_allowed_packet    = 1M table_cache           = 4 sort_buffer_size      = 128K read_buffer_size      = 512K read_rnd_buffer_size  = 512K net_buffer_length     = 2K thread_stack          = 128K skip-locking