Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Huge daemon size
- Thread starter ScottA
- Start date
Maybe it's just me, but I don't really see 24MB as a 'huge' daemon. Also, remember that this size will depend on a couple of things:
1. The type of query you are running. The resources needed by queries can be literally anything. It just depends on what your database size is and how complicated your query is.
2. The amount of available memory on your system. If you have more RAM, It seems MySQL will 'stretch out' and use a bit more available memory to optimize itself. If your resources are limited, the daemon will limit it's memory use, at the expense of perhaps some speed and scaleability.
I developed my first PHP/MySQL web app on a Pentium 90 with 16MB of RAM (as a test server), and the database had fairly complex queries, but I had absolutely no trouble with memory use. (as I recall, the average MySQL daemon size was 5-7 MB)
1. The type of query you are running. The resources needed by queries can be literally anything. It just depends on what your database size is and how complicated your query is.
2. The amount of available memory on your system. If you have more RAM, It seems MySQL will 'stretch out' and use a bit more available memory to optimize itself. If your resources are limited, the daemon will limit it's memory use, at the expense of perhaps some speed and scaleability.
I developed my first PHP/MySQL web app on a Pentium 90 with 16MB of RAM (as a test server), and the database had fairly complex queries, but I had absolutely no trouble with memory use. (as I recall, the average MySQL daemon size was 5-7 MB)
- Status