I Have a P4, with 1GB RAM on WinXP pro. Ive Tomcat as my container with MySQL 5.0 running in the default configuration. the only modifcation i did was this.
innodb_buffer_pool_size = 300M
I have innodb table with apprx 78,000 records and the record size is approx. 1KB.
When Mysqld-nt process starts it increase the Memory usage to 1.2GB, but my physical memory is only 1GB.
What modification i need to do
a. in my.ini to reduce the memory usage.
b. upgradation of my server hardware.