Why Does Ubuntu 18.04 Boot Even Slower After Networking is Disabled for Booting and ‘noresume’ Parameter is Added to Boot kernel?

I notice how my Ubuntu 18 boots very slow, so much slower than Windows that previously installed on the same machine. I don’t use dual-boot, my machine is : Ubuntu 18.04.3 LTS Intel® Core™ i7-7700HQ CPU @ 2.80GHz × 8 64-bit, NVIDIA GeForce GTX 950M NVIDIA was quite problematic and causing boot issues, so I…

Details

Mysql master/slave promotion of resources with Pacemaker not working

I’m trying to get a master/slave setup working with Pacemaker. However, I ran into a few problems. For some things I found a solution. I would like to have some feedback on this, because the official documentation seems to insufficient. I followed the resource-agents/heartbeat/README.mariadb.md instructions. My first problem was that the commands are out of…

Details

Mysql GROUP BY really slow on a view

I have these tables. CREATE TABLE `movements` ( `movementId` mediumint(8) UNSIGNED NOT NULL, `movementType` tinyint(3) UNSIGNED NOT NULL, `deleted` tinyint(1) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; ALTER TABLE `movements` ADD PRIMARY KEY (`movementId`), ADD KEY `movementType` (`movementType`) USING BTREE, ADD KEY `deleted` (`deleted`), ADD KEY `movementId` (`movementId`,`deleted`); CREATE TABLE `movements_items` ( `movementId` mediumint(8) UNSIGNED…

Details