(An Untitled Masterwork)
ActivePublic
Actions

Authored by jcrespo on May 5 2017, 2:44 PM.

Tags

None

Referenced Files

	F7937458:
	May 5 2017, 2:44 PM

Subscribers

None

	root@db1016.eqiad.wmnet[puppet]> EXPLAIN SELECT * FROM fact_values WHERE fact_name_id=1 AND host_id=1\G
	************************* 1. row *************************
	id: 1
	select_type: SIMPLE
	table: fact_values
	type: ref
	possible_keys: index_fact_values_on_fact_name_id,index_fact_values_on_host_id
	key: index_fact_values_on_host_id
	key_len: 4
	ref: const
	rows: 1
	Extra: Using where
	1 row in set (0.00 sec)

Event Timeline

jcrespo created this paste.May 5 2017, 2:44 PM

root@db1016.eqiad.wmnet[puppet]> EXPLAIN SELECT * FROM fact_values_fixed WHERE fact_name_id=1 AND host_id=1\G
*************************** 1. row ***************************
           id: 1
  select_type: SIMPLE
        table: fact_values_fixed
         type: ref
possible_keys: index_fact_values_on_fact_name_id,index_fact_values_on_host_id
          key: index_fact_values_on_host_id
      key_len: 8
          ref: const,const
         rows: 1
        Extra: 
1 row in set (0.00 sec)

(An Untitled Masterwork)ActivePublicActions

Event Timeline

(An Untitled Masterwork)
ActivePublic
Actions