Question : I took this example from a book where visitors_today is the cache table from visitor_stored. The idea is […]
Tag: alter-table
When changing the size of a nvarchar column, do I need to drop the unique index? And will the table get locked when recreating the index?
Question : In our database a big table exists that more or less looks like this: CREATE TABLE dbo.production_data ( […]
Prevent replication of ALTER commands
Question : I am using MariaDB 10.0 multi-source replication for a specific use case. For security reasons, I would like […]
Adding a default constraint in Oracle while altering a column
Question : I’m new to Oracle. I need to port a SQL Server command to Oracle. I want to alter […]
Adding nullable column to table costs more than 10 minutes
Question : I have problems to add a new column on a table. I tried to run it a couple […]
Renaming a column in a materialized view with an unknown name
Question : I have a materialized view with an unknown column name, and I need to give that column a […]
Why do my RDS read IOPS drop after a certain period of time?
Question : I am trying to add non-null constraints on several columns in a table with about 70,000,000 rows. Each […]
Cannot add a column to an InnoDB table in Mariadb
Question : I have this InnoDB table with less than 10 rows in mysql 5.5.40-MariaDB on Linux (x86_64). +—————–+————–+——+—–+——————-+—————-+ | […]
Preventing replication of alter table command to change engine
Question : I am in the process of switching a MySQL table from MyISAM to InnoDB and I do not […]
MySQL – fastest way to ALTER TABLE for InnoDB
Question : I have an InnoDB table that I want to alter. The table has ~80M rows, and quit a […]