Am 21.05.2013 11:41, schrieb Cor Bosman:
the system would be much more scalable and is much more scalable with *not* using MySQL for storing sessions and RC is performance wise the weakest part of the whole infrastructure
You probably have a different view of what it means to be scalable than the rest of the world Scalable means you can add more servers to handle the load
you must live in your own world
scalability means it can handle a growing load, this *may be* done by spread the load over more servers
good and really scalable software scales also by add hardware like memory or CPU's to the same machine and in this context doing disk IO instead use a tmpfs for sessions is exactly the opposite you would want
well, finally the db-sessions become your bottleneck by mysql deadlocks if you have too much users resulting in *a lot* of concurrency on the same, shared table
been there, done that, what you *not* want is a growing amount of writing queries on a database under real load