Hi, all
I have 2 questions:
1) Is there any limit on the number of tables I can create in MySQL and
how large I can hold in a database?
2) Does MYSQL support to save binary data file in the table. I can't just
save paths to the files. They files reside in another machine.
Thanks for reply.
MySQL is generally limited by the OS you are running it on. If you
start having thousands of table, the OS is probably going to get
bogged down in trying to keep track of all the file handles needed
for all those tables and indexes. The practical limit to the number
of tables is far lower
I am using a development build of 4.1.3 (the last 4.1.3 release I think;
mysql-4.1.3-beta-nightly-20040628) so I suppose I have this coming, but
here goes:
As I am running on RH Enterprise Server 3 with a Pentium Xeon (32-bit)
According to the documentation, for a 32 bit processor, I should be
You must be getting an error code when inserting now.
If that is related to index file size (that's what I had)
.
You can do ALTER TABLE tablename MAX_ROWS=big_num
On Mon, 2004-07-26 at 11:48, Michael Dykman wrote:
I am using a development build of 4.1.3 (the last 4.1.3 release I think;
At 12:48 -0400 7/26/04, Michael Dykman wrote:
I am using a development build of 4.1.3 (the last 4.1.3 release I think;
mysql-4.1.3-beta-nightly-20040628) so I suppose I have this coming, but
here goes:
As I am running on RH Enterprise Server 3 with a Pentium Xeon (32-bit)
According to the
thank you for the suggestion, I will give that a try. I thought it
suspicious that the table stopped receiving data at 2 bytes under the
natural 4G limit (8 byte int) which was standard under 3.22. As I said,
I am using a development release and I have found 1 or 2 other
regression errors along
I apologize for my skepticism of 15 minutes ago. I finally _read_
http://dev.mysql.com/doc/mysql/en/Table_size.html carefully, and indeed
your suggestion is dead on.
thank you again.
On Mon, 2004-07-26 at 14:19, Paul DuBois wrote:
At 12:48 -0400 7/26/04, Michael Dykman wrote:
I am using a
I'm not a suitable person to compare MySQL against other databases but MySQL
will cope with this size of database if the tables are properly indexed and
your queries optomised. Here our main database has over 90 tables and several
of our tablse hold about the amount of data your'll acrue in
On Wed, May 01, 2002 at 08:02:20AM +0200, Svensson, B.A.T. (HKG) wrote:
Do you have any idea how well MySQL scales with tables containing
some 10th of million rows of data?
How about 280 million? We've got one that big. It performs very
well--because we have it properly indexed and don't
On Sat, 27 Apr 2002, Sam Minnee wrote:
I've been asked to put together a very large (well, it's large to me)
database, and while mySQL is great for my current uses, I haven't had
experience with stuff of this scale.
The database will have about 88 tables, with up to 100 fields per table.
On Sat, Apr 27, 2002 at 05:15:10PM +1200, Sam Minnee wrote:
I've been asked to put together a very large (well, it's large to
me) database, and while mySQL is great for my current uses, I
haven't had experience with stuff of this scale.
The database will have about 88 tables, with up to
I've been asked to put together a very large (well, it's large to me)
database, and while mySQL is great for my current uses, I haven't had
experience with stuff of this scale.
The database will have about 88 tables, with up to 100 fields per table.
There is a _lot_ of interlinking among the
On Tue, Feb 20, 2001 at 09:33:40AM +0800, yindu wrote:
thank you.
i know mysql stored its tables in files,And i have looked through the mysql
handbook.But i hadn't found information about the file systerm of mysql,i think a
table
is a file,then all tables in the same database should be
On Fri, Feb 16, 2001 at 10:46:40AM -0800, Fox Mulder wrote:
--- Brian Reichert [EMAIL PROTECTED] wrote:
On Sat, Feb 17, 2001 at 03:23:49PM +0800, yindu wrote:
There are no DB defined space limits on MySQL Databases ?It's
dangerours .How to control
the database space on my database
On Sat, Feb 17, 2001 at 03:23:49PM +0800, yindu wrote:
There are no DB defined space limits on MySQL Databases ?It's dangerours .How to
control
the database space on my database user?
Filesystem quotas.
--
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303
--- Brian Reichert [EMAIL PROTECTED] wrote:
On Sat, Feb 17, 2001 at 03:23:49PM +0800, yindu wrote:
There are no DB defined space limits on MySQL Databases ?It's
dangerours .How to control
the database space on my database user?
Filesystem quotas.
But, to define filesystem quota, I
There are no DB defined space limits on MySQL Databases ?It's dangerours .How to
control
the database space on my database user?
17 matches
Mail list logo