Right now I am running mysql on couple dual processor sparc ultra-80s. Since mysql is using solaris threads the mysql daemon is running in a single process with lightweight threads for each connection. So mysql can only run on one of the processors. Is it advisable to try to compile mysql using pthreads in order that mysql will use heavyweight threads and therefore be able to take advantage of the second processor? Or is it possible that the combination of solaris threads being quicker than pthreads and the reduced amount of context switches when mysql is running on its 'own' processor makes it faster than if I were to get mysql running on both processors? Or maybe I am even wrong about using pthreads being the method to have mysql take advantage of both processors? -- struct Programmer/Analyst 'Danny Rathjens' {this.place = "MyCity.com";} "How can I prove I am human?" -- Q, "Die." -- Worf "Oh, how very clever, Worf. Eat any good books lately?" -- Q, ST:TNG --------------------------------------------------------------------- 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