No backups (like innodb-backup) running during these times.
We have 16GB of RAM and are currently using about 8GB of it. We think we might have narrowed it down to a few hellish queries that are hitting a few tables that we recently converted to InnoDB from MyISAM. We're gonna convert them back to MyISAM tonight and see if that fixes it. Thanks for your help, Kevin On 12/7/06, Michael Bacarella <[EMAIL PROTECTED]> wrote:
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]
-- Kevin Old [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
