MySQL 在线optimize 77 G 大表记录

原创 2017年08月31日 23:01:56

1,操作原因:

线上表访问比较慢,update尤其慢,查了下,max(id)有146亿了,但是总记录数才2亿,所以怀疑是以前做了太多delete操作导致碎片过多引起的,所以决定做optimize操作。

2,环境

MySQL cdb实例,版本5.6.34,共享实例非物理独占类型。


3,操作前措施:

为了安全起见,停止应用写操作,应用读操作保留


4,操作方案选择:

刚准备用alter table xxxxx ,虽然5.6 在线ddl不锁全表了,但是考虑到万一故障了,回滚起来就慢的要死,说不定有可能坏表,就暂时放弃了。
最终选择pt-online-schema-change工具进行操作。


5,操作时间

半夜1点,应用发布后立即执行操作。


6,操作过程:

[huangshan@db1ys] ~/pt$ bash -x muzhi_2.sh 
+ pt-online-schema-change --recursion-method=none --no-version-check --execute --alter 'engine=innodb;' h=172.20.200.251,P=3306,u=root,p=L0xxFy3e4xhmsaml,D=user_db,t=huayuan_devices
No slaves found.  See --recursion-method if host TENCENT64.site has slaves.
Not checking slave lag because no slaves were found and --check-slave-lag was not specified.
Operation, tries, wait:
  analyze_table, 10, 1
  copy_rows, 10, 0.25
  create_triggers, 10, 1
  drop_triggers, 10, 1
  swap_tables, 10, 1
  update_foreign_keys, 10, 1
Altering `user_db`.`huayuan_devices`...
Creating new table...
Created new table user_db._huayuan_devices_new OK.
Altering new table...
Altered `user_db`.`_huayuan_devices_new` OK.
2017-08-30T01:20:26 Creating triggers...
2017-08-30T01:20:26 Created triggers OK.
2017-08-30T01:20:26 Copying approximately 284468721 rows...
Copying `user_db`.`huayuan_devices`:   0% 02:04:22 remain
Copying `user_db`.`huayuan_devices`:   0% 02:10:22 remain
Copying `user_db`.`huayuan_devices`:   1% 02:15:47 remain
Copying `user_db`.`huayuan_devices`:   1% 02:16:21 remain
Copying `user_db`.`huayuan_devices`:   1% 02:16:39 remain
Copying `user_db`.`huayuan_devices`:   2% 02:16:55 remain
Copying `user_db`.`huayuan_devices`:   2% 02:16:53 remain
Copying `user_db`.`huayuan_devices`:   2% 02:17:11 remain
Copying `user_db`.`huayuan_devices`:   3% 02:17:23 remain
Copying `user_db`.`huayuan_devices`:   3% 02:18:07 remain
Copying `user_db`.`huayuan_devices`:   3% 02:18:08 remain
Copying `user_db`.`huayuan_devices`:   4% 02:18:01 remain
Copying `user_db`.`huayuan_devices`:   4% 02:17:45 remain
Copying `user_db`.`huayuan_devices`:   4% 02:17:47 remain
Copying `user_db`.`huayuan_devices`:   5% 02:17:34 remain
Copying `user_db`.`huayuan_devices`:   5% 02:17:52 remain
Copying `user_db`.`huayuan_devices`:   5% 02:17:47 remain
Copying `user_db`.`huayuan_devices`:   6% 02:17:37 remain
Copying `user_db`.`huayuan_devices`:   6% 02:17:19 remain
Copying `user_db`.`huayuan_devices`:   6% 02:17:11 remain
Copying `user_db`.`huayuan_devices`:   7% 02:16:51 remain
Copying `user_db`.`huayuan_devices`:   7% 02:16:33 remain
Copying `user_db`.`huayuan_devices`:   7% 02:16:28 remain
Copying `user_db`.`huayuan_devices`:   8% 02:16:14 remain
Copying `user_db`.`huayuan_devices`:   8% 02:15:56 remain
Copying `user_db`.`huayuan_devices`:   8% 02:15:45 remain
Copying `user_db`.`huayuan_devices`:   9% 02:15:28 remain
Copying `user_db`.`huayuan_devices`:   9% 02:15:09 remain
Copying `user_db`.`huayuan_devices`:   9% 02:14:55 remain
Copying `user_db`.`huayuan_devices`:  10% 02:14:36 remain
Copying `user_db`.`huayuan_devices`:  10% 02:14:08 remain
Copying `user_db`.`huayuan_devices`:  10% 02:13:46 remain
Copying `user_db`.`huayuan_devices`:  11% 02:13:25 remain
Copying `user_db`.`huayuan_devices`:  11% 02:13:05 remain
Copying `user_db`.`huayuan_devices`:  11% 02:12:44 remain
Copying `user_db`.`huayuan_devices`:  11% 02:12:38 remain
Copying `user_db`.`huayuan_devices`:  12% 02:12:10 remain
Copying `user_db`.`huayuan_devices`:  12% 02:11:45 remain
Copying `user_db`.`huayuan_devices`:  12% 02:11:23 remain
Copying `user_db`.`huayuan_devices`:  13% 02:10:57 remain
Copying `user_db`.`huayuan_devices`:  13% 02:10:34 remain
Copying `user_db`.`huayuan_devices`:  13% 02:10:05 remain
Copying `user_db`.`huayuan_devices`:  14% 02:09:49 remain
Copying `user_db`.`huayuan_devices`:  14% 02:09:19 remain
Copying `user_db`.`huayuan_devices`:  14% 02:08:54 remain
Copying `user_db`.`huayuan_devices`:  15% 02:08:28 remain
Copying `user_db`.`huayuan_devices`:  15% 02:08:00 remain
Copying `user_db`.`huayuan_devices`:  15% 02:07:41 remain
Copying `user_db`.`huayuan_devices`:  16% 02:07:14 remain
Copying `user_db`.`huayuan_devices`:  16% 02:06:54 remain
Copying `user_db`.`huayuan_devices`:  16% 02:06:28 remain
Copying `user_db`.`huayuan_devices`:  17% 02:06:03 remain
Copying `user_db`.`huayuan_devices`:  17% 02:05:32 remain
Copying `user_db`.`huayuan_devices`:  17% 02:05:07 remain
Copying `user_db`.`huayuan_devices`:  18% 02:04:42 remain
Copying `user_db`.`huayuan_devices`:  18% 02:04:15 remain
Copying `user_db`.`huayuan_devices`:  18% 02:03:55 remain
Copying `user_db`.`huayuan_devices`:  19% 02:03:29 remain
Copying `user_db`.`huayuan_devices`:  19% 02:02:56 remain
Copying `user_db`.`huayuan_devices`:  19% 02:02:29 remain
Copying `user_db`.`huayuan_devices`:  19% 02:02:04 remain
Copying `user_db`.`huayuan_devices`:  20% 02:01:34 remain
Copying `user_db`.`huayuan_devices`:  20% 02:01:11 remain
Copying `user_db`.`huayuan_devices`:  20% 02:00:41 remain
Copying `user_db`.`huayuan_devices`:  21% 02:00:14 remain
Copying `user_db`.`huayuan_devices`:  21% 01:59:42 remain
Copying `user_db`.`huayuan_devices`:  21% 01:59:14 remain
Copying `user_db`.`huayuan_devices`:  22% 01:58:43 remain
Copying `user_db`.`huayuan_devices`:  22% 01:58:13 remain
Copying `user_db`.`huayuan_devices`:  22% 01:57:50 remain
Copying `user_db`.`huayuan_devices`:  23% 01:57:18 remain
Copying `user_db`.`huayuan_devices`:  23% 01:56:48 remain
Copying `user_db`.`huayuan_devices`:  23% 01:56:16 remain
Copying `user_db`.`huayuan_devices`:  24% 01:55:49 remain
Copying `user_db`.`huayuan_devices`:  24% 01:55:21 remain
Copying `user_db`.`huayuan_devices`:  24% 01:54:52 remain
Copying `user_db`.`huayuan_devices`:  25% 01:54:28 remain
Copying `user_db`.`huayuan_devices`:  25% 01:53:57 remain
Copying `user_db`.`huayuan_devices`:  25% 01:53:29 remain
Copying `user_db`.`huayuan_devices`:  26% 01:52:57 remain
Copying `user_db`.`huayuan_devices`:  26% 01:52:28 remain
Copying `user_db`.`huayuan_devices`:  26% 01:52:00 remain
Copying `user_db`.`huayuan_devices`:  27% 01:51:33 remain
Copying `user_db`.`huayuan_devices`:  27% 01:51:14 remain
Copying `user_db`.`huayuan_devices`:  27% 01:50:47 remain
Copying `user_db`.`huayuan_devices`:  28% 01:50:20 remain
Copying `user_db`.`huayuan_devices`:  28% 01:49:51 remain
Copying `user_db`.`huayuan_devices`:  28% 01:49:24 remain
Copying `user_db`.`huayuan_devices`:  29% 01:48:55 remain
Copying `user_db`.`huayuan_devices`:  29% 01:48:27 remain
Copying `user_db`.`huayuan_devices`:  29% 01:48:02 remain
Copying `user_db`.`huayuan_devices`:  29% 01:47:33 remain
Copying `user_db`.`huayuan_devices`:  30% 01:47:01 remain
Copying `user_db`.`huayuan_devices`:  30% 01:46:32 remain
Copying `user_db`.`huayuan_devices`:  30% 01:46:05 remain
Copying `user_db`.`huayuan_devices`:  31% 01:45:35 remain
Copying `user_db`.`huayuan_devices`:  31% 01:45:08 remain
Copying `user_db`.`huayuan_devices`:  31% 01:44:42 remain
Copying `user_db`.`huayuan_devices`:  32% 01:44:13 remain
Copying `user_db`.`huayuan_devices`:  32% 01:43:45 remain
Copying `user_db`.`huayuan_devices`:  32% 01:43:16 remain
Copying `user_db`.`huayuan_devices`:  33% 01:42:47 remain
Copying `user_db`.`huayuan_devices`:  33% 01:42:16 remain
Copying `user_db`.`huayuan_devices`:  33% 01:41:51 remain
Copying `user_db`.`huayuan_devices`:  34% 01:41:21 remain
Copying `user_db`.`huayuan_devices`:  34% 01:40:49 remain
Copying `user_db`.`huayuan_devices`:  34% 01:40:18 remain
Copying `user_db`.`huayuan_devices`:  35% 01:39:47 remain
Copying `user_db`.`huayuan_devices`:  35% 01:39:16 remain
Copying `user_db`.`huayuan_devices`:  35% 01:38:45 remain
Copying `user_db`.`huayuan_devices`:  36% 01:38:18 remain
Copying `user_db`.`huayuan_devices`:  36% 01:37:47 remain
Copying `user_db`.`huayuan_devices`:  36% 01:37:15 remain
Copying `user_db`.`huayuan_devices`:  37% 01:36:44 remain
Copying `user_db`.`huayuan_devices`:  37% 01:36:13 remain
Copying `user_db`.`huayuan_devices`:  37% 01:35:41 remain
Copying `user_db`.`huayuan_devices`:  38% 01:35:10 remain
Copying `user_db`.`huayuan_devices`:  38% 01:34:41 remain
Copying `user_db`.`huayuan_devices`:  38% 01:34:09 remain
Copying `user_db`.`huayuan_devices`:  39% 01:33:37 remain
Copying `user_db`.`huayuan_devices`:  39% 01:33:05 remain
Copying `user_db`.`huayuan_devices`:  39% 01:32:33 remain
Copying `user_db`.`huayuan_devices`:  40% 01:32:00 remain
Copying `user_db`.`huayuan_devices`:  40% 01:31:30 remain
Copying `user_db`.`huayuan_devices`:  40% 01:31:01 remain
Copying `user_db`.`huayuan_devices`:  41% 01:30:29 remain
Copying `user_db`.`huayuan_devices`:  41% 01:29:58 remain
Copying `user_db`.`huayuan_devices`:  41% 01:29:26 remain
Copying `user_db`.`huayuan_devices`:  42% 01:28:53 remain
Copying `user_db`.`huayuan_devices`:  42% 01:28:22 remain
Copying `user_db`.`huayuan_devices`:  42% 01:27:52 remain
Copying `user_db`.`huayuan_devices`:  43% 01:27:21 remain
Copying `user_db`.`huayuan_devices`:  43% 01:26:49 remain
Copying `user_db`.`huayuan_devices`:  43% 01:26:18 remain
Copying `user_db`.`huayuan_devices`:  44% 01:25:46 remain
Copying `user_db`.`huayuan_devices`:  44% 01:25:14 remain
Copying `user_db`.`huayuan_devices`:  44% 01:24:42 remain
Copying `user_db`.`huayuan_devices`:  45% 01:24:14 remain
Copying `user_db`.`huayuan_devices`:  45% 01:23:41 remain
Copying `user_db`.`huayuan_devices`:  45% 01:23:08 remain
Copying `user_db`.`huayuan_devices`:  46% 01:22:37 remain
Copying `user_db`.`huayuan_devices`:  46% 01:22:05 remain
Copying `user_db`.`huayuan_devices`:  46% 01:21:34 remain
Copying `user_db`.`huayuan_devices`:  47% 01:21:02 remain
Copying `user_db`.`huayuan_devices`:  47% 01:20:33 remain
Copying `user_db`.`huayuan_devices`:  47% 01:20:01 remain
Copying `user_db`.`huayuan_devices`:  48% 01:19:31 remain
Copying `user_db`.`huayuan_devices`:  48% 01:18:59 remain
Copying `user_db`.`huayuan_devices`:  48% 01:18:28 remain
Copying `user_db`.`huayuan_devices`:  49% 01:17:57 remain
Copying `user_db`.`huayuan_devices`:  49% 01:17:27 remain
Copying `user_db`.`huayuan_devices`:  49% 01:16:59 remain
Copying `user_db`.`huayuan_devices`:  50% 01:16:29 remain
Copying `user_db`.`huayuan_devices`:  50% 01:15:57 remain
Copying `user_db`.`huayuan_devices`:  50% 01:15:25 remain
Copying `user_db`.`huayuan_devices`:  51% 01:14:53 remain
Copying `user_db`.`huayuan_devices`:  51% 01:14:21 remain
Copying `user_db`.`huayuan_devices`:  51% 01:13:52 remain
Copying `user_db`.`huayuan_devices`:  52% 01:13:20 remain
Copying `user_db`.`huayuan_devices`:  52% 01:12:49 remain
Copying `user_db`.`huayuan_devices`:  52% 01:12:17 remain
Copying `user_db`.`huayuan_devices`:  53% 01:11:46 remain
Copying `user_db`.`huayuan_devices`:  53% 01:11:14 remain
Copying `user_db`.`huayuan_devices`:  53% 01:10:43 remain
Copying `user_db`.`huayuan_devices`:  54% 01:10:13 remain
Copying `user_db`.`huayuan_devices`:  54% 01:09:40 remain
Copying `user_db`.`huayuan_devices`:  54% 01:09:08 remain
Copying `user_db`.`huayuan_devices`:  55% 01:08:36 remain
Copying `user_db`.`huayuan_devices`:  55% 01:08:04 remain
Copying `user_db`.`huayuan_devices`:  55% 01:07:31 remain
Copying `user_db`.`huayuan_devices`:  56% 01:07:02 remain
Copying `user_db`.`huayuan_devices`:  56% 01:06:30 remain
Copying `user_db`.`huayuan_devices`:  56% 01:05:59 remain
Copying `user_db`.`huayuan_devices`:  57% 01:05:28 remain
Copying `user_db`.`huayuan_devices`:  57% 01:04:56 remain
Copying `user_db`.`huayuan_devices`:  57% 01:04:24 remain
Copying `user_db`.`huayuan_devices`:  58% 01:03:52 remain
Copying `user_db`.`huayuan_devices`:  58% 01:03:22 remain
Copying `user_db`.`huayuan_devices`:  58% 01:02:51 remain
Copying `user_db`.`huayuan_devices`:  59% 01:02:19 remain
Copying `user_db`.`huayuan_devices`:  59% 01:01:45 remain
Copying `user_db`.`huayuan_devices`:  59% 01:01:14 remain
Copying `user_db`.`huayuan_devices`:  60% 01:00:41 remain
Copying `user_db`.`huayuan_devices`:  60% 01:00:07 remain
Copying `user_db`.`huayuan_devices`:  60% 59:36 remain
Copying `user_db`.`huayuan_devices`:  61% 59:05 remain
Copying `user_db`.`huayuan_devices`:  61% 58:33 remain
Copying `user_db`.`huayuan_devices`:  61% 58:02 remain
Copying `user_db`.`huayuan_devices`:  62% 57:29 remain
Copying `user_db`.`huayuan_devices`:  62% 56:58 remain
Copying `user_db`.`huayuan_devices`:  62% 56:30 remain
Copying `user_db`.`huayuan_devices`:  63% 55:57 remain
Copying `user_db`.`huayuan_devices`:  63% 55:26 remain
Copying `user_db`.`huayuan_devices`:  63% 54:54 remain
Copying `user_db`.`huayuan_devices`:  64% 54:22 remain
Copying `user_db`.`huayuan_devices`:  64% 53:51 remain
Copying `user_db`.`huayuan_devices`:  64% 53:19 remain
Copying `user_db`.`huayuan_devices`:  65% 52:50 remain
Copying `user_db`.`huayuan_devices`:  65% 52:19 remain
Copying `user_db`.`huayuan_devices`:  65% 51:47 remain
Copying `user_db`.`huayuan_devices`:  66% 51:16 remain
Copying `user_db`.`huayuan_devices`:  66% 50:44 remain
Copying `user_db`.`huayuan_devices`:  66% 50:12 remain
Copying `user_db`.`huayuan_devices`:  67% 49:43 remain
Copying `user_db`.`huayuan_devices`:  67% 49:12 remain
Copying `user_db`.`huayuan_devices`:  67% 48:40 remain
Copying `user_db`.`huayuan_devices`:  68% 48:08 remain
Copying `user_db`.`huayuan_devices`:  68% 47:37 remain
Copying `user_db`.`huayuan_devices`:  68% 47:05 remain
Copying `user_db`.`huayuan_devices`:  69% 46:34 remain
Copying `user_db`.`huayuan_devices`:  69% 46:04 remain
Copying `user_db`.`huayuan_devices`:  69% 45:33 remain
Copying `user_db`.`huayuan_devices`:  70% 45:01 remain
Copying `user_db`.`huayuan_devices`:  70% 44:29 remain
Copying `user_db`.`huayuan_devices`:  70% 43:57 remain
Copying `user_db`.`huayuan_devices`:  71% 43:25 remain
Copying `user_db`.`huayuan_devices`:  71% 42:55 remain
Copying `user_db`.`huayuan_devices`:  72% 42:23 remain
Copying `user_db`.`huayuan_devices`:  72% 41:51 remain
Copying `user_db`.`huayuan_devices`:  72% 41:19 remain
Copying `user_db`.`huayuan_devices`:  73% 40:48 remain
Copying `user_db`.`huayuan_devices`:  73% 40:16 remain
Copying `user_db`.`huayuan_devices`:  73% 39:45 remain
Copying `user_db`.`huayuan_devices`:  74% 39:14 remain
Copying `user_db`.`huayuan_devices`:  74% 38:41 remain
Copying `user_db`.`huayuan_devices`:  74% 38:10 remain
Copying `user_db`.`huayuan_devices`:  75% 37:38 remain
Copying `user_db`.`huayuan_devices`:  75% 37:07 remain
Copying `user_db`.`huayuan_devices`:  75% 36:35 remain
Copying `user_db`.`huayuan_devices`:  76% 36:05 remain
Copying `user_db`.`huayuan_devices`:  76% 35:34 remain
Copying `user_db`.`huayuan_devices`:  76% 35:02 remain
Copying `user_db`.`huayuan_devices`:  77% 34:29 remain
Copying `user_db`.`huayuan_devices`:  77% 33:58 remain
Copying `user_db`.`huayuan_devices`:  77% 33:26 remain
Copying `user_db`.`huayuan_devices`:  78% 32:57 remain
Copying `user_db`.`huayuan_devices`:  78% 32:25 remain
Copying `user_db`.`huayuan_devices`:  78% 31:53 remain
Copying `user_db`.`huayuan_devices`:  79% 31:22 remain
Copying `user_db`.`huayuan_devices`:  79% 30:51 remain
Copying `user_db`.`huayuan_devices`:  79% 30:19 remain
Copying `user_db`.`huayuan_devices`:  80% 29:48 remain
Copying `user_db`.`huayuan_devices`:  80% 29:18 remain
Copying `user_db`.`huayuan_devices`:  80% 28:45 remain
Copying `user_db`.`huayuan_devices`:  81% 28:14 remain
Copying `user_db`.`huayuan_devices`:  81% 27:42 remain
Copying `user_db`.`huayuan_devices`:  81% 27:10 remain
Copying `user_db`.`huayuan_devices`:  82% 26:39 remain
Copying `user_db`.`huayuan_devices`:  82% 26:09 remain
Copying `user_db`.`huayuan_devices`:  82% 25:37 remain
Copying `user_db`.`huayuan_devices`:  83% 25:06 remain
Copying `user_db`.`huayuan_devices`:  83% 24:35 remain
Copying `user_db`.`huayuan_devices`:  84% 24:03 remain
Copying `user_db`.`huayuan_devices`:  84% 23:32 remain
Copying `user_db`.`huayuan_devices`:  84% 23:02 remain
Copying `user_db`.`huayuan_devices`:  85% 22:30 remain
Copying `user_db`.`huayuan_devices`:  85% 21:59 remain
Copying `user_db`.`huayuan_devices`:  85% 21:27 remain
Copying `user_db`.`huayuan_devices`:  86% 20:56 remain
Copying `user_db`.`huayuan_devices`:  86% 20:25 remain
Copying `user_db`.`huayuan_devices`:  86% 19:54 remain
Copying `user_db`.`huayuan_devices`:  87% 19:23 remain
Copying `user_db`.`huayuan_devices`:  87% 18:52 remain
Copying `user_db`.`huayuan_devices`:  87% 18:20 remain
Copying `user_db`.`huayuan_devices`:  88% 17:48 remain
Copying `user_db`.`huayuan_devices`:  88% 17:17 remain
Copying `user_db`.`huayuan_devices`:  88% 16:46 remain
Copying `user_db`.`huayuan_devices`:  89% 16:16 remain
Copying `user_db`.`huayuan_devices`:  89% 15:45 remain
Copying `user_db`.`huayuan_devices`:  89% 15:14 remain
Copying `user_db`.`huayuan_devices`:  90% 14:42 remain
Copying `user_db`.`huayuan_devices`:  90% 14:11 remain
Copying `user_db`.`huayuan_devices`:  90% 13:40 remain
Copying `user_db`.`huayuan_devices`:  91% 13:11 remain
Copying `user_db`.`huayuan_devices`:  91% 12:39 remain
Copying `user_db`.`huayuan_devices`:  91% 12:08 remain
Copying `user_db`.`huayuan_devices`:  92% 11:37 remain
Copying `user_db`.`huayuan_devices`:  92% 11:06 remain
Copying `user_db`.`huayuan_devices`:  92% 10:36 remain
Copying `user_db`.`huayuan_devices`:  93% 10:07 remain
Copying `user_db`.`huayuan_devices`:  93% 09:40 remain
Copying `user_db`.`huayuan_devices`:  93% 09:11 remain
Copying `user_db`.`huayuan_devices`:  94% 08:42 remain
Copying `user_db`.`huayuan_devices`:  94% 08:14 remain
Copying `user_db`.`huayuan_devices`:  94% 07:45 remain
Copying `user_db`.`huayuan_devices`:  95% 07:17 remain
Copying `user_db`.`huayuan_devices`:  95% 06:49 remain
Copying `user_db`.`huayuan_devices`:  95% 06:22 remain
Copying `user_db`.`huayuan_devices`:  96% 05:54 remain
Copying `user_db`.`huayuan_devices`:  96% 05:26 remain
Copying `user_db`.`huayuan_devices`:  96% 04:57 remain
Copying `user_db`.`huayuan_devices`:  97% 04:28 remain
Copying `user_db`.`huayuan_devices`:  97% 03:59 remain
Copying `user_db`.`huayuan_devices`:  97% 03:30 remain
Copying `user_db`.`huayuan_devices`:  97% 03:03 remain
Copying `user_db`.`huayuan_devices`:  98% 02:33 remain
Copying `user_db`.`huayuan_devices`:  98% 02:04 remain
Copying `user_db`.`huayuan_devices`:  98% 01:35 remain
Copying `user_db`.`huayuan_devices`:  99% 01:07 remain
Copying `user_db`.`huayuan_devices`:  99% 00:37 remain
Copying `user_db`.`huayuan_devices`:  99% 00:09 remain
2017-08-30T03:54:44 Copied rows OK.
2017-08-30T03:54:44 Analyzing new table...
2017-08-30T03:54:44 Swapping tables...
2017-08-30T03:54:44 Swapped original and new tables OK.
2017-08-30T03:54:44 Dropping old table...
2017-08-30T03:55:20 Dropped old table `user_db`.`_huayuan_devices_old` OK.
2017-08-30T03:55:20 Dropping triggers...
2017-08-30T03:55:20 Dropped triggers OK.
Successfully altered `user_db`.`huayuan_devices`.
[huangshan@db1ys] ~/pt$ 
版权声明:本文为博主原创文章,未经博主允许不得转载。

相关文章推荐

OpenVPN协议解析-握手数据包分析

学习一种协议的最好的方式就是研究它的数据包,这样可以加深对协议的理解。对于研究过某种协议数据包的家伙来讲,他一定知道协议头的哪个位置对应哪个字段,虽然这对于理解协议为什么这么设计可能没有太大的帮助,然...

CTDB代码流程简要梳理

ctdb 2.5.3主体代码流程

Inception 初探

1,安装下载组件 wget clone https:/github.com/mysql-inception/inception.git rz ll unzip inception-master....

比特币与区块链的大众科普文

前言本文相对稍微长一点。        近日不知道为什么,区块链重新又火了起来,自2013年结识这个概念到现在已经4年了,最近由于大家都在聊这个,我也就想参与进来,然而我发现这是一个很难学习的东西,我...
  • dog250
  • dog250
  • 2017-03-31 00:51
  • 4128

MySQL 大表在线DML神器--pt-online-schema-change

一个朋友问我在线对大表进行ddl操作,如何做能尽量避免主从延迟以及不影响在线dml操作呢?我想到一个开源的pt-online-schema-change工具,测试了吧,效果还可以。pt-online-...

山重水复疑无路,柳暗花明又一村

同事报告说有个cdb mysql实例最近很慢,写入速度巨慢,而且是间歇性的有的时候每隔7到8分钟就卡一会,有的时候每隔12分钟就卡一会,问他们是否有定时任务在拉数据?他们说没有。 那是否有很多比较慢的...

OkHttp源码解析

同步请求用例//创建对象 OkHttpClient client = new OkHttpClient(); //创建请求 Request request = new Request.Builder(...

ViewGroup源码解读

本篇文章已授权我的公众号:我就是马云飞 首发 我们之前刚刚分析完事件传递机制和view的源码,如果没有看过的,建议看完View的事件拦截机制浅析以及View的事件源码解析。这次我们来分析下viewgr...

面向对象的常见写法与优缺点

我们通过表单验证的功能,来逐步演进面向对象的方式.   对于刚刚接触javascript的朋友来说,如果要写一个验证用户名,密码,邮箱的功能, 一般可能会这么写: 1 //...

Linux下SVN配置

1.安装svn yum install subversion   2.创建版本库fengyu (版本库的名字取来和你web项目的名字相同,否则你在服务器检出后会变成web项目里还有一层版本库的...
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:深度学习:神经网络中的前向传播和反向传播算法推导
举报原因:
原因补充:

(最多只允许输入30个字)