-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Steve --
...and then Steve Vernon said...
%
% Hiya!
Hi!
%
% Thanks for the quick reply!!!
Sure thing :-)
%
% But dosen't it make more sense to have 20 0.5 Gig files rather than one 10
% Gig file?
I wouldn't think so. The manual doesn't seem to think so, either:
* The RAID_TYPE option will help you to break the 2G/4G limit for
the MyISAM datafile (not the index file) on operating systems that
don't support big files. Note that this option is not recommended
for filesystem that supports big files! You can get more speed
from the I/O bottleneck by putting RAID directories on different
physical disks. RAID_TYPE will work on any OS, as long as you have
configured MySQL with --with-raid. For now the only allowed
RAID_TYPE is STRIPED (1 and RAID0 are aliases for this). If you
specify RAID_TYPE=STRIPED for a MyISAM table, MyISAM will create
RAID_CHUNKS subdirectories named 00, 01, 02 in the database
directory. In each of these directories MyISAM will create a
table_name.MYD. When writing data to the datafile, the RAID
handler will map the first RAID_CHUNKSIZE *1024 bytes to the first
file, the next RAID_CHUNKSIZE *1024 bytes to the next file and so
on.
%
% I know you can split files, but basically because we have raid I trust it to
% a point. But I would like to make backup's. It costs a lot to have our
Ah! Now that's a completely different problem.
Go ahead and figure out what your real issue is and then let us know. Go
ahead; I'll wait.
OK. If it's still backups, let's go on :-)
% server provider to do backup's themselves. We can't afford replication and
% backups at the moment. So I plan to stop MySQL. Copy the database files to a
How on earth do you have 10G of data to handle without any budget for
replication or backups? What happens when your hardware breaks, or even
someone fat-fingers a delete command?
% temp directory. THen download them at my leisure. Oh and I suppose I need to
% start MySQL then! ;-) The backup will be to Windows 2000, and I want to be
% able to use the local copy of the files.
OK; I don't know how large Win2k can go, but you might need to have
smaller files.
%
% So if I have smaller files, I can download them, and keep a local copy.
Sure.
% Theres no way I want to start downloading a 10 Gig file from the server. Ok
That would be a bit tough, admittedly. You might look into unison or
rsync for such...
% I can do it, I have a download manager etc, Iv'e downloaded bigger. But I
% guess it must be a massive strain on the server sending the data, and we
Not really; I'm sure the network is your bottleneck.
% dont have that fast an internet connection so it's easier. We only have 512
% broadband and it sometimes messes up files larger than 2 Gig. The download
I can imagine. That's a fair bit of data to pull over a fairly small
line.
% manager realises there is a problem, seems to backtrack or something, so
% takes ages. Cable is not available where I live.
Get a T1 :-)
%
% If we go beyond 10 Gigs, it just increases the complexity.
Yep.
%
% Do you or anyone know of any serious speed differences between having one
% file or 20 smaller files for one table? With one files, isn't there a worry
% if it gets corrupted you loose the lot?
I'm sure that's not an issue; if you're going to lose a bit, it's just as
likely to happen in one of twenty small files as in one large file.
%
% A couple of years ago I looked into big tables for myself and everyone said
% you need the raid option in MySQL. Now I'm not sure!
That's probably because ext3 and reiser and xfs weren't around :-)
%
% Thanks,
%
% Steve
HTH & HAND
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health"
http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg!
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (FreeBSD)
iD8DBQE/oxOnGb7uCXufRwARAqFYAJwOmQS2rSj3ETIdh8W58LQTZO8mPwCg3/+b
xgBqMyArFJveTUjm+eW/NyY=
=zQ3E
-----END PGP SIGNATURE-----
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
