2nd-phase is very slow

[Evgeniy Stepchenko]

2nd-phase is InnoDB: Progress in percents: 0 1 2 3 4 5 6
it is VERY slow now

How to improve:
...

[Yasufumi Kinoshita (yasufumi-kinoshita)]

Basically, 2nd-phase of prepare is slow. It should be random read IO bound to applying transaction log.

I have changed polling period of buf_read_recv_pages(), and increased IO threads.
They may be helpful for the performance of the 2nd-phase when we use based on RAID storage.

[Yasufumi Kinoshita (yasufumi-kinoshita)]

Sorry, the changes are at

http://bazaar.launchpad.net/~percona-dev/percona-xtrabackup/trunk/revision/41

[Vadim Tkachenko (vadim-tk)]

Yasufumi,

I see you made hard 10 io-threads, may be we should be able to configure
that ?

Yasufumi Kinoshita wrote:
> Sorry, the changes are at
>
> http://bazaar.launchpad.net/~percona-dev/percona-
> xtrabackup/trunk/revision/41
>
> ** Changed in: percona-xtrabackup
> Status: Confirmed => Fix Committed
>
> ** Changed in: percona-xtrabackup
> Assignee: (unassigned) => Yasufumi Kinoshita (yasufumi-kinoshita)
>

--
Vadim Tkachenko, CTO
Percona Inc.
ICQ: 369-510-335, Skype: vadimtk153, Phone [phone]
MySQL Performance Blog - http://www.mysqlperformanceblog.com
MySQL Consulting http://www.percona.com/

  Attend the 2009 Percona Performance Conference
  April 22-23 - http://conferences.percona.com/

[Yasufumi Kinoshita (yasufumi-kinoshita)]

We can set by innodb_file_io_threads.
But currently, it is set to 10 threads if it is under 10. over 10 is configurable.

In recovery process, read IO threads do the recovery after the each read of page.
So I think the 10 threads may be profitable even if single HDD is used.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXB-256