The pv command is one that I really enjoy using but it's also one that I often forget about. You can't get a much more concise definition of what pv does than
In general, MySQL is quite fast at restoring data, but I observed that while restoring 20gb of backup its taking more than the usual time. This can happen when