#!/bin/bash

# > df -T /var/lib/mysql
# Filesystem                    Type  1K-blocks       Used  Available Use% Mounted on
# /dev/mapper/vgmysql-lvolmysql ext4 4226435512 2283978596 1749651528  57% /var/lib/mysql

# > df -T /var/lib/mysql
# Filesystem     Type 1K-blocks     Used Available Use% Mounted on
# mysql_datadir  zfs  142989952 22156976 120832976  16% /var/lib/mysql

VAR_LIB_MYSQL="$(df -T /var/lib/mysql | grep -Ev '^Filesystem' | awk '{print $1,$2}')"
#echo "VAR_LIB_MYSQL=${VAR_LIB_MYSQL}"

DEV_NAME="$(echo "${VAR_LIB_MYSQL}" | awk '{print $1}')"
FS_NAME="$(echo "${VAR_LIB_MYSQL}" | awk '{print $2}')"
if [ zfs = "${FS_NAME}" ] ; then
        #zpool status ${DEV_NAME} | sed -ne '/config:/,/errors:/p' | grep -Ev 'config:|NAME[[:space:]]+STATE|errors:|^[[:space:]]*$' | tail -n1 | awk '{print $1}'
        #zpool iostat -v ${DEV_NAME} | sed -ne '/-------------/,/-------------/p' | grep -Fv -- '-------------' | grep -Fv ${DEV_NAME} | awk '{print $1}'
        ZPOOL_IOSTAT="$(zpool iostat -v ${DEV_NAME} | sed -ne '/-------------/,/-------------/p' | grep -Fv -- '-------------' | grep -Fv ${DEV_NAME})"
        DAS_DEV="$(echo "${ZPOOL_IOSTAT}" | awk '{print $1}')"
else
        DAS_DEV="$(readlink -f ${DEV_NAME})"
fi

if [ -e "${DAS_DEV}" ] ; then
        #ls -lha ${DAS_DEV}
	echo ${DAS_DEV}
else
        #ls -lha /dev/${DAS_DEV}
	echo /dev/${DAS_DEV}
fi