Запустил оптимизацию таблиц из админки Битрикса Сайт не доступен. Загрузка процессора 90-100%
Чего не хватает для работоспособности сайта? Ведь оптимизация таблиц не должна блокировать работу сайта перезапуск mysql ни чего не дает https://yadi.sk/i/mRS42afPRDUdZA Как отключить этот процесс оптимизации?
| Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined | +----+-------------+-----------+-----------+---------+------+--------------+------------------------------------------------------------------------------------------------------+-----------+---------------+ | 3 | xqg7ssauser | localhost | xqg7ssadb | Query | 1 | Sending data | SELECT BE.ID as ID,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,UNIX_TIMESTAMP(B | 0 | 881 | | 7 | xqg7ssauser | localhost | xqg7ssadb | Query | 0 | Sending data | SELECT BE.ID as ID,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,UNIX_TIMESTAMP(B | 0 | 863 | | 8 | xqg7ssauser | localhost | xqg7ssadb | Query | 1 | Sending data | SELECT BE.ID as ID,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,UNIX_TIMESTAMP(B | 0 | 855 | | 17 | xqg7ssauser | localhost | xqg7ssadb | Query | 1 | Sending data | SELECT BE.ID as ID,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,UNIX_TIMESTAMP(B | 1 | 851 | | 22 | xqg7ssauser | localhost | xqg7ssadb | Query | 1 | Sending data | SELECT BE.ID as ID,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,UNIX_TIMESTAMP(B | 0 | 879 | | 23 | xqg7ssauser | localhost | xqg7ssadb | Query | 1 | Sending data | SELECT BE.ID as ID,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,UNIX_TIMESTAMP(B | 0 | 879 | | 24 | xqg7ssauser | localhost | xqg7ssadb | Query | 1 | Sending data | SELECT BE.ID as ID,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,UNIX_TIMESTAMP(B | 0 | 851 | | 28 | xqg7ssauser | localhost | xqg7ssadb | Query | 1 | Sending data | SELECT BE.ID as ID,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,UNIX_TIMESTAMP(B | 2 | 853 | | 29 | xqg7ssauser | localhost | xqg7ssadb | Query | 0 | Sending data | SELECT BE.ID as ID,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,UNIX_TIMESTAMP(B | 0 | 853 | | 32 | xqg7ssauser | localhost | xqg7ssadb | Query | 1 | Sending data | SELECT BE.ID as ID,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,UNIX_TIMESTAMP(B | 6 | 861 | | 35 | xqg7ssauser | localhost | xqg7ssadb | Query | 1 | Sending data | SELECT BE.ID as ID,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,UNIX_TIMESTAMP(B | 0 | 851 | | 36 | xqg7ssauser | localhost | xqg7ssadb | Query | 1 | Sending data | SELECT BE.ID as ID,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,UNIX_TIMESTAMP(B | 0 | 861 | | 37 | xqg7ssauser | localhost | xqg7ssadb | Query | 1 | Sending data | SELECT BE.ID as ID,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,UNIX_TIMESTAMP(B | 0 | 853 | | 40 | xqg7ssauser | localhost | xqg7ssadb | Query | 1 | Sending data | SELECT BE.ID as ID,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,UNIX_TIMESTAMP(B | 0 | 851 | | 43 | xqg7ssauser | localhost | xqg7ssadb | Query | 1 | Sending data | SELECT BE.ID as ID,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,UNIX_TIMESTAMP(B | 0 | 851 | | 44 | xqg7ssauser | localhost | xqg7ssadb | Query | 1 | Sending data | SELECT BE.ID as ID,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,UNIX_TIMESTAMP(B | 0 | 851 | | 45 | xqg7ssauser | localhost | xqg7ssadb | Query | 0 | Sending data | SELECT BE.ID as ID,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,UNIX_TIMESTAMP(B | 0 | 851 | | 46 | xqg7ssauser | localhost | xqg7ssadb | Query | 1 | Sending data | SELECT BE.ID as ID,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,UNIX_TIMESTAMP(B | 0 | 851 | | 47 | xqg7ssauser | localhost | xqg7ssadb | Query | 1 | Sending data | SELECT BE.ID as ID,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,UNIX_TIMESTAMP(B | 40 | 929 | | 48 | xqg7ssauser | localhost | xqg7ssadb | Query | 1 | Sending data | SELECT BE.ID as ID,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,UNIX_TIMESTAMP(B | 0 | 853 | | 53 | xqg7ssauser | localhost | xqg7ssadb | Query | 1 | Sending data | SELECT BE.ID as ID,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,UNIX_TIMESTAMP(B | 0 | 859 | | 55 | xqg7ssauser | localhost | xqg7ssadb | Query | 1 | Sending data | SELECT BE.ID as ID,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,UNIX_TIMESTAMP(B | 0 | 853 | | 56 | xqg7ssauser | localhost | xqg7ssadb | Query | 1 | Sending data | SELECT BE.ID as ID,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,UNIX_TIMESTAMP(B | 3 | 855 | | 57 | xqg7ssauser | localhost | xqg7ssadb | Query | 1 | Sending data | SELECT BE.ID as ID,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,UNIX_TIMESTAMP(B | 0 | 855 | | 58 | xqg7ssauser | localhost | xqg7ssadb | Query | 1 | Sending data | SELECT BE.ID as ID,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,UNIX_TIMESTAMP(B | 1 | 851 | | 59 | xqg7ssauser | localhost | xqg7ssadb | Query | 1 | Sending data | SELECT BE.ID as ID,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,UNIX_TIMESTAMP(B | 0 | 851 | | 61 | xqg7ssauser | localhost | xqg7ssadb | Query | 0 | Sending data | SELECT BE.ID as ID,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,UNIX_TIMESTAMP(B | 0 | 853 | | 63 | xqg7ssauser | localhost | xqg7ssadb | Query | 1 | Sending data | SELECT BE.ID as ID,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,UNIX_TIMESTAMP(B | 13 | 875 | | 65 | xqg7ssauser | localhost | xqg7ssadb | Query | 0 | Sending data | SELECT BE.ID as ID,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,UNIX_TIMESTAMP(B | 0 | 851 | | 68 | xqg7ssauser | localhost | xqg7ssadb | Query | 1 | query end | SELECT BE.ID as ID,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,UNIX_TIMESTAMP(B | 6 | 64288 | | 69 | root | localhost | NULL | Query | 0 | starting | SHOW PROCESSLIST | 0 | 0 | +----+-------------+-----------+-----------+---------+------+--------------+------------------------------------------------------------------------------------------------------+-----------+---------------+ 31 rows in set (0.00 sec)
В списке запросов только тяжелые выборки. Попробуйте локализовать место откуда они вызываются и поправить вызов АПИ что бы запрос не был таким тяжелым.