Hello List,

I am restoring a MySQL backup (about 40MB), and its taking well over 2 hours
to restore.

the area where its really hanging is when its importing the "BLOB"
There are about 1200 records, totaling about 10mb in size for these blobs.

I am running MyISAM,  my current memory settings read:

bulk_insert_buffer_size         805306368
innodb_additional_mem_pool_size 7340032
innodb_buffer_pool_awe_mem_mb   0
innodb_buffer_pool_size         318767104
innodb_log_buffer_size          4194304
join_buffer_size                131072
key_buffer_size                 164626432
myisam_sort_buffer_size         193986560
net_buffer_length               16384
read_buffer_size                61440
read_rnd_buffer_size            258048
sort_buffer_size                262136

Any ideas whats going on here?

its a 3 ghz P4, running 1024 ram.

Reply via email to