on 05/19/2004 08:36 AM, Brent Baisley at [EMAIL PROTECTED] wrote:
> I wouldn't upgrade until you know where the bottleneck is (CPU, disk,
> network, or RAM). Since you are using "professional" software, I
> wouldn't try to change the queries. Have you made changes to your
> my.cnf file? Since you
On Wed, May 19, 2004 at 11:36:38AM -0400, Brent Baisley wrote:
> I wouldn't upgrade until you know where the bottleneck is (CPU, disk,
> network, or RAM). Since you are using "professional" software, I
> wouldn't try to change the queries. Have you made changes to your
> my.cnf file? Since you h
I wouldn't upgrade until you know where the bottleneck is (CPU, disk,
network, or RAM). Since you are using "professional" software, I
wouldn't try to change the queries. Have you made changes to your
my.cnf file? Since you have enough ram to hold all the data, ram is
probably not your bottlene
On Wed, May 19, 2004 at 08:47:28AM -0400, Brent Baisley wrote:
> Something that small shouldn't really need optimizing. What is the size
> of your data (mb?, gb?) and what does your query look like? If you are
> doing a wild card search on a large text field without a full text
> index, then tho
Something that small shouldn't really need optimizing. What is the size
of your data (mb?, gb?) and what does your query look like? If you are
doing a wild card search on a large text field without a full text
index, then those times may be the best you're going to get. Many times
it's about op
sorry Egor Egorov, Mutt sent the mail to your private inbox ;)
resending to the mailing list.
On Wed, May 19, 2004 at 02:02:29PM +0300, Egor Egorov wrote:
> Mohammed Sameer <[EMAIL PROTECTED]> wrote:
> > I'm running a MySQL server on a duel P III 1G, with 2 GB RAM.
> > MySQL 4.0.18 compiled from s
Mohammed Sameer <[EMAIL PROTECTED]> wrote:
> I'm running a MySQL server on a duel P III 1G, with 2 GB RAM.
> MySQL 4.0.18 compiled from source.
>
> We have 2 webservers running apache, And this is the backend database server.
> The server is really slow.
> a select on a table with 138,247 rows take
