MySQL Forums
Forum List  »  Performance

Re: RAM requirements- new server
Posted by: A B
Date: April 02, 2009 03:27PM

Thanks, Rick.
As always, you are extremely, helpful. much appreciated.

The random access of the large file has been a point of conjecture. Having an outside viewpoint may break the stalemate...


The commit option- never sure about this one. Our setting is:
innodb_flush_log_at_trx_commit=0
Not sure if that is reasonable.
We have between 100 and 400 queries per second on the database.
I will check out the link you provided today.

RAID is h/w.
your last comment about the 'summary' tables is one i will pursue with the developer.


thanks, again.
A



Rick James Wrote:
-------------------------------------------------------
> 13/18 -- fine.
> Other ram things -- not much.
>
> 40GB table -- if randomly accessed, you will be
> effectively I/O bound in spite of your big RAM.
>
> file-per-table -- desirable.
>
> innodb_flush_method = O_DIRECT -- desirable,
> especially if you have good buffering in the Disk
> controller.
>
> innodb_flush_log_at_trx_commit -- this can make
> the biggest diff in performance.
> More info:
> http://forums.mysql.com/read.php?24,213851,214241
>
> Check the details of your RAID.
> * Controller or software? (hdw is better)
> * Onboard write cache? (very desirable)
> * Write caching on drives, themselves? (probably
> should turn off)
>
> For many queries, RAID-5 is as fast as RAID-10.
>
> Your overnight stuff could probably be turned into
> summary tables that can be maintained "up to the
> minute" without noticeable performance hit. But
> that is another discussion.

Options: ReplyQuote


Subject
Views
Written By
Posted
12402
A B
April 02, 2009 12:15AM
3744
April 02, 2009 01:17AM
Re: RAM requirements- new server
3110
A B
April 02, 2009 03:27PM
2640
April 02, 2009 09:02PM
2413
A B
April 03, 2009 12:54AM
2403
April 03, 2009 10:06AM
2354
A B
April 05, 2009 09:49PM
2379
April 07, 2009 08:18AM
2323
A B
April 08, 2009 05:40PM


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.