Mailing List Archive

Bayes converstion: SQL--> Redis?
Hey there all,

In looking at my sql server, it looks like the on-disk size of my MySQL
DB's is like 9G (because of InnoDB, it's hard to glean just from the
filesystem what tables are which).

Anyway, I'd like to move over to a global redis system, but I don't see an
easy way to convert from bayes SQL to redis bayes.

Is this somewhere and I can't find it?

-Dan

--

--------Dan Mahoney--------
Techie, Sysadmin, WebGeek
Gushi on efnet/undernet IRC
FB: fb.com/DanielMahoneyIV
LI: linkedin.com/in/gushi
Site: http://www.gushi.org
---------------------------
Re: Bayes converstion: SQL--> Redis? [ In reply to ]
On 2/4/21 10:47 AM, Dan Mahoney (Gushi) wrote:
> Hey there all,
>
> In looking at my sql server, it looks like the on-disk size of my MySQL DB's is like 9G (because of InnoDB, it's hard to glean just from the filesystem what tables are which).
>
> Anyway, I'd like to move over to a global redis system, but I don't see an easy way to convert from bayes SQL to redis bayes.
>
> Is this somewhere and I can't find it?
>
"sa-learn --backup" with old config and "sa-learn --restore" with new one should do what you need.

Giovanni
Re: Bayes converstion: SQL--> Redis? [ In reply to ]
On 2/4/2021 5:32 AM, Giovanni Bechis wrote:
> On 2/4/21 10:47 AM, Dan Mahoney (Gushi) wrote:
>> Hey there all,
>>
>> In looking at my sql server, it looks like the on-disk size of my MySQL DB's is like 9G (because of InnoDB, it's hard to glean just from the filesystem what tables are which).
>>
>> Anyway, I'd like to move over to a global redis system, but I don't see an easy way to convert from bayes SQL to redis bayes.
>>
>> Is this somewhere and I can't find it?
>>
> "sa-learn --backup" with old config and "sa-learn --restore" with new one should do what you need.
>
> Giovanni
Hi Gushi, I also like to use innodb-file-per-table = 1 so I don't have
one centralized innodb file.