Re: Big innodb tables, how can I work with them?

2014-05-19 Thread Antonio Fernández Pérez
​Hi, Thanks for your replies. In our case, we can't implement NOSQL solution. Thats requires modify/check all our application and all services (Including FreeRADIUS that I'm not sure if it's compatible). Andrew, I have heard about people that has a lot of data, more than me. I know that MySQL su

Re: Big innodb tables, how can I work with them?

2014-05-19 Thread Andrew Moore
What kind of queries is this table serving? 8GB is not a huge amount of data at all and IMO it's not enough to warrant sharding. On Thu, May 15, 2014 at 1:26 PM, Antonio Fernández Pérez < antoniofernan...@fabergroup.es> wrote: > ​ > > ​ > ​Hi, > > I have in my server database some tables that ar

Re: Big innodb tables, how can I work with them?

2014-05-19 Thread Manuel Arostegui
2014-05-19 11:49 GMT+02:00 Johan De Meersman : > > - Original Message - > > From: "Manuel Arostegui" > > Subject: Re: Big innodb tables, how can I work with them? > > > > noSQL/table sharding/partitioning/archiving. > > I keep wondering how people believe that NoSQL solutions magically do

Re: Big innodb tables, how can I work with them?

2014-05-19 Thread Johan De Meersman
- Original Message - > From: "Manuel Arostegui" > Subject: Re: Big innodb tables, how can I work with them? > > noSQL/table sharding/partitioning/archiving. I keep wondering how people believe that NoSQL solutions magically don't need RAM to work. Nearly all of them slow down to a craw