Answered Very quick backup. Is this normal?

[Cecil]

I just done a manual backup of my database for the first time on new CentOS 64bit Xen hosted environment. The database was moved from CentOS 32bit and it did the backup in only 3 seconds. Is that normal, or is it acceptable when running on SSD?

# /usr/dlc/bin/probkup online report report.bkp

68751 active blocks out of 68795 blocks in report will be dumped. (6686)
256 BI blocks will be dumped. (6688)
Backup requires an estimated 539.7 MBytes of media. (9285)
Restore would require an estimated 69079 db blocks using 539.1 MBytes of media. (9286)
Backed up 69007 db blocks in 00:00:03
Wrote a total of 1970 backup blocks using 523.3 MBytes of media. (13625)

Backup complete. (3740)

OE: 11.3 64bit
OS: CentOS Linux 6.4 64bit
Kernel and CPU Linux: 2.6.32.46-xenU on x86_64
Processor: Intel(R) Xeon(R) CPU E5-2630 0 @ 2.30GHz, 2 cores

 

[cj_brandt]

the db is 500mb so the backup will be pretty quick.

a good test for a backup is to restore the backup to a new database and ensure it works.

 

[LarryD]

Cecil, from SSD's we backup 3 databases (full backups), on average in about 14 minutes.

Last backup we did:
95GB (13:30), 2GB (19 seconds), and 2GB (14 seconds)

500mb in that short of time falls within the values we see on a regular basis.

 

[Rob Fitzpatrick]

I looked at our dev DB backups from last night. A 680 MB DB online backup finished in about 5 seconds (10K SAS disks, RAID 1).

 

[TomBascom]

If you need it to be slower pull out the SSD and mail it to me...

 

[Cecil]

Just did a quick database restore and it only took 4 seconds to read 69007 db blocks but the total real time was 25.211 seconds from start to finish. Hey, this is still faster than what I had before.

Oh BTW Tom, sorry I can't give you any SSD as they are not mine, but I will give you a sterling thumbs up for effort.

 

[casinologin]

Just did a quick database restore and it only took 4 seconds to read 69007 db blocks but the total real time was 25.211 seconds from start to finish. Hey, this is still faster than what I had before.

Oh BTW Tom, sorry I can't give you any SSD as they are not mine, but I will give you a sterling thumbs up for effort.

evewrything is normal, if you are able to restore the backup completely