4 messages in com.mysql.lists.mysqlSCSI Tape Backups
FromSent OnAttachments
Mark Maggelet10 Apr 2000 19:17 
Matthew Clark10 Apr 2000 19:33 
sin...@mysql.com11 Apr 2000 06:06 
sin...@mysql.com11 Apr 2000 06:07 
Subject:SCSI Tape Backups
From:Matthew Clark (m.r.@btinternet.com)
Date:04/10/2000 07:33:00 PM
List:com.mysql.lists.mysql

Hi guys n gals,

I would like to backup my data to a tape drive.. but I can't really afford to lock everyone out of the system when I do this.. is it necessary for me to obtain a READ LOCK to backup the data?

Note that I would not be using MySQL to do the backup but actually copying the actual files to the backup device..

What are the issues with this?

Regards,

Matthew Clark.

-----Original Message----- From: Mark Maggelet [mailto:magg@mminternet.com] Sent: 11 April 2000 03:18 To: mys@lists.mysql.com Subject: how big is too big for key_buffer_size

for the variable key_buffer_size, the documentation reads: Index blocks are buffered and are shared by all threads. key_buffer_size is the size of the buffer used for index blocks. Increase this get better index handling (for all reads and multiple writes) to as much as you can afford. If you make this too big the system will starte to page and go REAL slow

how big is too big? I have 250M worth of ISD files, so I want to make it 250M, is this ok on a linux 2.2 machine with 1Gig of ram?

thanks, - Mark

--

--------------------------------------------------------------------- Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail mysq@lists.mysql.com

To unsubscribe, send a message to: <mysql-unsubscribe-m.r.clark=btin@lists.mysql.com>