| 1 | Last login: Fri Sep 16 08:35:18 2011 from desktop
|
|---|
| 2 | [root@mythtv ~]# mysql -u root mythconverg
|
|---|
| 3 | Reading table information for completion of table and column names
|
|---|
| 4 | You can turn off this feature to get a quicker startup with -A
|
|---|
| 5 |
|
|---|
| 6 | Welcome to the MySQL monitor. Commands end with ; or \g.
|
|---|
| 7 | Your MySQL connection id is 1941
|
|---|
| 8 | Server version: 5.5.15 Source distribution
|
|---|
| 9 |
|
|---|
| 10 | mysql> select * from jobqueue;
|
|---|
| 11 | +-------+--------+---------------------+---------------------+------+------+-------+--------+---------------------+----------+------+--------------------------------+---------------------+
|
|---|
| 12 | | id | chanid | starttime | inserttime | type | cmds | flags | status | statustime | hostname | args | comment | schedruntime |
|
|---|
| 13 | +-------+--------+---------------------+---------------------+------+------+-------+--------+---------------------+----------+------+--------------------------------+---------------------+
|
|---|
| 14 | | 13354 | 11590 | 2011-04-10 10:10:00 | 2011-05-24 22:00:56 | 256 | 0 | 0 | 256 | 2011-05-26 14:05:48 | mythtv | | Complete - 195 seconds elapsed | 2011-05-24 22:00:57 |
|
|---|
| 15 | | 13390 | 9305 | 2011-09-05 21:40:00 | 2011-09-05 21:40:01 | 2 | 0 | 2 | 272 | 2011-09-15 03:13:53 | mythtv | | 2 commercial breaks | 2011-09-05 21:40:01 |
|
|---|
| 16 | | 13397 | 15318 | 2011-09-14 17:00:00 | 2011-09-14 17:00:03 | 4 | 0 | 2 | 272 | 2011-09-15 02:35:48 | mythtv | | Metadata Lookup Complete. | 2011-09-14 17:00:03 |
|
|---|
| 17 | | 13395 | 15318 | 2011-09-13 17:00:00 | 2011-09-13 17:00:03 | 4 | 0 | 2 | 272 | 2011-09-14 02:36:03 | mythtv | | Metadata Lookup Complete. | 2011-09-13 17:00:03 |
|
|---|
| 18 | | 13404 | 15318 | 2011-09-15 17:00:00 | 2011-09-15 17:00:04 | 4 | 0 | 2 | 272 | 2011-09-15 17:00:50 | mythtv | | Metadata Lookup Complete. | 2011-09-15 17:00:04 |
|
|---|
| 19 | | 13398 | 15318 | 2011-09-15 07:00:00 | 2011-09-15 07:00:01 | 4 | 0 | 2 | 272 | 2011-09-15 07:33:50 | mythtv | | Metadata Lookup Complete. | 2011-09-15 07:00:01 |
|
|---|
| 20 | | 13401 | 9072 | 2011-09-13 20:05:00 | 2011-09-15 08:15:15 | 2 | 0 | 0 | 272 | 2011-09-15 09:13:34 | mythtv | | 4 commercial breaks | 2011-09-15 08:15:15 |
|
|---|
| 21 | | 13400 | 9072 | 2011-09-15 08:00:00 | 2011-09-15 08:00:17 | 2 | 0 | 2 | 272 | 2011-09-15 09:04:51 | mythtv | | 0 commercial breaks | 2011-09-15 08:00:17 |
|
|---|
| 22 | | 13405 | 9072 | 2011-09-15 20:05:00 | 2011-09-15 20:05:01 | 2 | 0 | 2 | 272 | 2011-09-15 20:57:58 | mythtv | | 3 commercial breaks | 2011-09-15 20:05:01 |
|
|---|
| 23 | | 13408 | 9072 | 2011-09-16 08:00:00 | 2011-09-16 09:14:12 | 2 | 0 | 0 | 1 | 2011-09-16 09:14:12 | NULL | | | 2011-09-16 09:14:12 |
|
|---|
| 24 | +-------+--------+---------------------+---------------------+------+------+-------+--------+---------------------+----------+------+--------------------------------+---------------------+
|
|---|
| 25 | 10 rows in set (0.00 sec)
|
|---|
| 26 |
|
|---|
| 27 | mysql> |
|---|
