> That's because ignoring cpu and query complexity isn't generally done.
> Sure, you can run a zillion queries per second if all you're doing is
> "SELECT num from table;". But really threads are limited by memory
I agree with many of your points. We tuned our per-thread buffers
appropriately a
On 5/19/06, Lyle Tagawa <[EMAIL PROTECTED]> wrote:
Given a nptl/linux box (or pthreads/freeBSD) for example, can you tell
what is the theoretical max running thread count (in the context of
paging/process scheduling and not in the context of memory sizing),
assuming that there's no configuration
Hello,
This question is for those with experience sizing their MySQL back-end.
I have one box running 3000 mysqld threads and serving 6000 qps, and is
operating fine. The run queue is generally empty, but we observe ~20K
context-switches/s. At some point, as usage increases, the run queue
le
