On Fri, 28 Oct 2005, Richard Ryder wrote:
I recently tried to initiate a restore for someone who couldn't recall
the exact name of the files and directories they were interested in
restoring.
I had thisd happen not long ago.
The file server in question has a 2TB file system of which about 1TB is
full. There are a -lot- (in the millions) of tiny files on it. That
seems to be the cause of this problem.
Yes, MySQL gets rather large.
I used bconsole to select the desired backup to restore from. It
reports that when building the tree the query fails. I ran the query in
the mysql client and it failed with an out of memory error. The system
has 2G of RAM and 2G of swap.
It's not the system out of memory, it's MySQL.
I have 16Gb of swap but have never seen more than 2Gb in use for longer
than a few minutes.
Adjusting /etc/my.cnf is required for large (number, not filesize) backup
sets:
set-variable = key_buffer=1024M
set-variable = max_allowed_packet=256M
set-variable = table_cache=1280
set-variable = sort_buffer=1024M
set-variable = net_buffer_length=2400K
set-variable = myisam_sort_buffer_size=1024M
[mysqldump]
quick
set-variable = max_allowed_packet=256M
[isamchk]
set-variable = key_buffer=1000M
set-variable = sort_buffer=1000M
set-variable = read_buffer=256M
set-variable = write_buffer=256M
[myisamchk]
set-variable = key_buffer=1000M
set-variable = sort_buffer=1000M
set-variable = read_buffer=256M
set-variable = write_buffer=256M
-------------------------------------------------------
This SF.Net email is sponsored by the JBoss Inc.
Get Certified Today * Register for a JBoss Training Course
Free Certification Exam for All Training Attendees Through End of 2005
Visit http://www.jboss.com/services/certification for more information
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
