Hi,
we are having very bad performance problems, for example creation of a simple mysql table
CREATE TABLE `catalogsearch_fulltext_scope5` ( `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID', `attribute_id` int(10) unsigned NOT NULL COMMENT 'Attribute_id', `data_index` longtext COMMENT 'Data index', PRIMARY KEY (`entity_id`,`attribute_id`), FULLTEXT KEY `FTI_FULLTEXT_DATA_INDEX` (`data_index`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='catalogsearch_fulltext_scope5' ;
takes around a minute.
On another VM we then set writeback in Proxmox to unsafe (it is a only a testing VM) and had a spead gain from 27 secounds in that case to 0.02 seconds.
How "safe" is it to set "unsafe" on production VMs ? What's the worst case that could happen? What would happen in case of a crash of one node?
we are having very bad performance problems, for example creation of a simple mysql table
CREATE TABLE `catalogsearch_fulltext_scope5` ( `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID', `attribute_id` int(10) unsigned NOT NULL COMMENT 'Attribute_id', `data_index` longtext COMMENT 'Data index', PRIMARY KEY (`entity_id`,`attribute_id`), FULLTEXT KEY `FTI_FULLTEXT_DATA_INDEX` (`data_index`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='catalogsearch_fulltext_scope5' ;
takes around a minute.
On another VM we then set writeback in Proxmox to unsafe (it is a only a testing VM) and had a spead gain from 27 secounds in that case to 0.02 seconds.
How "safe" is it to set "unsafe" on production VMs ? What's the worst case that could happen? What would happen in case of a crash of one node?
