{"action":"created","issue":{"url":"https://api.github.com/repos/owncloud/core/issues/22747","repository_url":"https://api.github.com/repos/owncloud/core","labels_url":"https://api.github.com/repos/owncloud/core/issues/22747/labels{/name}","comments_url":"https://api.github.com/repos/owncloud/core/issues/22747/comments","events_url":"https://api.github.com/repos/owncloud/core/issues/22747/events","html_url":"https://github.com/owncloud/core/issues/22747","id":137520388,"number":22747,"title":"Adding a column to the filecache is super time consuming (depending on db)","user":{"login":"butonic","id":956847,"avatar_url":"https://avatars.githubusercontent.com/u/956847?v=3","gravatar_id":"","url":"https://api.github.com/users/butonic","html_url":"https://github.com/butonic","followers_url":"https://api.github.com/users/butonic/followers","following_url":"https://api.github.com/users/butonic/following{/other_user}","gists_url":"https://api.github.com/users/butonic/gists{/gist_id}","starred_url":"https://api.github.com/users/butonic/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/butonic/subscriptions","organizations_url":"https://api.github.com/users/butonic/orgs","repos_url":"https://api.github.com/users/butonic/repos","events_url":"https://api.github.com/users/butonic/events{/privacy}","received_events_url":"https://api.github.com/users/butonic/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/owncloud/core/labels/db:mysql","name":"db:mysql","color":"444444"},{"url":"https://api.github.com/repos/owncloud/core/labels/db:postgresql","name":"db:postgresql","color":"444444"},{"url":"https://api.github.com/repos/owncloud/core/labels/performance","name":"performance","color":"fbca04"},{"url":"https://api.github.com/repos/owncloud/core/labels/release%20note","name":"release note","color":"BFD4F2"},{"url":"https://api.github.com/repos/owncloud/core/labels/sev1-critical","name":"sev1-critical","color":"fc2929"}],"state":"closed","locked":false,"assignee":{"login":"VicDeo","id":991300,"avatar_url":"https://avatars.githubusercontent.com/u/991300?v=3","gravatar_id":"","url":"https://api.github.com/users/VicDeo","html_url":"https://github.com/VicDeo","followers_url":"https://api.github.com/users/VicDeo/followers","following_url":"https://api.github.com/users/VicDeo/following{/other_user}","gists_url":"https://api.github.com/users/VicDeo/gists{/gist_id}","starred_url":"https://api.github.com/users/VicDeo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/VicDeo/subscriptions","organizations_url":"https://api.github.com/users/VicDeo/orgs","repos_url":"https://api.github.com/users/VicDeo/repos","events_url":"https://api.github.com/users/VicDeo/events{/privacy}","received_events_url":"https://api.github.com/users/VicDeo/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/owncloud/core/milestones/77","html_url":"https://github.com/owncloud/core/milestones/9.0.2-current-maintenance","labels_url":"https://api.github.com/repos/owncloud/core/milestones/77/labels","id":1632540,"number":77,"title":"9.0.2-current-maintenance","description":null,"creator":{"login":"MorrisJobke","id":245432,"avatar_url":"https://avatars.githubusercontent.com/u/245432?v=3","gravatar_id":"","url":"https://api.github.com/users/MorrisJobke","html_url":"https://github.com/MorrisJobke","followers_url":"https://api.github.com/users/MorrisJobke/followers","following_url":"https://api.github.com/users/MorrisJobke/following{/other_user}","gists_url":"https://api.github.com/users/MorrisJobke/gists{/gist_id}","starred_url":"https://api.github.com/users/MorrisJobke/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MorrisJobke/subscriptions","organizations_url":"https://api.github.com/users/MorrisJobke/orgs","repos_url":"https://api.github.com/users/MorrisJobke/repos","events_url":"https://api.github.com/users/MorrisJobke/events{/privacy}","received_events_url":"https://api.github.com/users/MorrisJobke/received_events","type":"User","site_admin":false},"open_issues":17,"closed_issues":21,"state":"open","created_at":"2016-03-09T09:57:18Z","updated_at":"2016-04-19T15:10:13Z","due_on":"2016-05-03T04:00:00Z","closed_at":null},"comments":56,"created_at":"2016-03-01T09:32:27Z","updated_at":"2016-04-19T15:10:13Z","closed_at":"2016-04-19T15:10:13Z","body":"The resulting ALTER TABLE for the [added checksum column in OC9](https://github.com/owncloud/core/pull/21997) will create a temp table with tha same columns as the filecache, add the colum, COPY the table content and finally rename it and delete the original table. Big installations will experience a very long downtime as we have seen today with a huge activity table change when updating to oc 8.2.2.\r\n\r\nIn this case mysql 5.5 was used. In the documentation for it I see no way around copying the contents: http://dev.mysql.com/doc/refman/5.5/en/alter-table.html#idm140603778401088 It seems this has still not changed with mysql 5.7: http://dev.mysql.com/doc/refman/5.7/en/innodb-create-index-overview.html#idm140023654764880 although it should be less of a performance hog.\r\n\r\ncc @MorrisJobke @DeepDiver1975 @karlitschek \r\n\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/owncloud/core/issues/comments/211971758","html_url":"https://github.com/owncloud/core/issues/22747#issuecomment-211971758","issue_url":"https://api.github.com/repos/owncloud/core/issues/22747","id":211971758,"user":{"login":"PVince81","id":277525,"avatar_url":"https://avatars.githubusercontent.com/u/277525?v=3","gravatar_id":"","url":"https://api.github.com/users/PVince81","html_url":"https://github.com/PVince81","followers_url":"https://api.github.com/users/PVince81/followers","following_url":"https://api.github.com/users/PVince81/following{/other_user}","gists_url":"https://api.github.com/users/PVince81/gists{/gist_id}","starred_url":"https://api.github.com/users/PVince81/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/PVince81/subscriptions","organizations_url":"https://api.github.com/users/PVince81/orgs","repos_url":"https://api.github.com/users/PVince81/repos","events_url":"https://api.github.com/users/PVince81/events{/privacy}","received_events_url":"https://api.github.com/users/PVince81/received_events","type":"User","site_admin":false},"created_at":"2016-04-19T15:10:13Z","updated_at":"2016-04-19T15:10:13Z","body":"So if I understand well the warning has been added 9.0.1, closing hence.\r\n\r\nPlease reopen if you think there is something left to do."}}