FW: table size in mysql

[nm]

Is it possible to MERGE innodb tables?
Can't find docs on mysql.com

In replication. I guess I can update the slave if the master is not
responding, right? Shall I 'stop slave' before , in case the master is down?

Also will this create problems when the master comes back and the slave
copies updates from the master log file?

application/web server
| |
| |
master -- slave

This way I would write master and read on slave as default. But I would like
to use slave as mater automatically if the first server is down.
Also I would use a few innodb tables.

Thanks.

|-----Original Message-----
|From: Roger Baklund [mailto:ro***@charlott.no]
|Sent: Tuesday, August 05, 2003 6:25 PM
|To: my***@lists.mysql.com
|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 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 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?
|
|Should not be a problem.
|
|--
|Roger
|
|
|--
|MySQL General Mailing List
|For list archives: http://lists.mysql.com/mysql
|To unsubscribe: http://lists.mysql.com/my****************@seg.inf.cu
|
|

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw