pt-online-schema-change 使用基础1

mysql> create table forpttest( id int(6), name char(10), comment char(10), abc char(10));
Query OK, 0 rows affected (0.10 sec)

mysql> show create table forpttest\G
*************************** 1. row ***************************
       Table: forpttest
Create Table: CREATE TABLE `forpttest` (
  `id` int(6) DEFAULT NULL,
  `name` char(10) DEFAULT NULL,
  `comment` char(10) DEFAULT NULL,
  `abc` char(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1
1 row in set (0.00 sec)

mysql> 
mysql> desc forpttest;
+---------+----------+------+-----+---------+-------+
| Field   | Type     | Null | Key | Default | Extra |
+---------+----------+------+-----+---------+-------+
| id      | int(6)   | YES  |     | NULL    |       |
| name    | char(10) | YES  |     | NULL    |       |
| comment | char(10) | YES  |     | NULL    |       |
| abc     | char(10) | YES  |     | NULL    |       |
+---------+----------+------+-----+---------+-------+
4 rows in set (0.01 sec)


mysql> insert into pt.forpttest (id,name,comment,abc) values(1,1,1,1);
Query OK, 1 row affected (0.01 sec)

mysql>