How to adjust the number of slots per host in gridengine

qconf -mq all.q  (if you're using the default queue)
Then you should see a line similar to:

slots                 1,[host1.abc.com=8],[host2.abc.com=12], \

                      [host3.abc.com=12]

Change the =## on a per host basis and then exit and save your editor.

Convert SQL TIME field to plain seconds

Here's something I do occasionally and always have to go search the interwebs for.
So let me write it somewhere I (and hopefully others) can find it easily.

select TIME_TO_SEC(FIELD_NAME) as MY_ALIAS_FIELD_NAME from TABLE...;