Skip to content
GitLab
Projects Groups Topics Snippets
  • /
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
  • Register
  • Sign in
  • EAR EAR
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributor statistics
    • Graph
    • Compare revisions
  • Issues 0
    • Issues 0
    • List
    • Boards
    • Service Desk
    • Milestones
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Deployments
    • Deployments
    • Releases
  • Wiki
    • Wiki
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar
  • EAR_teamEAR_team
  • EAREAR
  • Wiki
  • EAR Database

EAR Database · Changes

Page history
Update EAR Database authored Sep 10, 2021 by Lluis Alonso's avatar Lluis Alonso
Show whitespace changes
Inline Side-by-side
EAR-Database.md
View page @ 05c4bf1c
...@@ -49,13 +49,13 @@ If *Signatures* and/or *Periodic_metrics* have additional columns but their resp ...@@ -49,13 +49,13 @@ If *Signatures* and/or *Periodic_metrics* have additional columns but their resp
Several fields have to be added in this update. To do so, run the following commands to the database's CLI client: Several fields have to be added in this update. To do so, run the following commands to the database's CLI client:
``` ```
ALTER TABLE Signatures ADD COLUMN avg_imc_f BIGINT unsigned AFTER avg_f; ALTER TABLE Signatures ADD COLUMN avg_imc_f INT unsigned AFTER avg_f;
ALTER TABLE Signatures ADD COLUMN perc_MPI DOUBLE AFTER time; ALTER TABLE Signatures ADD COLUMN perc_MPI FLOAT AFTER time;
ALTER TABLE Signatures ADD COLUMN IO_MBS DOUBLE AFTER GBS; ALTER TABLE Signatures ADD COLUMN IO_MBS FLOAT AFTER GBS;
ALTER TABLE Learning_signatures ADD COLUMN avg_imc_f BIGINT unsigned AFTER avg_f; ALTER TABLE Learning_signatures ADD COLUMN avg_imc_f INT unsigned AFTER avg_f;
ALTER TABLE Learning_signatures ADD COLUMN perc_MPI DOUBLE AFTER time; ALTER TABLE Learning_signatures ADD COLUMN perc_MPI FLOAT AFTER time;
ALTER TABLE Learning_signatures ADD COLUMN IO_MBS DOUBLE AFTER GBS; ALTER TABLE Learning_signatures ADD COLUMN IO_MBS FLOAT AFTER GBS;
``` ```
......
Clone repository
  • Home
  • Running jobs with EAR
  • Using the EAR api
  • Policies
  • Commands
  • Admin Guide
    • Quick installation guide
    • Installation from source
    • Installation from RPM
    • Configuration
    • Starting services
    • Tools
    • Learning phase
    • Plugins
  • Architecture
    • EARD
    • EARDBD
    • EARGM
    • EARL
    • EARLO
    • SLURM Plugin
  • Database summary
  • Systems supported
  • CHANGELOG
  • FAQs