tables.
Thanks.
|-Original Message-
|From: Roger Baklund [mailto:[EMAIL PROTECTED]
|Sent: Tuesday, August 05, 2003 6:25 PM
|To: [EMAIL PROTECTED]
|Cc: NEWMEDIAPLAN
|Subject: Re: table size in mysql
|
|
|* NEWMEDIAPLAN
|> how many records can i put in a mysql table.
|
|As many as you like, pretty mu
* nm
> Is it possible to MERGE innodb tables?
No, MERGE is for MyIsam tables only. InnoDb tables are stored in
tablespaces, the problem with file size does not apply. You simply use
multiple tablespaces when the data outgrows the OS limits.
> Can't find docs on mysql.com
hm... mysql.com seems to
* NEWMEDIAPLAN
> what variable values /mysql tuning you suggest for more than 2000
> potential concurrent users and big tables.
2000 concurrent users is much, at least if you mean 2000 concurrent requests
to the database, as opposed to 2000 concurrent users of a web site. It is
hard to give you a
hello.
how many records can i put in a mysql table. i need a table with more than
50,000,000 records (just 4 short fields, it's basically a log with
id,action,date,result). What do you think?
thanks in advance!!!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
* NEWMEDIAPLAN
> how many records can i put in a mysql table.
As many as you like, pretty much. The total file size could be delimited by
your OS, but this can be dealt with using MERGE tables (splitting a single
table in multiple files) or InnoDB tables (with multiple table spaces).
> i need a t
Date |Fri, 24 Aug 2001 10:29:53 -0700
>From |"Benjamin Arai" <[EMAIL PROTECTED]>
Hello!
BA> What is the maximum table size allowed by MySQL and Redhat 7.0 be default?
BA> Benjamin Arai
Read about it here:
http://www.mysql.com/doc/T/a/Table_size.html
What is the maximum table size allowed by MySQL and Redhat 7.0 be default?
Benjamin Arai
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)