Re: InnoDB Log Optimisation

[Iñigo Medina García]

Hi Ben,

> 
> Dear MySql,
> 
> I am trying to optimise InnoDB, and trying to find out how much of the
> innodb log file contains row data which has not been written to storage.
> 
> Therefore I can optimize the size of the log, keeping it low to reduce
> crash recovery time yet high enough to be useful.

:-)

> I can see the varaible 'Innodb_data_pending_writes' which may be what I
> need.  This is zero, I am not sure whether this means I have no
> uncommitted data in the log, or something else.
> 
> Can't find anything much on Google.
> 
> If any member can help me, would be very usesful :)

What spits "SHOW INNODB STATUS\G" ?

    Iñigo

> Regards,
> 
> Ben.
> 
> 
> *************************************************************************
> This e-mail is confidential and may be legally privileged. It is intended
> solely for the use of the individual(s) to whom it is addressed. Any
> content in this message is not necessarily a view or statement from Road
> Tech Computer Systems Limited but is that of the individual sender. If
> you are not the intended recipient, be advised that you have received
> this e-mail in error and that any use, dissemination, forwarding,
> printing, or copying of this e-mail is strictly prohibited. We use
> reasonable endeavours to virus scan all e-mails leaving the company but
> no warranty is given that this e-mail and any attachments are virus free.
> You should undertake your own virus checking. The right to monitor e-mail
> communications through our networks is reserved by us
> 
>  Road Tech Computer Systems Ltd. Shenley Hall, Rectory Lane, Shenley,
>  Radlett, Hertfordshire, WD7 9AN. - VAT Registration No GB 449 3582 17
>  Registered in England No: 02017435, Registered Address: Charter Court,
>  Midland Road, Hemel Hempstead,  Hertfordshire, HP2 5GE.
> *************************************************************************
> 


-- 
--------
Iñigo Medina García			
Librería Díaz de Santos		Madrid (Spain)
imedina@stripped		facilmejor@stripped