Cryptocurrency Miner Parts Arrival (Part 2)

Today, our postal workers brought to the fold my CPU, RAM, motherboard, USB PCIe Risers and a 3rd GPU. We’re going to try the Pentium G4400, 4GB DDR4 RAM running at 2133MHz from Crucial and starting off the build with three 1060 OC 6GB cards from Asus.

Cryptocurrency Miner Build Ramping Up

Hello! My Co-workers and I have decided to create a co-op cryptocurrency miner. It is making use of the brand new Rosewill BM-600 mining case and so much more. Here is the first teaser of the received parts.

RAM Upgrade!!!!

Did some hardware work this morning on the FreeNAS box. I’ve added another 8GB DDR3 so I’m now running with headroom (yay!) and a total of 16GB of RAM. Additionally, I swapped the SATA cable connected to my 4TB Toshiba drive (the one giving me CDMA errors) and hopefully that eliminates the SATA communication errors… Continue reading RAM Upgrade!!!!

Back to MySQL tuning

Running MySQL Tuner we get: [!!] Temporary tables created on disk: 65% (640 on disk / 973 total) Variables to adjust: tmp_table_size (> 32M) max_heap_table_size (> 16M) And [OK] InnoDB buffer pool / data size: 128.0M/1.8M [OK] InnoDB buffer pool instances: 1 [!!] InnoDB Used buffer: 6.45% (528 used/ 8192 total) I’ll continue tweaking the… Continue reading Back to MySQL tuning

BSDCan coming to town and…more MySQL Tuning

The best conference in Ottawa….in my opinion! Check it out, it is very UNIXy and Linuxy: BSDCan 2016. I see this: [!!] Temporary tables created on disk: 65% (274 on disk / 416 total) and this: Variables to adjust: tmp_table_size (> 16M) And with some reading at the MySQL handbook, I agree with mysqltuner’s recommendations. Based on the… Continue reading BSDCan coming to town and…more MySQL Tuning

Time to tune my WordPress database

I’ll start by inspecting the anonymous accounts listed here: Remove Anonymous User accounts – there are 2 Anonymous accounts. Set up a Password for user with the following SQL statement ( SET PASSWORD FOR ‘user’@’SpecificDNSorIp’ = PASSWORD(‘secure_password’); ) Set up a Secure Password for user@host ( SET PASSWORD FOR ‘user’@’SpecificDNSorIp’ = PASSWORD(‘secure_password’); ) Log in… Continue reading Time to tune my WordPress database