Hi,

> I have the following table in mysql 5.0.20...
> 
> employ
> ======
> empid
> date_time
> site
> 
> I am using this table to store all the websites accessed by each
> employees. There is no primary key on that table since the same
> employee will access more than 100 sites per day. If there is 100
> employees then the rows inserted per day will be  ~ 100*100= 10000. If
> it grows till 2 months or 3 months then the table size will become
> larger. As we all know the default table size in MySQl is 4 GB.
> 
> Can anyone explain will it produce issues in the future? How to
> overcome this? How to design a table for this scenario?

maybe this is still correct:
http://jeremy.zawodny.com/blog/archives/000796.html

But perhaps you don't need it at all:

10000 records * e.g. 300 byte = 3000000 byte/day
4GB = 4294967296 byte
4294967296 byte / 3000000 byte/day = 1431 days

No issues for about 3 years. And after that time you could simply create a
new table.

hth,

Tom Horstmann




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to