Tuning InnoDB situation

2004-08-13 Thread Boyd E. Hemphill
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

Re: Tuning InnoDB situation

2004-08-13 Thread Ware Adams
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

RE: Tuning InnoDB situation

2004-08-13 Thread Victor Pendleton
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 need