On 29/11/11 18:49, Lars Aronsson wrote:
In the last few days, I've learned many things,
such as
1) using the rrdb instead of userdb servers,
If you were to store the data in the
server, you would need a userdb server.
(...)
Does the toolserver give me any other options to get statistics
on the enwiki database?
You could load it in ranges, and then merge all of the results.
I could load page.sql and
externallinks.sql into my own MySQL instance, now that
these dumps are produced on a monthly schedule. Is that
my best option? Can I set up my own MySQL for this on the
toolserver? Or should I move the project to my own server?
That's the wrong solution. It might be faster to process the sql file
with string tools (unlikely, having to match pageids with namespaces)
but using a user level mysqld for that is completely overkill.