Skip to main content
Solved

MySQL XtraBackup slow restore


Forum|alt.badge.img+3

I’m testing my restore times and i’m running into extremely low xtrabackup restore times.

A full VM restore is able to achieve 1,3gbps but MySQL restore only get to around 40mbps (I know it’s not the same but still)

 

5900  24e0  10/04 15:15:33 544344 33-# [FSRESTHEAD ] Stats: AppTy 104, AF 1, Seeks 1/1/1, WrkItms 161353, MxRdr (Bsy-Tot: 1-15, Pnd 0), MsgsRcvd 24, QLen 20, LstMsg 536872180(536872180)
5900  24e0  10/04 15:15:33 544344 33-# [FSRESTHEAD ] Stats: [AllocBuf Time] Exp Avg [0.24], Total Avg [0.04], Total Time [11388.53], Total Count [322699]
5900  24e0  10/04 15:15:33 544344 33-# [FSRESTHEAD ] Stats: [AllocBuf Speed] Curr Avg [0.25] MB/Sec, Bytes [154177584]; Total Avg [1.77] MB/Sec, Bytes [21135493704]
5900  24e0  10/04 15:15:33 544344 33-# [FSRESTHEAD ] Stats: [MediaRead Time] Exp Avg [0.00], Total Avg [0.00], Total Time [4.43], Total Count [322699]
5900  24e0  10/04 15:15:33 544344 33-# [FSRESTHEAD ] Stats: [MediaRead Speed] Curr Avg [651.85] MB/Sec, Bytes [20668482]; Total Avg [783.46] MB/Sec, Bytes [3640384783]

iperf3 test between media agent and restore destination get 2gbps

[ ID] Interval           Transfer     Bandwidth       Retr  Cwnd
[  4]   0.00-1.00   sec   241 MBytes  2.02 Gbits/sec    0    867 KBytes       
[  4]   1.00-2.00   sec   238 MBytes  1.99 Gbits/sec    0   1.18 MBytes       
[  4]   2.00-3.00   sec   235 MBytes  1.97 Gbits/sec    0   1.43 MBytes       
[  4]   3.00-4.00   sec   234 MBytes  1.96 Gbits/sec    0   1.64 MBytes       
[  4]   4.00-5.00   sec   234 MBytes  1.96 Gbits/sec    0   1.83 MBytes       
[  4]   5.00-6.00   sec   232 MBytes  1.95 Gbits/sec    0   1.99 MBytes       
[  4]   6.00-7.00   sec   232 MBytes  1.95 Gbits/sec    0   2.01 MBytes       
[  4]   7.00-8.00   sec   214 MBytes  1.79 Gbits/sec    0   2.01 MBytes       
[  4]   8.00-9.00   sec   234 MBytes  1.96 Gbits/sec    0   2.01 MBytes       
[  4]   9.00-10.00  sec   232 MBytes  1.95 Gbits/sec    0   2.01 MBytes       
[  4]  10.00-11.00  sec   234 MBytes  1.96 Gbits/sec    0   2.01 MBytes       
[  4]  11.00-12.00  sec   234 MBytes  1.96 Gbits/sec    0   2.01 MBytes       
[  4]  12.00-13.00  sec   235 MBytes  1.97 Gbits/sec    0   2.01 MBytes       
[  4]  13.00-14.00  sec   234 MBytes  1.96 Gbits/sec    0   2.01 MBytes       
[  4]  14.00-15.00  sec   235 MBytes  1.97 Gbits/sec    0   2.01 MBytes       
[  4]  15.00-16.00  sec   228 MBytes  1.91 Gbits/sec    0   2.01 MBytes       
[  4]  16.00-17.00  sec   236 MBytes  1.98 Gbits/sec    0   2.01 MBytes       
[  4]  17.00-18.00  sec   235 MBytes  1.97 Gbits/sec    0   2.01 MBytes       
[  4]  18.00-19.00  sec   234 MBytes  1.96 Gbits/sec    0   2.01 MBytes       
[  4]  19.00-20.00  sec   228 MBytes  1.91 Gbits/sec    0   2.01 MBytes       
- - - - - - - - - - - - - - - - - - - - - - - - -
[ ID] Interval           Transfer     Bandwidth       Retr
[  4]   0.00-20.00  sec  4.55 GBytes  1.95 Gbits/sec    0             sender
[  4]   0.00-20.00  sec  4.55 GBytes  1.95 Gbits/sec                  receiver

Ideas?


Self-hosted running 11.34.36

Best answer by Sunil

Hi @FQueiroloCeibal 

Are you using Full instance XtraBackup restore? Please confirm.

We made a performance fix related to full instance backup/restore in 11.34.37.

 

If you need you can install next MR pack or I can provide the update bundle link.

 

Thanks,

Sunil

View original
Did this answer your question?

4 replies

Sunil
Vaulter
Forum|alt.badge.img+13
  • Vaulter
  • 289 replies
  • Answer
  • October 4, 2024

Hi @FQueiroloCeibal 

Are you using Full instance XtraBackup restore? Please confirm.

We made a performance fix related to full instance backup/restore in 11.34.37.

 

If you need you can install next MR pack or I can provide the update bundle link.

 

Thanks,

Sunil


Forum|alt.badge.img+3
Sunil wrote:

Hi @FQueiroloCeibal 

Are you using Full instance XtraBackup restore? Please confirm.

We made a performance fix related to full instance backup/restore in 11.34.37.

 

If you need you can install next MR pack or I can provide the update bundle link.

 

Thanks,

Sunil



Yes I am using full instance xtrabackup

I’ll install the last release, test and update this post

 

thanks​​​​​​


Forum|alt.badge.img+3

I updated and restore performance skyrocketed!

Thanks!


Sunil
Vaulter
Forum|alt.badge.img+13
  • Vaulter
  • 289 replies
  • October 8, 2024
FQueiroloCeibal wrote:

I updated and restore performance skyrocketed!

Thanks!

Excellent! Thanks for the update.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings