04-Apr-2006

PHP/MYSQL update
As it turned out tonight, logging at the top level using phpmyadmin indeed DID show all databases, but one level lower that user lacked privileges - as did the Wordpress administrator. Omce that was settled, the PHP programs could be reused as intended.
In that investigation proces it was found that lack of speed and surounding problems simply has been a matter of lack of paging space. On the system disk, there is a pagefile of 523.500 bl;ocks (which is 260 Mb - just over the system's memory - and on the local disk there's one of 600.000 blocks (just less than 300Mb):

Paging File Usage (8KB pages): Index Free Size
ALPHASYS:[local]PAGEFILE.SYS;1 253 15125 37496
DISK$AXP082:[SYS0.SYSEXE]PAGEFILE.SYS 254 10776 33280

size is in 8KB pages - so it makes sense.

That aought to be sufficient, but presumably, it isn't.
Fully running, after updates with PHPMyAdminand Wordpress al most consumed all. Matter of buffers in Mysql, I guess, or even a problem with PHP's memory requirements?
Putted it on ITRC, we'll see.

(What wonders me is that BOTH pagefiles are heavily used, where the primary one (index 254) should NOT be used that heavily; the other one is installed very early in the startup sequence so I would expect it be used more heavily. But it can be that pagefile usage has been improved in VMS 8.2 over 7.3-2)