MySQL Forums
Forum List  »  InnoDB

Re: Larger than expected tmp files querying InnoDB format database
Posted by: Michael Lueck
Date: July 15, 2014 08:30PM

Michael Lueck Wrote:
-------------------------------------------------------
> Ahhh... perhaps they have gobs of RAM on their
> server? This client is paying for a 1GB slice of
> RAM. Perhaps given bookoo more RAM, MySQL might
> not have to swap to disk so much? Is that a
> plausible explanation of my peers drastically
> better results?

That seems to have hit the nail on the head. My peer in the CiviCRM forum has 8GB in their server we were comparing to. I think the technique was to throw hardware at a not well optimized app and the problems disappear.

Back to our client with this news.

I am thankful,

Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Larger than expected tmp files querying InnoDB format database
1075
July 15, 2014 08:30PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.