Did we already talk about the log flush method you're using with
InnoDB? I don't recall...
Log flush method? As described by Mysql documentation:
If you can afford the loss of some latest committed transactions, you
can set the `my.cnf' parameter |innodb_flush_log_at_trx_commit| to 0.
|In
OK, I'll qualify the statement. Software RAID-5 on my adaptec SCSI
controller and external disk array logs a message "aic7xxx_abort returns
0x2003" to /var/log/messages and the whole array shuts down (and
anything else attached to the card, regardless of bus) for minutes at a
time before resta
On Fri, Nov 07, 2003 at 05:03:43PM -0600, William Baker wrote:
> Sorry for the slow reply. I was battling SCSI controller bugs as well
> as database issues. I have given up on the software raid for now
> because it is unstable.
Really? I've run Linux software RAID quite happily on several sys
Sorry for the slow reply. I was battling SCSI controller bugs as well
as database issues. I have given up on the software raid for now
because it is unstable.
Back to the subject at hand: performance.
You are right, the "load" is meaningless outside the context of a
specific machine...and of
On Mon, Nov 03, 2003 at 01:35:26PM -0600, William Baker wrote:
> It's hard to tell. The CPU is under a reasonable load (uptime shows 1.0
> - 2.0), no swapping, and the hard drive is churning away continually.
The "load average" is relatively meaningless. What's the actualy CPU
utilization as sh
On Mon, Nov 03, 2003 at 01:37:26PM -0600, William Baker wrote:
> Now why didn't I think of a single alter tablethat should certainly
> improve things. I'll give it a try.
Oh, yeah. That will probably help A LOT.
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<
Now why didn't I think of a single alter tablethat should certainly
improve things. I'll give it a try.
bbaker
William Baker wrote:
I am using a pentium4-2GHz machine with Linux-RH9 installed and 1GB
RAM. The database is on a dedicated SCSI drive with an Adaptec
UltraScsi3 controller
It's hard to tell. The CPU is under a reasonable load (uptime shows 1.0
- 2.0), no swapping, and the hard drive is churning away continually.
One thing that makes me think I am doing something wrong is that if I
build the indexes on a 60MB file, it still takes a considerable amount
of time (6-
On Mon, Nov 03, 2003 at 11:18:55AM -0600, William Baker wrote:
> I am using a pentium4-2GHz machine with Linux-RH9 installed and 1GB
> RAM. The database is on a dedicated SCSI drive with an Adaptec
> UltraScsi3 controller which shows 40MHz bus connecting the 10K-RPM
> disks. (Fairly new, fairl
William Baker wrote:
I am using a pentium4-2GHz machine with Linux-RH9 installed and 1GB
RAM. The database is on a dedicated SCSI drive with an Adaptec
UltraScsi3 controller which shows 40MHz bus connecting the 10K-RPM
disks. (Fairly new, fairly capable, low-end server grade.)
I have a 2GB
10 matches
Mail list logo
