Bug #5307

Add indexes to DB to speed up HA recovery

Added by Jaime Melis almost 4 years ago. Updated almost 4 years ago.

Status:ClosedStart date:08/07/2017
Priority:NormalDue date:
Assignee:Javi Fontan% Done:

0%

Category:Core & System
Target version:Release 5.4.1
Resolution:fixed Pull request:
Affected Versions:OpenNebula 5.4

Description

create index timestamp_idx on logdb (timestamp);
create index fed_index_idx on logdb (fed_index);

Must be added to the migrator and to the core bootstrap.

Associated revisions

Revision 55d82ac2
Added by Ruben S. Montero almost 4 years ago

B #5307: Build index for logdb table

Revision 9158a2b9
Added by Ruben S. Montero almost 4 years ago

B #5307: Build index for logdb table

(cherry picked from commit 55d82ac237dd2bd0e5a811a902d8131f34a37884)

History

#1 Updated by Jaime Melis almost 4 years ago

  • Tracker changed from Feature to Bug
  • Affected Versions OpenNebula 5.4 added

#2 Updated by Tino Vázquez almost 4 years ago

Include this in 5.4.1 migrator

#3 Updated by Ruben S. Montero almost 4 years ago

  • Assignee changed from Jaime Melis to Javi Fontan

#4 Updated by Ruben S. Montero almost 4 years ago

  • Status changed from Pending to Closed
  • Resolution set to fixed

Also available in: Atom PDF