By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,564 Members | 1,070 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,564 IT Pros & Developers. It's quick & easy.

Merge Table: Too many open files

P: n/a
Hello,

my problem:

I merged about 1.000 Tables with

Create table name (variables) type=merge
union=(table1,table2,...,table1000);

MySQL now creates a tables, but I can't open it. Everytime I get the
message: Error 24. Which means: 'Too many open files'.

I tried to tune the server by setting the variable for
open_files_limit to 10.000. But still the same problem.

Can anybody help me?

Thanks,

Nils
Jul 19 '05 #1
Share this Question
Share on Google+
8 Replies


P: n/a
kr******@smileconsult.de (Nils) wrote in message news:<21**************************@posting.google. com>...
Hello,

my problem:

I merged about 1.000 Tables with

Create table name (variables) type=merge
union=(table1,table2,...,table1000);

MySQL now creates a tables, but I can't open it. Everytime I get the
message: Error 24. Which means: 'Too many open files'.

I tried to tune the server by setting the variable for
open_files_limit to 10.000. But still the same problem.

Can anybody help me?


Well, I don't think your problem is related to file handles...
Merging 1000 tables is usually a sign of a design problem. Can you
explain why you need to merge that many tables???
Jul 19 '05 #2

P: n/a
kr******@smileconsult.de (Nils) wrote in message news:<21**************************@posting.google. com>...
Hello,

my problem:

I merged about 1.000 Tables with

Create table name (variables) type=merge
union=(table1,table2,...,table1000);

MySQL now creates a tables, but I can't open it. Everytime I get the
message: Error 24. Which means: 'Too many open files'.

I tried to tune the server by setting the variable for
open_files_limit to 10.000. But still the same problem.

Can anybody help me?


Well, I don't think your problem is related to file handles...
Merging 1000 tables is usually a sign of a design problem. Can you
explain why you need to merge that many tables???
Jul 19 '05 #3

P: n/a
bs*****@yahoo.com (Benoit St-Jean) wrote in message news:<35**************************@posting.google. com>...
kr******@smileconsult.de (Nils) wrote in message news:<21**************************@posting.google. com>...
Hello,

my problem:

I merged about 1.000 Tables with

Create table name (variables) type=merge
union=(table1,table2,...,table1000);

MySQL now creates a tables, but I can't open it. Everytime I get the
message: Error 24. Which means: 'Too many open files'.

I tried to tune the server by setting the variable for
open_files_limit to 10.000. But still the same problem.

Can anybody help me?


Well, I don't think your problem is related to file handles...
Merging 1000 tables is usually a sign of a design problem. Can you
explain why you need to merge that many tables???

Because I have so many points. (Simple description *g*)

I have to deal with geographical points (x,y,z). They are stored in a
point table. For each point table I made a table with metainformation.
For an overwiev I want to join these metainformation.

Sure, I can put all metainformation in one table. But I want to have
each measurement in a separat table.

It has worked with about 1 Billion points from about 400 measurements.

Now I have less points but more measurements. About 1000. And I tried
the same architecture.
Jul 19 '05 #4

P: n/a
bs*****@yahoo.com (Benoit St-Jean) wrote in message news:<35**************************@posting.google. com>...
kr******@smileconsult.de (Nils) wrote in message news:<21**************************@posting.google. com>...
Hello,

my problem:

I merged about 1.000 Tables with

Create table name (variables) type=merge
union=(table1,table2,...,table1000);

MySQL now creates a tables, but I can't open it. Everytime I get the
message: Error 24. Which means: 'Too many open files'.

I tried to tune the server by setting the variable for
open_files_limit to 10.000. But still the same problem.

Can anybody help me?


Well, I don't think your problem is related to file handles...
Merging 1000 tables is usually a sign of a design problem. Can you
explain why you need to merge that many tables???

Because I have so many points. (Simple description *g*)

I have to deal with geographical points (x,y,z). They are stored in a
point table. For each point table I made a table with metainformation.
For an overwiev I want to join these metainformation.

Sure, I can put all metainformation in one table. But I want to have
each measurement in a separat table.

It has worked with about 1 Billion points from about 400 measurements.

Now I have less points but more measurements. About 1000. And I tried
the same architecture.
Jul 19 '05 #5

P: n/a
kr******@smileconsult.de (Nils) wrote in message news:<21**************************@posting.google. com>...
bs*****@yahoo.com (Benoit St-Jean) wrote in message news:<35**************************@posting.google. com>...
kr******@smileconsult.de (Nils) wrote in message news:<21**************************@posting.google. com>...
Hello,

my problem:

I merged about 1.000 Tables with

Create table name (variables) type=merge
union=(table1,table2,...,table1000);

MySQL now creates a tables, but I can't open it. Everytime I get the
message: Error 24. Which means: 'Too many open files'.

I tried to tune the server by setting the variable for
open_files_limit to 10.000. But still the same problem.

Can anybody help me?


Well, I don't think your problem is related to file handles...
Merging 1000 tables is usually a sign of a design problem. Can you
explain why you need to merge that many tables???

Because I have so many points. (Simple description *g*)

I have to deal with geographical points (x,y,z). They are stored in a
point table. For each point table I made a table with metainformation.
For an overwiev I want to join these metainformation.

Sure, I can put all metainformation in one table. But I want to have
each measurement in a separat table.

It has worked with about 1 Billion points from about 400 measurements.

Now I have less points but more measurements. About 1000. And I tried
the same architecture.


Well, have a look at :
http://www.mysql.com/doc/en/MERGE.html

Especially read the section on MERGE table disadvantages, it talks
about file handles...

I'd say try to change your design...
Jul 19 '05 #6

P: n/a
kr******@smileconsult.de (Nils) wrote in message news:<21**************************@posting.google. com>...
bs*****@yahoo.com (Benoit St-Jean) wrote in message news:<35**************************@posting.google. com>...
kr******@smileconsult.de (Nils) wrote in message news:<21**************************@posting.google. com>...
Hello,

my problem:

I merged about 1.000 Tables with

Create table name (variables) type=merge
union=(table1,table2,...,table1000);

MySQL now creates a tables, but I can't open it. Everytime I get the
message: Error 24. Which means: 'Too many open files'.

I tried to tune the server by setting the variable for
open_files_limit to 10.000. But still the same problem.

Can anybody help me?


Well, I don't think your problem is related to file handles...
Merging 1000 tables is usually a sign of a design problem. Can you
explain why you need to merge that many tables???

Because I have so many points. (Simple description *g*)

I have to deal with geographical points (x,y,z). They are stored in a
point table. For each point table I made a table with metainformation.
For an overwiev I want to join these metainformation.

Sure, I can put all metainformation in one table. But I want to have
each measurement in a separat table.

It has worked with about 1 Billion points from about 400 measurements.

Now I have less points but more measurements. About 1000. And I tried
the same architecture.


Well, have a look at :
http://www.mysql.com/doc/en/MERGE.html

Especially read the section on MERGE table disadvantages, it talks
about file handles...

I'd say try to change your design...
Jul 19 '05 #7

P: n/a
bs*****@yahoo.com (Benoit St-Jean) wrote in message news:<35**************************@posting.google. com>...
kr******@smileconsult.de (Nils) wrote in message news:<21**************************@posting.google. com>...
bs*****@yahoo.com (Benoit St-Jean) wrote in message news:<35**************************@posting.google. com>...
kr******@smileconsult.de (Nils) wrote in message news:<21**************************@posting.google. com>...
> Hello,
>
> my problem:
>
> I merged about 1.000 Tables with
>
> Create table name (variables) type=merge
> union=(table1,table2,...,table1000);
>
> MySQL now creates a tables, but I can't open it. Everytime I get the
> message: Error 24. Which means: 'Too many open files'.
>
> I tried to tune the server by setting the variable for
> open_files_limit to 10.000. But still the same problem.
>
> Can anybody help me?

Well, I don't think your problem is related to file handles...
Merging 1000 tables is usually a sign of a design problem. Can you
explain why you need to merge that many tables???

Because I have so many points. (Simple description *g*)

I have to deal with geographical points (x,y,z). They are stored in a
point table. For each point table I made a table with metainformation.
For an overwiev I want to join these metainformation.

Sure, I can put all metainformation in one table. But I want to have
each measurement in a separat table.

It has worked with about 1 Billion points from about 400 measurements.

Now I have less points but more measurements. About 1000. And I tried
the same architecture.


Well, have a look at :
http://www.mysql.com/doc/en/MERGE.html

Especially read the section on MERGE table disadvantages, it talks
about file handles...

I'd say try to change your design...


I think you are right. OK, another weekend work. *g*
Thanks.
Jul 19 '05 #8

P: n/a
bs*****@yahoo.com (Benoit St-Jean) wrote in message news:<35**************************@posting.google. com>...
kr******@smileconsult.de (Nils) wrote in message news:<21**************************@posting.google. com>...
bs*****@yahoo.com (Benoit St-Jean) wrote in message news:<35**************************@posting.google. com>...
kr******@smileconsult.de (Nils) wrote in message news:<21**************************@posting.google. com>...
> Hello,
>
> my problem:
>
> I merged about 1.000 Tables with
>
> Create table name (variables) type=merge
> union=(table1,table2,...,table1000);
>
> MySQL now creates a tables, but I can't open it. Everytime I get the
> message: Error 24. Which means: 'Too many open files'.
>
> I tried to tune the server by setting the variable for
> open_files_limit to 10.000. But still the same problem.
>
> Can anybody help me?

Well, I don't think your problem is related to file handles...
Merging 1000 tables is usually a sign of a design problem. Can you
explain why you need to merge that many tables???

Because I have so many points. (Simple description *g*)

I have to deal with geographical points (x,y,z). They are stored in a
point table. For each point table I made a table with metainformation.
For an overwiev I want to join these metainformation.

Sure, I can put all metainformation in one table. But I want to have
each measurement in a separat table.

It has worked with about 1 Billion points from about 400 measurements.

Now I have less points but more measurements. About 1000. And I tried
the same architecture.


Well, have a look at :
http://www.mysql.com/doc/en/MERGE.html

Especially read the section on MERGE table disadvantages, it talks
about file handles...

I'd say try to change your design...


I think you are right. OK, another weekend work. *g*
Thanks.
Jul 19 '05 #9

This discussion thread is closed

Replies have been disabled for this discussion.