Cc: 'Gabriel PREDA'; mysql@lists.mysql.com
Subject: RE: mysterious speedup after doing "FLUSH TABLES"
Hi,
What about your table_cache setting ?
Is show status reporting a high number for Opened_tables ?
---
Regards,
Jocelyn Fournier
www.mesdiscussions.net
> I wil
cking issue, will grab the output of INNODB
STATUS the next time it happens.
Moritz
-Original Message-
From: Gabriel PREDA [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 12, 2006 11:22 AM
To: Moritz Möller
Subject: Re: mysterious speedup after doing "FLUSH TABLES"
See http://
speedup after doing "FLUSH TABLES"
What value do you have innodb_thread_concurency ?
There is a bug with that on 64bit machines !
--
Gabriel PREDA
Senior Web Developer
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.
Hello list,
we use MySQL 4.1.13 / InnoDB on Xeon em64t running Debian, kernel 2.6.8.
After a while, queries run slower and slower, although the CPU is >70% idle
and diskio is nearly zero. A simple select by primary key takes up to one
second. After doing a FLUSH TABLES the speed is up again.
I a