* 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/[EMAIL PROTECTED]

Reply via email to