Antonio Fernández Pérez Big innodb tables, how can I work with them?
May 15, 2014; 14:26
Antonio Fernández Pérez
Big innodb tables, how can I work with them?
?
? ?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 or not navigate in Internet (Depending on the time of all his sessions).
So, with 8GB of data in one table, what are your advices to follow? Fragmentation and sharding discarted because we are working with disk arrays, so not apply. Another option is to delete rows, but in this case, I can't. For the other hand, maybe de only possible solution is increase the resources (RAM).
Any ideas?
Thanks in advance.
Regards,
Antonio.?
May 15
Reindl Harald Re: Big innodb tables, how can I work with them?
May 15, 2014; 14:45
Reindl Harald
Re: Big innodb tables, how can I work with them?
May 19
Manuel Arostegui Re: Big innodb tables, how can I work with them?
May 19, 2014; 08:18
Manuel Arostegui
Re: Big innodb tables, how can I work with them?
May 19
Johan De Meersman Re: Big innodb tables, how can I work with them?
May 19, 2014; 11:49
Johan De Meersman
Re: Big innodb tables, how can I work with them?
May 19
Manuel Arostegui Re: Big innodb tables, how can I work with them?
May 19, 2014; 13:48
Manuel Arostegui
Re: Big innodb tables, how can I work with them?
May 19
Andrew Moore Re: Big innodb tables, how can I work with them?
May 19, 2014; 13:04
Andrew Moore
Re: Big innodb tables, how can I work with them?
May 20
Antonio Fernández Pérez Re: Big innodb tables, how can I work with them?
May 20, 2014; 06:39
Antonio Fernández Pérez
Re: Big innodb tables, how can I work with them?
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!