MySQL Optimize

Optimize MariaDB Edit file

Find

On this section, you will see “#skip-external-locking”, add below.

This is some basic settings. Now run MySQL tuner, make suggestions as required. To make the settings live, you need to restart MariaDB server.

MySQL Tuner

innodb_buffer_pool_size On a server with 32 GB RAM, set

[…]

Read More…

Create Dummy Data in Amazon EFS

Disk read/write speed in Amazon EFS depends on how much data you have on the file system. Amazon EFS have something called BurstCreditBalance, that shows much much data balance you have available. Initially all file system have some 2 TB Burst credit, this is is for you to copy data. If you don’t copy dummy […]

Read More…

Nginx configuration for aMember

Here is Nginx configuration for aMember script

See Nginx […]

Read More…

Install R1Soft Agent

To install R1Soft Agent on CentOS, create a file

Add

Now you can install Agent with command

You can stop/start agent with command

Once installed, verify connectivity with command

See r1soft […]

Read More…

Delta RPMs disabled

When i install software on CentOS server, i get following warning Delta RPMs disabled because /usr/bin/applydeltarpm not installed. You can install deltaparm package

This will save you some bandwidth as yum will only download difference between previous package. […]

Read More…

r1soft

r1soft is a backup software from https://www.r1soft.com Installing Agent Install R1Soft Agent on CentOS Installing r1soft server backup agent on Debian/Ubuntu r1Soft Setup Add Server to R1Soft Server Backup Manager Configure Server Backup in R1Soft Backup Manager Using r1Soft Server Backup How to restore R1Soft Backup r1Soft Errors r1Soft public key is not available See […]

Read More…

btrfs

On ubuntu, install it with

To format a partition in btrfs, run

To mount, use

Since we don’t create any partition inside /dev/sdc, we just use sdc instead of normal sdc1. I tried with /dev/sdc1, but did not work.

[…]

Read More…

MySQL

MySQL 8 Find all MySQL databases using InnoDB engine Find MySQL Server Version MySQL Installation Install MySQL 8 on CentOS 6/7 Install MySQL 8 on Ubuntu/Debian MySQL root can’t login to phpMyAdmin How to Disable MySQL Strict Mode Install MySQL as Service in Windows MySQL Initialize Data Directory MySQL User Management Create MySQL User MySQL […]

Read More…