i was *thinking* of logging all the http referer's and ip address's of visitors for a about a thousand domains i'm planning to forward.
combined it should be less then 1~2 million hits per day on my current server which will be only forwarding those domains and doing almost nothing else.
i was planning to allow the owners of the domains to be able to see who visited their site through what referer the day before.
but what worries me alot is that the number of records would get very very large in a small matter of time. would mysql have problems proccessing this kind of load even if i properly indexed the data?
i was thinking of storing the domain, ip, referer, time in mysql. indexing the domain and time. retrieving the info by something like select ip, referer from logtable where time=yesterday's date and domain=domain we're looking for
System:
256M of RAM (planning to upgrade to 512M)
Pentium III (forgot how many MHZ)
40G IDE (not SCSI hard drive)
Connected at 100 MPS
Latest stable release of Mysql
PHP for storing and retrieving the info
combined it should be less then 1~2 million hits per day on my current server which will be only forwarding those domains and doing almost nothing else.
i was planning to allow the owners of the domains to be able to see who visited their site through what referer the day before.
but what worries me alot is that the number of records would get very very large in a small matter of time. would mysql have problems proccessing this kind of load even if i properly indexed the data?
i was thinking of storing the domain, ip, referer, time in mysql. indexing the domain and time. retrieving the info by something like select ip, referer from logtable where time=yesterday's date and domain=domain we're looking for
System:
256M of RAM (planning to upgrade to 512M)
Pentium III (forgot how many MHZ)
40G IDE (not SCSI hard drive)
Connected at 100 MPS
Latest stable release of Mysql
PHP for storing and retrieving the info