← Back to team overview

maria-developers team mailing list archive

WL#224 New (by Monty): Handle milions of users & roles.

 

-----------------------------------------------------------------------
                              WORKLOG TASK
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
TASK...........: Handle milions of users & roles.
CREATION DATE..: Thu, 30 Jun 2011, 17:54
SUPERVISOR.....: Sergei
IMPLEMENTOR....: 
COPIES TO......: 
CATEGORY.......: Server-BackLog
TASK ID........: 224 (http://askmonty.org/worklog/?tid=224)
VERSION........: Server-5.7
STATUS.........: Un-Assigned
PRIORITY.......: 60
WORKED HOURS...: 0
ESTIMATE.......: 0 (hours remain)
ORIG. ESTIMATE.: 0

PROGRESS NOTES:



DESCRIPTION:

The database should be able to work fine with one million users, one million
roles. Do not keep all data in memory, load the required info on login into a
cache (size changeable without restart).

On login, load the requested data, if it is not in cache already.

Example:

SET GLOBAL USERNAME_CACHE = 1000000;
SET GLOBAL ROLE_CACHE = 1000000;


ESTIMATED WORK TIME

ESTIMATED COMPLETION DATE
-----------------------------------------------------------------------
WorkLog (v4.0.0)