MySQL Forums
Forum List  »  Data Recovery

Mysql dump restore takes long time
Posted by: Dilshan Pelpolaarachchi
Date: January 29, 2014 05:05AM

Hi,
I have a mysql database which is having both myisam and innodb databases. Size is arround 150GB. I'm actually facing a problem with regard to mysql restoration. Though I can get the full DB backup within 2 hours of time, it takes more than 2 days to restore.

Appreciate if anyone can help me with this.

Server capacity:

16GB RAM
8 cores
215GB HDD
Server version: 5.5.35-0ubuntu0.12.04.1 (Ubuntu)

Following are the my.cnf file contents.

[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock


[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0

[mysqld]
#
# * Basic Settings
#
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
key_buffer_size = 4300M
max_allowed_packet = 1024M
thread_stack = 192K
thread_cache_size = 8
myisam_sort_buffer_size = 4300M
myisam-recover = BACKUP
max_connections = 200
#table_cache = 64
thread_concurrency = 10
query_cache_limit = 1M
query_cache_size = 16M
log_error = /var/log/mysql/error.log
[mysqldump]
quick
quote-names
max_allowed_packet = 16M

[mysql]
#no-auto-rehash # faster start of mysql but no tab completition

[isamchk]
key_buffer_size = 4300M

#
# * IMPORTANT: Additional settings that can override those from this file!
# The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/

Options: ReplyQuote


Subject
Views
Written By
Posted
Mysql dump restore takes long time
4984
January 29, 2014 05:05AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.