17M per mysqld thread seems excessive

[csbdeady]

Hi

I am running RedHat 9 Linux on a Dell Poweredge.

Using the top command I can see that mysqld is using 17M (18388k) - however that is per instance (thread?) of mysqld. If I refresh my browser window several times in quick succession I can see several more mysqld instances, each using 17M appear.

I used the following command to do this:
top | grep mysqld

I am assuming that as each instance is using exactly the same amount of memory (17 megabytes) that this is some kind of preset - if I refresh other pages performing other SQL, the value is still 17M.

My question is this - 17 megabytes seems rather excessive for the sql queries that are being run; how can I reduce the memory load that MySQL requires on my system?

Thanks!
-Colin

 

[KarveR]

its about right, on my production server the minimum is 16M per thread

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.