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)
[EMAIL PROTECTED] [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
