Software: nginx/1.23.4. PHP/5.6.40-65+ubuntu20.04.1+deb.sury.org+1 

uname -a: Linux foro-restaurado-2 5.15.0-1040-oracle #46-Ubuntu SMP Fri Jul 14 21:47:21 UTC 2023
aarch64 

uid=33(www-data) gid=33(www-data) groups=33(www-data) 

Safe-mode: OFF (not secure)

/home/scripts/   drwxr-xr-x
Free 83.32 GB of 96.73 GB (86.14%)
                            Encoder    Tools    Proc.    FTP brute    Sec.    SQL    PHP-code    Update    Feedback    Self remove    Logout    

Viewing file:     optimiza_mysql.sh (994 B)      -rw-rw-r--

#!/bin/sh

#echo -n "MySQL username: " ; read username
#echo -n "MySQL password: " ; stty -echo ; read password ; stty echo ; echo
username='papyr225_1'
password='ilvm2rg2'

mysql -u $username -p"$password" -NBe "SHOW DATABASES;" | grep -v 'lost+found' |grep -v 'papyr225_phpb1'| while read database ; do
mysql -u $username -p"$password" -NBe "SHOW TABLE STATUS;" $database | while read name engine version rowformat rows avgrowlength datalength maxdatalength indexlength datafree autoincrement createtime updatetime checktime collation checksum createoptions comment ; do
  if [ "$datafree" -gt 0 ] ; then
   fragmentation=$(($datafree * 100 / $datalength))
   echo "$database.$name is $fragmentation% fragmented."
   mysql -u "$username" -p"$password" -NBe "OPTIMIZE TABLE $name;" "$database"
  fi
done
done
mysql -u "$username" -p"$password" -NBe "TRUNCATE phpbb_sessions_keys;" "papyr225_phpb1"
mysql -u "$username" -p"$password" -NBe "OPTIMIZE TABLE phpbb_sessions_keys;" "papyr225_phpb1"