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
Is that better?
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 qui
to souce code and using strace, I'm clueless as to how to
improve this situation. I think it's still way too high. I've tried
variations of all the system variables that appear to be relevant.
bbaker
On Mon, Nov 03, 2003 at 01:35:26PM -0600, William Baker wrote:
It's
If you insert records directly into the tables in mysql, then they only
have the rights you specifically specify. GRANT is smart enough to
handle a lot of the dirty-work for you. In particular, I like the:
GRANT SELECT on *.* to readonly@'%' identified by 'readonly';
This will create the user
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
n, though I suspect it is something else. I forgot to mention file
system is ext2.
bbaker
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
UltraScs
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 datafile with 10 indexe