Re: RAM requirements- new server
Posted by:
Rick James
Date: April 02, 2009 09:02PM
innodb_flush_log_at_trx_commit=0 -- one of the faster options. =1 is safer, but slow on cheap disk drives. -1 might be fast with your h/w RAID, assuming it has a write cache. Gory details:
http://mysql.secsup.org/doc/refman/5.1/en/innodb-parameters.html#sysvar_innodb_flush_log_at_trx_commit
"100 and 400 queries per second" -- I've seen InnoDB do a few thousand. Of course, it depends on how complicated each is.
I strongly recommend summary table(s). It can solve lots of perf problems (in certain situations, such as yours).
Subject
Views
Written By
Posted
12816
April 02, 2009 12:15AM
3839
April 02, 2009 01:17AM
3211
April 02, 2009 03:27PM
Re: RAM requirements- new server
2730
April 02, 2009 09:02PM
2499
April 03, 2009 12:54AM
2501
April 03, 2009 10:06AM
2430
April 05, 2009 09:49PM
2455
April 07, 2009 08:18AM
2392
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.