Do vmstat and top reveal anything about the server's performance? Can you
post the show status output?
-Original Message-
From: Boyd E. Hemphill
To: [EMAIL PROTECTED]
Sent: 8/13/04 12:17 PM
Subject: Tuning InnoDB situation
All:
I have been nosing about for some time now and think I
Boyd E. Hemphill wrote:
>But, some select and replace statements are taking an unusually long
>time. These seem to revolve around a couple of tables that are
>written to and read from very often.
>innodb_data_file_path = ibdata1:15G:autoextend
>We are running Gentoo Linux 2.6.4 on a dual AMD Op
All:
I have been nosing about for some time now and think I need some help.
The Problem:
Mytop is telling me that I am running no more than 1000 queries per second,
and the key efficiency is 100%. But, some select and replace statements are
taking an unusually long time. These seem to revolve a
