Sysadmin MariaDB issues with indexes of IPB forums

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

 

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