Version differences:

Node: AstRecipes/Debugging Qloaderd installation - showing differences between version 2 and 1

44a45
> ""Checking all data is in the database""
45a47,53
> If you want a breakdown by day of the contents of the each partition, you can run the following query:
> [#CODE:]
> SELECT partition, FROM_UNIXTIME(time_id, '%Y%m%d' ) as date, count(*) as n_rows 
> FROM queue_log 
> GROUP BY partition, FROM_UNIXTIME( time_id, '%Y%m%d' )
> ORDER BY partition, FROM_UNIXTIME( time_id, '%Y%m%d' );
> [:CODE#]
46a55
> The result will look something like:
47a57,69
> [#CODE:]
> +-----------+----------+--------+
> | partition | date     | n_rows |
> +-----------+----------+--------+
> | P01       | 20070329 |   4216 |
> | P01       | 20070411 |      5 |
> | P01       | 20070412 |      3 |
> | rt        | 20070508 |   9365 |
> | rt        | 20070509 |  13248 |
> | rt        | 20070510 |   3883 |
> +-----------+----------+--------+
> 6 rows in set (0.45 sec)
> [:CODE#]
48a71,72
> 
>

Back to history - See current version.