SEO

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

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.
************************************************** ***********************

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@diazdesantos.es facilmejor@gmail.com

Thanks for the idea. Unfortunately nothing I can easily use (for
instance in MySql Administrator) to log and monitor the lag in bytes
between log writes and row data writes.

Iñigo Medina García wrote:
> 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.
>> ************************************************** ***********************
>>
>
>

************************************************** ***********************
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.
************************************************** ***********************