I installed the latest RC on a dev box (1.7.2-rc8), and went to town. I fed it a daily log file from the production site, with 3.1 million lines, from/to local webserver. I’m using a virtual machine with 4 Xeon cores on a host with SSDs and 4GB of RAM. The import is, at lack of better words, horribly slow. I tried pumping more RAM into MySQL via increasing table_cache to 512 and key_buffer_size to 768M, but still no joy. Best I could get was 111 requests/second, and that was with 4 recorders. From the looks of top, Piwik itself takes ages to process a single request.
After importing nearly half a million requests (and then hitting Ctrl+C), I went to see how it Piwik itself behaved. The leftmost widgets took ages to load, and said 18k visits and 260k pageviews (which fits with the above partial import). However, any widgets other than those (and the blog) simply don’t load.
So… any suggestions?