Jon,
So how do I optimize memory usage? Where to start ?
If your server is compiled with debug=full, the command
mysqladmin proc stat
shows you total server memory use. Look in the manual at
How MySQL uses Memory
SHOW VARIABLES (for all vars that control server memory use)
I have a small PHP website that gets a fair amount of traffic. It's a
simple layout with two tables. I average about 50 concurrently open
apache sessions and 40 open mysql connections. I am calling for
persistent connections from the mySQL/PHP API.
But here is the kicker. Each mySQL thread
In the last episode (Oct 07), Jon Shoberg said:
I have a small PHP website that gets a fair amount of traffic. It's
a simple layout with two tables. I average about 50 concurrently open
apache sessions and 40 open mysql connections. I am calling for
persistent connections from the mySQL/PHP
Ok,
So how do I optimize memory usage? Where to start ?
-Jon
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 07, 2002 9:16 PM
To: Jon Shoberg
Cc: [EMAIL PROTECTED]
Subject: Re: .Optimize mySQL memory usage ? 41MB threads ??
In the last
In the last episode (Oct 07), Jon Shoberg said:
From: Dan Nelson [mailto:[EMAIL PROTECTED]]
In the last episode (Oct 07), Jon Shoberg said:
I have a small PHP website that gets a fair amount of traffic.
It's a simple layout with two tables. I average about 50
concurrently open
mySQL memory usage ? 41MB threads ??
In the last episode (Oct 07), Jon Shoberg said:
I have a small PHP website that gets a fair amount of traffic. It's
a simple layout with two tables. I average about 50 concurrently open
apache sessions and 40 open mysql connections. I am calling