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]

Reply via email to