MySQL Forums
Forum List  »  InnoDB

Re: log sequence number
Posted by: Aftab Khan
Date: April 16, 2009 07:23AM

mysql> select (3838334638 - 3836410803 )/1024/1024;
based on your findings, approximatly 1.8M bytes wrote into log file size

B/W log file size should be 25%-100% of the innodb buffer pool size, your buffer pool is 6G compared to 512M log file size.



Edited 1 time(s). Last edit at 04/16/2009 07:31AM by Aftab Khan.

Options: ReplyQuote


Subject
Views
Written By
Posted
3611
April 15, 2009 01:01PM
4330
April 16, 2009 04:17AM
Re: log sequence number
2191
April 16, 2009 07:23AM
2181
April 16, 2009 09:29AM
2076
April 17, 2009 05:43AM


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.