Change Mariabdb tmp location for repair

[paulconca]

Hi All

I am running a database " " repair and i get the below error


/usr/bin/myisamchk: Disk is full writing '/var/tmp/STNj7oMm' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)

Is there a way to change where the tmp files are writing?


I have tried the following but its still fills up /tmp

***************************

vi /etc/my.cnf

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
tmpdir=/usr/tmpmariadb
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd

[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

***************************

myisamchk --tmpdir=/usr/tmpmariadb

and boolean options {FALSE|TRUE} Value (after reading options)
--------------------------------- ----------------------------------------
character-sets-dir (No default value)
data-file-length 0
keys-used 18446744073709551615
max-record-length 9223372036854775807
set-auto-increment 0
set-collation (No default value)
sort-records 0
tmpdir /usr/tmpmariadb
key-buffer-size 520192
key-cache-block-size 1024
myisam-block-size 1024
read-buffer-size 262136
write-buffer-size 262136
sort-buffer-size 2097144
myisam-sort-buffer-size 2097144
sort-key-blocks 16
decode-bits 9
ft-min-word-len 4
ft-max-word-len 84
ft-stopword-file (No default value)
stats-method nulls_unequal

[ssax]

You may need to edit this file:

Code: Select all

/usr/lib/systemd/system/mariadb.service

And change this:

Code: Select all

PrivateTmp=true

To:

Code: Select all

PrivateTmp=false

Then reload the unit file and restart mariadb:

Code: Select all

systemctl daemon-reload
systemctl restart mariadb

What is the output of these commands?

Code: Select all

uname -a
cat /etc/*release
df -Th
df -Ti

[paulconca]

That didn't seem to work


Linux *******p.net 3.10.0-1127.19.1.el7.x86_64 #1 SMP Tue Aug 25 17:23:54 UTC 2020 x86_64 x86_64 x86_64 GNU/Linux



CentOS Linux release 7.8.2003 (Core)
NAME="CentOS Linux"
VERSION="7 (Core)"
ID="centos"
ID_LIKE="rhel fedora"
VERSION_ID="7"
PRETTY_NAME="CentOS Linux 7 (Core)"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:centos:centos:7"
HOME_URL="https://www.centos.org/"
BUG_REPORT_URL="https://bugs.centos.org/"

CENTOS_MANTISBT_PROJECT="CentOS-7"
CENTOS_MANTISBT_PROJECT_VERSION="7"
REDHAT_SUPPORT_PRODUCT="centos"
REDHAT_SUPPORT_PRODUCT_VERSION="7"

CentOS Linux release 7.8.2003 (Core)
CentOS Linux release 7.8.2003 (Core)


df -Th
Filesystem Type Size Used Avail Use% Mounted on
devtmpfs devtmpfs 16G 0 16G 0% /dev
tmpfs tmpfs 16G 264K 16G 1% /dev/shm
tmpfs tmpfs 16G 386M 16G 3% /run
tmpfs tmpfs 16G 0 16G 0% /sys/fs/cgroup
/dev/mapper/system-root xfs 29G 8.6G 21G 30% /
/dev/mapper/system-usr xfs 248G 86G 163G 35% /usr
/dev/sda1 xfs 1014M 244M 771M 25% /boot
/dev/mapper/system-openv xfs 5.0G 33M 5.0G 1% /usr/openv
/dev/mapper/systemlog-tmp xfs 29G 33M 29G 1% /tmp
/dev/mapper/systemlog-var xfs 240G 96G 145G 40% /var
/dev/mapper/system-home xfs 10G 34M 10G 1% /home
/dev/mapper/system-crash xfs 10G 33M 10G 1% /var/crash
/dev/mapper/systemlog-log xfs 15G 13G 2.9G 82% /var/log
/dev/mapper/system-opt xfs 7.0G 361M 6.7G 6% /opt
tmpfs tmpfs 2.0G 31M 2.0G 2% /var/nagiosramdisk
tmpfs tmpfs 3.2G 0 3.2G 0% /run/user/1020
tmpfs tmpfs 3.2G 0 3.2G 0% /run/user/1022
tmpfs tmpfs 3.2G 0 3.2G 0% /run/user/1035



df -Ti
Filesystem Type Inodes IUsed IFree IUse% Mounted on
devtmpfs devtmpfs 4092253 476 4091777 1% /dev
tmpfs tmpfs 4095205 23 4095182 1% /dev/shm
tmpfs tmpfs 4095205 750 4094455 1% /run
tmpfs tmpfs 4095205 16 4095189 1% /sys/fs/cgroup
/dev/mapper/system-root xfs 15202304 13174 15189130 1% /
/dev/mapper/system-usr xfs 130023424 155114 129868310 1% /usr
/dev/sda1 xfs 524288 378 523910 1% /boot
/dev/mapper/system-openv xfs 2621440 3 2621437 1% /usr/openv
/dev/mapper/systemlog-tmp xfs 15202304 51 15202253 1% /tmp
/dev/mapper/systemlog-var xfs 125827072 11155 125815917 1% /var
/dev/mapper/system-home xfs 5240832 297 5240535 1% /home
/dev/mapper/system-crash xfs 5240832 3 5240829 1% /var/crash
/dev/mapper/systemlog-log xfs 5937184 192 5936992 1% /var/log
/dev/mapper/system-opt xfs 3670016 11817 3658199 1% /opt
tmpfs tmpfs 4095205 354 4094851 1% /var/nagiosramdisk
tmpfs tmpfs 4095205 1 4095204 1% /run/user/1020
tmpfs tmpfs 4095205 1 4095204 1% /run/user/1022
tmpfs tmpfs 4095205 1 4095204 1% /run/user/1035

[ssax]

Please create a ticket for this and include a link back to this forum thread so we can get a remote session setup:

https://support.nagios.com/tickets/

Thank you!