Project

General

Profile

Actions

Bug #7448

open

host deletion generates inefficient sql queries

Added by Ohad Levy over 9 years ago. Updated over 9 years ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
Performance
Target version:
-
Difficulty:
Triaged:
Fixed in Releases:
Found in Releases:

Description

for example, deleting facts:

  (0.1ms)  BEGIN
  Model Load (5.9ms)  SELECT `models`.* FROM `models` WHERE `models`.`id` = 2 ORDER BY models.name LIMIT 1
  SQL (15.0ms)  UPDATE `models` SET `hosts_count` = COALESCE(`hosts_count`, 0) - 1 WHERE `models`.`id` = 2 ORDER BY models.name
  FactValue Load (11.7ms)  SELECT `fact_values`.* FROM `fact_values` WHERE `fact_values`.`host_id` = 2009
  SQL (29.6ms)  DELETE FROM `fact_values` WHERE `fact_values`.`id` = 42995779
  SQL (3.9ms)  DELETE FROM `fact_values` WHERE `fact_values`.`id` = 42995780
  SQL (0.2ms)  DELETE FROM `fact_values` WHERE `fact_values`.`id` = 42995781
  SQL (0.2ms)  DELETE FROM `fact_values` WHERE `fact_values`.`id` = 42995782
  SQL (0.2ms)  DELETE FROM `fact_values` WHERE `fact_values`.`id` = 42995783
  SQL (0.3ms)  DELETE FROM `fact_values` WHERE `fact_values`.`id` = 42995784
  SQL (0.2ms)  DELETE FROM `fact_values` WHERE `fact_values`.`id` = 42995785
  SQL (0.2ms)  DELETE FROM `fact_values` WHERE `fact_values`.`id` = 42995786
  SQL (0.2ms)  DELETE FROM `fact_values` WHERE `fact_values`.`id` = 42995787
  SQL (0.2ms)  DELETE FROM `fact_values` WHERE `fact_values`.`id` = 42995788
  SQL (0.2ms)  DELETE FROM `fact_values` WHERE `fact_values`.`id` = 42995789
  SQL (0.2ms)  DELETE FROM `fact_values` WHERE `fact_values`.`id` = 42995790
  SQL (0.2ms)  DELETE FROM `fact_values` WHERE `fact_values`.`id` = 42995791
  SQL (0.1ms)  DELETE FROM `fact_values` WHERE `fact_values`.`id` = 42995792
  SQL (0.1ms)  DELETE FROM `fact_values` WHERE `fact_values`.`id` = 42995793
  SQL (0.1ms)  DELETE FROM `fact_values` WHERE `fact_values`.`id` = 42995794
  SQL (0.1ms)  DELETE FROM `fact_values` WHERE `fact_values`.`id` = 42995795
  SQL (0.1ms)  DELETE FROM `fact_values` WHERE `fact_values`.`id` = 42995796
  SQL (0.1ms)  DELETE FROM `fact_values` WHERE `fact_values`.`id` = 42995797
  SQL (0.1ms)  DELETE FROM `fact_values` WHERE `fact_. ...

Actions #1

Updated by Dominic Cleal over 9 years ago

  • Category set to Performance
Actions

Also available in: Atom PDF