* 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
* 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
