MySQL Forums
Forum List  »  General

Issue adding Field to MYSQL Table
Posted by: Inam Awan
Date: July 29, 2024 02:47AM

Hi,

We are trying to add a column e.g. columnA tinyint(1) to an existing table. Total number of columns already used in the table are 103, where as total number of rows are 230K and size of the table is about 230 MB. There are 12 indexed columns in the table and we are using InnoDB engine. While we add this column to the table it takes forever; while when we exported the complete database schema and imported it on another server, after import we added the same column in the same table and it worked fine. Row size already checked it is very low.
We are unable to add this column yet. What is the possible reason of not adding a column with tinyint(1) data size? Just for exploring we tried adding column of different types e.g. varchar, longtext; the result was the same.

Prompt reply will help us alot in resolving this issue, and we will be much obliged.

We are using MYSQL 5.7.

Thanks and Regards,
Inam

Options: ReplyQuote


Subject
Written By
Posted
Issue adding Field to MYSQL Table
July 29, 2024 02:47AM


Sorry, only registered users may post in this forum.

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.