We have 2 databases, one is a replication used for read only, with around a million records, we want to add a new column to the master db, to one of the tables.
Do I just go on MySql workbench and add the column, or do I need to shutdown the database first?
SELECT COUNT(1) FROM mytable;
===>489170
CREATE TABLE `mytable` (
`column1` int(11) NOT NULL auto_increment,
`column2` char(1) NOT NULL default '',
`column3` varchar(32) NOT NULL default '',
`column4` varchar(32) NOT NULL default '',
`column5` varchar(32) NOT NULL default '',
`column6` datetime NOT NULL default '0000-00-00 00:00:00',
`column7` varchar(96) NOT NULL default '',
`column8` int(11) NOT NULL default '0',
`column9` varchar(32) NOT NULL default '',
`column10` tinyint(1) NOT NULL default '1',
`column11` varchar(32) default NULL,
`column12` tinyint(1) NOT NULL default '1',
`column13` varchar(32) default NULL,
`column14` tinyint(1) NOT NULL default '1',
`column15` tinyint(1) NOT NULL default '1',
`column16` varchar(32) default NULL,
`column17` varchar(32) default NULL,
`column18` tinyint(1) NOT NULL default '1',
`column19` varchar(40) NOT NULL default '',
`column20` char(1) default '1',
`column21` varchar(11) default NULL,
`column22` tinyint(3) unsigned NOT NULL default '0',
`column23` int(11) NOT NULL default '1',
`column24` int(10) default '0',
`column25` text,
`column26` varchar(64) default NULL,
`column27` varchar(64) default NULL,
`column28` varchar(64) NOT NULL default '',
`column29` tinyint(2) default NULL,
`column30` varchar(12) NOT NULL default '',
`column31` varchar(12) NOT NULL default '',
`column32` varchar(32) NOT NULL default '',
`column33` varchar(32) default NULL,
`column34` int(10) default NULL,
`column35` int(10) default NULL,
`column36` tinyint(1) default '0',
`column37` int(1) NOT NULL default '0',
`column38` int(11) NOT NULL,
`column39` varchar(64) default NULL,
PRIMARY KEY (`column1`),
KEY `key1` (`column7`),
KEY `key2` (`column21`),
KEY `key3` (`column4`,`column5`),
KEY `key4` (`column8`),
KEY `key5` (`column24`),
KEY `key6` (`column38`)
) ENGINE=MyISAM AUTO_INCREMENT=489814 DEFAULT CHARSET=latin1
SHOW CREATE TABLE mytable\G
and runSELECT COUNT(1) FROM mytable;
and display it in the question please – RolandoMySQLDBA Jul 26 '14 at 0:47