Discover Centmin Mod today
Register Now

Sysadmin MariaDB issues with indexes of IPB forums

Discussion in 'System Administration' started by pamamolf, Mar 9, 2017.

  1. pamamolf

    pamamolf Premium Member Premium Member

    3,167
    304
    83
    May 31, 2014
    Ratings:
    +551
    Local Time:
    3:45 PM
    Nginx-1.13.x
    MariaDB 10.1.x
    Hi :)

    I am using the latest version of MariaDB and all working great but once or twice per day it is going down due to mysql heavy resource usage...

    Checking the logs i found this info that i have never seen anything related on MariaDB logs:

    Code:
    Mar 07 22:29:33 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:33 140159928490752 [Note] InnoDB: Online DDL : Start reading clustered index of the table and create temporary files
    Mar 07 22:29:40 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:40 140159928490752 [Note] InnoDB: Online DDL : End of reading clustered index of the table and create temporary files
    Mar 07 22:29:40 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:40 140159928490752 [Note] InnoDB: Online DDL : Start merge-sorting index `PRIMARY` (1 / 19), estimated cost : 17.2508
    Mar 07 22:29:40 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:40 140159928490752 [Note] InnoDB: Online DDL : merge-sorting has estimated 266 runs
    Mar 07 22:29:48 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:48 140159928490752 [Note] InnoDB: Online DDL : End of  merge-sorting index `PRIMARY` (1 / 19)
    Mar 07 22:29:48 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:48 140159928490752 [Note] InnoDB: Online DDL : Start building index `PRIMARY` (1 / 19), estimated cost : 25.8762
    Mar 07 22:29:54 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:54 140159928490752 [Note] InnoDB: Online DDL : End of building index `PRIMARY` (1 / 19)
    Mar 07 22:29:54 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:54 140159928490752 [Note] InnoDB: Online DDL : Completed
    Mar 07 22:29:54 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:54 140159928490752 [Note] InnoDB: Online DDL : Start merge-sorting index `bday_day` (2 / 19), estimated cost : 1.1833
    Mar 07 22:29:54 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:54 140159928490752 [Note] InnoDB: Online DDL : merge-sorting has estimated 3 runs
    Mar 07 22:29:54 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:54 140159928490752 [Note] InnoDB: Online DDL : End of  merge-sorting index `bday_day` (2 / 19)
    Mar 07 22:29:54 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:54 140159928490752 [Note] InnoDB: Online DDL : Start building index `bday_day` (2 / 19), estimated cost : 1.7749
    Mar 07 22:29:54 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:54 140159928490752 [Note] InnoDB: Online DDL : End of building index `bday_day` (2 / 19)
    Mar 07 22:29:54 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:54 140159928490752 [Note] InnoDB: Online DDL : Completed
    Mar 07 22:29:54 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:54 140159928490752 [Note] InnoDB: Online DDL : Start merge-sorting index `bday_month` (3 / 19), estimated cost : 1.1833
    Mar 07 22:29:54 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:54 140159928490752 [Note] InnoDB: Online DDL : merge-sorting has estimated 3 runs
    Mar 07 22:29:54 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:54 140159928490752 [Note] InnoDB: Online DDL : End of  merge-sorting index `bday_month` (3 / 19)
    Mar 07 22:29:54 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:54 140159928490752 [Note] InnoDB: Online DDL : Start building index `bday_month` (3 / 19), estimated cost : 1.7749
    Mar 07 22:29:55 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:55 140159928490752 [Note] InnoDB: Online DDL : End of building index `bday_month` (3 / 19)
    Mar 07 22:29:55 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:55 140159928490752 [Note] InnoDB: Online DDL : Completed
    Mar 07 22:29:55 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:55 140159928490752 [Note] InnoDB: Online DDL : Start merge-sorting index `members_bitoptions` (4 / 19), estimated cost : 1.1222
    Mar 07 22:29:55 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:55 140159928490752 [Note] InnoDB: Online DDL : merge-sorting has estimated 2 runs
    Mar 07 22:29:55 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:55 140159928490752 [Note] InnoDB: Online DDL : End of  merge-sorting index `members_bitoptions` (4 / 19)
    Mar 07 22:29:55 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:55 140159928490752 [Note] InnoDB: Online DDL : Start building index `members_bitoptions` (4 / 19), estimated cost : 1.6833
    Mar 07 22:29:55 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:55 140159928490752 [Note] InnoDB: Online DDL : End of building index `members_bitoptions` (4 / 19)
    Mar 07 22:29:55 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:55 140159928490752 [Note] InnoDB: Online DDL : Completed
    Mar 07 22:29:55 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:55 140159928490752 [Note] InnoDB: Online DDL : Start merge-sorting index `ip_address` (5 / 19), estimated cost : 1.2444
    Mar 07 22:29:55 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:55 140159928490752 [Note] InnoDB: Online DDL : merge-sorting has estimated 4 runs
    Mar 07 22:29:55 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:55 140159928490752 [Note] InnoDB: Online DDL : End of  merge-sorting index `ip_address` (5 / 19)
    Mar 07 22:29:55 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:55 140159928490752 [Note] InnoDB: Online DDL : Start building index `ip_address` (5 / 19), estimated cost : 1.8666
    Mar 07 22:29:55 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:55 140159928490752 [Note] InnoDB: Online DDL : End of building index `ip_address` (5 / 19)
    Mar 07 22:29:55 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:55 140159928490752 [Note] InnoDB: Online DDL : Completed
    Mar 07 22:29:55 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:55 140159928490752 [Note] InnoDB: Online DDL : Start merge-sorting index `failed_login_count` (6 / 19), estimated cost : 1.1222
    Mar 07 22:29:55 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:55 140159928490752 [Note] InnoDB: Online DDL : merge-sorting has estimated 2 runs
    Mar 07 22:29:55 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:55 140159928490752 [Note] InnoDB: Online DDL : End of  merge-sorting index `failed_login_count` (6 / 19)
    Mar 07 22:29:55 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:55 140159928490752 [Note] InnoDB: Online DDL : Start building index `failed_login_count` (6 / 19), estimated cost : 1.6833
    Mar 07 22:29:56 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:56 140159928490752 [Note] InnoDB: Online DDL : End of building index `failed_login_count` (6 / 19)
    Mar 07 22:29:56 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:56 140159928490752 [Note] InnoDB: Online DDL : Completed
    Mar 07 22:29:56 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:56 140159928490752 [Note] InnoDB: Online DDL : Start merge-sorting index `joined` (7 / 19), estimated cost : 1.1222
    Mar 07 22:29:56 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:56 140159928490752 [Note] InnoDB: Online DDL : merge-sorting has estimated 2 runs
    Mar 07 22:29:56 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:56 140159928490752 [Note] InnoDB: Online DDL : End of  merge-sorting index `joined` (7 / 19)
    Mar 07 22:29:56 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:56 140159928490752 [Note] InnoDB: Online DDL : Start building index `joined` (7 / 19), estimated cost : 1.6833
    Mar 07 22:29:56 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:56 140159928490752 [Note] InnoDB: Online DDL : End of building index `joined` (7 / 19)
    Mar 07 22:29:56 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:56 140159928490752 [Note] InnoDB: Online DDL : Completed
    Mar 07 22:29:56 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:56 140159928490752 [Note] InnoDB: Online DDL : Start merge-sorting index `fb_uid` (8 / 19), estimated cost : 1.1833
    Mar 07 22:29:56 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:56 140159928490752 [Note] InnoDB: Online DDL : merge-sorting has estimated 3 runs
    Mar 07 22:29:56 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:56 140159928490752 [Note] InnoDB: Online DDL : End of  merge-sorting index `fb_uid` (8 / 19)
    Mar 07 22:29:56 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:56 140159928490752 [Note] InnoDB: Online DDL : Start building index `fb_uid` (8 / 19), estimated cost : 1.7749
    Mar 07 22:29:57 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:57 140159928490752 [Note] InnoDB: Online DDL : End of building index `fb_uid` (8 / 19)
    Mar 07 22:29:57 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:57 140159928490752 [Note] InnoDB: Online DDL : Completed
    Mar 07 22:29:57 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:57 140159928490752 [Note] InnoDB: Online DDL : Start merge-sorting index `twitter_id` (9 / 19), estimated cost : 1.1222
    Mar 07 22:29:57 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:57 140159928490752 [Note] InnoDB: Online DDL : merge-sorting has estimated 2 runs
    Mar 07 22:29:57 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:57 140159928490752 [Note] InnoDB: Online DDL : End of  merge-sorting index `twitter_id` (9 / 19)
    Mar 07 22:29:57 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:57 140159928490752 [Note] InnoDB: Online DDL : Start building index `twitter_id` (9 / 19), estimated cost : 1.6833
    Mar 07 22:29:57 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:57 140159928490752 [Note] InnoDB: Online DDL : End of building index `twitter_id` (9 / 19)
    Mar 07 22:29:57 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:57 140159928490752 [Note] InnoDB: Online DDL : Completed
    Mar 07 22:29:57 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:57 140159928490752 [Note] InnoDB: Online DDL : Start merge-sorting index `email` (10 / 19), estimated cost : 1.3055
    Mar 07 22:29:57 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:57 140159928490752 [Note] InnoDB: Online DDL : merge-sorting has estimated 5 runs
    Mar 07 22:29:57 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:57 140159928490752 [Note] InnoDB: Online DDL : End of  merge-sorting index `email` (10 / 19)
    Mar 07 22:29:57 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:57 140159928490752 [Note] InnoDB: Online DDL : Start building index `email` (10 / 19), estimated cost : 1.9582
    Mar 07 22:29:58 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:58 140159928490752 [Note] InnoDB: Online DDL : End of building index `email` (10 / 19)
    Mar 07 22:29:58 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:58 140159928490752 [Note] InnoDB: Online DDL : Completed
    Mar 07 22:29:58 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:58 140159928490752 [Note] InnoDB: Online DDL : Start merge-sorting index `member_groups` (11 / 19), estimated cost : 1.1222
    Mar 07 22:29:58 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:58 140159928490752 [Note] InnoDB: Online DDL : merge-sorting has estimated 2 runs
    Mar 07 22:29:58 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:58 140159928490752 [Note] InnoDB: Online DDL : End of  merge-sorting index `member_groups` (11 / 19)
    Mar 07 22:29:58 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:58 140159928490752 [Note] InnoDB: Online DDL : Start building index `member_groups` (11 / 19), estimated cost : 1.6833
    Mar 07 22:29:58 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:58 140159928490752 [Note] InnoDB: Online DDL : End of building index `member_groups` (11 / 19)
    Mar 07 22:29:58 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:58 140159928490752 [Note] InnoDB: Online DDL : Completed
    Mar 07 22:29:58 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:58 140159928490752 [Note] InnoDB: Online DDL : Start merge-sorting index `google_id` (12 / 19), estimated cost : 1.1222
    Mar 07 22:29:58 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:58 140159928490752 [Note] InnoDB: Online DDL : merge-sorting has estimated 2 runs
    Mar 07 22:29:58 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:58 140159928490752 [Note] InnoDB: Online DDL : End of  merge-sorting index `google_id` (12 / 19)
    Mar 07 22:29:58 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:58 140159928490752 [Note] InnoDB: Online DDL : Start building index `google_id` (12 / 19), estimated cost : 1.6833
    Mar 07 22:29:58 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:58 140159928490752 [Note] InnoDB: Online DDL : End of building index `google_id` (12 / 19)
    Mar 07 22:29:58 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:58 140159928490752 [Note] InnoDB: Online DDL : Completed
    Mar 07 22:29:58 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:58 140159928490752 [Note] InnoDB: Online DDL : Start merge-sorting index `linkedin_id` (13 / 19), estimated cost : 1.1222
    Mar 07 22:29:58 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:58 140159928490752 [Note] InnoDB: Online DDL : merge-sorting has estimated 2 runs
    Mar 07 22:29:58 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:58 140159928490752 [Note] InnoDB: Online DDL : End of  merge-sorting index `linkedin_id` (13 / 19)
    Mar 07 22:29:58 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:58 140159928490752 [Note] InnoDB: Online DDL : Start building index `linkedin_id` (13 / 19), estimated cost : 1.6833
    Mar 07 22:29:59 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:59 140159928490752 [Note] InnoDB: Online DDL : End of building index `linkedin_id` (13 / 19)
    Mar 07 22:29:59 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:59 140159928490752 [Note] InnoDB: Online DDL : Completed
    Mar 07 22:29:59 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:59 140159928490752 [Note] InnoDB: Online DDL : Start merge-sorting index `mgroup` (14 / 19), estimated cost : 1.1222
    Mar 07 22:29:59 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:59 140159928490752 [Note] InnoDB: Online DDL : merge-sorting has estimated 2 runs
    Mar 07 22:29:59 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:59 140159928490752 [Note] InnoDB: Online DDL : End of  merge-sorting index `mgroup` (14 / 19)
    Mar 07 22:29:59 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:59 140159928490752 [Note] InnoDB: Online DDL : Start building index `mgroup` (14 / 19), estimated cost : 1.6833
    Mar 07 22:29:59 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:59 140159928490752 [Note] InnoDB: Online DDL : End of building index `mgroup` (14 / 19)
    Mar 07 22:29:59 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:59 140159928490752 [Note] InnoDB: Online DDL : Completed
    Mar 07 22:29:59 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:59 140159928490752 [Note] InnoDB: Online DDL : Start merge-sorting index `allow_admin_mails` (15 / 19), estimated cost : 1.1222
    Mar 07 22:29:59 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:59 140159928490752 [Note] InnoDB: Online DDL : merge-sorting has estimated 2 runs
    Mar 07 22:29:59 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:59 140159928490752 [Note] InnoDB: Online DDL : End of  merge-sorting index `allow_admin_mails` (15 / 19)
    Mar 07 22:29:59 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:59 140159928490752 [Note] InnoDB: Online DDL : Start building index `allow_admin_mails` (15 / 19), estimated cost : 1.6833
    Mar 07 22:29:59 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:59 140159928490752 [Note] InnoDB: Online DDL : End of building index `allow_admin_mails` (15 / 19)
    Mar 07 22:29:59 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:59 140159928490752 [Note] InnoDB: Online DDL : Completed
    Mar 07 22:29:59 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:59 140159928490752 [Note] InnoDB: Online DDL : Start merge-sorting index `name_index` (16 / 19), estimated cost : 1.1833
    Mar 07 22:29:59 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:59 140159928490752 [Note] InnoDB: Online DDL : merge-sorting has estimated 3 runs
    Mar 07 22:29:59 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:59 140159928490752 [Note] InnoDB: Online DDL : End of  merge-sorting index `name_index` (16 / 19)
    Mar 07 22:29:59 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:29:59 140159928490752 [Note] InnoDB: Online DDL : Start building index `name_index` (16 / 19), estimated cost : 1.7749
    Mar 07 22:30:00 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:00 140159928490752 [Note] InnoDB: Online DDL : End of building index `name_index` (16 / 19)
    Mar 07 22:30:00 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:00 140159928490752 [Note] InnoDB: Online DDL : Completed
    Mar 07 22:30:00 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:00 140159928490752 [Note] InnoDB: Online DDL : Start merge-sorting index `ipsconnect_id` (17 / 19), estimated cost : 1.1222
    Mar 07 22:30:00 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:00 140159928490752 [Note] InnoDB: Online DDL : merge-sorting has estimated 2 runs
    Mar 07 22:30:00 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:00 140159928490752 [Note] InnoDB: Online DDL : End of  merge-sorting index `ipsconnect_id` (17 / 19)
    Mar 07 22:30:00 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:00 140159928490752 [Note] InnoDB: Online DDL : Start building index `ipsconnect_id` (17 / 19), estimated cost : 1.6833
    Mar 07 22:30:00 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:00 140159928490752 [Note] InnoDB: Online DDL : End of building index `ipsconnect_id` (17 / 19)
    Mar 07 22:30:00 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:00 140159928490752 [Note] InnoDB: Online DDL : Completed
    Mar 07 22:30:00 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:00 140159928490752 [Note] InnoDB: Online DDL : Start merge-sorting index `mod_posts` (18 / 19), estimated cost : 1.1222
    Mar 07 22:30:00 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:00 140159928490752 [Note] InnoDB: Online DDL : merge-sorting has estimated 2 runs
    Mar 07 22:30:00 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:00 140159928490752 [Note] InnoDB: Online DDL : End of  merge-sorting index `mod_posts` (18 / 19)
    Mar 07 22:30:00 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:00 140159928490752 [Note] InnoDB: Online DDL : Start building index `mod_posts` (18 / 19), estimated cost : 1.6833
    Mar 07 22:30:01 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:01 140159928490752 [Note] InnoDB: Online DDL : End of building index `mod_posts` (18 / 19)
    Mar 07 22:30:01 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:01 140159928490752 [Note] InnoDB: Online DDL : Completed
    Mar 07 22:30:01 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:01 140159928490752 [Note] InnoDB: Online DDL : Start merge-sorting index `photo_last_update` (19 / 19), estimated cost : 1.1222
    Mar 07 22:30:01 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:01 140159928490752 [Note] InnoDB: Online DDL : merge-sorting has estimated 2 runs
    Mar 07 22:30:01 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:01 140159928490752 [Note] InnoDB: Online DDL : End of  merge-sorting index `photo_last_update` (19 / 19)
    Mar 07 22:30:01 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:01 140159928490752 [Note] InnoDB: Online DDL : Start building index `photo_last_update` (19 / 19), estimated cost : 1.6833
    Mar 07 22:30:01 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:01 140159928490752 [Note] InnoDB: Online DDL : End of building index `photo_last_update` (19 / 19)
    Mar 07 22:30:01 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:01 140159928490752 [Note] InnoDB: Online DDL : Completed
    Mar 07 22:30:01 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:01 140159928490752 [Note] InnoDB: Online DDL : Start
    Mar 07 22:30:01 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:01 140159928490752 [Note] InnoDB: Online DDL : Start reading clustered index of the table and create temporary files
    Mar 07 22:30:09 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:09 140159928490752 [Note] InnoDB: Online DDL : End of reading clustered index of the table and create temporary files
    Mar 07 22:30:09 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:09 140159928490752 [Note] InnoDB: Online DDL : Start merge-sorting index `PRIMARY` (1 / 19), estimated cost : 17.2508
    Mar 07 22:30:09 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:09 140159928490752 [Note] InnoDB: Online DDL : merge-sorting has estimated 266 runs
    Mar 07 22:30:19 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:19 140159928490752 [Note] InnoDB: Online DDL : End of  merge-sorting index `PRIMARY` (1 / 19)
    Mar 07 22:30:19 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:19 140159928490752 [Note] InnoDB: Online DDL : Start building index `PRIMARY` (1 / 19), estimated cost : 25.8762
    Mar 07 22:30:25 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:25 140159928490752 [Note] InnoDB: Online DDL : End of building index `PRIMARY` (1 / 19)
    Mar 07 22:30:25 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:25 140159928490752 [Note] InnoDB: Online DDL : Completed
    Mar 07 22:30:25 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:25 140159928490752 [Note] InnoDB: Online DDL : Start merge-sorting index `bday_day` (2 / 19), estimated cost : 1.1833
    Mar 07 22:30:25 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:25 140159928490752 [Note] InnoDB: Online DDL : merge-sorting has estimated 3 runs
    Mar 07 22:30:25 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:25 140159928490752 [Note] InnoDB: Online DDL : End of  merge-sorting index `bday_day` (2 / 19)
    Mar 07 22:30:25 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:25 140159928490752 [Note] InnoDB: Online DDL : Start building index `bday_day` (2 / 19), estimated cost : 1.7749
    Mar 07 22:30:25 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:25 140159928490752 [Note] InnoDB: Online DDL : End of building index `bday_day` (2 / 19)
    Mar 07 22:30:25 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:25 140159928490752 [Note] InnoDB: Online DDL : Completed
    Mar 07 22:30:25 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:25 140159928490752 [Note] InnoDB: Online DDL : Start merge-sorting index `bday_month` (3 / 19), estimated cost : 1.1833
    Mar 07 22:30:25 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:25 140159928490752 [Note] InnoDB: Online DDL : merge-sorting has estimated 3 runs
    Mar 07 22:30:25 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:25 140159928490752 [Note] InnoDB: Online DDL : End of  merge-sorting index `bday_month` (3 / 19)
    Mar 07 22:30:25 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:25 140159928490752 [Note] InnoDB: Online DDL : Start building index `bday_month` (3 / 19), estimated cost : 1.7749
    Mar 07 22:30:26 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:26 140159928490752 [Note] InnoDB: Online DDL : End of building index `bday_month` (3 / 19)
    Mar 07 22:30:26 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:26 140159928490752 [Note] InnoDB: Online DDL : Completed
    Mar 07 22:30:26 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:26 140159928490752 [Note] InnoDB: Online DDL : Start merge-sorting index `members_bitoptions` (4 / 19), estimated cost : 1.1222
    Mar 07 22:30:26 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:26 140159928490752 [Note] InnoDB: Online DDL : merge-sorting has estimated 2 runs
    Mar 07 22:30:26 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:26 140159928490752 [Note] InnoDB: Online DDL : End of  merge-sorting index `members_bitoptions` (4 / 19)
    Mar 07 22:30:26 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:26 140159928490752 [Note] InnoDB: Online DDL : Start building index `members_bitoptions` (4 / 19), estimated cost : 1.6833
    Mar 07 22:30:26 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:26 140159928490752 [Note] InnoDB: Online DDL : End of building index `members_bitoptions` (4 / 19)
    Mar 07 22:30:26 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:26 140159928490752 [Note] InnoDB: Online DDL : Completed
    Mar 07 22:30:26 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:26 140159928490752 [Note] InnoDB: Online DDL : Start merge-sorting index `ip_address` (5 / 19), estimated cost : 1.2444
    Mar 07 22:30:26 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:26 140159928490752 [Note] InnoDB: Online DDL : merge-sorting has estimated 4 runs
    Mar 07 22:30:26 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:26 140159928490752 [Note] InnoDB: Online DDL : End of  merge-sorting index `ip_address` (5 / 19)
    Mar 07 22:30:26 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:26 140159928490752 [Note] InnoDB: Online DDL : Start building index `ip_address` (5 / 19), estimated cost : 1.8666
    Mar 07 22:30:26 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:26 140159928490752 [Note] InnoDB: Online DDL : End of building index `ip_address` (5 / 19)
    Mar 07 22:30:26 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:26 140159928490752 [Note] InnoDB: Online DDL : Completed
    Mar 07 22:30:26 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:26 140159928490752 [Note] InnoDB: Online DDL : Start merge-sorting index `failed_login_count` (6 / 19), estimated cost : 1.1222
    Mar 07 22:30:26 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:26 140159928490752 [Note] InnoDB: Online DDL : merge-sorting has estimated 2 runs
    Mar 07 22:30:26 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:26 140159928490752 [Note] InnoDB: Online DDL : End of  merge-sorting index `failed_login_count` (6 / 19)
    Mar 07 22:30:26 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:26 140159928490752 [Note] InnoDB: Online DDL : Start building index `failed_login_count` (6 / 19), estimated cost : 1.6833
    Mar 07 22:30:27 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:27 140159928490752 [Note] InnoDB: Online DDL : End of building index `failed_login_count` (6 / 19)
    Mar 07 22:30:27 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:27 140159928490752 [Note] InnoDB: Online DDL : Completed
    Mar 07 22:30:27 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:27 140159928490752 [Note] InnoDB: Online DDL : Start merge-sorting index `joined` (7 / 19), estimated cost : 1.1222
    Mar 07 22:30:27 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:27 140159928490752 [Note] InnoDB: Online DDL : merge-sorting has estimated 2 runs
    Mar 07 22:30:27 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:27 140159928490752 [Note] InnoDB: Online DDL : End of  merge-sorting index `joined` (7 / 19)
    Mar 07 22:30:27 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:27 140159928490752 [Note] InnoDB: Online DDL : Start building index `joined` (7 / 19), estimated cost : 1.6833
    Mar 07 22:30:27 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:27 140159928490752 [Note] InnoDB: Online DDL : End of building index `joined` (7 / 19)
    Mar 07 22:30:27 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:27 140159928490752 [Note] InnoDB: Online DDL : Completed
    Mar 07 22:30:27 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:27 140159928490752 [Note] InnoDB: Online DDL : Start merge-sorting index `fb_uid` (8 / 19), estimated cost : 1.1833
    Mar 07 22:30:27 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:27 140159928490752 [Note] InnoDB: Online DDL : merge-sorting has estimated 3 runs
    Mar 07 22:30:27 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:27 140159928490752 [Note] InnoDB: Online DDL : End of  merge-sorting index `fb_uid` (8 / 19)
    Mar 07 22:30:27 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:27 140159928490752 [Note] InnoDB: Online DDL : Start building index `fb_uid` (8 / 19), estimated cost : 1.7749
    Mar 07 22:30:28 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:28 140159928490752 [Note] InnoDB: Online DDL : End of building index `fb_uid` (8 / 19)
    Mar 07 22:30:28 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:28 140159928490752 [Note] InnoDB: Online DDL : Completed
    Mar 07 22:30:28 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:28 140159928490752 [Note] InnoDB: Online DDL : Start merge-sorting index `twitter_id` (9 / 19), estimated cost : 1.1222
    Mar 07 22:30:28 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:28 140159928490752 [Note] InnoDB: Online DDL : merge-sorting has estimated 2 runs
    Mar 07 22:30:28 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:28 140159928490752 [Note] InnoDB: Online DDL : End of  merge-sorting index `twitter_id` (9 / 19)
    Mar 07 22:30:28 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:28 140159928490752 [Note] InnoDB: Online DDL : Start building index `twitter_id` (9 / 19), estimated cost : 1.6833
    Mar 07 22:30:28 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:28 140159928490752 [Note] InnoDB: Online DDL : End of building index `twitter_id` (9 / 19)
    Mar 07 22:30:28 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:28 140159928490752 [Note] InnoDB: Online DDL : Completed
    Mar 07 22:30:28 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:28 140159928490752 [Note] InnoDB: Online DDL : Start merge-sorting index `email` (10 / 19), estimated cost : 1.3055
    Mar 07 22:30:28 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:28 140159928490752 [Note] InnoDB: Online DDL : merge-sorting has estimated 5 runs
    Mar 07 22:30:28 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:28 140159928490752 [Note] InnoDB: Online DDL : End of  merge-sorting index `email` (10 / 19)
    Mar 07 22:30:28 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:28 140159928490752 [Note] InnoDB: Online DDL : Start building index `email` (10 / 19), estimated cost : 1.9582
    Mar 07 22:30:29 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:29 140159928490752 [Note] InnoDB: Online DDL : End of building index `email` (10 / 19)
    Mar 07 22:30:29 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:29 140159928490752 [Note] InnoDB: Online DDL : Completed
    Mar 07 22:30:29 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:29 140159928490752 [Note] InnoDB: Online DDL : Start merge-sorting index `member_groups` (11 / 19), estimated cost : 1.1222
    Mar 07 22:30:29 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:29 140159928490752 [Note] InnoDB: Online DDL : merge-sorting has estimated 2 runs
    Mar 07 22:30:29 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:29 140159928490752 [Note] InnoDB: Online DDL : End of  merge-sorting index `member_groups` (11 / 19)
    Mar 07 22:30:29 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:29 140159928490752 [Note] InnoDB: Online DDL : Start building index `member_groups` (11 / 19), estimated cost : 1.6833
    Mar 07 22:30:29 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:29 140159928490752 [Note] InnoDB: Online DDL : End of building index `member_groups` (11 / 19)
    Mar 07 22:30:29 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:29 140159928490752 [Note] InnoDB: Online DDL : Completed
    Mar 07 22:30:29 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:29 140159928490752 [Note] InnoDB: Online DDL : Start merge-sorting index `google_id` (12 / 19), estimated cost : 1.1222
    Mar 07 22:30:29 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:29 140159928490752 [Note] InnoDB: Online DDL : merge-sorting has estimated 2 runs
    Mar 07 22:30:29 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:29 140159928490752 [Note] InnoDB: Online DDL : End of  merge-sorting index `google_id` (12 / 19)
    Mar 07 22:30:29 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:29 140159928490752 [Note] InnoDB: Online DDL : Start building index `google_id` (12 / 19), estimated cost : 1.6833
    Mar 07 22:30:30 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:30 140159928490752 [Note] InnoDB: Online DDL : End of building index `google_id` (12 / 19)
    Mar 07 22:30:30 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:30 140159928490752 [Note] InnoDB: Online DDL : Completed
    Mar 07 22:30:30 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:30 140159928490752 [Note] InnoDB: Online DDL : Start merge-sorting index `linkedin_id` (13 / 19), estimated cost : 1.1222
    Mar 07 22:30:30 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:30 140159928490752 [Note] InnoDB: Online DDL : merge-sorting has estimated 2 runs
    Mar 07 22:30:30 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:30 140159928490752 [Note] InnoDB: Online DDL : End of  merge-sorting index `linkedin_id` (13 / 19)
    Mar 07 22:30:30 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:30 140159928490752 [Note] InnoDB: Online DDL : Start building index `linkedin_id` (13 / 19), estimated cost : 1.6833
    Mar 07 22:30:30 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:30 140159928490752 [Note] InnoDB: Online DDL : End of building index `linkedin_id` (13 / 19)
    Mar 07 22:30:30 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:30 140159928490752 [Note] InnoDB: Online DDL : Completed
    Mar 07 22:30:30 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:30 140159928490752 [Note] InnoDB: Online DDL : Start merge-sorting index `mgroup` (14 / 19), estimated cost : 1.1222
    Mar 07 22:30:30 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:30 140159928490752 [Note] InnoDB: Online DDL : merge-sorting has estimated 2 runs
    Mar 07 22:30:30 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:30 140159928490752 [Note] InnoDB: Online DDL : End of  merge-sorting index `mgroup` (14 / 19)
    Mar 07 22:30:30 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:30 140159928490752 [Note] InnoDB: Online DDL : Start building index `mgroup` (14 / 19), estimated cost : 1.6833
    Mar 07 22:30:30 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:30 140159928490752 [Note] InnoDB: Online DDL : End of building index `mgroup` (14 / 19)
    Mar 07 22:30:30 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:30 140159928490752 [Note] InnoDB: Online DDL : Completed
    Mar 07 22:30:30 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:30 140159928490752 [Note] InnoDB: Online DDL : Start merge-sorting index `allow_admin_mails` (15 / 19), estimated cost : 1.1222
    Mar 07 22:30:30 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:30 140159928490752 [Note] InnoDB: Online DDL : merge-sorting has estimated 2 runs
    Mar 07 22:30:30 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:30 140159928490752 [Note] InnoDB: Online DDL : End of  merge-sorting index `allow_admin_mails` (15 / 19)
    Mar 07 22:30:30 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:30 140159928490752 [Note] InnoDB: Online DDL : Start building index `allow_admin_mails` (15 / 19), estimated cost : 1.6833
    Mar 07 22:30:31 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:31 140159928490752 [Note] InnoDB: Online DDL : End of building index `allow_admin_mails` (15 / 19)
    Mar 07 22:30:31 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:31 140159928490752 [Note] InnoDB: Online DDL : Completed
    Mar 07 22:30:31 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:31 140159928490752 [Note] InnoDB: Online DDL : Start merge-sorting index `name_index` (16 / 19), estimated cost : 1.1833
    Mar 07 22:30:31 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:31 140159928490752 [Note] InnoDB: Online DDL : merge-sorting has estimated 3 runs
    Mar 07 22:30:31 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:31 140159928490752 [Note] InnoDB: Online DDL : End of  merge-sorting index `name_index` (16 / 19)
    Mar 07 22:30:31 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:31 140159928490752 [Note] InnoDB: Online DDL : Start building index `name_index` (16 / 19), estimated cost : 1.7749
    Mar 07 22:30:31 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:31 140159928490752 [Note] InnoDB: Online DDL : End of building index `name_index` (16 / 19)
    Mar 07 22:30:31 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:31 140159928490752 [Note] InnoDB: Online DDL : Completed
    Mar 07 22:30:31 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:31 140159928490752 [Note] InnoDB: Online DDL : Start merge-sorting index `ipsconnect_id` (17 / 19), estimated cost : 1.1222
    Mar 07 22:30:31 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:31 140159928490752 [Note] InnoDB: Online DDL : merge-sorting has estimated 2 runs
    Mar 07 22:30:31 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:31 140159928490752 [Note] InnoDB: Online DDL : End of  merge-sorting index `ipsconnect_id` (17 / 19)
    Mar 07 22:30:31 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:31 140159928490752 [Note] InnoDB: Online DDL : Start building index `ipsconnect_id` (17 / 19), estimated cost : 1.6833
    Mar 07 22:30:32 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:32 140159928490752 [Note] InnoDB: Online DDL : End of building index `ipsconnect_id` (17 / 19)
    Mar 07 22:30:32 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:32 140159928490752 [Note] InnoDB: Online DDL : Completed
    Mar 07 22:30:32 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:32 140159928490752 [Note] InnoDB: Online DDL : Start merge-sorting index `mod_posts` (18 / 19), estimated cost : 1.1222
    Mar 07 22:30:32 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:32 140159928490752 [Note] InnoDB: Online DDL : merge-sorting has estimated 2 runs
    Mar 07 22:30:32 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:32 140159928490752 [Note] InnoDB: Online DDL : End of  merge-sorting index `mod_posts` (18 / 19)
    Mar 07 22:30:32 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:32 140159928490752 [Note] InnoDB: Online DDL : Start building index `mod_posts` (18 / 19), estimated cost : 1.6833
    Mar 07 22:30:32 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:32 140159928490752 [Note] InnoDB: Online DDL : End of building index `mod_posts` (18 / 19)
    Mar 07 22:30:32 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:32 140159928490752 [Note] InnoDB: Online DDL : Completed
    Mar 07 22:30:32 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:32 140159928490752 [Note] InnoDB: Online DDL : Start merge-sorting index `photo_last_update` (19 / 19), estimated cost : 1.1222
    Mar 07 22:30:32 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:32 140159928490752 [Note] InnoDB: Online DDL : merge-sorting has estimated 2 runs
    Mar 07 22:30:32 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:32 140159928490752 [Note] InnoDB: Online DDL : End of  merge-sorting index `photo_last_update` (19 / 19)
    Mar 07 22:30:32 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:32 140159928490752 [Note] InnoDB: Online DDL : Start building index `photo_last_update` (19 / 19), estimated cost : 1.6833
    Mar 07 22:30:32 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:32 140159928490752 [Note] InnoDB: Online DDL : End of building index `photo_last_update` (19 / 19)
    Mar 07 22:30:32 server.bariatricpal.com mysqld[24021]: 2017-03-07 22:30:32 140159928490752 [Note] InnoDB: Online DDL : Completed
    Any ideas?

    Thank you
     
  2. eva2000

    eva2000 Administrator Staff Member

    38,019
    8,343
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,856
    Local Time:
    11:45 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
  3. pamamolf

    pamamolf Premium Member Premium Member

    3,167
    304
    83
    May 31, 2014
    Ratings:
    +551
    Local Time:
    3:45 PM
    Nginx-1.13.x
    MariaDB 10.1.x
    I just run the same command with the same results:

    Code:
    mysqladmin ext | grep Innodb_onlineddl | tr -s ' '
    | Innodb_onlineddl_rowlog_rows | 0 |
    | Innodb_onlineddl_rowlog_pct_used | 0 |
    | Innodb_onlineddl_pct_progress | 0 |
    From what i was read there is no clear solution for it :(

    Maybe my bad english didn't help me today? :)

    Which variable at my.cnf is holding the value for row log buffer size ?

    Is this one?

    Code:
    innodb_log_file_size
     
..