I have a 64-bit server 2003 Standard Ed R2 with 4 GB physical memory installed.
I'm looking into performance issues from a mysql database that is running roughly 1250 mb in memory. Task manager shows 2 GB available physical memory, and 3 GB page file usage.
The mysqld-nt.exe *32 process always starts with ~94% of the 1250 MB in VM and remains this way. Why is this memory not being allocated to physical memory rather than virtual?