I'm researching whether it is possible to store large amounts (30-70MB
files) into mysql columns. It looks as if a LONG BLOB could handle this,
however I read that the communications buffer size can only support up to 16
MB transfers. It also said that you could increase the size of the buffer,
I'm not an SQL expert but if FreeBSD supports 4GB files than you should
check your MAX_DATA_LENGTH properties on the table you're using. You can
do this by running SHOW TABLE STATUS on the table. I believe you can use
ALTER (or on create table statements) to change this value.
Hope this helps,
I'm writing in as to how I can contribute in the development in Parallel
databasing. I understand MySQL currently supports replications which is a
nice way of keeping live backups of a mysql server, however is hardly the
preferred method when dealing with load-balancing and redundancy, just