I have a question related to the overhead. I have a customer (i only support the infrastructure) that wants to upgrade his mysql server. they are running linux with a single processor (600Mhz) and 1 gig of RAM. when i do a 'top' it says that each spawning of PID for mysqld that is running is taking up 152MB RAM. it is for an ecommerce system and each user request opens another PID and another 152MB RAM. they have used all the RAM in the box because of so many users and mysqld PID's. they would like to expand the system, because the web front end is getting 404 errors because they cannot open any more mysql sessions. the cpu is only running at 20 to 30%. my guess is that more RAM would allow more spawns of sessions, but my experiecne with btrieve showed me that there were usually limits to the number of spawns. how do i accurately size and scale the server AND tweak mysql to accept more connections? can i cluster to multiple servers? add more RAM???
please help ASAP
please help ASAP
