Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-81823

Upgrade to 7.1: UpgradeMySQL.upgradeDatetimePrecision can take hours with large tables with datetime fields

    Details

      Description

      Executing an upgrade under the following conditions:

      • Original version of Liferay: 6.1.30
      • Java Process: -Xmx20000m
      • CPU: 2 sockets of 8 cores
      • Database in the same machine than the Liferay server: Mysql 5.7.22 with default configuration plus query_cache_size=0
      • 40 GB DL filesystem
      • 7GB database with the following number of records (only showed those with more than 1000 records):
        Table name                           Rows
        --------------                 --------------
        ExpandoValue                     18431938
        ResourcePermission                1640588
        Image                             1364895
        JournalArticleImage               1201244
        AssetEntry                         837528
        LayoutSet                          800018
        Users_Roles                        641449
        Group_                             400009
        Contact_                           400001
        User_                              400001
        PasswordPolicyRel                  400000
        MBDiscussion                       330627
        MBMessage                          330627
        MBThread                           330627
        RatingsEntry                       231618
        Layout                             223726
        PortletPreferences                 140227
        DLSync                             103100
        JournalArticle                     100020
        DLFileEntry                        100000
        DLFileVersion                      100000
        SocialActivity                     100000
        DDMContent                          99999
        DDMStorageLink                      99999
        DDMStructureLink                    99999
        DLFileEntryMetadata                 99999
        ExpandoRow                          52506
        RatingsStats                        22116
        JournalArticleResource               6901
        ExpandoColumn                        5002
        DLFolder                             3100
        

      These are the results:
      The process UpgradeMySQL.upgradeDatetimePrecision took 3:45 minutes during a test under the following conditions:

      Log traces for this case:

      2018-05-28 01:01:30.780 INFO  [main][LoggingTimer:73] Starting com.liferay.portal.upgrade.v7_0_0.UpgradeMySQL#upgradeDatetimePrecision
      2018-05-28 01:01:30.827 INFO  [main][UpgradeMySQL:130] Updating table Account_ column createDate to datetime(6)
      2018-05-28 01:01:30.926 INFO  [main][UpgradeMySQL:130] Updating table Account_ column modifiedDate to datetime(6)
      2018-05-28 01:01:31.030 INFO  [main][UpgradeMySQL:130] Updating table Address column createDate to datetime(6)
      2018-05-28 01:01:31.196 INFO  [main][UpgradeMySQL:130] Updating table Address column modifiedDate to datetime(6)
      2018-05-28 01:01:31.396 INFO  [main][UpgradeMySQL:130] Updating table AnnouncementsEntry column createDate to datetime(6)
      2018-05-28 01:01:31.539 INFO  [main][UpgradeMySQL:130] Updating table AnnouncementsEntry column modifiedDate to datetime(6)
      2018-05-28 01:01:31.675 INFO  [main][UpgradeMySQL:130] Updating table AnnouncementsEntry column displayDate to datetime(6)
      2018-05-28 01:01:31.841 INFO  [main][UpgradeMySQL:130] Updating table AnnouncementsEntry column expirationDate to datetime(6)
      2018-05-28 01:01:32.026 INFO  [main][UpgradeMySQL:130] Updating table AnnouncementsFlag column createDate to datetime(6)
      2018-05-28 01:01:32.157 INFO  [main][UpgradeMySQL:130] Updating table AssetCategory column createDate to datetime(6)
      2018-05-28 01:01:32.346 INFO  [main][UpgradeMySQL:130] Updating table AssetCategory column modifiedDate to datetime(6)
      2018-05-28 01:01:32.569 INFO  [main][UpgradeMySQL:130] Updating table AssetCategoryProperty column createDate to datetime(6)
      2018-05-28 01:01:32.718 INFO  [main][UpgradeMySQL:130] Updating table AssetCategoryProperty column modifiedDate to datetime(6)
      2018-05-28 01:01:32.878 INFO  [main][UpgradeMySQL:130] Updating table AssetEntry column createDate to datetime(6)
      2018-05-28 01:04:16.984 INFO  [main][UpgradeMySQL:130] Updating table AssetEntry column modifiedDate to datetime(6)
      2018-05-28 01:07:32.315 INFO  [main][UpgradeMySQL:130] Updating table AssetEntry column startDate to datetime(6)
      2018-05-28 01:11:12.790 INFO  [main][UpgradeMySQL:130] Updating table AssetEntry column endDate to datetime(6)
      2018-05-28 01:14:42.445 INFO  [main][UpgradeMySQL:130] Updating table AssetEntry column publishDate to datetime(6)
      2018-05-28 01:18:07.445 INFO  [main][UpgradeMySQL:130] Updating table AssetEntry column expirationDate to datetime(6)
      2018-05-28 01:21:35.727 INFO  [main][UpgradeMySQL:130] Updating table AssetLink column createDate to datetime(6)
      2018-05-28 01:21:36.711 INFO  [main][UpgradeMySQL:130] Updating table AssetTag column createDate to datetime(6)
      2018-05-28 01:21:37.379 INFO  [main][UpgradeMySQL:130] Updating table AssetTag column modifiedDate to datetime(6)
      2018-05-28 01:21:37.830 INFO  [main][UpgradeMySQL:130] Updating table AssetVocabulary column createDate to datetime(6)
      2018-05-28 01:21:38.871 INFO  [main][UpgradeMySQL:130] Updating table AssetVocabulary column modifiedDate to datetime(6)
      2018-05-28 01:21:39.580 INFO  [main][UpgradeMySQL:130] Updating table BlogsEntry column createDate to datetime(6)
      2018-05-28 01:21:40.045 INFO  [main][UpgradeMySQL:130] Updating table BlogsEntry column modifiedDate to datetime(6)
      2018-05-28 01:21:40.709 INFO  [main][UpgradeMySQL:130] Updating table BlogsEntry column displayDate to datetime(6)
      2018-05-28 01:21:41.476 INFO  [main][UpgradeMySQL:130] Updating table BlogsEntry column statusDate to datetime(6)
      2018-05-28 01:21:41.862 INFO  [main][UpgradeMySQL:130] Updating table BlogsStatsUser column lastPostDate to datetime(6)
      2018-05-28 01:21:43.531 INFO  [main][UpgradeMySQL:130] Updating table BookmarksEntry column createDate to datetime(6)
      2018-05-28 01:21:43.809 INFO  [main][UpgradeMySQL:130] Updating table BookmarksEntry column modifiedDate to datetime(6)
      2018-05-28 01:21:44.690 INFO  [main][UpgradeMySQL:130] Updating table BookmarksFolder column createDate to datetime(6)
      2018-05-28 01:21:45.425 INFO  [main][UpgradeMySQL:130] Updating table BookmarksFolder column modifiedDate to datetime(6)
      2018-05-28 01:21:45.724 INFO  [main][UpgradeMySQL:130] Updating table CalEvent column createDate to datetime(6)
      2018-05-28 01:21:46.375 INFO  [main][UpgradeMySQL:130] Updating table CalEvent column modifiedDate to datetime(6)
      2018-05-28 01:21:46.626 INFO  [main][UpgradeMySQL:130] Updating table CalEvent column startDate to datetime(6)
      2018-05-28 01:21:46.859 INFO  [main][UpgradeMySQL:130] Updating table CalEvent column endDate to datetime(6)
      2018-05-28 01:21:47.798 INFO  [main][UpgradeMySQL:130] Updating table Contact_ column createDate to datetime(6)
      2018-05-28 01:22:12.651 INFO  [main][UpgradeMySQL:130] Updating table Contact_ column modifiedDate to datetime(6)
      2018-05-28 01:22:33.942 INFO  [main][UpgradeMySQL:130] Updating table Contact_ column birthday to datetime(6)
      2018-05-28 01:23:01.939 INFO  [main][UpgradeMySQL:130] Updating table DDLRecord column createDate to datetime(6)
      2018-05-28 01:23:02.669 INFO  [main][UpgradeMySQL:130] Updating table DDLRecord column modifiedDate to datetime(6)
      2018-05-28 01:23:02.884 INFO  [main][UpgradeMySQL:130] Updating table DDLRecordSet column createDate to datetime(6)
      2018-05-28 01:23:03.449 INFO  [main][UpgradeMySQL:130] Updating table DDLRecordSet column modifiedDate to datetime(6)
      2018-05-28 01:23:03.683 INFO  [main][UpgradeMySQL:130] Updating table DDLRecordVersion column createDate to datetime(6)
      2018-05-28 01:23:03.896 INFO  [main][UpgradeMySQL:130] Updating table DDLRecordVersion column statusDate to datetime(6)
      2018-05-28 01:23:04.479 INFO  [main][UpgradeMySQL:130] Updating table DDMContent column createDate to datetime(6)
      2018-05-28 01:23:24.005 INFO  [main][UpgradeMySQL:130] Updating table DDMContent column modifiedDate to datetime(6)
      2018-05-28 01:23:47.354 INFO  [main][UpgradeMySQL:130] Updating table DDMStructure column createDate to datetime(6)
      2018-05-28 01:23:49.101 INFO  [main][UpgradeMySQL:130] Updating table DDMStructure column modifiedDate to datetime(6)
      2018-05-28 01:23:50.637 INFO  [main][UpgradeMySQL:130] Updating table DDMTemplate column createDate to datetime(6)
      2018-05-28 01:23:52.201 INFO  [main][UpgradeMySQL:130] Updating table DDMTemplate column modifiedDate to datetime(6)
      2018-05-28 01:23:53.196 INFO  [main][UpgradeMySQL:130] Updating table DLFileEntry column createDate to datetime(6)
      2018-05-28 01:24:28.872 INFO  [main][UpgradeMySQL:130] Updating table DLFileEntry column modifiedDate to datetime(6)
      2018-05-28 01:25:06.184 INFO  [main][UpgradeMySQL:130] Updating table DLFileEntryType column createDate to datetime(6)
      2018-05-28 01:25:06.986 INFO  [main][UpgradeMySQL:130] Updating table DLFileEntryType column modifiedDate to datetime(6)
      2018-05-28 01:25:07.182 INFO  [main][UpgradeMySQL:130] Updating table DLFileRank column createDate to datetime(6)
      2018-05-28 01:25:08.058 INFO  [main][UpgradeMySQL:130] Updating table DLFileShortcut column createDate to datetime(6)
      2018-05-28 01:25:08.704 INFO  [main][UpgradeMySQL:130] Updating table DLFileShortcut column modifiedDate to datetime(6)
      2018-05-28 01:25:08.935 INFO  [main][UpgradeMySQL:130] Updating table DLFileShortcut column statusDate to datetime(6)
      2018-05-28 01:25:09.159 INFO  [main][UpgradeMySQL:130] Updating table DLFileVersion column createDate to datetime(6)
      2018-05-28 01:25:34.426 INFO  [main][UpgradeMySQL:130] Updating table DLFileVersion column modifiedDate to datetime(6)
      2018-05-28 01:26:00.300 INFO  [main][UpgradeMySQL:130] Updating table DLFileVersion column statusDate to datetime(6)
      2018-05-28 01:26:29.968 INFO  [main][UpgradeMySQL:130] Updating table DLFolder column createDate to datetime(6)
      2018-05-28 01:26:32.410 INFO  [main][UpgradeMySQL:130] Updating table DLFolder column modifiedDate to datetime(6)
      2018-05-28 01:26:34.175 INFO  [main][UpgradeMySQL:130] Updating table DLFolder column lastPostDate to datetime(6)
      2018-05-28 01:26:35.768 INFO  [main][UpgradeMySQL:130] Updating table EmailAddress column createDate to datetime(6)
      2018-05-28 01:26:36.046 INFO  [main][UpgradeMySQL:130] Updating table EmailAddress column modifiedDate to datetime(6)
      2018-05-28 01:26:36.295 INFO  [main][UpgradeMySQL:130] Updating table Image column modifiedDate to datetime(6)
      2018-05-28 01:27:29.453 INFO  [main][UpgradeMySQL:130] Updating table JournalArticle column createDate to datetime(6)
      2018-05-28 01:46:52.968 INFO  [main][UpgradeMySQL:130] Updating table JournalArticle column modifiedDate to datetime(6)
      2018-05-28 02:03:20.317 INFO  [main][UpgradeMySQL:130] Updating table JournalArticle column displayDate to datetime(6)
      2018-05-28 02:18:28.520 INFO  [main][UpgradeMySQL:130] Updating table JournalArticle column expirationDate to datetime(6)
      2018-05-28 02:32:45.045 INFO  [main][UpgradeMySQL:130] Updating table JournalArticle column reviewDate to datetime(6)
      2018-05-28 02:46:16.389 INFO  [main][UpgradeMySQL:130] Updating table JournalArticle column statusDate to datetime(6)
      2018-05-28 02:59:15.025 INFO  [main][UpgradeMySQL:130] Updating table JournalFeed column createDate to datetime(6)
      2018-05-28 02:59:17.915 INFO  [main][UpgradeMySQL:130] Updating table JournalFeed column modifiedDate to datetime(6)
      2018-05-28 02:59:19.809 INFO  [main][UpgradeMySQL:130] Updating table Layout column createDate to datetime(6)
      2018-05-28 03:05:05.317 INFO  [main][UpgradeMySQL:130] Updating table Layout column modifiedDate to datetime(6)
      2018-05-28 03:10:56.856 INFO  [main][UpgradeMySQL:130] Updating table LayoutRevision column createDate to datetime(6)
      2018-05-28 03:10:58.892 INFO  [main][UpgradeMySQL:130] Updating table LayoutRevision column modifiedDate to datetime(6)
      2018-05-28 03:11:00.253 INFO  [main][UpgradeMySQL:130] Updating table LayoutRevision column statusDate to datetime(6)
      2018-05-28 03:11:01.590 INFO  [main][UpgradeMySQL:130] Updating table LayoutSet column createDate to datetime(6)
      2018-05-28 03:11:50.996 INFO  [main][UpgradeMySQL:130] Updating table LayoutSet column modifiedDate to datetime(6)
      2018-05-28 03:12:36.090 INFO  [main][UpgradeMySQL:130] Updating table LayoutSetBranch column createDate to datetime(6)
      2018-05-28 03:12:36.632 INFO  [main][UpgradeMySQL:130] Updating table LayoutSetBranch column modifiedDate to datetime(6)
      2018-05-28 03:12:36.882 INFO  [main][UpgradeMySQL:130] Updating table LayoutSetPrototype column createDate to datetime(6)
      2018-05-28 03:12:37.213 INFO  [main][UpgradeMySQL:130] Updating table LayoutSetPrototype column modifiedDate to datetime(6)
      2018-05-28 03:12:37.725 INFO  [main][UpgradeMySQL:130] Updating table Lock_ column createDate to datetime(6)
      2018-05-28 03:12:37.909 INFO  [main][UpgradeMySQL:130] Updating table Lock_ column expirationDate to datetime(6)
      2018-05-28 03:12:38.098 INFO  [main][UpgradeMySQL:130] Updating table MBBan column createDate to datetime(6)
      2018-05-28 03:12:38.536 INFO  [main][UpgradeMySQL:130] Updating table MBBan column modifiedDate to datetime(6)
      2018-05-28 03:12:38.816 INFO  [main][UpgradeMySQL:130] Updating table MBCategory column createDate to datetime(6)
      2018-05-28 03:12:39.082 INFO  [main][UpgradeMySQL:130] Updating table MBCategory column modifiedDate to datetime(6)
      2018-05-28 03:12:39.526 INFO  [main][UpgradeMySQL:130] Updating table MBCategory column lastPostDate to datetime(6)
      2018-05-28 03:12:39.808 INFO  [main][UpgradeMySQL:130] Updating table MBMailingList column createDate to datetime(6)
      2018-05-28 03:12:40.072 INFO  [main][UpgradeMySQL:130] Updating table MBMailingList column modifiedDate to datetime(6)
      2018-05-28 03:12:40.412 INFO  [main][UpgradeMySQL:130] Updating table MBMessage column createDate to datetime(6)
      2018-05-28 03:16:45.777 INFO  [main][UpgradeMySQL:130] Updating table MBMessage column modifiedDate to datetime(6)
      2018-05-28 03:21:02.954 INFO  [main][UpgradeMySQL:130] Updating table MBMessage column statusDate to datetime(6)
      2018-05-28 03:25:15.465 INFO  [main][UpgradeMySQL:130] Updating table MBStatsUser column lastPostDate to datetime(6)
      2018-05-28 03:25:15.908 INFO  [main][UpgradeMySQL:130] Updating table MBThread column lastPostDate to datetime(6)
      2018-05-28 03:26:00.625 INFO  [main][UpgradeMySQL:130] Updating table MBThread column statusDate to datetime(6)
      2018-05-28 03:26:43.861 INFO  [main][UpgradeMySQL:130] Updating table MBThreadFlag column modifiedDate to datetime(6)
      2018-05-28 03:26:44.691 INFO  [main][UpgradeMySQL:130] Updating table MDRAction column createDate to datetime(6)
      2018-05-28 03:26:45.266 INFO  [main][UpgradeMySQL:130] Updating table MDRAction column modifiedDate to datetime(6)
      2018-05-28 03:26:45.772 INFO  [main][UpgradeMySQL:130] Updating table MDRRule column createDate to datetime(6)
      2018-05-28 03:26:46.521 INFO  [main][UpgradeMySQL:130] Updating table MDRRule column modifiedDate to datetime(6)
      2018-05-28 03:26:46.735 INFO  [main][UpgradeMySQL:130] Updating table MDRRuleGroup column createDate to datetime(6)
      2018-05-28 03:26:47.344 INFO  [main][UpgradeMySQL:130] Updating table MDRRuleGroup column modifiedDate to datetime(6)
      2018-05-28 03:26:47.585 INFO  [main][UpgradeMySQL:130] Updating table MembershipRequest column createDate to datetime(6)
      2018-05-28 03:26:47.830 INFO  [main][UpgradeMySQL:130] Updating table MembershipRequest column replyDate to datetime(6)
      2018-05-28 03:26:48.327 INFO  [main][UpgradeMySQL:130] Updating table PasswordPolicy column createDate to datetime(6)
      2018-05-28 03:26:48.492 INFO  [main][UpgradeMySQL:130] Updating table PasswordPolicy column modifiedDate to datetime(6)
      2018-05-28 03:26:48.701 INFO  [main][UpgradeMySQL:130] Updating table PasswordTracker column createDate to datetime(6)
      2018-05-28 03:26:48.871 INFO  [main][UpgradeMySQL:130] Updating table Phone column createDate to datetime(6)
      2018-05-28 03:26:49.233 INFO  [main][UpgradeMySQL:130] Updating table Phone column modifiedDate to datetime(6)
      2018-05-28 03:26:49.426 INFO  [main][UpgradeMySQL:130] Updating table PollsQuestion column createDate to datetime(6)
      2018-05-28 03:26:49.622 INFO  [main][UpgradeMySQL:130] Updating table PollsQuestion column modifiedDate to datetime(6)
      2018-05-28 03:26:49.770 INFO  [main][UpgradeMySQL:130] Updating table PollsQuestion column expirationDate to datetime(6)
      2018-05-28 03:26:50.008 INFO  [main][UpgradeMySQL:130] Updating table PollsQuestion column lastVoteDate to datetime(6)
      2018-05-28 03:26:50.138 INFO  [main][UpgradeMySQL:130] Updating table PollsVote column createDate to datetime(6)
      2018-05-28 03:26:50.304 INFO  [main][UpgradeMySQL:130] Updating table PollsVote column modifiedDate to datetime(6)
      2018-05-28 03:26:50.499 INFO  [main][UpgradeMySQL:130] Updating table PollsVote column voteDate to datetime(6)
      2018-05-28 03:26:50.644 INFO  [main][UpgradeMySQL:130] Updating table PortletItem column createDate to datetime(6)
      2018-05-28 03:26:50.808 INFO  [main][UpgradeMySQL:130] Updating table PortletItem column modifiedDate to datetime(6)
      2018-05-28 03:26:51.044 INFO  [main][UpgradeMySQL:130] Updating table RatingsEntry column createDate to datetime(6)
      2018-05-28 03:27:13.657 INFO  [main][UpgradeMySQL:130] Updating table RatingsEntry column modifiedDate to datetime(6)
      2018-05-28 03:27:41.900 INFO  [main][UpgradeMySQL:130] Updating table Release_ column createDate to datetime(6)
      2018-05-28 03:27:42.636 INFO  [main][UpgradeMySQL:130] Updating table Release_ column modifiedDate to datetime(6)
      2018-05-28 03:27:42.850 INFO  [main][UpgradeMySQL:130] Updating table Release_ column buildDate to datetime(6)
      2018-05-28 03:27:43.866 INFO  [main][UpgradeMySQL:130] Updating table Repository column createDate to datetime(6)
      2018-05-28 03:27:44.823 INFO  [main][UpgradeMySQL:130] Updating table Repository column modifiedDate to datetime(6)
      2018-05-28 03:27:45.357 INFO  [main][UpgradeMySQL:130] Updating table Subscription column createDate to datetime(6)
      2018-05-28 03:27:45.556 INFO  [main][UpgradeMySQL:130] Updating table Subscription column modifiedDate to datetime(6)
      2018-05-28 03:27:45.753 INFO  [main][UpgradeMySQL:130] Updating table Team column createDate to datetime(6)
      2018-05-28 03:27:45.909 INFO  [main][UpgradeMySQL:130] Updating table Team column modifiedDate to datetime(6)
      2018-05-28 03:27:46.466 INFO  [main][UpgradeMySQL:130] Updating table Ticket column createDate to datetime(6)
      2018-05-28 03:27:46.643 INFO  [main][UpgradeMySQL:130] Updating table Ticket column expirationDate to datetime(6)
      2018-05-28 03:27:46.825 INFO  [main][UpgradeMySQL:130] Updating table UserTracker column modifiedDate to datetime(6)
      2018-05-28 03:27:47.544 INFO  [main][UpgradeMySQL:130] Updating table UserTrackerPath column pathDate to datetime(6)
      2018-05-28 03:27:47.698 INFO  [main][UpgradeMySQL:130] Updating table User_ column createDate to datetime(6)
      2018-05-28 03:30:21.673 INFO  [main][UpgradeMySQL:130] Updating table User_ column modifiedDate to datetime(6)
      2018-05-28 03:33:08.336 INFO  [main][UpgradeMySQL:130] Updating table User_ column passwordModifiedDate to datetime(6)
      2018-05-28 03:35:38.312 INFO  [main][UpgradeMySQL:130] Updating table User_ column loginDate to datetime(6)
      2018-05-28 03:38:18.245 INFO  [main][UpgradeMySQL:130] Updating table User_ column lastLoginDate to datetime(6)
      2018-05-28 03:41:05.028 INFO  [main][UpgradeMySQL:130] Updating table User_ column lastFailedLoginDate to datetime(6)
      2018-05-28 03:43:48.686 INFO  [main][UpgradeMySQL:130] Updating table User_ column lockoutDate to datetime(6)
      2018-05-28 03:46:36.675 INFO  [main][UpgradeMySQL:130] Updating table WebDAVProps column createDate to datetime(6)
      2018-05-28 03:46:37.570 INFO  [main][UpgradeMySQL:130] Updating table WebDAVProps column modifiedDate to datetime(6)
      2018-05-28 03:46:38.181 INFO  [main][UpgradeMySQL:130] Updating table Website column createDate to datetime(6)
      2018-05-28 03:46:38.391 INFO  [main][UpgradeMySQL:130] Updating table Website column modifiedDate to datetime(6)
      2018-05-28 03:46:38.605 INFO  [main][UpgradeMySQL:130] Updating table WikiNode column createDate to datetime(6)
      2018-05-28 03:46:40.413 INFO  [main][UpgradeMySQL:130] Updating table WikiNode column modifiedDate to datetime(6)
      2018-05-28 03:46:40.743 INFO  [main][UpgradeMySQL:130] Updating table WikiNode column lastPostDate to datetime(6)
      2018-05-28 03:46:41.394 INFO  [main][UpgradeMySQL:130] Updating table WikiPage column createDate to datetime(6)
      2018-05-28 03:46:42.142 INFO  [main][UpgradeMySQL:130] Updating table WikiPage column modifiedDate to datetime(6)
      2018-05-28 03:46:43.651 INFO  [main][UpgradeMySQL:130] Updating table WikiPage column statusDate to datetime(6)
      2018-05-28 03:46:44.927 INFO  [main][UpgradeMySQL:130] Updating table WorkflowDefinitionLink column createDate to datetime(6)
      2018-05-28 03:46:45.421 INFO  [main][UpgradeMySQL:130] Updating table WorkflowDefinitionLink column modifiedDate to datetime(6)
      2018-05-28 03:46:45.591 INFO  [main][UpgradeMySQL:130] Updating table WorkflowInstanceLink column createDate to datetime(6)
      2018-05-28 03:46:45.738 INFO  [main][UpgradeMySQL:130] Updating table WorkflowInstanceLink column modifiedDate to datetime(6)
      2018-05-28 03:46:45.887 INFO  [main][LoggingTimer:39] Completed com.liferay.portal.upgrade.v7_0_0.UpgradeMySQL#upgradeDatetimePrecision in 9915107 ms
      

      Expected results:
      Reduce the time for this upgrade drastically.

      Analysis:
      At first glance we see one improvement area:

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                brian.chan Brian Chan
                Reporter:
                alberto.chaparro Alberto Chaparro
                Participants of an Issue:
                Recent user:
                Michael Saechang
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  2 years, 9 weeks, 2 days ago

                  Packages

                  Version Package
                  7.1.0 Beta 3
                  7.1.X
                  Master