"Opcode Caching is Up and Running"

"Opcode Caching Disabled"

# wget http://www.1c-bitrix.ru/download/vm/vm.tar.gz
# mv /var/www /var/www.0
# mkdir /var/www/
# cd /var/www/
# tar xzf ~/vm.tar.gz
# chown -R bitrix.bitrix /var/www

CXN    When   Load  QPS     Slow  QCacheHit  KCacheHit  BpsIn    BpsOut
local  Now    0.00  286.87     0     68.14%     99.20%  279.27k   1.14M
local  Total  0.00  259.85     3     71.51%     99.08%  219.76k   1.44M

CXN     Cmd    ID      User      Host           DB            Time      Query
local   Query  132330  bitrix  192.168.0.1    bitrix  01:01:07  SELECT DISTINCT
local   Query  158219  bitrix  192.168.0.1    bitrix     12:37  SELECT DISTINCT

mysql> select version();
+--------------------------+
| version()                |
+--------------------------+
| 5.0.32-Debian_7etch6-log |
+--------------------------+
1 row in set (0.00 sec)

mysql> show full processlist;
...
| 132330 | bitrix | 192.168.0.1:45057 | bitrix | Query   | 3612 | statistics | 
SELECT DISTINCT BE.ID as ID,BE.NAME as NAME,BE.XML_ID as EXTERNAL_ID,BE.IBLOCK_ID as IBLOCK_ID,BE.IBLOCK_SECTION_ID as IBLOCK_SECTION_ID,B.DETAIL_PAGE_URL as DETAIL_PAGE_URL,BE.PREVIEW_PICTURE as PREVIEW_PICTURE, FPV1.VALUE as PROPERTY_MANUFACTURER_SRC_VALUE, FPV1.ID as PROPERTY_MANUFACTURER_SRC_VALUE_ID, FPEN2.VALUE as PROPERTY_STICKERS_VALUE, FPEN2.ID as PROPERTY_STICKERS_ENUM_ID, FPV2.ID as PROPERTY_STICKERS_VALUE_ID, FPV4.VALUE as PROPERTY_ARTICULS_VALUE, FPV4.ID as PROPERTY_ARTICULS_VALUE_ID, FPV5.VALUE as PROPERTY_RATE_VALUE, FPV5.ID as PROPERTY_RATE_VALUE_ID,L.DIR as LANG_DIR,BE.CODE as CODE,B.IBLOCK_TYPE_ID as IBLOCK_TYPE_ID,B.CODE as IBLOCK_CODE,B.XML_ID as IBLOCK_EXTERNAL_ID FROM b_iblock B      INNER JOIN b_lang L ON B.LID=L.LID      INNER JOIN b_iblock_element BE ON BE.IBLOCK_ID = B.ID INNER JOIN b_iblock_section_element BSE ON BSE.IBLOCK_ELEMENT_ID = BE.ID  INNER JOIN b_iblock_section BS ON BSE.IBLOCK_SECTION_ID = BS.ID  LEFT JOIN b_iblock_property FP1 ON FP1.IBLOCK_ID=B.ID AND  FP1.CODE='MANUFACTURER_SRC'  LEFT JOIN b_iblock_element_property FPV1 ON FP1.ID=FPV1.IBLOCK_PROPERTY_ID     AND FPV1.IBLOCK_ELEMENT_ID=BE.ID  LEFT JOIN b_iblock_property FP2 ON FP2.IBLOCK_ID=B.ID AND  FP2.CODE='STICKERS'  LEFT JOIN b_iblock_element_property FPV2 ON FP2.ID=FPV2.IBLOCK_PROPERTY_ID   AND FPV2.IBLOCK_ELEMENT_ID=BE.ID         LEFT JOIN b_iblock_property_enum FPEN2 ON FP2.ID = FPEN2.PROPERTY_ID AND FPV2.VALUE_ENUM=FPEN2.ID  LEFT JOIN b_iblock_property FP4 ON FP4.IBLOCK_ID=B.ID AND  FP4.CODE='ARTICULS'  LEFT JOIN b_iblock_element_property FPV4 ON FP4.ID=FPV4.IBLOCK_PROPERTY_ID   AND FPV4.IBLOCK_ELEMENT_ID=BE.ID  LEFT JOIN b_iblock_property FP5 ON FP5.IBLOCK_ID=B.ID AND  FP5.CODE='RATE'  LEFT JOIN b_iblock_element_property FPV5 ON FP5.ID=FPV5.IBLOCK_PROPERTY_ID        AND FPV5.IBLOCK_ELEMENT_ID=BE.ID  INNER JOIN b_iblock_property FP6 ON FP6.IBLOCK_ID=B.ID AND  FP6.CODE='MANUFACTURER'  INNER JOIN b_iblock_element_property FPV6 ON FP6.ID=FPV6.IBLOCK_PROPERTY_ID      AND FPV6.IBLOCK_ELEMENT_ID=BE.ID  INNER JOIN b_iblock_property FP7 ON FP7.IBLOCK_ID=B.ID AND  FP7.CODE='BIG_PHOTO'  INNER JOIN b_iblock_element_property FPV7 ON FP7.ID=FPV7.IBLOCK_PROPERTY_ID AND FPV7.IBLOCK_ELEMENT_ID=BE.ID        INNER JOIN b_iblock_property_enum FPEN7 ON FP7.ID = FPEN7.PROPERTY_ID AND FPV7.VALUE_ENUM=FPEN7.ID  INNER JOIN b_iblock_property FP9 ON FP9.IBLOCK_ID=B.ID AND  FP9.CODE='BIG_PLANS'  INNER JOIN b_iblock_element_property FPV9 ON FP9.ID=FPV9.IBLOCK_PROPERTY_ID       AND FPV9.IBLOCK_ELEMENT_ID=BE.ID        INNER JOIN b_iblock_property_enum FPEN9 ON FP9.ID = FPEN9.PROPERTY_ID AND FPV9.VALUE_ENUM=FPEN9.ID  INNER JOIN b_iblock_property FP11 ON FP11.IBLOCK_ID=B.ID AND  FP11.CODE='STABILIZATION'  INNER JOIN b_iblock_element_property FPV11 ON FP11.ID=FPV11.IBLOCK_PROPERTY_ID    AND FPV11.IBLOCK_ELEMENT_ID=BE.ID  INNER JOIN b_iblock_property FP12 ON FP12.IBLOCK_ID=B.ID AND  FP12.CODE='PHOTO_RESOLUTION'  INNER JOIN b_iblock_element_property FPV12 ON FP12.ID=FPV12.IBLOCK_PROPERTY_ID    AND FPV12.IBLOCK_ELEMENT_ID=BE.ID  INNER JOIN b_iblock_property FP13 ON FP13.IBLOCK_ID=B.ID AND  FP13.CODE='OPTICAL_ZOOM'  INNER JOIN b_iblock_element_property FPV13 ON FP13.ID=FPV13.IBLOCK_PROPERTY_ID       AND FPV13.IBLOCK_ELEMENT_ID=BE.ID WHERE 1=1  AND B.ID IN (0,21)         AND     (               (BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL)         ) 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 ((((FPV6.VALUE_NUM = '218232')) OR ((FPV6.VALUE_NUM = '218235')) OR ((FPV6.VALUE_NUM = '218237')) OR ((FPV6.VALUE_NUM = '218238'))))  AND ((((FPEN7.VALUE LIKE 'ДА'))))  AND ((((FPEN9.VALUE LIKE 'ДА'))))  AND ((((FPV11.VALUE_ENUM = '1388'))))  AND ((((FPV12.VALUE >= '8'))))  AND ((((FPV13.VALUE >= '5'))))  AND ((BS.ID = 1481))

mysql> show global variables like 'optimizer_search_depth';
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| optimizer_search_depth | 62    |
+------------------------+-------+

mysql> explain select...
Query aborted by Ctrl+C
Empty set (4.90 sec)

mysql> set session optimizer_search_depth=30;
Query aborted by Ctrl+C
Empty set (7.92 sec)

mysql> set session optimizer_search_depth=10;
28 rows in set (0.22 sec)

mysql> set session optimizer_search_depth=0;
28 rows in set (0.03 sec)

mysql> [B]set session[/B] optimizer_search_depth=...;

mysql> [B]set global[/B] optimizer_search_depth=...;

[FONT=Courier]Top 5 Timed Events                                         Avg %Total
~~~~~~~~~~~~~~~~~~                                        wait   Call
Event                                 Waits    Time (s)   (ms)   Time
------------------------------ ------------ ----------- ------ ------
CPU time                                          8,511         73.6
db file scattered read            2,836,881       1,012      0   8.7
db file sequential read           2,452,163         606      0   5.2
log file sync                        24,138         463     19   4.0
log file parallel write              26,075         283     11   2.4
---------------------------------------------------------------------
Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
            Buffer Nowait %:   99.98       Redo NoWait %:  100.00
            Buffer  Hit   %:   94.95    In-memory Sort %:  100.00
            Library Hit   %:   98.75        Soft Parse %:   98.75
         Execute to Parse %:    7.35         Latch Hit %:   99.90
Parse CPU to Parse Elapsd %:   86.79     % Non-Parse CPU:   96.29[/FONT]

[FONT=Courier]Top 5 Timed Events                                         Avg %Total
~~~~~~~~~~~~~~~~~~                                        wait   Call
Event                                 Waits    Time (s)   (ms)   Time
------------------------------ ------------ ----------- ------ ------
CPU time                                          5,041         80.9
log file sync                        33,127         657     20  10.6
db file sequential read             482,404         379      1   6.1
log file parallel write              33,075         372     11   6.0
SQL*Net message to client        19,624,717          29      0   0.5
---------------------------------------------------------------------[/FONT]