LINUX.ORG.RU

Thin + Rufus-scheduler.


0

1
(22359.2ms)  SELECT COUNT(*) FROM `domains` WHERE `domains`.`name` = 'linux.ru'
  Domain Load (4106.7ms)  SELECT `domains`.* FROM `domains` WHERE `domains`.`name` = 'linux.ru' LIMIT 1
  Site Load (9617.9ms)  SELECT `sites`.* FROM `sites` WHERE `sites`.`domain_id` = 2 LIMIT 1
   (623.9ms)  BEGIN
  Position Load (15131.9ms)  SELECT `positions`.* FROM `positions` WHERE `positions`.`domain_id` = 2 AND `positions`.`word_id` = 1 AND (`positions`.`time` BETWEEN '2012-02-18 00:00:00' AND '2012-02-18 23:59:59')
  SQL (9253.9ms)  DELETE FROM `positions` WHERE `positions`.`id` = 3951
  SQL (1558.3ms)  INSERT INTO `positions` (`active`, `domain_id`, `position`, `time`, `word_id`) VALUES (0, 2, 1, '2012-02-18 04:47:35', 1)
   (779.3ms)  COMMIT
   (1974.2ms)  SELECT COUNT(*) FROM `domains` WHERE `domains`.`name` = 'ru.wikipedia.org'
  Domain Load (5407.4ms)  SELECT `domains`.* FROM `domains` WHERE `domains`.`name` = 'ru.wikipedia.org' LIMIT 1
  Site Load (10709.5ms)  SELECT `sites`.* FROM `sites` WHERE `sites`.`domain_id` = 4 LIMIT 1
   (1559.7ms)  BEGIN
  Position Load (47473.7ms)  SELECT `positions`.* FROM `positions` WHERE `positions`.`domain_id` = 4 AND `positions`.`word_id` = 1 AND (`positions`.`time` BETWEEN '2012-02-18 00:00:00' AND '2012-02-18 23:59:59')
  SQL (23606.8ms)  DELETE FROM `positions` WHERE `positions`.`id` = 3952
  SQL (2443.1ms)  INSERT INTO `positions` (`active`, `domain_id`, `position`, `time`, `word_id`) VALUES (0, 4, 2, '2012-02-18 04:49:17', 1)
   (7388.3ms)  COMMIT
   (0.5ms)  SELECT COUNT(*) FROM `domains` WHERE `domains`.`name` = 'linux.org.ru'
  Domain Load (0.2ms)  SELECT `domains`.* FROM `domains` WHERE `domains`.`name` = 'linux.org.ru' LIMIT 1
  Site Load (0.2ms)  SELECT `sites`.* FROM `sites` WHERE `sites`.`domain_id` = 5 LIMIT 1
   (0.2ms)  BEGIN
  Position Load (0.7ms)  SELECT `positions`.* FROM `positions` WHERE `positions`.`domain_id` = 5 AND `positions`.`word_id` = 1 AND (`positions`.`time` BETWEEN '2012-02-18 00:00:00' AND '2012-02-18 23:59:59')
  SQL (0.4ms)  DELETE FROM `positions` WHERE `positions`.`id` = 3953
  SQL (0.2ms)  INSERT INTO `positions` (`active`, `domain_id`, `position`, `time`, `word_id`) VALUES (0, 5, 3, '2012-02-18 04:50:50', 1)
   (41.3ms)  COMMIT

Обратите внимание на время выполнения запросов. Такое происходит только с Thin.


Ответ на: комментарий от tensai_cirno

Не помню. Хорошо, похоже что.

daris
() автор топика
Вы не можете добавлять комментарии в эту тему. Тема перемещена в архив.