I installed phpMyAdmin on CentOS 4.4. When accessing phpMyAdmin the memory usage jumps. Memory usage for http jumps to 700MB spawning 4-5 httpd processes (about 3GB of ram). Mysql also jumps to using close to 600MB in some cases This is a Daul Dual core Xeon 3GHz machine with 4 GB of 667Mhz ram. Should I be seeing this spike in Memory usage? The spikes only last about 5 seconds but my manager doesn't want to see those jumps. The databases appear to be about 450MB-600MB. On a side note I had a requirement from the dev group here to set php to a maximum memory usage of 1GB due to the large files that are being parsed via a web page. Any help would be appreciated. Thanks! -- Matthew Martz CentOS Mirror Admin mdmartz at gflug.net
well, it's sort of a php/mysql question, but you hit it on the head when noting your php memory settings. those will impact the tool's performance, if you have a spare machine, you can perhaps do a comparison..... -krb Matthew Martz wrote:>I installed phpMyAdmin on CentOS 4.4. > >When accessing phpMyAdmin the memory usage jumps. Memory usage for http >jumps to 700MB spawning 4-5 httpd processes (about 3GB of ram). Mysql >also jumps to using close to 600MB in some cases > >This is a Daul Dual core Xeon 3GHz machine with 4 GB of 667Mhz ram. > >Should I be seeing this spike in Memory usage? The spikes only last about >5 seconds but my manager doesn't want to see those jumps. > >The databases appear to be about 450MB-600MB. > >On a side note I had a requirement from the dev group here to set php to a >maximum memory usage of 1GB due to the large files that are being parsed >via a web page. > >Any help would be appreciated. > >Thanks! > > >
On 3/19/07, Matthew Martz <mdmartz at gflug.net> wrote:> I installed phpMyAdmin on CentOS 4.4.I'm sorry.> Should I be seeing this spike in Memory usage? The spikes only last about > 5 seconds but my manager doesn't want to see those jumps.He's okay with phpmyadmin, but doesn't want memory used?> The databases appear to be about 450MB-600MB.Not bad, but what operation were you performing on the database at the time? complex queries with joins and such will drive memory/processor usage up.> On a side note I had a requirement from the dev group here to set php to a > maximum memory usage of 1GB due to the large files that are being parsedHoly CRAP that's huge. Is this a real need, or is this just the dev group wanting to not fix a problem? This seems like it could very quickly get out of hand if more than a user or two decide to kick off similar processes. -- During times of universal deceit, telling the truth becomes a revolutionary act. George Orwell