importing big database, some help please

M

mr-cracker

Verified User
Joined
Sep 17, 2009
Messages
54
hi all,

i have database size 2.68GB on my server, used this commmand to import it yesterday
mysql -u user-p dbname < name.sql

the process was very fast but when it reached post indexes it becamse really really slow, after 14 hours of importing it gave an error saying "SSH terminated bcuz system is doing a HALT" i became really :mad:

i changed my.cnf and gave some more reasources to bufer size and others, and started importing again but its still slow.

Any help guys, i'm really of need of this
its vbulletin forum database if that helps

regards
 
Isn't a halt a system shutdown or power off?
Halt notes that the system is being brought down in the file /var/log/wtmp, and then either tells the kernel to halt, reboot or poweroff the system.
Click to expand...
 
i know friend, for some reason the system brought down, but that is not my problem my problem is to wait long long hours to import 2.68GB database. any solution for that??
 
i found better solutuin, for everyone having the same problem, edit /etc/my.cnf and change it to the following


for 1-2GB ram us this
[mysqld]
safe-show-database
skip-innodb
max_connections = 750
key_buffer = 128M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1024
thread_cache_size = 128
wait_timeout = 7200
connect_timeout = 10
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 2M
query_cache_size = 64M
query_cache_type = 1
tmp_table_size = 64M
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 64M

[mysqld_safe]
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
Click to expand...


for 3GB ram server try this one


[mysqld]
safe-show-database
skip-innodb
max_connections = 750
key_buffer = 192M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1500
thread_cache_size = 128
wait_timeout = 7200
connect_timeout = 10
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 3M
query_cache_size = 128M
query_cache_type = 1
tmp_table_size = 128M
read_rnd_buffer_size = 1M
bulk_insert_buffer_size = 64M

[mysqld_safe]
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
Click to expand...
 
You must log in or register to reply here.
Back
Top