I am studying the scalability of MYSQL on SMPs on Linux. I am wondering if any one has performed scalability studies. If so, I would be interested in a pointer to the results; if not, I am curious if there is interest in MYSQL's scalability. Pointers to benchmarks used to study MYSQL would also be appreciated. Another thing I was wondering is if anyone had experience or recommendations in choosing the server parameters of MYSQL to tune for SMP performance.
Khaled