Skip to content
Navigation Menu
Toggle navigation
Sign in
In this repository
All GitHub Enterprise
↵
Jump to
↵
No suggested jump to results
In this repository
All GitHub Enterprise
↵
Jump to
↵
In this user
All GitHub Enterprise
↵
Jump to
↵
In this repository
All GitHub Enterprise
↵
Jump to
↵
Sign in
Reseting focus
You signed in with another tab or window.
Reload
to refresh your session.
You signed out in another tab or window.
Reload
to refresh your session.
You switched accounts on another tab or window.
Reload
to refresh your session.
Dismiss alert
{{ message }}
mariux
/
mxq
Public
forked from
mariux64/mxq
Notifications
You must be signed in to change notification settings
Fork
0
Star
0
Code
Pull requests
0
Actions
Projects
0
Security
Insights
Issues
Additional navigation options
Code
Pull requests
Actions
Projects
Security
Insights
Issues
Files
cce9159
manpages
mysql
alter_tables_0.13.0.sql
alter_tables_0.15.0.sql
create_tables.sql
create_trigger.sql
drop_tables.sql
fix_cancelled_job_dates.sql
fix_host_id.sql
fix_stats_runwaitidle_sec.sql
web
.gitignore
LICENSE
Makefile
README.md
mx_flock.c
mx_flock.h
mx_getopt.c
mx_getopt.h
mx_log.c
mx_log.h
mx_mysql.c
mx_mysql.h
mx_util.c
mx_util.h
mxq.h
mxq_group.c
mxq_group.h
mxq_job.c
mxq_job.h
mxq_log.c
mxqadmin.c
mxqd.c
mxqd.h
mxqdctl-hostconfig.sh
mxqdump.c
mxqkill.c
mxqsub.c
os-release
test.c
test_mx_log.c
test_mx_mysql.c
test_mx_util.c
Breadcrumbs
mxq
/
mysql
/
create_tables.sql
Blame
Blame
Latest commit
History
History
140 lines (105 loc) · 5.19 KB
Breadcrumbs
mxq
/
mysql
/
create_tables.sql
Top
File metadata and controls
Code
Blame
140 lines (105 loc) · 5.19 KB
Raw
CREATE TABLE IF NOT EXISTS mxq_group ( group_id INT8 UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, group_name VARCHAR(511) NOT NULL DEFAULT 'default', group_status INT1 UNSIGNED NOT NULL DEFAULT 0, group_flags INT8 UNSIGNED NOT NULL DEFAULT 0, group_priority INT2 UNSIGNED NOT NULL DEFAULT 127, user_uid INT4 UNSIGNED NOT NULL, user_name VARCHAR(255) NOT NULL, user_gid INT4 UNSIGNED NOT NULL, user_group VARCHAR(255) NOT NULL, job_command VARCHAR(4095) NOT NULL, job_threads INT2 UNSIGNED NOT NULL DEFAULT 1, job_memory INT8 UNSIGNED NOT NULL DEFAULT 1024, job_time INT4 UNSIGNED NOT NULL DEFAULT 15, job_max_per_node INT2 UNSIGNED NOT NULL DEFAULT 0, group_jobs INT8 UNSIGNED NOT NULL DEFAULT 0, group_jobs_inq INT8 UNSIGNED NOT NULL DEFAULT 0, group_jobs_running INT8 UNSIGNED NOT NULL DEFAULT 0, group_jobs_finished INT8 UNSIGNED NOT NULL DEFAULT 0, group_jobs_failed INT8 UNSIGNED NOT NULL DEFAULT 0, group_jobs_cancelled INT8 UNSIGNED NOT NULL DEFAULT 0, group_jobs_unknown INT8 UNSIGNED NOT NULL DEFAULT 0, group_jobs_restarted INT8 UNSIGNED NOT NULL DEFAULT 0, group_slots_running INT8 UNSIGNED NOT NULL DEFAULT 0, group_mtime TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, group_date_end TIMESTAMP NOT NULL DEFAULT 0, stats_max_maxrss INT8 UNSIGNED NOT NULL DEFAULT 0, stats_max_utime_sec INT8 UNSIGNED NOT NULL DEFAULT 0, stats_max_stime_sec INT8 UNSIGNED NOT NULL DEFAULT 0, stats_max_real_sec INT8 UNSIGNED NOT NULL DEFAULT 0, stats_total_utime_sec INT8 UNSIGNED NOT NULL DEFAULT 0, stats_total_stime_sec INT8 UNSIGNED NOT NULL DEFAULT 0, stats_total_real_sec INT8 UNSIGNED NOT NULL DEFAULT 0, stats_total_wait_sec INT8 UNSIGNED NOT NULL DEFAULT 0, stats_wait_sec INT8 UNSIGNED NOT NULL DEFAULT 0, stats_run_sec INT8 UNSIGNED NOT NULL DEFAULT 0, stats_idle_sec INT8 UNSIGNED NOT NULL DEFAULT 0, stats_total_utime_sec_finished INT8 UNSIGNED NOT NULL DEFAULT 0, stats_total_stime_sec_finished INT8 UNSIGNED NOT NULL DEFAULT 0, stats_total_real_sec_finished INT8 UNSIGNED NOT NULL DEFAULT 0, stats_total_wait_sec_finished INT8 UNSIGNED NOT NULL DEFAULT 0, depends_on_group INT8 UNSIGNED NULL DEFAULT NULL, dependency_of_group INT8 UNSIGNED NULL DEFAULT NULL, INDEX(group_id), INDEX(group_name) ); CREATE TABLE IF NOT EXISTS mxq_job ( job_id INT8 UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, job_status INT2 UNSIGNED NOT NULL DEFAULT 0, job_flags INT8 UNSIGNED NOT NULL DEFAULT 0, job_priority INT2 UNSIGNED NOT NULL DEFAULT 127, group_id INT8 UNSIGNED NOT NULL, job_workdir VARCHAR(4095) NOT NULL, job_argc INT2 UNSIGNED NOT NULL, job_argv VARCHAR(40959) NOT NULL, job_stdout VARCHAR(4095) NOT NULL DEFAULT '/dev/null', job_stderr VARCHAR(4095) NOT NULL DEFAULT '/dev/null', job_umask INT4 NOT NULL, host_submit VARCHAR(64) NOT NULL DEFAULT "localhost", server_id VARCHAR(1023) NOT NULL DEFAULT "", host_id VARCHAR(1023) NOT NULL DEFAULT "", host_hostname VARCHAR(64) NOT NULL DEFAULT "", host_pid INT4 UNSIGNED NOT NULL DEFAULT 0, host_slots INT4 UNSIGNED NOT NULL DEFAULT 0, date_submit TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, date_start TIMESTAMP NOT NULL DEFAULT 0, date_end TIMESTAMP NOT NULL DEFAULT 0, job_id_new INT8 UNSIGNED NULL DEFAULT NULL, job_id_old INT8 UNSIGNED NULL DEFAULT NULL, job_id_first INT8 UNSIGNED NULL DEFAULT NULL, stats_status INT4 UNSIGNED NOT NULL DEFAULT 0, stats_utime_sec INT8 UNSIGNED NOT NULL DEFAULT 0, stats_utime_usec INT4 UNSIGNED NOT NULL DEFAULT 0, stats_stime_sec INT8 UNSIGNED NOT NULL DEFAULT 0, stats_stime_usec INT4 UNSIGNED NOT NULL DEFAULT 0, stats_real_sec INT8 UNSIGNED NOT NULL DEFAULT 0, stats_real_usec INT4 UNSIGNED NOT NULL DEFAULT 0, stats_maxrss INT8 NOT NULL DEFAULT 0, stats_minflt INT8 NOT NULL DEFAULT 0, stats_majflt INT8 NOT NULL DEFAULT 0, stats_nswap INT8 NOT NULL DEFAULT 0, stats_inblock INT8 NOT NULL DEFAULT 0, stats_oublock INT8 NOT NULL DEFAULT 0, stats_nvcsw INT8 NOT NULL DEFAULT 0, stats_nivcsw INT8 NOT NULL DEFAULT 0, INDEX (job_id), INDEX (group_id), INDEX (job_status), INDEX (job_priority), INDEX (host_hostname(64)), INDEX (server_id(767)) ); CREATE TABLE IF NOT EXISTS mxq_server ( host_id INT4 UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, host_hostname VARCHAR(511) NOT NULL DEFAULT 'localhost', server_id VARCHAR(511) NOT NULL DEFAULT 'default', host_slots INT2 UNSIGNED NOT NULL DEFAULT 1, host_memory INT8 UNSIGNED NOT NULL DEFAULT 1024, host_time INT4 UNSIGNED NOT NULL DEFAULT 15, host_jobs_running INT2 UNSIGNED NOT NULL DEFAULT 0, host_slots_running INT2 UNSIGNED NOT NULL DEFAULT 0, host_mtime TIMESTAMP DEFAULT CURRENT_TIMESTAMP, server_start TIMESTAMP DEFAULT 0, server_stop TIMESTAMP DEFAULT 0 );
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
You can’t perform that action at this time.