Interview Question in SQL Server Performance Tuning


 

Interview Question :: PHP and MySQL footprint on Windows Server 2003 IIS 6 setup


I realize this is more of a server question than a networking one, but hopefully somebody could shed some light on this for me.

We have a client running a .net setup across IIS; we've convinced them to install PHP an MySQL on their system. They're wondering what type of performance impact or footprint these installs will leave on their system. I just don't know enough about servers to answer it effectively; I stick to coding and leave the server stuff to more capable people.

Oh, btw - they're also going to be running MS SQL Express on the same box for some legacy applications they have in place.

Any help would be appreciated - thanks!
Answers to "PHP and MySQL footprint on Windows Server 2003 IIS 6 setup"
RE: PHP and MySQL footprint on Windows Server 2003 IIS 6 setup?

There's not really enough here to answer with any depth. It all depends on how much traffic will be hitting the new servers. My experience with Apache and MySQL has been that they don't hog resources, but that was on a Linux box. I haven't tried running them on Windows.



I assume that part of the point of going to PHP/MySQL is to wean them off IIS anyway. If that's so, then it seems like the impact to the server will stay more or less the same since clients that used to query IIS will now be directed to Apache/MySQL. Otherwise the server daemons will just be sitting there. If they are really keen on knowing exactly how much RAM and CPU cycles the progs will take up, suggest installing them for a day and take a look at the Task Manager.
 
Vote for this answer ::  
Update Alert Setting