> > Hi, > > mysqld is single-process/multi-thread. > What you see are 4 threads, ps on Linux doen not differenciate between > threads and processes. > For more details on these threads, you can look at the manual: > http://www.mysql.com/doc/M/y/MySQL_threads.html > when i ps on freebsd 4.4 i saw only one thread. is it normal ?
another question : i run mysql on dual processor pentium II 550 Mhz with 1 GB memory. When i type top on prompt, i saw this : 105 processes: 2 running, 103 sleeping CPU states: 30.2% user, 0.0% nice, 25.9% system, 0.0% interrupt, 44.0% idle Mem: 94M Active, 123M Inact, 82M Wired, 13M Cache, 112M Buf, 693M Free Swap: 2052M Total, 2052M Free PID USERNAME PRI NICE SIZE RES STATE C TIME WCPU CPU COMMAND 63408 mysql 61 0 37028K 35420K CPU1 1 17.5H 97.41% 97.41% mysqld there is 44 % persen of CPU idle, although mysql using 97 %. Can i force mysql to use that 44 % CPU idle ? how to set mysqld for optimal performance for my hardware specification above ? Thanks. regards, Antok --------------------------------------------------------------------- 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