rasqlinsert partition by month
Carter Bullard
carter at qosient.com
Sat Oct 13 09:44:18 EDT 2012
Hey CS Lee,
To make the tables monthly, adjust the time and take the day out of the table name:
rasqlinsert -S argus -w mysql://user@localhost/db/table_%Y_%m -M time 1M
If that doesn't work, holler !!!!
Carter
On Oct 13, 2012, at 3:15 AM, CS Lee <geek00l at gmail.com> wrote:
> hi Carter,
>
> I'm not sure if I'm overlooking, rasqlinsert can partition the table based on the time, especially for daily table, is there an easy way for it to roll based on month?
>
> rasqlinsert -S argus -w mysql://user@localhost/db/table_%Y_%m_%d -M time 1d
>
> Rasqlinsert can do this easily to create daily table, is there a way for it to do it easily with monthly table.
>
> Thank you.
>
> --
> Best Regards,
>
> CS Lee<geek00L[at]gmail.com>
>
> http://geek00l.blogspot.com
> http://defcraft.net
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://pairlist1.pair.net/pipermail/argus/attachments/20121013/4dcf5c6c/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2589 bytes
Desc: not available
URL: <https://pairlist1.pair.net/pipermail/argus/attachments/20121013/4dcf5c6c/attachment.bin>
More information about the argus
mailing list