is be a
> performance bug in the query cache?
>
> What is your my.cnf like? How big is your table cache?
>
> Best regards,
>
> Heikki Tuuri
> Innobase Oy
> Foreign keys, transactions, and row level locking for MySQL
> InnoDB Hot Backup - a hot backup tool for InnoDB
/network/
- Original Message -
From: ""Andy McCurdy"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Friday, April 22, 2005 2:02 AM
Subject: Re: InnoDB Writes blocking Reads
I forgot to mention: we're running mysql version 4.0.23-standard-log --
Andy,
Can you send me the table layout and the script ? I'd like to try it
here on one my test systems running 4.0.23.
walt
Andy McCurdy wrote:
I haven't seen any other replies as of yet. After looking closer at
the innodb status dump, the last known deadlock occured several days
ago... so I don
Andy McCurdy wrote:
I forgot to mention: we're running mysql version 4.0.23-standard-log --
Official MySQL-standard binary. Here's the innodb status output during a
problematic period.
=
050421 15:29:46 INNODB MONITOR OUTPUT
I forgot to mention: we're running mysql version 4.0.23-standard-log --
Official MySQL-standard binary. Here's the innodb status output during a
problematic period.
=
050421 15:29:46 INNODB MONITOR OUTPUT
=
Per second averag
Andy McCurdy wrote:
I've been seeing some weirdness w/ MySQL and InnoDB over the past few days.
I have a database that's entirely using InnoDB. The database is roughly
4.5G (one datafile) and contains a little over 50 tables. The web
applications that hit this database do about 85-90% reads an
I've been seeing some weirdness w/ MySQL and InnoDB over the past few days.
I have a database that's entirely using InnoDB. The database is roughly
4.5G (one datafile) and contains a little over 50 tables. The web
applications that hit this database do about 85-90% reads and 10-15% writes.
Wh