Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Define what is a major database upgrade #7357

Closed
mrjoops opened this issue Mar 4, 2015 · 3 comments
Closed

Define what is a major database upgrade #7357

mrjoops opened this issue Mar 4, 2015 · 3 comments
Labels
answered For when a question was asked and we referred to forum or answered it.

Comments

@mrjoops
Copy link

mrjoops commented Mar 4, 2015

I have a heavy Piwik 2.10.0 install I wanted to upgrade to 2.11.2, so I looked at the changelog for the 2.11.* versions.
None of the 2.11.* versions mentionned a major database upgrade, so I started confidently the upgrade operation.
But then I saw the queries (one for each archive_blob table) : UPDATE piwik_archive_blob_2015_03 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';

Actually, with a database of nearly 200GB, I think it is a quite major upgrade.
IMHO every upgrade operation that updates any of the archive_blob, archive_numeric and log_visit tables should be a major one.

I welcome your comments.
@mattab
Copy link
Member

mattab commented Mar 4, 2015

Hi @mrjoops
A major database upgrade is a Schema altering on one of the log_* tables or archive_* tables. This UPDATE statement is definitely not a major DB upgrade, as it should complete within minutes at most. See also: #6953

@mattab mattab closed this as completed Mar 4, 2015
@mattab mattab added the answered For when a question was asked and we referred to forum or answered it. label Mar 4, 2015
@mrjoops
Copy link
Author

mrjoops commented Mar 5, 2015

Well, I don't know if 80 minutes fit in "within minutes at most"...

@mattab
Copy link
Member

mattab commented Mar 6, 2015

80 minutes is quite long indeed.. this issue will help get an idea: #7276

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
answered For when a question was asked and we referred to forum or answered it.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@mattab @mrjoops