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

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

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

2014-05-18 Thread Manuel Arostegui
2014-05-15 14:26 GMT+02:00 Antonio Fernández Pérez < antoniofernan...@fabergroup.es>: > ​ > > ​ > ​Hi, > > I have in my server database some tables that are too much big and produce > some slow query, even with correct indexes created. > > For my application, it's necessary to have all the data be

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

2014-05-15 Thread Reindl Harald
Am 15.05.2014 14:26, schrieb Antonio Fernández Pérez: > I have in my server database some tables that are too much big and produce > some slow query, even with correct indexes created. > > For my application, it's necessary to have all the data because we make an > authentication process with RA

Big innodb tables, how can I work with them?

2014-05-15 Thread Antonio Fernández Pérez
​ ​ ​Hi, I have in my server database some tables that are too much big and produce some slow query, even with correct indexes created. For my application, it's necessary to have all the data because we make an authentication process with RADIUS users (AAA protocol) to determine if one user can