If I have 100,000 unique visitors per day and 500,000 page views per day
and not auto archiving and not setting up LOAD DATA INFILE is there be
any problem? and how HDD space I need for this huge amount of visitors?
what about this message in setting>systemcheck>Database abilities
Using LOAD DATA INFILE will greatly speed piwik archiving process up. To
make it available to piwik, try updating your PHP & MySQL software and
make sure your database user has the FILE privilege.
If your piwik server tracks high traffic websites (eg. > 100,000 pages
per month), we recommend to try fix this problem.
I have php 5.3 and latest mysql I think.