What determines the size of a mysqld instance?

[JWS]

I'm seeing the size of my mysqld instances around 76k each, and I'm just wondering what determines the size of the processes. I can't seem to find anything on the MySQL site about the size of the processes.

Also, how does one see the actual queries that are running in the mysqld processes?

[eva2000]

hard to explain since i'm not clear on that myself :o

but read
http://www.mysql.com/doc/O/p/Optimizing_the_Server.html

http://www.mysql.com/doc/M/e/Memory_use.html

[JWS]

Still trying to figure this goofy thing out, George. I removed the Usenet hack just to see if that would help -- nada. VO upgraded the kernel -- didn't seem to help. Reduced the wait_timeout and interactive_wait_timeout to around 5 minutes.

The mysqld processes seem to be in the 65k range each. Still digging on the MySQL newsgroups and archives.

I just don't see why that CPU is pegged at 2.5-5.5 all the time.

[eva2000]

65MB each you mean? that's normally for your my.cnf settings mine are slight smaller at 47 - 50MB each

you memory usage doesn't seem to be the problem from when i last looked

if you want to lower memory used for each mysql process lower your key_buffer from 24M to 16M and lower join, sort and and record buffers by 2M each to something like 4 - 5M

restart mysql and you'll see each process smaller in memory usage but your memory usage is fine from what i saw

[JWS]

Let me throw this out there then.... would moving these 40-65MB processes in and out of memory not take some CPU cycles?

[eva2000]

Originally posted by JWS
Let me throw this out there then.... would moving these 40-65MB processes in and out of memory not take some CPU cycles? not sure really :o