Roger,
On Sat, Mar 10, 2001 at 12:52:54AM +0100, Roger Westin wrote:
> Thanks Setve,
> but right now I cant change the filesystem, so I need to go for the
> with-raid option,
> I read the manual and recompiled my MySQL, but I still cant get bigger
> files than 2GB. Accordning to the manual it shall create sub directorys
> named 00, 01, 02, etc
> any idea?
>
Depending on your needs, MERGE tables may be useful. They allow you to
combine identically defined tables as one table for SELECT, UPDATE and
DELETE queries. An INSERT needs to be done on one of the actual tables,
whichever one you care to specify in the INSERT query.
Please refer to the documentation for more (dis-)advantages of MERGE
tables.
The documentation says that MERGE tables are still in beta. I've been
using them for a while now with just one problem that will be fixed in
3.23.34. In 3.23.33 you can prevent the problem by disabling concurrent
inserts or I can post the single-line fix to the 3.23.33 sources if you
want to compile your own binary. Oh yes, there's another problem with
query optimization where MySQL selects a sub-optimal index. You can
specify the index you want using the SELECT ... USE INDEX (myindex)
syntax. I still need to report this last one...
Regards,
Fred.
--
Fred van Engen XO Communications B.V.
email: [EMAIL PROTECTED] Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424 The Netherlands
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
