Re: Merge table limit - Jerry - com.mysql.lists.mysql

4 messages in com.mysql.lists.mysqlRe: Merge table limit

From	Sent On	Attachments
Jerry	08 Feb 2003 01:32
Jerry	09 Feb 2003 04:13
Diana Soares	11 Feb 2003 04:28
Jerry	11 Feb 2003 04:51

Subject:	Re: Merge table limit
From:	Jerry (jer...@metalcat.net)
Date:	02/11/2003 04:51:32 AM
List:	com.mysql.lists.mysql

Cheers.

The only limit I've hit so far on 365 tables, was the max number of open files, so I've ramped that up and its working fine at the moment.

Jerry

--------------------- Jeremy Hutchings Apps R&D Cable and Wireless

---------------------

Hi,

On Sat, 2003-02-08 at 09:33, Jerry wrote:

Hello all.

Does any one know, or can anyone point me in the direction of the limits of a number of tables I can put in a union of a merge table, I can figure out what the sql would be.

Don't know if there is a limit.. But you must take into account the number of file descriptors a merge table uses... Instead of only two per user, it would be number_of_tables+1 file descriptors per user.

So, maybe the limit is defined by the number of file descriptors your OS can have. (but i'm only assuming, i'm not shure).

I have daily tables for an application that average about 25000000 rows (2.5 million) , I want to make a merge table for a year that will encompass them all (i.e. 9.1 billion rows).

Has anyone had 365 tables in a merge table ? or more ?

Only less than 10.. :-(

Thanks Jerry

--------------------- Jeremy Hutchings Apps R&D Cable and Wireless

---------------------

To request this thread, e-mail <mysq...@lists.mysql.com> To unsubscribe, e-mail <mysql-unsubscribe-jerry=meta...@lists.mysql.com> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php