Re: MariaDB instead of MySQL

So - after a few days all is good. The verdict seems to be that MariaDB works much better than MySQL. The conversion was trivial and everything just works now. I'm filtering for about 80k users. MySQL never worked for me longer than a few hours. Token count is abut 2,000,000. I'm recommending

Re: MariaDB instead of MySQL

On 5/17/2013 8:45 AM, Benny Pedersen wrote: Marc Perkel skrev den 2013-05-17 17:38: I have a dedicated SQL server with 32 gigs of ram so I have the resources to handle it. that is not my point, one single mysql to more then one server will die sonner or later, if i had the resouces you have i

Re: MariaDB instead of MySQL

On Fri, May 17, 2013 at 08:58:53AM -0700, Quanah Gibson-Mount wrote: > --On Friday, May 17, 2013 10:02 AM -0400 "David F. Skoll" > wrote: > > >On Fri, 17 May 2013 15:52:26 +0200 > >Axb wrote: > > > >>With that amount of traffic, you might want to look into the trunk SA > >>3.4 Redis backend. > >

Re: MariaDB instead of MySQL

On Fri, 17 May 2013 09:26:53 -0700 Quanah Gibson-Mount wrote: > If you look at the microbenchmark Symas did, you can see that LMDB is > at least 7 times faster than BDB > when going directly through the API. Interesting. For now, CDB is more than adequate for

Re: MariaDB instead of MySQL

On Fri, 17 May 2013 11:28:23 -0500 (CDT) Dave Funk wrote: > If CDB is read-only, how do you store the a-time values on lookups so > you know which tokens aren't being used to facilitate expiry? We don't. We have a different Bayes implementation with a different expiry strategy. I didn't realiz

Re: MariaDB instead of MySQL

On Fri, 17 May 2013, David F. Skoll wrote: On Fri, 17 May 2013 08:58:53 -0700 Quanah Gibson-Mount wrote: Personally I wish SA supported LMDB. We've had very good luck with CDB, Dan Bernstein's "constant database" format. Reads are unbelievably fast. The only downside to CDB is that you ca

Re: MariaDB instead of MySQL

--On Friday, May 17, 2013 12:07 PM -0400 "David F. Skoll" wrote: On Fri, 17 May 2013 08:58:53 -0700 Quanah Gibson-Mount wrote: Personally I wish SA supported LMDB. We've had very good luck with CDB, Dan Bernstein's "constant database" format. Reads are unbelievably fast. The only downsi

Re: MariaDB instead of MySQL

On Fri, 17 May 2013 08:58:53 -0700 Quanah Gibson-Mount wrote: > Personally I wish SA supported LMDB. We've had very good luck with CDB, Dan Bernstein's "constant database" format. Reads are unbelievably fast. The only downside to CDB is that you cannot update a CDB file. You need to generate

Re: MariaDB instead of MySQL

--On Friday, May 17, 2013 10:02 AM -0400 "David F. Skoll" wrote: On Fri, 17 May 2013 15:52:26 +0200 Axb wrote: With that amount of traffic, you might want to look into the trunk SA 3.4 Redis backend. Yes, I would have thought a SQL database would be completely inappropriate for Bayes look

Re: MariaDB instead of MySQL

Marc Perkel skrev den 2013-05-17 17:38: I have a dedicated SQL server with 32 gigs of ram so I have the resources to handle it. that is not my point, one single mysql to more then one server will die sonner or later, if i had the resouces you have i would have running mysql on all the 7 serv

Re: MariaDB instead of MySQL

On 5/17/2013 6:45 AM, Benny Pedersen wrote: Marc Perkel skrev den 2013-05-17 06:12: Yeah - I'm running global too. Not per user. why do you have 7 servers and only one mysql server ? :) well to get more performance out of mysql one need to use clustered backends aswell, so to get most perfo

Re: MariaDB instead of MySQL

On Fri, 17 May 2013 15:52:26 +0200 Axb wrote: > With that amount of traffic, you might want to look into the trunk SA > 3.4 Redis backend. Yes, I would have thought a SQL database would be completely inappropriate for Bayes lookups. You just want a blazingly fast key/value lookup. Regards, D

Re: MariaDB instead of MySQL

On 05/17/2013 12:59 AM, Marc Perkel wrote: In the past I have never managed to get bayes to work with MySQL in a reliable way. Even running in ram it would die of some sort of corruption after a few hours. Now I'm trying the MariaDB replacement. I will admit I'm running a faster server than the

Re: MariaDB instead of MySQL

Marc Perkel skrev den 2013-05-17 06:12: Yeah - I'm running global too. Not per user. why do you have 7 servers and only one mysql server ? :) well to get more performance out of mysql one need to use clustered backends aswell, so to get most performance it would make sense to read from all m

Re: MariaDB instead of MySQL

Yeah - I'm running global too. Not per user. On 5/16/2013 5:38 PM, Rick Macdougall wrote: Hi, One common bayes DB running MySql on one server. Spa001 running SA and MySQL plus auto learn Spa010 running SA no auto learn Spa011 running SA no auto learn Spa013 running SA with auto learn All Spas

Re: MariaDB instead of MySQL

On 5/16/2013 5:02 PM, Alex wrote: Hi, Running a 4 server cluster of SA servers with MySQL running on one. 2 running auto learn and the other two just doing queries. Looks like I average about 6300 queries a minute. No noticeable problems with it. So they are all separate from each other,

Re: MariaDB instead of MySQL

Hi, One common bayes DB running MySql on one server. Spa001 running SA and MySQL plus auto learn Spa010 running SA no auto learn Spa011 running SA no auto learn Spa013 running SA with auto learn All Spas looking at the MySQL server on Spa001. Global bayes database btw, not per user as we are an

Re: MariaDB instead of MySQL

Hi, > Running a 4 server cluster of SA servers with MySQL running on one. 2 > running auto learn and the other two just > doing queries. Looks like I average about 6300 queries a minute. No > noticeable problems with it. So they are all separate from each other, not sharing a common bayes db

Re: MariaDB instead of MySQL

Hi, Running a 4 server cluster of SA servers with MySQL running on one. 2 running auto learn and the other two just doing queries. Looks like I average about 6300 queries a minute. No noticeable problems with it. Recently looked at Maria but we are in the middle of a move here, would love to