RAM too, how are you on RAM? Obviously 100GB+ probably isn't going to fit in cache, but the usage pattern during slower periods might be causing killer thrashing.
On Thu, Dec 07, 2006 at 12:43:17PM -0600, Dan Buettner wrote: > 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] -- Michael Bacarella <[EMAIL PROTECTED]> 1-646-641-8662 (cell) 545 Eighth Avenue * Suite 401 New York, NY 10018 http://michael.bacarella.com/ http://netgraft.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]