Heres what im wanting to do

[eXtremeTim]

What im wanting to do is get my php optimized and mysql optimized as much as possible to speed up creations times. Im on a very fast and powerful server and I know there are ways to optimize php.

My config right now is
Windows 2003 enterprise server
PHP v4.3.2 as cgi
MySql 4.0.12
on iis 6

My mysql right now already flies but if i can get it faster that would be great. My php seems to be more or less whats limiting my speed right now. As you can see my mysql is less than 10% of the time most every time on vb3.

Page generated in 0.17342496 seconds (91.04% PHP - 8.96% MySQL) with 16 queries.

I have installed the zend php accel engine as well. If you guys could help tell me the fastest settings to use on things in php.ini that would be great. Your help will be much appriciated. If their are any addons to php/mysql that make them faster and can be used on windows please let me know so i can look into them.

[Steve Machol]

See the Sticky thread at the top of this forum:

http://www.vbulletin.com/forum/showthread.php?t=70117

[eXtremeTim]

Sorry about not reading it I am very tired. Its was my mistake for not paying attention. Here is the info to the best that i can give right now.

Dedicated Server

Memory: 2(512 mb ddr400 pc3200)
Hard Drives: 1 160 gig maxtor ultra ata 133 5400 rpm and 1 60 gig ibm ata 100 7200rpm
CPU: xp2200
Mobo: a7v8x deluxe
PHP 4.3.2 as cgi
MySql 4.0.12
IIS6
Windows 2003 enterprise edition

no innodb tables as far as i know.

MySql was installed by the standard installer.

No top stats since windows

Cannot find the my.cnf file

No extended stats since the file is not made for vb3

Their is one other vb on my server.

Low number of concurent users right now but it will get alot bigger once i luanch the site in full swing. right now i would say 1-3. but the other vb hits about 10-20.

http://www.extremescripts.com/phpinfo.php

vbulletin v3.0.0 beta 4

[eXtremeTim]

Well I found a good php accelerator for apache today and played with it and its working perfectly with my windows iis configuration since it was for the windows apache version. Its helping out a great deal. But if somebody could help me config mysql and php even more that would be great.

[eva2000]

well do you have a my.ini or my.cnf anywhere on your server ?

is mysql making use of that slow 5400 rpm hdd ?

[eXtremeTim]

well do you have a my.ini or my.cnf anywhere on your server ?

is mysql making use of that slow 5400 rpm hdd ?
Right now mysql is on the 5400 rpm hard drive. My 5400 rpm drive seems to be just as fast as my 7200 in the end performace wise due to the increase in transfer speed. Would it help any if i made the 140 gig partition smaller? as in for finding the files and such?

Yes i have a my.ini in winnt. Im not sure what all kinda stuff should be in it. Its only got like 3-5 lines not commented out not counting the root info created winmysqladmin. If you could help me tweak php and mysql that would be great. I got the turck mmcache working with my php and iis. Thats helping to speed up php a good amount. not im getting .10-.12 on the same page that i posted the stuff for above. My mysql seems to be flying pretty good even thought it is stock install non optimized.

[eXtremeTim]

What should my my.ini look like on a windows 2003 enterprise server to improve its speed and optimize it?

Plus i managed to get turck mmcache working on my windows box with iis that seems to be helping out a good deal with php.

[eva2000]

can you post your my.ini contents (change the root password in it to some dummy password)

[eXtremeTim]

can you post your my.ini contents (change the root password in it to some dummy password)

sure thing

#This File was made using the WinMySQLAdmin 1.4 Tool
#6/10/2003 10:42:23 PM
#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions
[mysqld]
basedir=D:/sites/mysql
#bind-address=64.219.55.145
datadir=D:/sites/mysql/data
#language=D:/sites/mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=D:/sites/mysql/bin/mysqld-nt.exe
user=root
password=*removed*
QueryInterval=10

[eva2000]

change my.ini to below and readd your mysql root password and restart mysql see if that helps :)


#This File was made using the WinMySQLAdmin 1.4 Tool
#6/10/2003 10:42:23 PM
#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions

[mysqld]
basedir=D:/sites/mysql
datadir=D:/sites/mysql/data
set-variable = max_connections=400
set-variable = key_buffer=16M
set-variable = myisam_sort_buffer_size=64M
set-variable = join_buffer=1M
set-variable = record_buffer=2M
set-variable = sort_buffer=2M
set-variable = table_cache=1024
set-variable = thread_cache_size=64
set-variable = wait_timeout=3600
set-variable = connect_timeout=10
set-variable = max_allowed_packet=16M
set-variable = max_connect_errors=10

[safe_mysqld]
open_files_limit=8192

[mysqldump]
quick
set-variable = max_allowed_packet=16M

[myisamchk]
set-variable = key_buffer=64M
set-variable = sort_buffer=64M
set-variable = read_buffer=16M
set-variable = write_buffer=16M

[WinMySQLadmin]
Server=D:/sites/mysql/bin/mysqld-nt.exe
user=root
password=*removed*
QueryInterval=10

[Steve Machol]

change my.ini to below and readd your mysql root password and restart mysql see if that helps :)
I think George meant my.cnf.

[eva2000]

nope my.ini is and can be the windows equivalent of my.cnf for linux ;)

[Steve Machol]

Ahhh, another stupid Windows trick, eh? ;)

[eva2000]

Ahhh, another stupid Windows trick, eh? ;)
http://www.mysql.com/doc/en/Option_files.html ;)

[eXtremeTim]

Thanks
Now any chance you could help me optimize php?

[eva2000]

Thanks
Now any chance you could help me optimize php?
not much to optimise in way of PHP has latest 4.3.2 and install Turck Mmache :)

[eXtremeTim]

Thanks anyway. Turck mmcache seems to work pretty solid on a windows system with iis even tho it says it doesn't work with iis.