Nightly History Export changes

I had to make a change to how the items_history tables are exported. It was taking too long and was locking the table, which was causing the server to slow down near downtime. Originally in the Developers section you could download mysql_items_history.txt.gz and mysql_items_history_30.txt.gz. These have now been split up into each region. So to get the entire universe you’ll have to fetch them separately, then import them all (they still go to the same table).

I also found a bug where the 30-day ones were actually returning ALL the dates, so that’s been fixed, and should cut down on download sizes substantially.



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: