its a linux server fedora with 2GB ram, insert mostly used through the
update, no load or on cpu during that time
mysql> show status;
+++
| Variable_name | Value |
+++
| Aborted_clients
Some other info you can post to the list to help us zero in on the problem:
1) What is the SQL used to update the tables
2) What is the table structure? "Show Create Table mytablex"
3) How long does it take for how many rows?
4) How busy is the CPU when the updates are occuring?
5) Show Status -
In the last episode (Apr 18), tech user said:
> My mysql table has been created for long time, it increases day by
> day, and become huge. Right now a full scan to the table for the
> first time is very slow. So I was thinking to optimize it. This table
> is stored in many non-sequential disk fragm
Try to run an explain on the query to see how mysql optimizes it.
Also have a look at your system resources while the query runs to see if
you have a problem with memory/swapping.
I am not sure (since i've never used union), but my guess is that mysql
uses temporary tables for this, so maybe t
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)
Pe
: [EMAIL PROTECTED]
> Subject: Re: .Optimize 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
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
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:
> 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/
