MySQL Forums
Forum List  »  InnoDB

Re: InnoDB Log Size
Posted by: Ben Clewett
Date: June 30, 2008 01:58AM

Eric,

Thanks for the information. This gives a useful rule.

I want to take this a little further and try to find a measurement of current use of the log file in order to judge how successful my chosen policy is. Then I can design it to exactly the right size.

Looking as SHOW INNODB STATUS and I usually get something like:

---
LOG
---
Log sequence number 130 2804246616
Log flushed up to 130 2804246436
Last checkpoint at 130 2614827546
0 pending log writes, 0 pending chkp writes
53678835 log i/o's done, 52.43 log i/o's/second

This server is heavily used with up to 500 DML statements a second. This seems to suggest that the log file is always flushed concurrently. I never get pending writes or chkp writes.

In which case is there any point in having a log file of more than a few MB? Or even a few KB? I am misunderstanding what the log file is used for?

Thanks for any information...

Ben Clewett

Options: ReplyQuote


Subject
Views
Written By
Posted
3842
June 26, 2008 09:04AM
1871
June 26, 2008 09:46AM
Re: InnoDB Log Size
1809
June 30, 2008 01:58AM
1687
June 30, 2008 03:55AM


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.