Re: what's the limit on number of tables in MERGE table?
Posted by:
JinNo Kim
Date: November 10, 2005 08:24AM
Thank you for the correction, Ingo. :)
After a little fun with limits.conf and ulimit I was able to go beyond 16k tables in the Merge spec on the
box I'm using for testing. We'll never do this in production, it was more to see if I *could* :) Your
response helped me see through something I completely overlooked...
I was only looking at the values from /proc/sys/fs/files-max and files-nr (which apparently do very
little), ignoring (foolishly) limits.h and ulimit :/ ... I'll need to keep this in mind on our production server
- we haven't bumped up against it there yet (amazingly), but I think that's more from how we use
MySQL and some dumb luck than anything else. :)
It was a pleasure as always, thank you!
-JNK
Subject
Views
Written By
Posted
9316
April 04, 2005 04:30PM
5515
May 06, 2005 03:15AM
5467
May 13, 2005 04:23AM
5251
November 09, 2005 01:19PM
4827
November 10, 2005 05:17AM
Re: what's the limit on number of tables in MERGE table?
4433
November 10, 2005 08:24AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.