Another thought is - do you have backups running during this time? Something that might be attempting to backup live the InnoDB files? We had similar problems with MySQL and backup software a while ago, though we used all-MyISAM.
Dan On 12/7/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hi, Do you use MySQL with a NPTL or a linuxthread glibc configuration ? Regards, Jocelyn Fournier www.mesdiscussions.net > Hello everyone, > > We have a 4 CPU master server running the 5.0.27 RPM x86_64 version of > MySQL with a mix of InnoDB and MyISAM tables. > > We normally run at 1500 queries/per second and lately, the server will > all of a sudden lock up and we are forced to restart mysql. > > This is not related to higher load, as it frequently happens during > our slowest load period (early AM). This is not related to any > significant code changes. > > We have recently converted about 20 of our largest and most frequently > used tables from MyISAM to InnoDB. The size of our InnoDB tables > collectively is about 95GB. > > I can provide my configuration if it is necessary, but was just > wondering if someone else might have experienced this and could > possibly point me in the right direction as to what might be causing > this. > > Thanks, > Kevin > -- > Kevin Old > [EMAIL PROTECTED] > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
