MySQL: Настройка производительности
Array ( [0] => Array ( [PRICES] => Array ( [BASE] => Array ( [PRICE_ID] => 1 [ID] => 64915 [CAN_ACCESS] => Y [CAN_BUY] => Y [MIN_PRICE] => Y [CURRENCY] => RUB [VALUE_VAT] => 60000 [VALUE_NOVAT] => 60000 [DISCOUNT_VALUE_VAT] => 60000 [DISCOUNT_VALUE_NOVAT] => 60000 [ROUND_VALUE_VAT] => 60000 [ROUND_VALUE_NOVAT] => 60000 [VALUE] => 60000 [UNROUND_DISCOUNT_VALUE] => 60000 [DISCOUNT_VALUE] => 60000 [DISCOUNT_DIFF] => 0 [DISCOUNT_DIFF_PERCENT] => 0 [VATRATE_VALUE] => 0 [DISCOUNT_VATRATE_VALUE] => 0 [ROUND_VATRATE_VALUE] => 0 [PRINT_VALUE_NOVAT] => 60 000 руб. [PRINT_VALUE_VAT] => 60 000 руб. [PRINT_VATRATE_VALUE] => 0 руб. [PRINT_DISCOUNT_VALUE_NOVAT] => 60 000 руб. [PRINT_DISCOUNT_VALUE_VAT] => 60 000 руб. [PRINT_DISCOUNT_VATRATE_VALUE] => 0 руб. [PRINT_VALUE] => 60 000 руб. [PRINT_DISCOUNT_VALUE] => 60 000 руб. [PRINT_DISCOUNT_DIFF] => 0 руб. ) ) [PRICE_MATRIX] => [MIN_PRICE] => Array ( [PRICE_ID] => 1 [ID] => 64915 [CAN_ACCESS] => Y [CAN_BUY] => Y [MIN_PRICE] => Y [CURRENCY] => RUB [VALUE_VAT] => 60000 [VALUE_NOVAT] => 60000 [DISCOUNT_VALUE_VAT] => 60000 [DISCOUNT_VALUE_NOVAT] => 60000 [ROUND_VALUE_VAT] => 60000 [ROUND_VALUE_NOVAT] => 60000 [VALUE] => 60000 [UNROUND_DISCOUNT_VALUE] => 60000 [DISCOUNT_VALUE] => 60000 [DISCOUNT_DIFF] => 0 [DISCOUNT_DIFF_PERCENT] => 0 [VATRATE_VALUE] => 0 [DISCOUNT_VATRATE_VALUE] => 0 [ROUND_VATRATE_VALUE] => 0 [PRINT_VALUE_NOVAT] => 60 000 руб. [PRINT_VALUE_VAT] => 60 000 руб. [PRINT_VATRATE_VALUE] => 0 руб. [PRINT_DISCOUNT_VALUE_NOVAT] => 60 000 руб. [PRINT_DISCOUNT_VALUE_VAT] => 60 000 руб. [PRINT_DISCOUNT_VATRATE_VALUE] => 0 руб. [PRINT_VALUE] => 60 000 руб. [PRINT_DISCOUNT_VALUE] => 60 000 руб. [PRINT_DISCOUNT_DIFF] => 0 руб. ) [CATALOG_GROUP_ID_1] => 1 [~CATALOG_GROUP_ID_1] => 1 [CATALOG_GROUP_NAME_1] => Базовая цена [~CATALOG_GROUP_NAME_1] => Базовая цена [CATALOG_CAN_ACCESS_1] => Y [~CATALOG_CAN_ACCESS_1] => Y [CATALOG_CAN_BUY_1] => Y [~CATALOG_CAN_BUY_1] => Y [CATALOG_PRICE_ID_1] => 64915 [~CATALOG_PRICE_ID_1] => 64915 [CATALOG_PRICE_1] => 60000.00 [~CATALOG_PRICE_1] => 60000.00 [CATALOG_CURRENCY_1] => RUB [~CATALOG_CURRENCY_1] => RUB [CATALOG_QUANTITY_FROM_1] => [~CATALOG_QUANTITY_FROM_1] => [CATALOG_QUANTITY_TO_1] => [~CATALOG_QUANTITY_TO_1] => [CATALOG_EXTRA_ID_1] => [~CATALOG_EXTRA_ID_1] => [ID] => 62558 [~ID] => 62558 [IBLOCK_ID] => 24 [~IBLOCK_ID] => 24 [PROPERTY_85_VALUE] => 62544 [~PROPERTY_85_VALUE] => 62544 [PROPERTY_85_VALUE_ID] => 5481540 [~PROPERTY_85_VALUE_ID] => 5481540 [PREVIEW_PICTURE] => [~PREVIEW_PICTURE] => [DETAIL_PICTURE] => [~DETAIL_PICTURE] => [PROPERTY_DATE_FROM_VALUE] => 27.03.2023 [~PROPERTY_DATE_FROM_VALUE] => 27.03.2023 [PROPERTY_DATE_FROM_VALUE_ID] => 5481547 [~PROPERTY_DATE_FROM_VALUE_ID] => 5481547 [NAME] => MySQL: Настройка производительности [~NAME] => MySQL: Настройка производительности [SORT_HASH] => 1d3fc9b3d524ac49b4ce3debe65e5988 [LINK_ELEMENT_ID] => 62544 [PROPERTIES] => Array ( [CML2_LINK] => Array ( [ID] => 85 [IBLOCK_ID] => 24 [NAME] => Элемент каталога [ACTIVE] => Y [SORT] => 5 [CODE] => CML2_LINK [DEFAULT_VALUE] => [PROPERTY_TYPE] => E [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => CML2_LINK [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 25 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => Y [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => SKU [USER_TYPE_SETTINGS] => Array ( [VIEW] => A [SHOW_ADD] => N [MAX_WIDTH] => 0 [MIN_HEIGHT] => 24 [MAX_HEIGHT] => 1000 [BAN_SYM] => ,; [REP_SYM] => [OTHER_REP_SYM] => [IBLOCK_MESS] => N ) [HINT] => [~NAME] => Элемент каталога [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => 62544 [PROPERTY_VALUE_ID] => 5481540 [DESCRIPTION] => [~VALUE] => 62544 [~DESCRIPTION] => ) [CITY] => Array ( [ID] => 92 [IBLOCK_ID] => 24 [NAME] => Город проведения [ACTIVE] => Y [SORT] => 500 [CODE] => CITY [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => Y [FILTRABLE] => Y [IS_REQUIRED] => Y [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => [HINT] => [~NAME] => Город проведения [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => Москва [PROPERTY_VALUE_ID] => 5481549 [DESCRIPTION] => [~VALUE] => Москва [~DESCRIPTION] => ) [MAX_COUNT] => Array ( [ID] => 100 [IBLOCK_ID] => 24 [NAME] => Исходное количество мест [ACTIVE] => Y [SORT] => 500 [CODE] => MAX_COUNT [DEFAULT_VALUE] => [PROPERTY_TYPE] => N [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => [HINT] => [~NAME] => Исходное количество мест [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [DATE_FROM] => Array ( [ID] => 101 [IBLOCK_ID] => 24 [NAME] => Начало курса [ACTIVE] => Y [SORT] => 500 [CODE] => DATE_FROM [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => Y [FILTRABLE] => Y [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => DateTime [USER_TYPE_SETTINGS] => [HINT] => [~NAME] => Начало курса [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => 27.03.2023 [PROPERTY_VALUE_ID] => 5481547 [DESCRIPTION] => [~VALUE] => 27.03.2023 [~DESCRIPTION] => ) [DATE_TO] => Array ( [ID] => 102 [IBLOCK_ID] => 24 [NAME] => Окончание курса [ACTIVE] => Y [SORT] => 500 [CODE] => DATE_TO [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => Y [FILTRABLE] => Y [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => DateTime [USER_TYPE_SETTINGS] => [HINT] => [~NAME] => Окончание курса [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => 30.03.2023 [PROPERTY_VALUE_ID] => 5481548 [DESCRIPTION] => [~VALUE] => 30.03.2023 [~DESCRIPTION] => ) [FLAG_SALE] => Array ( [ID] => 141 [IBLOCK_ID] => 24 [NAME] => Скидки [ACTIVE] => Y [SORT] => 500 [CODE] => FLAG_SALE [DEFAULT_VALUE] => [PROPERTY_TYPE] => L [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => C [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => [HINT] => [~NAME] => Скидки [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => [VALUE_ENUM_ID] => ) [IN_ACTION] => Array ( [ID] => 142 [IBLOCK_ID] => 24 [NAME] => Участвует в акциях [ACTIVE] => Y [SORT] => 500 [CODE] => IN_ACTION [DEFAULT_VALUE] => [PROPERTY_TYPE] => E [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => Y [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 30 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => EList [USER_TYPE_SETTINGS] => Array ( [size] => 1 [width] => 0 [group] => N [multiple] => N ) [HINT] => [~NAME] => Участвует в акциях [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [NEW] => Array ( [ID] => 144 [IBLOCK_ID] => 24 [NAME] => Новинка [ACTIVE] => Y [SORT] => 500 [CODE] => NEW [DEFAULT_VALUE] => [PROPERTY_TYPE] => L [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => C [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => [HINT] => [~NAME] => Новинка [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => [VALUE_ENUM_ID] => ) [DURATION_HOURS] => Array ( [ID] => 174 [IBLOCK_ID] => 24 [NAME] => Длитеность, часов [ACTIVE] => Y [SORT] => 500 [CODE] => DURATION_HOURS [DEFAULT_VALUE] => [PROPERTY_TYPE] => N [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => [HINT] => [~NAME] => Длитеность, часов [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => 32 [PROPERTY_VALUE_ID] => 5481543 [DESCRIPTION] => [~VALUE] => 32 [~DESCRIPTION] => ) [DURATION_DAYS] => Array ( [ID] => 175 [IBLOCK_ID] => 24 [NAME] => Длитеность, дней [ACTIVE] => Y [SORT] => 500 [CODE] => DURATION_DAYS [DEFAULT_VALUE] => [PROPERTY_TYPE] => N [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => [HINT] => [~NAME] => Длитеность, дней [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => 4 [PROPERTY_VALUE_ID] => 5481544 [DESCRIPTION] => [~VALUE] => 4 [~DESCRIPTION] => ) [COURSE_CODE] => Array ( [ID] => 176 [IBLOCK_ID] => 24 [NAME] => Код курса [ACTIVE] => Y [SORT] => 500 [CODE] => COURSE_CODE [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => [HINT] => [~NAME] => Код курса [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => MySQLPT_au [PROPERTY_VALUE_ID] => 5481545 [DESCRIPTION] => [~VALUE] => MySQLPT_au [~DESCRIPTION] => ) [ACTION_NUMBER] => Array ( [ID] => 177 [IBLOCK_ID] => 24 [NAME] => Номер акции [ACTIVE] => Y [SORT] => 500 [CODE] => ACTION_NUMBER [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => [HINT] => [~NAME] => Номер акции [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [MARKER] => Array ( [ID] => 178 [IBLOCK_ID] => 24 [NAME] => Маркер [ACTIVE] => Y [SORT] => 500 [CODE] => MARKER [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => [HINT] => [~NAME] => Маркер [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => MySQL [PROPERTY_VALUE_ID] => 5481546 [DESCRIPTION] => [~VALUE] => MySQL [~DESCRIPTION] => ) [HINT] => Array ( [ID] => 179 [IBLOCK_ID] => 24 [NAME] => Примечание [ACTIVE] => Y [SORT] => 500 [CODE] => HINT [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => [HINT] => [~NAME] => Примечание [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [B_SPECIAL_PRICE] => Array ( [ID] => 180 [IBLOCK_ID] => 24 [NAME] => B_SPECIAL_PRICE [ACTIVE] => Y [SORT] => 500 [CODE] => B_SPECIAL_PRICE [DEFAULT_VALUE] => [PROPERTY_TYPE] => N [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => [HINT] => [~NAME] => B_SPECIAL_PRICE [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => 0 [PROPERTY_VALUE_ID] => 5481541 [DESCRIPTION] => [~VALUE] => 0 [~DESCRIPTION] => ) [NORMAL_PRICE] => Array ( [ID] => 181 [IBLOCK_ID] => 24 [NAME] => Стандартная цена для 1 чел. [ACTIVE] => Y [SORT] => 500 [CODE] => NORMAL_PRICE [DEFAULT_VALUE] => [PROPERTY_TYPE] => N [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => [HINT] => [~NAME] => Стандартная цена для 1 чел. [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => 60000 [PROPERTY_VALUE_ID] => 5481542 [DESCRIPTION] => [~VALUE] => 60000 [~DESCRIPTION] => ) [SECTION_CODE] => Array ( [ID] => 186 [IBLOCK_ID] => 24 [NAME] => Подкатегория курса 4 [ACTIVE] => Y [SORT] => 500 [CODE] => SECTION_CODE [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => [HINT] => [~NAME] => Подкатегория курса 4 [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => 30 [PROPERTY_VALUE_ID] => 5481550 [DESCRIPTION] => [~VALUE] => 30 [~DESCRIPTION] => ) [SHOW_TO_MAIN] => Array ( [ID] => 189 [IBLOCK_ID] => 24 [NAME] => Показывать на главной [ACTIVE] => Y [SORT] => 500 [CODE] => SHOW_TO_MAIN [DEFAULT_VALUE] => [PROPERTY_TYPE] => L [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => C [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => [HINT] => [~NAME] => Показывать на главной [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => [VALUE_ENUM_ID] => ) ) [DISPLAY_PROPERTIES] => Array ( [DATE_TO] => Array ( [ID] => 102 [IBLOCK_ID] => 24 [NAME] => Окончание курса [ACTIVE] => Y [SORT] => 500 [CODE] => DATE_TO [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => Y [FILTRABLE] => Y [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => DateTime [USER_TYPE_SETTINGS] => [HINT] => [~NAME] => Окончание курса [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => 30.03.2023 [PROPERTY_VALUE_ID] => 5481548 [DESCRIPTION] => [~VALUE] => 30.03.2023 [~DESCRIPTION] => [DISPLAY_VALUE] => 30.03.2023 ) ) [PRODUCT] => Array ( [TYPE] => 4 [AVAILABLE] => Y [BUNDLE] => N [QUANTITY] => 0 [QUANTITY_TRACE] => N [CAN_BUY_ZERO] => N [MEASURE] => 6 [SUBSCRIBE] => N [VAT_ID] => 0 [VAT_RATE] => 0 [VAT_INCLUDED] => N [WEIGHT] => 0 [WIDTH] => 0 [LENGTH] => 0 [HEIGHT] => 0 [PAYMENT_TYPE] => S [RECUR_SCHEME_TYPE] => D [RECUR_SCHEME_LENGTH] => 0 [TRIAL_PRICE_ID] => 0 ) [CATALOG_TYPE] => 4 [CATALOG_AVAILABLE] => Y [CATALOG_BUNDLE] => N [CATALOG_QUANTITY] => 0 [CATALOG_QUANTITY_TRACE] => N [CATALOG_CAN_BUY_ZERO] => N [CATALOG_MEASURE] => 6 [CATALOG_SUBSCRIBE] => N [CATALOG_VAT_ID] => [CATALOG_VAT_INCLUDED] => N [CATALOG_WEIGHT] => 0 [CATALOG_WIDTH] => [CATALOG_LENGTH] => [CATALOG_HEIGHT] => [CATALOG_PRICE_TYPE] => S [CATALOG_RECUR_SCHEME_LENGTH] => [CATALOG_RECUR_SCHEME_TYPE] => D [CATALOG_QUANTITY_TRACE_ORIG] => D [CATALOG_CAN_BUY_ZERO_ORIG] => D [CATALOG_SUBSCRIBE_ORIG] => D [CATALOG_PURCHASING_PRICE] => [CATALOG_PURCHASING_CURRENCY] => [CATALOG_BARCODE_MULTI] => N [CATALOG_TRIAL_PRICE_ID] => [CATALOG_WITHOUT_ORDER] => N [~CATALOG_TYPE] => 4 [~CATALOG_AVAILABLE] => Y [~CATALOG_BUNDLE] => N [~CATALOG_QUANTITY] => 0 [~CATALOG_QUANTITY_TRACE] => N [~CATALOG_CAN_BUY_ZERO] => N [~CATALOG_MEASURE] => 6 [~CATALOG_SUBSCRIBE] => N [~CATALOG_VAT_ID] => [~CATALOG_VAT_INCLUDED] => N [~CATALOG_WEIGHT] => 0 [~CATALOG_WIDTH] => [~CATALOG_LENGTH] => [~CATALOG_HEIGHT] => [~CATALOG_PRICE_TYPE] => S [~CATALOG_RECUR_SCHEME_LENGTH] => [~CATALOG_RECUR_SCHEME_TYPE] => D [~CATALOG_QUANTITY_TRACE_ORIG] => D [~CATALOG_CAN_BUY_ZERO_ORIG] => D [~CATALOG_SUBSCRIBE_ORIG] => D [~CATALOG_PURCHASING_PRICE] => [~CATALOG_PURCHASING_CURRENCY] => [~CATALOG_BARCODE_MULTI] => N [~CATALOG_TRIAL_PRICE_ID] => [~CATALOG_WITHOUT_ORDER] => N [~CATALOG_VAT] => 0 [CATALOG_VAT] => 0 [ITEM_PRICE_MODE] => S [ITEM_PRICES] => Array ( [0] => Array ( [UNROUND_BASE_PRICE] => 60000 [UNROUND_PRICE] => 60000 [BASE_PRICE] => 60000 [PRICE] => 60000 [ID] => 64915 [PRICE_TYPE_ID] => 1 [CURRENCY] => RUB [DISCOUNT] => 0 [PERCENT] => 0 [VAT] => 0 [QUANTITY_FROM] => [QUANTITY_TO] => [QUANTITY_HASH] => ZERO-INF [MEASURE_RATIO_ID] => [PRINT_BASE_PRICE] => 60 000 руб. [RATIO_BASE_PRICE] => 60000 [PRINT_RATIO_BASE_PRICE] => 60 000 руб. [PRINT_PRICE] => 60 000 руб. [RATIO_PRICE] => 60000 [PRINT_RATIO_PRICE] => 60 000 руб. [PRINT_DISCOUNT] => 0 руб. [RATIO_DISCOUNT] => 0 [PRINT_RATIO_DISCOUNT] => 0 руб. [PRINT_VAT] => 0 руб. [RATIO_VAT] => 0 [PRINT_RATIO_VAT] => 0 руб. [MIN_QUANTITY] => 1 ) ) [ITEM_QUANTITY_RANGES] => Array ( [ZERO-INF] => Array ( [HASH] => ZERO-INF [QUANTITY_FROM] => [QUANTITY_TO] => [SORT_FROM] => 0 [SORT_TO] => INF ) ) [ITEM_MEASURE_RATIOS] => Array ( [4256] => Array ( [ID] => 4256 [RATIO] => 1 [IS_DEFAULT] => Y [PRODUCT_ID] => 62558 ) ) [ITEM_MEASURE] => Array ( [ID] => 6 [TITLE] => место [~TITLE] => место ) [ITEM_MEASURE_RATIO_SELECTED] => 4256 [ITEM_QUANTITY_RANGE_SELECTED] => ZERO-INF [ITEM_PRICE_SELECTED] => 0 [CHECK_QUANTITY] => [CATALOG_MEASURE_NAME] => место [~CATALOG_MEASURE_NAME] => место [CAN_BUY] => 1 [ITEM_PRICES_CAN_BUY] => 1 [~BUY_URL] => /courses/MySQLPT_au/?action=BUY&id=62558 [BUY_URL] => /courses/MySQLPT_au/?action=BUY&id=62558 [~ADD_URL] => /courses/MySQLPT_au/?action=ADD2BASKET&id=62558 [ADD_URL] => /courses/MySQLPT_au/?action=ADD2BASKET&id=62558 [~SUBSCRIBE_URL] => /courses/MySQLPT_au/?action=SUBSCRIBE_PRODUCT&id=62558 [SUBSCRIBE_URL] => /courses/MySQLPT_au/?action=SUBSCRIBE_PRODUCT&id=62558 [~COMPARE_URL] => /courses/MySQLPT_au/?action=ADD_TO_COMPARE_LIST&id=62558 [COMPARE_URL] => /courses/MySQLPT_au/?action=ADD_TO_COMPARE_LIST&id=62558 [~COMPARE_DELETE_URL] => /courses/MySQLPT_au/?action=DELETE_FROM_COMPARE_LIST&id=62558 [COMPARE_DELETE_URL] => /courses/MySQLPT_au/?action=DELETE_FROM_COMPARE_LIST&id=62558 [CATALOG_MEASURE_RATIO] => 1 [OFFER_GROUP] => [RATIO_PRICE] => Array ( [VALUE] => 60000 [DISCOUNT_VALUE] => 60000 [PRINT_VALUE] => 60 000 руб. [PRINT_DISCOUNT_VALUE] => 60 000 руб. [DISCOUNT_DIFF] => 0 [PRINT_DISCOUNT_DIFF] => 0 руб. [DISCOUNT_DIFF_PERCENT] => 0 [CURRENCY] => RUB ) [MORE_PHOTO] => Array ( [0] => Array ( [SRC] => /bitrix/templates/.default/components/bitrix/catalog.element/course/images/no_photo.png [WIDTH] => 150 [HEIGHT] => 150 ) ) [MORE_PHOTO_COUNT] => 1 ) [1] => Array ( [PRICES] => Array ( [BASE] => Array ( [PRICE_ID] => 1 [ID] => 64972 [CAN_ACCESS] => Y [CAN_BUY] => Y [MIN_PRICE] => Y [CURRENCY] => RUB [VALUE_VAT] => 60000 [VALUE_NOVAT] => 60000 [DISCOUNT_VALUE_VAT] => 60000 [DISCOUNT_VALUE_NOVAT] => 60000 [ROUND_VALUE_VAT] => 60000 [ROUND_VALUE_NOVAT] => 60000 [VALUE] => 60000 [UNROUND_DISCOUNT_VALUE] => 60000 [DISCOUNT_VALUE] => 60000 [DISCOUNT_DIFF] => 0 [DISCOUNT_DIFF_PERCENT] => 0 [VATRATE_VALUE] => 0 [DISCOUNT_VATRATE_VALUE] => 0 [ROUND_VATRATE_VALUE] => 0 [PRINT_VALUE_NOVAT] => 60 000 руб. [PRINT_VALUE_VAT] => 60 000 руб. [PRINT_VATRATE_VALUE] => 0 руб. [PRINT_DISCOUNT_VALUE_NOVAT] => 60 000 руб. [PRINT_DISCOUNT_VALUE_VAT] => 60 000 руб. [PRINT_DISCOUNT_VATRATE_VALUE] => 0 руб. [PRINT_VALUE] => 60 000 руб. [PRINT_DISCOUNT_VALUE] => 60 000 руб. [PRINT_DISCOUNT_DIFF] => 0 руб. ) ) [PRICE_MATRIX] => [MIN_PRICE] => Array ( [PRICE_ID] => 1 [ID] => 64972 [CAN_ACCESS] => Y [CAN_BUY] => Y [MIN_PRICE] => Y [CURRENCY] => RUB [VALUE_VAT] => 60000 [VALUE_NOVAT] => 60000 [DISCOUNT_VALUE_VAT] => 60000 [DISCOUNT_VALUE_NOVAT] => 60000 [ROUND_VALUE_VAT] => 60000 [ROUND_VALUE_NOVAT] => 60000 [VALUE] => 60000 [UNROUND_DISCOUNT_VALUE] => 60000 [DISCOUNT_VALUE] => 60000 [DISCOUNT_DIFF] => 0 [DISCOUNT_DIFF_PERCENT] => 0 [VATRATE_VALUE] => 0 [DISCOUNT_VATRATE_VALUE] => 0 [ROUND_VATRATE_VALUE] => 0 [PRINT_VALUE_NOVAT] => 60 000 руб. [PRINT_VALUE_VAT] => 60 000 руб. [PRINT_VATRATE_VALUE] => 0 руб. [PRINT_DISCOUNT_VALUE_NOVAT] => 60 000 руб. [PRINT_DISCOUNT_VALUE_VAT] => 60 000 руб. [PRINT_DISCOUNT_VATRATE_VALUE] => 0 руб. [PRINT_VALUE] => 60 000 руб. [PRINT_DISCOUNT_VALUE] => 60 000 руб. [PRINT_DISCOUNT_DIFF] => 0 руб. ) [CATALOG_GROUP_ID_1] => 1 [~CATALOG_GROUP_ID_1] => 1 [CATALOG_GROUP_NAME_1] => Базовая цена [~CATALOG_GROUP_NAME_1] => Базовая цена [CATALOG_CAN_ACCESS_1] => Y [~CATALOG_CAN_ACCESS_1] => Y [CATALOG_CAN_BUY_1] => Y [~CATALOG_CAN_BUY_1] => Y [CATALOG_PRICE_ID_1] => 64972 [~CATALOG_PRICE_ID_1] => 64972 [CATALOG_PRICE_1] => 60000.00 [~CATALOG_PRICE_1] => 60000.00 [CATALOG_CURRENCY_1] => RUB [~CATALOG_CURRENCY_1] => RUB [CATALOG_QUANTITY_FROM_1] => [~CATALOG_QUANTITY_FROM_1] => [CATALOG_QUANTITY_TO_1] => [~CATALOG_QUANTITY_TO_1] => [CATALOG_EXTRA_ID_1] => [~CATALOG_EXTRA_ID_1] => [ID] => 62623 [~ID] => 62623 [IBLOCK_ID] => 24 [~IBLOCK_ID] => 24 [PROPERTY_85_VALUE] => 62544 [~PROPERTY_85_VALUE] => 62544 [PROPERTY_85_VALUE_ID] => 5481551 [~PROPERTY_85_VALUE_ID] => 5481551 [PREVIEW_PICTURE] => [~PREVIEW_PICTURE] => [DETAIL_PICTURE] => [~DETAIL_PICTURE] => [PROPERTY_DATE_FROM_VALUE] => 13.06.2023 [~PROPERTY_DATE_FROM_VALUE] => 13.06.2023 [PROPERTY_DATE_FROM_VALUE_ID] => 5481558 [~PROPERTY_DATE_FROM_VALUE_ID] => 5481558 [NAME] => MySQL: Настройка производительности [~NAME] => MySQL: Настройка производительности [SORT_HASH] => 1d3fc9b3d524ac49b4ce3debe65e5988 [LINK_ELEMENT_ID] => 62544 [PROPERTIES] => Array ( [CML2_LINK] => Array ( [ID] => 85 [IBLOCK_ID] => 24 [NAME] => Элемент каталога [ACTIVE] => Y [SORT] => 5 [CODE] => CML2_LINK [DEFAULT_VALUE] => [PROPERTY_TYPE] => E [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => CML2_LINK [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 25 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => Y [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => SKU [USER_TYPE_SETTINGS] => Array ( [VIEW] => A [SHOW_ADD] => N [MAX_WIDTH] => 0 [MIN_HEIGHT] => 24 [MAX_HEIGHT] => 1000 [BAN_SYM] => ,; [REP_SYM] => [OTHER_REP_SYM] => [IBLOCK_MESS] => N ) [HINT] => [~NAME] => Элемент каталога [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => 62544 [PROPERTY_VALUE_ID] => 5481551 [DESCRIPTION] => [~VALUE] => 62544 [~DESCRIPTION] => ) [CITY] => Array ( [ID] => 92 [IBLOCK_ID] => 24 [NAME] => Город проведения [ACTIVE] => Y [SORT] => 500 [CODE] => CITY [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => Y [FILTRABLE] => Y [IS_REQUIRED] => Y [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => [HINT] => [~NAME] => Город проведения [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => Москва [PROPERTY_VALUE_ID] => 5481560 [DESCRIPTION] => [~VALUE] => Москва [~DESCRIPTION] => ) [MAX_COUNT] => Array ( [ID] => 100 [IBLOCK_ID] => 24 [NAME] => Исходное количество мест [ACTIVE] => Y [SORT] => 500 [CODE] => MAX_COUNT [DEFAULT_VALUE] => [PROPERTY_TYPE] => N [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => [HINT] => [~NAME] => Исходное количество мест [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [DATE_FROM] => Array ( [ID] => 101 [IBLOCK_ID] => 24 [NAME] => Начало курса [ACTIVE] => Y [SORT] => 500 [CODE] => DATE_FROM [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => Y [FILTRABLE] => Y [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => DateTime [USER_TYPE_SETTINGS] => [HINT] => [~NAME] => Начало курса [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => 13.06.2023 [PROPERTY_VALUE_ID] => 5481558 [DESCRIPTION] => [~VALUE] => 13.06.2023 [~DESCRIPTION] => ) [DATE_TO] => Array ( [ID] => 102 [IBLOCK_ID] => 24 [NAME] => Окончание курса [ACTIVE] => Y [SORT] => 500 [CODE] => DATE_TO [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => Y [FILTRABLE] => Y [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => DateTime [USER_TYPE_SETTINGS] => [HINT] => [~NAME] => Окончание курса [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => 16.06.2023 [PROPERTY_VALUE_ID] => 5481559 [DESCRIPTION] => [~VALUE] => 16.06.2023 [~DESCRIPTION] => ) [FLAG_SALE] => Array ( [ID] => 141 [IBLOCK_ID] => 24 [NAME] => Скидки [ACTIVE] => Y [SORT] => 500 [CODE] => FLAG_SALE [DEFAULT_VALUE] => [PROPERTY_TYPE] => L [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => C [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => [HINT] => [~NAME] => Скидки [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => [VALUE_ENUM_ID] => ) [IN_ACTION] => Array ( [ID] => 142 [IBLOCK_ID] => 24 [NAME] => Участвует в акциях [ACTIVE] => Y [SORT] => 500 [CODE] => IN_ACTION [DEFAULT_VALUE] => [PROPERTY_TYPE] => E [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => Y [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 30 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => EList [USER_TYPE_SETTINGS] => Array ( [size] => 1 [width] => 0 [group] => N [multiple] => N ) [HINT] => [~NAME] => Участвует в акциях [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [NEW] => Array ( [ID] => 144 [IBLOCK_ID] => 24 [NAME] => Новинка [ACTIVE] => Y [SORT] => 500 [CODE] => NEW [DEFAULT_VALUE] => [PROPERTY_TYPE] => L [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => C [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => [HINT] => [~NAME] => Новинка [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => [VALUE_ENUM_ID] => ) [DURATION_HOURS] => Array ( [ID] => 174 [IBLOCK_ID] => 24 [NAME] => Длитеность, часов [ACTIVE] => Y [SORT] => 500 [CODE] => DURATION_HOURS [DEFAULT_VALUE] => [PROPERTY_TYPE] => N [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => [HINT] => [~NAME] => Длитеность, часов [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => 32 [PROPERTY_VALUE_ID] => 5481554 [DESCRIPTION] => [~VALUE] => 32 [~DESCRIPTION] => ) [DURATION_DAYS] => Array ( [ID] => 175 [IBLOCK_ID] => 24 [NAME] => Длитеность, дней [ACTIVE] => Y [SORT] => 500 [CODE] => DURATION_DAYS [DEFAULT_VALUE] => [PROPERTY_TYPE] => N [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => [HINT] => [~NAME] => Длитеность, дней [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => 4 [PROPERTY_VALUE_ID] => 5481555 [DESCRIPTION] => [~VALUE] => 4 [~DESCRIPTION] => ) [COURSE_CODE] => Array ( [ID] => 176 [IBLOCK_ID] => 24 [NAME] => Код курса [ACTIVE] => Y [SORT] => 500 [CODE] => COURSE_CODE [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => [HINT] => [~NAME] => Код курса [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => MySQLPT_au [PROPERTY_VALUE_ID] => 5481556 [DESCRIPTION] => [~VALUE] => MySQLPT_au [~DESCRIPTION] => ) [ACTION_NUMBER] => Array ( [ID] => 177 [IBLOCK_ID] => 24 [NAME] => Номер акции [ACTIVE] => Y [SORT] => 500 [CODE] => ACTION_NUMBER [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => [HINT] => [~NAME] => Номер акции [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [MARKER] => Array ( [ID] => 178 [IBLOCK_ID] => 24 [NAME] => Маркер [ACTIVE] => Y [SORT] => 500 [CODE] => MARKER [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => [HINT] => [~NAME] => Маркер [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => MySQL [PROPERTY_VALUE_ID] => 5481557 [DESCRIPTION] => [~VALUE] => MySQL [~DESCRIPTION] => ) [HINT] => Array ( [ID] => 179 [IBLOCK_ID] => 24 [NAME] => Примечание [ACTIVE] => Y [SORT] => 500 [CODE] => HINT [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => [HINT] => [~NAME] => Примечание [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [B_SPECIAL_PRICE] => Array ( [ID] => 180 [IBLOCK_ID] => 24 [NAME] => B_SPECIAL_PRICE [ACTIVE] => Y [SORT] => 500 [CODE] => B_SPECIAL_PRICE [DEFAULT_VALUE] => [PROPERTY_TYPE] => N [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => [HINT] => [~NAME] => B_SPECIAL_PRICE [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => 0 [PROPERTY_VALUE_ID] => 5481552 [DESCRIPTION] => [~VALUE] => 0 [~DESCRIPTION] => ) [NORMAL_PRICE] => Array ( [ID] => 181 [IBLOCK_ID] => 24 [NAME] => Стандартная цена для 1 чел. [ACTIVE] => Y [SORT] => 500 [CODE] => NORMAL_PRICE [DEFAULT_VALUE] => [PROPERTY_TYPE] => N [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => [HINT] => [~NAME] => Стандартная цена для 1 чел. [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => 60000 [PROPERTY_VALUE_ID] => 5481553 [DESCRIPTION] => [~VALUE] => 60000 [~DESCRIPTION] => ) [SECTION_CODE] => Array ( [ID] => 186 [IBLOCK_ID] => 24 [NAME] => Подкатегория курса 4 [ACTIVE] => Y [SORT] => 500 [CODE] => SECTION_CODE [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => [HINT] => [~NAME] => Подкатегория курса 4 [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => 30 [PROPERTY_VALUE_ID] => 5481561 [DESCRIPTION] => [~VALUE] => 30 [~DESCRIPTION] => ) [SHOW_TO_MAIN] => Array ( [ID] => 189 [IBLOCK_ID] => 24 [NAME] => Показывать на главной [ACTIVE] => Y [SORT] => 500 [CODE] => SHOW_TO_MAIN [DEFAULT_VALUE] => [PROPERTY_TYPE] => L [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => C [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => [HINT] => [~NAME] => Показывать на главной [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => [VALUE_ENUM_ID] => ) ) [DISPLAY_PROPERTIES] => Array ( [DATE_TO] => Array ( [ID] => 102 [IBLOCK_ID] => 24 [NAME] => Окончание курса [ACTIVE] => Y [SORT] => 500 [CODE] => DATE_TO [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => Y [FILTRABLE] => Y [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => DateTime [USER_TYPE_SETTINGS] => [HINT] => [~NAME] => Окончание курса [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => 16.06.2023 [PROPERTY_VALUE_ID] => 5481559 [DESCRIPTION] => [~VALUE] => 16.06.2023 [~DESCRIPTION] => [DISPLAY_VALUE] => 16.06.2023 ) ) [PRODUCT] => Array ( [TYPE] => 4 [AVAILABLE] => Y [BUNDLE] => N [QUANTITY] => 0 [QUANTITY_TRACE] => N [CAN_BUY_ZERO] => N [MEASURE] => 6 [SUBSCRIBE] => N [VAT_ID] => 0 [VAT_RATE] => 0 [VAT_INCLUDED] => N [WEIGHT] => 0 [WIDTH] => 0 [LENGTH] => 0 [HEIGHT] => 0 [PAYMENT_TYPE] => S [RECUR_SCHEME_TYPE] => D [RECUR_SCHEME_LENGTH] => 0 [TRIAL_PRICE_ID] => 0 ) [CATALOG_TYPE] => 4 [CATALOG_AVAILABLE] => Y [CATALOG_BUNDLE] => N [CATALOG_QUANTITY] => 0 [CATALOG_QUANTITY_TRACE] => N [CATALOG_CAN_BUY_ZERO] => N [CATALOG_MEASURE] => 6 [CATALOG_SUBSCRIBE] => N [CATALOG_VAT_ID] => [CATALOG_VAT_INCLUDED] => N [CATALOG_WEIGHT] => 0 [CATALOG_WIDTH] => [CATALOG_LENGTH] => [CATALOG_HEIGHT] => [CATALOG_PRICE_TYPE] => S [CATALOG_RECUR_SCHEME_LENGTH] => [CATALOG_RECUR_SCHEME_TYPE] => D [CATALOG_QUANTITY_TRACE_ORIG] => D [CATALOG_CAN_BUY_ZERO_ORIG] => D [CATALOG_SUBSCRIBE_ORIG] => D [CATALOG_PURCHASING_PRICE] => [CATALOG_PURCHASING_CURRENCY] => [CATALOG_BARCODE_MULTI] => N [CATALOG_TRIAL_PRICE_ID] => [CATALOG_WITHOUT_ORDER] => N [~CATALOG_TYPE] => 4 [~CATALOG_AVAILABLE] => Y [~CATALOG_BUNDLE] => N [~CATALOG_QUANTITY] => 0 [~CATALOG_QUANTITY_TRACE] => N [~CATALOG_CAN_BUY_ZERO] => N [~CATALOG_MEASURE] => 6 [~CATALOG_SUBSCRIBE] => N [~CATALOG_VAT_ID] => [~CATALOG_VAT_INCLUDED] => N [~CATALOG_WEIGHT] => 0 [~CATALOG_WIDTH] => [~CATALOG_LENGTH] => [~CATALOG_HEIGHT] => [~CATALOG_PRICE_TYPE] => S [~CATALOG_RECUR_SCHEME_LENGTH] => [~CATALOG_RECUR_SCHEME_TYPE] => D [~CATALOG_QUANTITY_TRACE_ORIG] => D [~CATALOG_CAN_BUY_ZERO_ORIG] => D [~CATALOG_SUBSCRIBE_ORIG] => D [~CATALOG_PURCHASING_PRICE] => [~CATALOG_PURCHASING_CURRENCY] => [~CATALOG_BARCODE_MULTI] => N [~CATALOG_TRIAL_PRICE_ID] => [~CATALOG_WITHOUT_ORDER] => N [~CATALOG_VAT] => 0 [CATALOG_VAT] => 0 [ITEM_PRICE_MODE] => S [ITEM_PRICES] => Array ( [0] => Array ( [UNROUND_BASE_PRICE] => 60000 [UNROUND_PRICE] => 60000 [BASE_PRICE] => 60000 [PRICE] => 60000 [ID] => 64972 [PRICE_TYPE_ID] => 1 [CURRENCY] => RUB [DISCOUNT] => 0 [PERCENT] => 0 [VAT] => 0 [QUANTITY_FROM] => [QUANTITY_TO] => [QUANTITY_HASH] => ZERO-INF [MEASURE_RATIO_ID] => [PRINT_BASE_PRICE] => 60 000 руб. [RATIO_BASE_PRICE] => 60000 [PRINT_RATIO_BASE_PRICE] => 60 000 руб. [PRINT_PRICE] => 60 000 руб. [RATIO_PRICE] => 60000 [PRINT_RATIO_PRICE] => 60 000 руб. [PRINT_DISCOUNT] => 0 руб. [RATIO_DISCOUNT] => 0 [PRINT_RATIO_DISCOUNT] => 0 руб. [PRINT_VAT] => 0 руб. [RATIO_VAT] => 0 [PRINT_RATIO_VAT] => 0 руб. [MIN_QUANTITY] => 1 ) ) [ITEM_QUANTITY_RANGES] => Array ( [ZERO-INF] => Array ( [HASH] => ZERO-INF [QUANTITY_FROM] => [QUANTITY_TO] => [SORT_FROM] => 0 [SORT_TO] => INF ) ) [ITEM_MEASURE_RATIOS] => Array ( [4257] => Array ( [ID] => 4257 [RATIO] => 1 [IS_DEFAULT] => Y [PRODUCT_ID] => 62623 ) ) [ITEM_MEASURE] => Array ( [ID] => 6 [TITLE] => место [~TITLE] => место ) [ITEM_MEASURE_RATIO_SELECTED] => 4257 [ITEM_QUANTITY_RANGE_SELECTED] => ZERO-INF [ITEM_PRICE_SELECTED] => 0 [CHECK_QUANTITY] => [CATALOG_MEASURE_NAME] => место [~CATALOG_MEASURE_NAME] => место [CAN_BUY] => 1 [ITEM_PRICES_CAN_BUY] => 1 [~BUY_URL] => /courses/MySQLPT_au/?action=BUY&id=62623 [BUY_URL] => /courses/MySQLPT_au/?action=BUY&id=62623 [~ADD_URL] => /courses/MySQLPT_au/?action=ADD2BASKET&id=62623 [ADD_URL] => /courses/MySQLPT_au/?action=ADD2BASKET&id=62623 [~SUBSCRIBE_URL] => /courses/MySQLPT_au/?action=SUBSCRIBE_PRODUCT&id=62623 [SUBSCRIBE_URL] => /courses/MySQLPT_au/?action=SUBSCRIBE_PRODUCT&id=62623 [~COMPARE_URL] => /courses/MySQLPT_au/?action=ADD_TO_COMPARE_LIST&id=62623 [COMPARE_URL] => /courses/MySQLPT_au/?action=ADD_TO_COMPARE_LIST&id=62623 [~COMPARE_DELETE_URL] => /courses/MySQLPT_au/?action=DELETE_FROM_COMPARE_LIST&id=62623 [COMPARE_DELETE_URL] => /courses/MySQLPT_au/?action=DELETE_FROM_COMPARE_LIST&id=62623 [CATALOG_MEASURE_RATIO] => 1 [OFFER_GROUP] => [RATIO_PRICE] => Array ( [VALUE] => 60000 [DISCOUNT_VALUE] => 60000 [PRINT_VALUE] => 60 000 руб. [PRINT_DISCOUNT_VALUE] => 60 000 руб. [DISCOUNT_DIFF] => 0 [PRINT_DISCOUNT_DIFF] => 0 руб. [DISCOUNT_DIFF_PERCENT] => 0 [CURRENCY] => RUB ) [MORE_PHOTO] => Array ( [0] => Array ( [SRC] => /bitrix/templates/.default/components/bitrix/catalog.element/course/images/no_photo.png [WIDTH] => 150 [HEIGHT] => 150 ) ) [MORE_PHOTO_COUNT] => 1 ) )
- 27.03.2023 Москва записаться
- 13.06.2023 Москва записаться
MySQL-самая популярная в мире база данных с открытым исходным кодом и лидирующая база данных для веб-приложений. Большинство крупнейших веб-сайтов полагаются на MySQL, чтобы справляться с огромным количеством транзакций одновременно, сохраняя при этом целостность своих данных. Поскольку пользователи продолжают требовать от веб-приложений повышения производительности и расширения функциональных возможностей, вам необходимо убедиться, что ваша база данных может идти в ногу со временем. Курс настройки производительности MySQL 8.0 научит вас использовать широкий спектр параметров конфигурации, инструментов мониторинга и методов, используемых специалистами по базам данных MySQL, чтобы ваши приложения были быстрыми, эффективными и безопасными.
После прохождения этого курса вы сможете понять как делать настройку производительности; тестировать и настраивать свой сервер; исследовать показатели производительности с помощью ряда системных метрик базы, командной строки и графических инструментов; разработать схему для оптимальной производительности; выявлять и оптимизировать медленные запросы и устранять распространенные проблемы с производительностью.
Будут изучаться:
Все материалы по курсу предоставляются на английском языке.
По окончании выдается сертификат Учебного центра РДТЕХ.
1. Введение
Слайды: как осуществлять поиск информации о курсах MySQL и вариантах сертификации.
2. Концепции настройки производительности
Устранение неполадок производительности.
3. Инструменты настройки производительности
Инструменты мониторинга сообщества. Демонстрация.
4. Схема настройки производительности
Конфигурация. Запрос данных о событиях.
5. Общая настройка сервера.
Отображение использования памяти MySQL.
6. Настройка таблиц, файлов и журналов
7. Настройка InnoDB.
Измерение производительности InnoDB.
8. Оптимизация Схемы
Сжатие таблиц InnoDB.
9. Мониторинг запросов.
Переменные состояния операторов SQL.
10. Оптимизация запросов
Трассировка оптимизатора.
11. Оптимизация операций блокировки
12. Настройка репликации
13. Заключение