Запустил оптимизацию таблиц из админки Битрикса
Сайт не доступен.
Загрузка процессора 90-100%
Чего не хватает для работоспособности сайта?
Ведь оптимизация таблиц не должна блокировать работу сайта
перезапуск mysql ни чего не дает
[URL=https://yadi.sk/i/mRS42afPRDUdZA]https://yadi.sk/i/mRS42afPRDUdZA[/URL]
Как отключить этот процесс оптимизации?
| 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)