Ticket 8087 - Info on Slurm acct'g database
Summary: Info on Slurm acct'g database
Status: RESOLVED INFOGIVEN
Alias: None
Product: Slurm
Classification: Unclassified
Component: Database (show other tickets)
Version: - Unsupported Older Versions
Hardware: Linux Linux
: 4 - Minor Issue
Assignee: Director of Support
QA Contact:
URL:
Depends on:
Blocks:
 
Reported: 2019-11-11 12:02 MST by Will Dennis
Modified: 2019-11-13 09:34 MST (History)
0 users

See Also:
Site: NEC Labs
Slinky Site: ---
Alineos Sites: ---
Atos/Eviden Sites: ---
Confidential Site: ---
Coreweave sites: ---
Cray Sites: ---
DS9 clusters: ---
Google sites: ---
HPCnow Sites: ---
HPE Sites: ---
IBM Sites: ---
NOAA SIte: ---
NoveTech Sites: ---
Nvidia HWinf-CS Sites: ---
OCF Sites: ---
Recursion Pharma Sites: ---
SFW Sites: ---
SNIC sites: ---
Tzag Elita Sites: ---
Linux Distro: Ubuntu
Machine Name:
CLE Version:
Version Fixed:
Target Release: ---
DevPrio: ---
Emory-Cloud Sites: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this ticket.
Description Will Dennis 2019-11-11 12:02:28 MST 
I am looking to get a couple of answers on the schema of the Slurm accounting database answered; I have searched the Slurm documentation for a database schema diagram to no avail, and also found nothing in Bugzilla. I am wanting to put together a report off the accounting db, and would find a table relationship diagram helpful, and also need to understand the format of date columns in the database (I see it's an unsigned 10-char INT field, but how to convert that to an external date format?) Thanks.
Comment 1 Will Dennis 2019-11-11 12:04:32 MST 
SLURM_VERSION = 16.05.4
Comment 2 Douglas Wightman 2019-11-11 14:47:41 MST 
Unfortunately there are no diagrams of the database available to download, though they can be generated using tools like mysql workbench:

https://database.guide/how-to-reverse-engineer-a-database-in-mysql-workbench/

Slurm stores dates in unix time format:

https://en.wikipedia.org/wiki/Unix_time
Comment 3 Douglas Wightman 2019-11-13 09:34:18 MST 
Information provided. Closing ticket.