admin.py
kill(restriction=None, connection=None, order_by=None)
¶
view and kill database connections.
:param restriction: restriction to be applied to processlist :param connection: a datajoint.Connection object. Default calls datajoint.conn() :param order_by: order by a single attribute or the list of attributes. defaults to 'id'.
Restrictions are specified as strings and can involve any of the attributes of information_schema.processlist: ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO.
Examples:
dj.kill('HOST LIKE "%compute%"') lists only connections from hosts containing "compute". dj.kill('TIME > 600') lists only connections in their current state for more than 10 minutes
Source code in datajoint/admin.py
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 |
|
kill_quick(restriction=None, connection=None)
¶
Kill database connections without prompting. Returns number of terminated connections.
:param restriction: restriction to be applied to processlist :param connection: a datajoint.Connection object. Default calls datajoint.conn()
Restrictions are specified as strings and can involve any of the attributes of information_schema.processlist: ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO.
Examples:
dj.kill('HOST LIKE "%compute%"') terminates connections from hosts containing "compute".
Source code in datajoint/admin.py
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 |
|