Sample Header Ad - 728x90

Adding columns upped my RAM usage significantly

1 vote
1 answer
152 views
I have a Google Cloud Platform MySQL 2nd Gen 5.7 instance with two databases, one for testing and one for production. There are about 20 or so tables. One of the tables accounts for 99% of the storage. I added 8 columns to the largest table (it already has ~150 columns) of the testing db. 6 of the new columns are Integer and 2 of them are Boolean (or more accurately, TinyInt). No indexes of any kind added. Below is a snapshot of the metrics from the migration operation. You can clearly see CPU and Storage peaks for each of the 8 columns. snapshots Weird part is, RAM usage goes up an stays up. Any insight on what I may have forgotten to do? The columns did not have any data populated to them, all are Null for each row so far
Asked by Brian Leach (225 rep)
Oct 30, 2018, 05:07 PM
Last activity: Jul 12, 2025, 12:04 AM