MySQL Forums
Forum List  »  InnoDB

Re: Cannot add column to partitioned table
Posted by: harry sheng
Date: August 03, 2015 10:49AM

Mysql 5.6.16 on redhat linux 6.4 64-bit VMWare player VM (on the same machine as the 32-bit mysql instance)
VM setting: 1cpu, 2GB memory, 150GB disk

mysql> select count(*) from oamdelaytestresultentity ;
+----------+
| count(*) |
+----------+
| 297065 |
+----------+
1 row in set (0.10 sec)

mysql> alter table oamdelaytestresultentity add column sumOfSquaresRoundTripTime bigint(20) DEFAULT 0;
Query OK, 0 rows affected (53.73 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql> select count(*) from information_schema.partitions where table_name='oamdelaytestresultentity' and table_schema='XXXXX';
+----------+
| count(*) |
+----------+
| 95 |
+----------+
1 row in set (0.08 sec)

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Cannot add column to partitioned table
1071
August 03, 2015 10:49AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.