Re: Cannot add column to partitioned table
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)
Subject
Views
Written By
Posted
3187
July 31, 2015 02:25PM
1348
August 01, 2015 04:24PM
1245
August 01, 2015 05:21PM
1063
August 01, 2015 05:54PM
1098
August 02, 2015 03:30PM
Re: Cannot add column to partitioned table
1076
August 03, 2015 10:49AM
1078
August 03, 2015 05:42PM
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.