Join the community today
Register Now

Sysadmin MariaDB issues with indexes of IPB forums

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

  1. pamamolf

    pamamolf Well-Known Member

    2,819
    251
    83
    May 31, 2014
    Ratings:
    +445
    Local Time:
    3:21 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

    30,924
    6,911
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,407
    Local Time:
    11:21 PM
    Nginx 1.13.x
    MariaDB 5.5
  3. pamamolf

    pamamolf Well-Known Member

    2,819
    251
    83
    May 31, 2014
    Ratings:
    +445
    Local Time:
    3:21 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