MySQL 4.1.9 - Requesting Optimization Tips
Matt Florido
matt at floridonet.com
Fri Feb 18 04:00:29 UTC 2005
Matt Florido wrote:
> 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)
More information about the fedora-list
mailing list