Home  >  Article  >  Database  >  mysql备份时会拖慢整台机器性能,有什么调整方案?

mysql备份时会拖慢整台机器性能,有什么调整方案?

WBOY
WBOYOriginal
2016-06-06 09:43:481047browse

mysql备份

现在是每天凌晨3点半开始备份,全库打包压缩,现在备份一次要1个多小时,备份期间整台机器基本无法访问,无法进行数据库的任何操作。

应该如何改进?
做个主从数据库吗?

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn