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