Knowledge base for Windows Webmasters, Administrators and Web hosting compagnies, with a special attention to WAMP (Windows Apache MySQL PHP). Most articles/tips are currently in use on web hosting servers. This is an open site, please participate or even join us.
New:
eAccelerator 0961 for PHP 5.3.3
eAccelerator 0961 for PHP 5.2.14
eAccelerator 0.9.5.1 for PHP 4.4.9

eAccelerator binaries for PHP 5.x (windows builds)

For the Windows eAccelerator for php 5.3+ visit our new page at:eAccelerator binaries for PHP 5.3+.

Updated: eAccelerator download using latest code (0.9.5.3 with PHP 5.2.9).

Please find following the compiled binaries of eAccelerator for Windows using Microsoft VC++ 6. For PHP 4 versions: eAccelerator binaries for PHP 4.x.
If you need a version not offered here, let us know (post comment).

APC binaries for PHP 4.x (windows builds)

Updated: APC download using latest code (3.0.11).

Please find following the compiled binaries of APC for Windows using Microsoft VC++ 6. For PHP 5 versions (following link should be updated soon): PHP APC binaries for PHP 5.x.
If you need a version not offered here, let us know (post comment).

APC binaries for PHP 5.x (windows builds)

Updated: APC download using latest code (3.0.12p2).

FrontPage Guestbook, Board, Forms spam

The main raison for people spamming your FrontPage Guestbook, Forum/Board or forms is that the search engine Google, counts every "back link" (i.e. link pointing to these SPAM sites) as a positive vote. So if they can get a link to their site on your Guestbook, Google will interpret this as an "endorsement" of their site and give then additional "importance".

This spamming activity is especially common nowadays since they are thousands of automated scripts looking for FrontPage (or not, they will try to spam anything really...) guestbooks, boards, or forms to post SPAM links.

Setting up PHP as Fast CGI (FCGI) under Apache

1) Download the Apache mod_fcgi module: http://fastcgi.coremail.cn/

2) Configuration in your Apache httpd.conf:
a) LoadModule fcgid_module modules/mod_fcgid.so

b.1) <Directory "C:/Apache2/htdocs/php/">
    SetHandler fcgid-script
    Options execCGI

Apache Better Log Rotation mod_log_rotate

Important: The Apache provided tool rotatelogs.exe is to buggy to use "for real", see: Apache Rotatelogs.exe for Windows Server

my.ini most important values: key_buffer_size table_cache

When tuning MySQL, the two most important variables to configure are key_buffer_size and table_cache. You should first feel confident that you have these set appropriately before trying to optimize any other variables. Ideally, key_buffer_size will be large enough to contain all the indexes (i.e. at least the total size of all .MYI files on the server) of your MyISAM tables.

MySQL recommendations (which appears to be on the conservative side...):
256MB system: key_buffer_size=64M table_cache=256 sort_buffer_size=4M read_buffer_size=1M
128MB system: key_buffer_size=16M sort_buffer_size=1M

How to determine, if you need to increase or decrease key_buffer_size:
Look at the "key_reads" (actual reads from the disk) and "key_read_requests" status variables.