Notes: MariaDb setup

MariaDb Setup

/etc/mysql/maria.conf.d/50-server.cnf

comment out:

bind-address = 127.0.0.1



Check Configurations

On db server, open shell (mysql -u root -p)

Run query, SELECT User, Host FROM mysql.user

Google Cloud Setup

VPC Network
Firewall Rules

Direction: Ingress
Source Filters: IP Address of device accessing db server
Applicable to instances: permission to users

Work Life: Another way to rename a file is to move it

Sometimes I do not learn my own lessons very well and having to re-invent the wheel each time. The latest example is for renaming SSRS reports. There is no option to rename, so I have just been deleting and uploading with the new file name. I knew this couldn't be the answer, so I kept searching because my initial searches didn't come up with the answer. Eventually finding out that I just had to move the file to the same location with a new name which to my embarrassment, I have also used. It just never clicked.

A palm to forehead moment would occur a few seconds later where I have used this solution elsewhere in my past. I cannot recall at the moment but I definitely had to do this before. Then it just evolves to just shaking my head.

Buggish: Microsoft Teams Web Excel slow performance at 7500 records

I use Microsoft Teams Web Excel. There is an obvious performance issue at 7500+ records with about 15 columns that are mostly populated.

This spreadsheet is an audit history of objects that I have promoted since last year. The largest column is the object path which typically would be file paths as they would include server and folder paths. The other columns are simple strings at most 50 characters or date-time fields.

The biggest problem is the copy/paste. I will oftentimes get the error:

Retrieving data. Wait a few seconds and try to cut or copy again.

Before, waiting will sometimes work but now waiting does not seem to work at all. I do not know if waiting will ever work but I've tried pasting a few hours later and I will still get this message.

Copy/pasting rows now take time. Inserting new rows take time. If I keep my browser open overnight, sometimes it takes a minute or two just for the page to allow me to click on something.

Do I know specifically that this is due to the number of records? No. I am only assuming because it seems to be a trend I see with Microsoft products. Also there is weak correlations between the number of records and frequency of issues or length of delay.

Rebooting sometimes helped before. Now, most little tricks to improve performance no longer work.

Update (2021-09-02)

I split some old data to another sheet, and the performance almost seems immediately better. I moved about 2500 records out of the primary sheet. With around 5200 records, performance still has intermittent issues but much less frequent and faster but still noticeable.