Posts

Getting Started with ZFS on Debian 8

Introduction

ZFS has been around for a very long time round about over 10 years, and that is the future Btrfs file system for Linux machines, ZFS has its own meaning. It was the first file system to implement many features to protect data from getting damaged.

But, although some distributions have started shipping Btrfs, he is still relatively young. ZFS on the other hand, is quite mature, and if you want to set up your own discs with a file system that is able to recover corrupted data, then you should look into ZFS.

There are many reasons why you should use for your ZFS file servers to create a hard disk pool to increase redundancy. On the one hand, it is scalable, so there is virtually no limit on the size of your storage is. And, it continues to check the integrity of your data to protect it from corruption.

How to Enable mysql slow query logs in Debian/Ubuntu

Step 1: Modify /etc/mysql/my.cnf File

To enable mysql slow query logs add the lines in my.cnf file.

#vi /etc/mysql/my.cnf

log_slow_queries = /var/log/mysql/mysql-slow.log
long_query_time = 2
log-queries-not-using-indexes

Step 2: Restart mysql service

After inserting the above entries restart mysql server.

#service mysqld restart