I'm running MySQL 4.1.9 on FC3 and it seems to be a resource hog. (understated) I'm wondering if anyone can provide any tips as to how to conserve resources. Currently, I see 10 instances of mysqld running. For my application of MySQL, I don't require a large amount of resources allocated to mysqld.
7085 mysql 16 0 90060 17m 2608 S 0.0 3.5 0:00.05 mysqld 7086 mysql 16 0 90060 17m 2608 S 0.0 3.5 0:00.00 mysqld 7087 mysql 20 0 90060 17m 2608 S 0.0 3.5 0:00.00 mysqld 7088 mysql 24 0 90060 17m 2608 S 0.0 3.5 0:00.00 mysqld 7089 mysql 24 0 90060 17m 2608 S 0.0 3.5 0:00.00 mysqld 7090 mysql 20 0 90060 17m 2608 S 0.0 3.5 0:00.00 mysqld 7091 mysql 16 0 90060 17m 2608 S 0.0 3.5 0:00.00 mysqld 7092 mysql 16 0 90060 17m 2608 S 0.0 3.5 0:00.00 mysqld 7093 mysql 16 0 90060 17m 2608 S 0.0 3.5 0:00.00 mysqld 7094 mysql 15 0 90060 17m 2608 S 0.0 3.5 0:00.00 mysqld
Found my answer from the helpful peeps at mysql.com. I put it here for reference. MySQL is not at all the resource hog I claimed it to be. Instead of 10 separate processes, they were 10 threads running a single process. Therefore, instead of 17M x 10, it was really simply 17M x 1. Not bad at all!
-- Regards, Matt Florido (Newly acquainted with FC3)
