Re: InnoDB Writes blocking Reads

2005-04-24 Thread Andy McCurdy
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

Re: InnoDB Writes blocking Reads

2005-04-21 Thread Andy McCurdy
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

InnoDB Writes blocking Reads

2005-04-21 Thread Andy McCurdy
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