Opened 3 years ago

Closed 3 years ago

Last modified 3 years ago

#2626 closed Task (fixed)

Load testing Script helper: copy visits/pages/conversions from custom date range to today

Reported by: matt Owned by:
Priority: low Milestone: 1.6 Piwik 1.6
Component: Core Keywords:
Cc: Sensitive: no


Copying old logs with server_time = CURRENT_DATE() means we can try Piwik in a "production" like environment. Running the script to copy the last week of data, into today, will effectively generate an unusual load on Piwik.

This script will allow to quickly generate huge piwik logs from a starting database (even with old data).

Script only used by developers

Change History (2)

comment:1 Changed 3 years ago by matt (mattab)

  • Resolution set to fixed
  • Status changed from new to closed

(In [5106]) Fixes #2626

  • Adding new script that will copy old visits/actions/conversions/purchased items from a date range (start,end) in TODAY. This is useful script to test the recent archive.php optimizations on a lot of data.

The only downside of this technique is that we effectively copy old data, therefore a few things are not as "varied" as they would be in prod, such as: Page URLs distribution (we "reuse" past URLs when normal piwik would always track new ones)

comment:2 Changed 3 years ago by matt (mattab)

I'm hoping to extend it later to generate this huge load over multiple days, as well as generating over a given number of websites.

Note: See TracTickets for help on using tickets.