Hi Scott, Log generation rate -
500MB size of log file is generated within minimum 3 mins to maximum of 20 mins depending on the database behavior. I did not understand the "fsync" stuff you mentioned. Please help me know how would fsync is related to log generation or logging host IPs in the log file ? Thanks Venkat On Tue, Aug 30, 2011 at 12:09 PM, Scott Marlowe <scott.marl...@gmail.com>wrote: > On Mon, Aug 29, 2011 at 11:55 PM, Venkat Balaji <venkat.bal...@verse.in> > wrote: > > If i notice high IO's and huge log generation, then i think Greg > Spileburg > > has suggested a good idea of using tcpdump on a different server. I would > > use this utility and see how it works (never used it before). Greg > > Spileburg, please help me with any sources of documents you have to use > > "tcpdump". > > There's also a lot to be said for dumping to a dedicated local drive > with fsync turned off. They're logs so you can chance losing them by > putting them on a cheap fast 7200 rpm SATA drive. If your logs take > up more than a few megs a second then they are coming out really fast. > Do you know what your log generation rate in bytes/second is? >
