}
2023 m. vasario 7 d., antradienis
php kodas, tikrinantis įmonės registracijos numerį
2022 m. kovo 28 d., pirmadienis
xtrabackup - mysql file level backup
https://www.digitalocean.com/community/tutorials/how-to-create-hot-backups-of-mysql-databases-with-percona-xtrabackup-on-centos-7
https://www.percona.com/blog/2020/04/10/percona-xtrabackup-backup-and-restore-of-a-single-table-or-database/
2022 m. vasario 28 d., pirmadienis
2022 m. vasario 16 d., trečiadienis
mysql connections
show variables like "%max_connections%";show global status like "%Max_used%";show status like "%thread%";
2022 m. vasario 15 d., antradienis
mysql memory calculator
#!/bin/sh# you might want to add some user authentication here
mysql -e "show variables; show status" | awk ' { VAR[$1]=$2 } END { MAX_CONN = VAR["max_connections"] MAX_USED_CONN = VAR["Max_used_connections"] BASE_MEM=VAR["key_buffer_size"] + VAR["query_cache_size"] + VAR["innodb_buffer_pool_size"] + VAR["innodb_additional_mem_pool_size"] + VAR["innodb_log_buffer_size"] MEM_PER_CONN=VAR["read_buffer_size"] + VAR["read_rnd_buffer_size"] + VAR["sort_buffer_size"] + VAR["join_buffer_size"] + VAR["binlog_cache_size"] + VAR["thread_stack"] + VAR["tmp_table_size"] MEM_TOTAL_MIN=BASE_MEM + MEM_PER_CONN*MAX_USED_CONN MEM_TOTAL_MAX=BASE_MEM + MEM_PER_CONN*MAX_CONN printf "+------------------------------------------+--------------------+\n" printf "| %40s | %15.3f MB |\n", "key_buffer_size", VAR["key_buffer_size"]/1048576 printf "| %40s | %15.3f MB |\n", "query_cache_size", VAR["query_cache_size"]/1048576 printf "| %40s | %15.3f MB |\n", "innodb_buffer_pool_size", VAR["innodb_buffer_pool_size"]/1048576 printf "| %40s | %15.3f MB |\n", "innodb_additional_mem_pool_size", VAR["innodb_additional_mem_pool_size"]/1048576 printf "| %40s | %15.3f MB |\n", "innodb_log_buffer_size", VAR["innodb_log_buffer_size"]/1048576 printf "+------------------------------------------+--------------------+\n" printf "| %40s | %15.3f MB |\n", "BASE MEMORY", BASE_MEM/1048576 printf "+------------------------------------------+--------------------+\n" printf "| %40s | %15.3f MB |\n", "sort_buffer_size", VAR["sort_buffer_size"]/1048576 printf "| %40s | %15.3f MB |\n", "read_buffer_size", VAR["read_buffer_size"]/1048576 printf "| %40s | %15.3f MB |\n", "read_rnd_buffer_size", VAR["read_rnd_buffer_size"]/1048576 printf "| %40s | %15.3f MB |\n", "join_buffer_size", VAR["join_buffer_size"]/1048576 printf "| %40s | %15.3f MB |\n", "thread_stack", VAR["thread_stack"]/1048576 printf "| %40s | %15.3f MB |\n", "binlog_cache_size", VAR["binlog_cache_size"]/1048576 printf "| %40s | %15.3f MB |\n", "tmp_table_size", VAR["tmp_table_size"]/1048576 printf "+------------------------------------------+--------------------+\n" printf "| %40s | %15.3f MB |\n", "MEMORY PER CONNECTION", MEM_PER_CONN/1048576 printf "+------------------------------------------+--------------------+\n" printf "| %40s | %18d |\n", "Max_used_connections", MAX_USED_CONN printf "| %40s | %18d |\n", "max_connections", MAX_CONN printf "+------------------------------------------+--------------------+\n" printf "| %40s | %15.3f MB |\n", "TOTAL (MIN)", MEM_TOTAL_MIN/1048576 printf "| %40s | %15.3f MB |\n", "TOTAL (MAX)", MEM_TOTAL_MAX/1048576 printf "+------------------------------------------+--------------------+\n" }'
2021 m. gruodžio 22 d., trečiadienis
mysql dump import pagreitintuvas
#!/bin/bash
DATA="/db.sql.gz"
SIZE="$(du $DATA | awk '{ print $1 }')K"
DBNAME="test"
DBPASS="Apasdasdasdfnti"
DBUSER="root"
{
#echo "Dropping/creating database ${DBNAME}" >&2
#echo "DROP DATABASE IF EXISTS ${DBNAME};"
#echo "CREATE DATABASE ${DBNAME};"
echo "use ${DBNAME};"
echo "Setting speed settings" >&2
echo "SET FOREIGN_KEY_CHECKS = 0;"
echo "SET UNIQUE_CHECKS = 0;"
echo "SET AUTOCOMMIT = 0;"
echo "Loading data (this will take a while)" >&2
cat $DATA | gzip -d
echo "Resetting speed settings" >&2
echo "SET FOREIGN_KEY_CHECKS = 1;"
echo "SET UNIQUE_CHECKS = 1;"
echo "COMMIT;"
echo "Done." >&2
} | pv -ps $SIZE | mysql --password=$DBPASS --user=$DBUSER
#paprastas 1 eilutes pvz
# pv /home/dnsb/dbtest.sql.gz | gunzip | mysql --password=Apdasdadti --user=root dbname
# pv dump.sql.gz | zcat | mysql -u user -ppasswd database
#nblogask itas pvz https://github.com/servercollective/import-large-mysql-dump/blob/master/import.sh
#ddl="$ddl set global net_buffer_length=1000000; "
#ddl="$ddl set global max_allowed_packet=1000000000; "