This worklog has been replaced with mariadb.org/jira

This site is here for historical purposes only. Do not add or edit tasks here!

 
 
 

WorkLog Frontpage Log in / Register
High-Level Description | Task Dependencies | High-Level Specification | Low-Level Design | File Attachments | User Comments | Time Estimates | Funding and Votes | Progress Reports

 Handle millions of users & roles.
Title
Task ID224
Queue
Version
Status
Priority
Copies toSergei

Created byMonty30 Jun 2011Done
Supervisor   
Lead Architect    
Architecture Review  
Implementor  
Code Review  
QA  
Documentation  
 High-Level 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;

As users log in, these caches fill up. If we SET GLOBAL ROLE_CACHE=1000, this
works as a LRU for the 1000 most recently used...
 Task Dependencies
Others waiting for Task 224Task 224 is waiting forGraph
 
 High-Level Specification
 Low-Level Design
 File Attachments
 NameTypeSizeByDate
 User Comments
 Time Estimates
NameHours WorkedLast Updated
Total0 
 Hrs WorkedProgressCurrentOriginal
Total000
 
 Funding and Votes
Votes: 0: 0%
 Make vote: Useless    Nice to have    Important    Very important    

Funding: 0 offers, total 0 Euro
 Progress Reports
(Monty - Thu, 30 Jun 2011, 19:33
    
Title modified.
--- /tmp/wklog.224.old.8097	2011-06-30 19:33:47.000000000 +0000
+++ /tmp/wklog.224.new.8097	2011-06-30 19:33:47.000000000 +0000
@@ -1,2 +1,2 @@
-Handle milions of users & roles.
+Handle millions of users & roles.
 

(Sergei - Thu, 30 Jun 2011, 18:33
    
Observers changed: Sergei

(Monty - Thu, 30 Jun 2011, 17:55
    
High Level Description modified.
--- /tmp/wklog.224.old.3757	2011-06-30 17:55:53.000000000 +0000
+++ /tmp/wklog.224.new.3757	2011-06-30 17:55:53.000000000 +0000
@@ -9,4 +9,6 @@
 SET GLOBAL USERNAME_CACHE = 1000000;
 SET GLOBAL ROLE_CACHE = 1000000;
 
+As users log in, these caches fill up. If we SET GLOBAL ROLE_CACHE=1000, this
+works as a LRU for the 1000 most recently used...
 


Report Generator:
 
Saved Reports:

WorkLog v4.0.0
  © 2010  Sergei Golubchik and Monty Program AB
  © 2004  Andrew Sweger <yDNA@perlocity.org> and Addnorya
  © 2003  Matt Wagner <matt@mysql.com> and MySQL AB