In the last episode (Jun 27), Marek Wysmulek said: > Dear all. > > (Debian 2.4.19, mysql.2.23) > > I'm sorry if case was discussed btu : can someone show me the > documentation or articles about cpu comsumption being done by mysql > server or/and clients. Or should I look for load balancing guide. > > Problem is that after ONLY 20 users are connected to the mysql server > via main socket 0 % of cpu grows to 80 (!) and % of swat also.
It all depends on what your queries are. 300 users doing single-record lookups may not consume as much CPU as one user doing a complex multi-table join. -- Dan Nelson [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php