# --- OpenVZ 7 host

vzctl create 100 --ostemplate debian-10.0-x86_64
vzctl set 100 --hostname mariadb-dbgsym --save
vzctl set 100 --ram 1024M --swap 1024M --save
vzctl set 100 --cpus 4 --save
vzctl set 100 --ipdel all --ipadd 10.31.0.66 --save
vzctl set 100 --nameserver 8.8.8.8 --nameserver 8.8.4.4 --save
vzctl set 100 --diskspace 32G --save
vzctl start 100

cp -av /home/bdd_www_xxxxxxxxxxxx_ch_2022-11-03_21-15-41.sql.bz2 /vz/root/100/home/

vzctl enter 100

# --- Inside container

wget -O- https://mariadb.org/mariadb_release_signing_key.asc | apt-key add -
echo "deb https://mirrors.ircam.fr/pub/mariadb/repo/10.9/debian buster main" >> /etc/apt/sources.list
apt-get update && apt-get -y upgrade
apt-get -y install gdb mariadb-server mariadb-server-core-dbgsym mariadb-client-dbgsym mariadb-server-dbgsym

echo "[server]" >> /etc/mysql/mariadb.cnf
echo "core_file" >> /etc/mysql/mariadb.cnf
echo "log_error = /var/log/mysql/error.log" >> /etc/mysql/mariadb.cnf
echo "long_query_time = 0.0001" >> /etc/mysql/mariadb.cnf
echo "slow_query_log = TRUE" >> /etc/mysql/mariadb.cnf
echo "slow_query_log_file = /var/log/mysql/slow.log" >> /etc/mysql/mariadb.cnf

systemctl restart mariadb

mysql -e "CREATE DATABASE bdd_test_1; CREATE DATABASE bdd_test_2; CREATE DATABASE bdd_test_3;"
( bzcat /home/bdd_www_xxxxxxxxxxxx_ch_2022-11-03_21-15-41.sql.bz2 | mysql bdd_test_1 ) &
( bzcat /home/bdd_www_xxxxxxxxxxxx_ch_2022-11-03_21-15-41.sql.bz2 | mysql bdd_test_2 ) &
( bzcat /home/bdd_www_xxxxxxxxxxxx_ch_2022-11-03_21-15-41.sql.bz2 | mysql bdd_test_3 ) &
wait
exit

# --- OpenVZ 7 host

vzctl suspend 100
sleep 300
vzctl resume 100
ls -1 /vz/root/100/var/lib/mysql/core.*
vzctl enter 100