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, joce@presence-pc.com <joce@presence-pc.com> 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
> >> kevinold@gmail.com
> >>
> >> --
> >> MySQL General Mailing List
> >> For list archives: http://lists.mysql.com/mysql
> >> To unsubscribe: http://lists.mysql.com/mysql?unsub=joc@presence-pc.com
> >>
> >>
> >
> >
> >--
> >MySQL General Mailing List
> >For list archives: http://lists.mysql.com/mysql
> >To unsubscribe: http://lists.mysql.com/mysql?unsub=drbuettner@gmail.com
> >
> >
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=mbac@netgraft.com

--
Michael Bacarella <mbac@netgraft.com>

1-646-641-8662 (cell)

545 Eighth Avenue * Suite 401
New York, NY 10018

http://michael.bacarella.com/
http://netgraft.com/