Categories
Uncategorized

Ricoh GR III cannot import directly into Mac Photos

My Ricoh GR III camera shows up in Mac Photos when connected however none of the photos are loaded. There is some issue with the type of connection to the Mac.

The easy workaround is running Image Capture.app (just do a search for image capture in the search function on the Mac) and you can download the photos from Image Capture directly to Photos.

Categories
Uncategorized

MySQL my.ini performance

The following configuration in the my.ini for MySQL provided me with very decent performance. Especially on Microsoft Windows 10 with MySQL 8.X

innodb_buffer_pool_size = 256M
innodb_log_file_size = 1G
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
innodb_thread_concurrency = 0
flush_time = 300
innodb_read_io_threads = 8
innodb_write_io_threads = 8

Categories
Uncategorized

PHPMyAdmin slow in loading table list

When you have innoDB tables with many rows, InnoDB does not store the number of rows in a table but MyISAM does.

So for each InnoDB table PHPMyAdmin invokes SELECT count(*) FROM query which is very slow if number of rows is very high. To resolve this you should edit config.inc.php file and set $cfg['MaxExactCount']. This will invoke count(*) sql for tables that has less MaxExactCount rows.

Open \config.inc.php file and add these two lines of code in it:

$cfg['MaxExactCount'] = 0;
$cfg['MaxExactCountViews'] = 0;

Resource: https://stackoverflow.com/questions/14027351/phpmyadmin-opens-mysql-table-lists-very-slowly/53140805

Categories
Uncategorized

Apple wireless Keyboard lag

When experiencing keyboard lag on your Apple wireless keyboards I found that resetting all connected apple devices resolved the issue. Simply removing / disconnecting the keyboard didn’t solve the issue.

Reset Connected Apple Devices

  1. Hold down the Shift and the Option keys and click on the Bluetooth icon in the top menu bar.
  2. Select Factory Reset all Connected Apple Devices.
  3. Reconnect (pair) your Bluetooth devices.
Categories
Uncategorized

High CPU usage by Google Drive

I’ve been noticing high CPU (20% and higher) by multiple google drive processes on an RDS Server. Killing Google Drive on the server did not fix the issue.

After further investigation it appeared that the users on the RDS server had Google Drive auto started but couldn’t use it as the screen would never show up to login. I’m guessing Google drive got into some weird loop or so. For each user on their desktop I went to the Settings > “Startup Apps” settings and disabled the auto start of Google Drive. This solved the issue all together.

The multiple high CPU processes created by Google Drive disappeared. This makes sense as I did not see just one Google Drive instance but multiples.

Categories
Uncategorized

Initialize MySQL 8 Data Directory on Windows 10

When installing MySQL 8 on Windows 10 you will have to initialize the data directory. Run a CMD as administrator and paste the following in

"C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld" --initialize-insecure --basedir="C:\Program Files\MySQL\MySQL Server 8.0" --datadir="C:\Program Files\MySQL\MySQL Server 8.0\data" --console

Without the data directory being in initialized you will get messages like:

  • “Failed to find valid data directory”
  • “Data Dictionary initialization failed”
Categories
Uncategorized

Resize Linux osDisk partition on Azure

1) Login to the VM using SSH, we can check the size of the disk by using:
sudo dmesg | grep -i sda

We should see something similar to the output below (assuming you changed the size to 100GB on the portal for the disk):
[    3.100914] sd 2:0:0:0: [sda] 209715200 512-byte logical blocks: (107 GB/100 GiB)

2) To proceed with the partition resize, we will use: sudo fdisk /dev/sda

type: p
this will show partition /dev/sda1

type: d
type: n then p1 (to recreate partition 1) you can accept the default values
NOTE: if you receive a message about deleting or keeping a signature on the disk, just answer N
type: w (to save the new partition)
type: q (to exit fdisk)
sudo reboot (to reboot the VM so the partition is updated)

3) To finalize the resize, after the reboot, execute the command: resize2fs /dev/sda1

4) Use the command: df -h to verify its size:
Filesystem Size Used Avail Use% Mounted on
/dev/sda1 99G 698M 94G 1% /

From: https://docs.microsoft.com/en-us/archive/blogs/linuxonazure/how-to-resize-linux-osdisk-partition-on-azure

Categories
Uncategorized

Install the Azure Linux Agent

Perhaps as easy as? –

apt install waagent
service walinuxagent restart

——-NOT THE FOLLOWING?!—–

Choose the Azure Linux Agent release here:

https://github.com/Azure/WALinuxAgent/releases

Copy the URL to the tar.gz file

Go the the directory you want to download the file and enter

wget https://github.com/Azure/WALinuxAgent/archive/XXXXX.tar.gz

Expand the file

tar -xvf XXXXXXXX.tar.gz

Install the new python downloaded version

sudo python setup.py install --register-service

Restart the waagent service

sudo service waagent restart

Verify the version details

waagent -version

If you get an error saying setup tools is missing run the following:

To install setuptools on Debian:

sudo apt-get install python3-setuptools

For an older version of Python (Python 2.x):

sudo apt-get install python-setuptools

Reference: https://github.com/Azure/WALinuxAgent

Reference: https://cloudskillsup.com/upgrade-microsoft-azure-linux-python-agent-in-private-network-node/

Categories
Uncategorized

Gnome GUI “Authentication Required” Administrator password

When getting a popup message to Authenticate as “administrator” in gnome it most likely means the user you are using does not have the correct groups associated to them.

Some of the messages you see were “Authentication required to refresh system repositories”

When rebooting or relogging in, it will now show your username to authenticate instead of “administrator”

Add the user to the adm and sudo group.

sudo usermod -a -G adm <username>

sudo usermod -a -G sudo <username>

Not exactly related – but similar issue:

https://gitlab.gnome.org/GNOME/gnome-shell/-/issues/352

Categories
Uncategorized

Compacting Linux VHDX with Hyper-V

I wasn’t able to reduce the file size of my Linux disks on Hyper-V through the build in compact function of Hyper-V

In order to compact your disk run the following command on the Linux install

sudo fstrim -v

Shutdown your Linux install

Compact your disk

Credit: https://helgeklein.com/blog/2016/11/faster-trimming-compacting-hyper-v-ubuntu-vms/