max edit time is up on my original post, so if someone could edit it so it specifies my.ini for windows, that would be good <img src="/forum/images/graemlins/smile.gif" alt="" />

got it for you <img src="/forum/images/graemlins/smile.gif" alt="" /> As moderator for this forum, you should be able to indefinitely edit your posts... let's see if we can fix it <img src="/forum/images/graemlins/smile.gif" alt="" />

But I'm not a moderator of the MySQL forum <img src="/forum/images/graemlins/smile.gif" alt="" />

? really? hmmm... gotta fix that <img src="/forum/images/graemlins/tongue.gif" alt="" />

[]Jeremy said:<br />But I'm not a moderator of the MySQL forum <img src="/forum/images/graemlins/smile.gif" alt="" /> [/]<br /><br />You are now <img src="/forum/images/graemlins/smile.gif" alt="" /> and thanks for the post.

Thanks <img src="/forum/images/graemlins/smile.gif" alt="" /> I can't hack threads code for crap, but at least I can be helpful in other areas <img src="/forum/images/graemlins/grin.gif" alt="" />

Dunno what else you're good for, <img src="/forum/images/graemlins/smile.gif" alt="" /> but this thread was VERY helpful to me...<br /><br />Thanks!<br /><br />[]http://www.threadsdev.com/threads/php/uploads/panels/6747-13980.png[/]

Chcuk, try /bin/top /bin/ps<br /><br />or if they don't work try<br /><br />bash2.04$ whereis top<br />bash2.04$ whereis ps<br />bash2.04$ whereis netstat<br /><br />It looks to me as though your environment isn't setup well, no paths. We should probably make another thread soemwhere on customizing your environment.

I notice from the large version it says in mine...<br /><br /># Try number of CPU's*2 for thread_concurrency<br />set-variable = thread_concurrency=8<br /><br />What would be the additional setting to benefit from dual CPU's?<br /><br />

set-variable = threads_concurrency=4<br /><br />dual CPU = 2 CPU, times 2 = 4.<br /><br />

Thanks.<br /><br />Going off to add <br /><br />set-variable = threads_concurrency=4<br />dual CPU = 2 CPU, times 2 = 4.<br /><br />to my cnf fle <img src="/forum/images/graemlins/smile.gif" alt="" /><br />

Actually Dave ps is the only one in the /bin directory the other two top and netstat are nowhere to be found. The command whereis is not found LOL

[]Ian_W said: <br />Thanks. <br /> <br />Going off to add <br /> <br />set-variable = threads_concurrency=4 <br />dual CPU = 2 CPU, times 2 = 4. <br /> <br />to my cnf fle <img src="/forum/images/graemlins/smile.gif" alt="" /> <br /> [/] <br /> <br />I think you'll have more luck if you only add <br />

Doh!! Just re-read what he put LOL

chcuk when I run whereis whereis on one of the machines I am handy to I get<br /><br />[root@machine:/root]# whereis whereis<br />whereis: /usr/bin/whereis /usr/share/man/man1/whereis.1.gz<br /><br />perhaps /usr/bin is not in your path?<br /><br />Look at your .bash_profile if you're running bash.<br /><br /><br />PATH=$PATH:$HOME/bin:/usr/local/bin<br /><br />Add more to it as you feel necessary, colon delimited. log out, log in. magic. Now it will start finding things for you.

How do you find your bash profile?

When you are ssh'd in just type more .bash_profile to read it, to edit it use pico or vi.<br /><br />the file will be in your home directory.

Jeremy<br /><br />I think my server needs your trick.<br /><br />Here is my result:<br /><br /><br />I am using Xeon HT 2.4Ghz on Intel Server board with 1GB ECC RAM and SCSI.<br /><br />On average there are 100 users login at the same time. Does persistant connection help?

No, in most cases persistant connections are a bad idea.

I have a P4 2.4 with 1GB RAM dedicated server 100Mbps net connection<br /><br />It runs WHM 8.8.0 cPanel 8.8.0-R73 RedHat 9 - WHM X v2.1.2 apache (1.3.29 (Unix)) mysql (4.0.15-standard)<br /><br />This machine is entirely use for just 1 domain with a vBulletin board. The site has about somewhere from 200+ to 800+ users online concurrent depends on time of the day.<br /><br />When the number of users about 300- (less than 300) the server seem to react normally (Not Slow)<br /><br />However, when the number of users increase at night (7mp - 5am PST) the server react extreamly slow (I mean really really slow) and it sometimes refuse to dislay page and not to load images as well.<br /><br />1. Is this because of MySQL not tuned or Apache not Turned? How do I go about finding what need to fix?<br /><br />2. I have include the 2 results (when site not busy & busy) of the script Germy provide, with the numbers shown, How I optimize MySQL to be the most efficient for my site?<br /><br />3. With the hardware I have how many users I could have on the site just to browse the vBulletin board?<br /><br />Thank you in advance for helping.<br /><br />Result when site not busy:<br /><br />Thu Feb 19 15:57:00 PST 2004<br /><br /> 15:57:01 up 8:37, 1 user, load average: 0.53, 0.68, 0.72<br />99 processes: 89 sleeping, 1 running, 9 zombie, 0 stopped<br />Mem: 1032320k av, 994240k used, 38080k free, 0k shrd, 16036k buff<br /> 151248k active, 805548k inactive<br />Swap: 2104504k av, 936k used, 2103568k free 862944k cached<br /><br /> PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND<br /> 7416 nobody 19 0 1096 1096 752 R 1.9 0.1 0:00 0 top<br /><br /><br />Http processes currently running = 24<br />Mysql processes currently running = 3