🖥️mysqladmin

➡️This is a command-line reference manual for commands and command combinations that you don’t use often enough to remember it. This cheatsheet explains the mysqladmin command with important options and switches using examples.

2 minute read

▁ ▂ ▃ ▄ ꧁ 🔴☠ COMMANDLINE-KUNGFU WITH CHEATSHEETS ☠🔴꧂▅ ▃ ▂ ▁

#  ███╗   ███╗██╗   ██╗███████╗ ██████╗ ██╗      █████╗ ██████╗ ███╗   ███╗██╗███╗   ██╗
#  ████╗ ████║╚██╗ ██╔╝██╔════╝██╔═══██╗██║     ██╔══██╗██╔══██╗████╗ ████║██║████╗  ██║
#  ██╔████╔██║ ╚████╔╝ ███████╗██║   ██║██║     ███████║██║  ██║██╔████╔██║██║██╔██╗ ██║
#  ██║╚██╔╝██║  ╚██╔╝  ╚════██║██║▄▄ ██║██║     ██╔══██║██║  ██║██║╚██╔╝██║██║██║╚██╗██║
#  ██║ ╚═╝ ██║   ██║   ███████║╚██████╔╝███████╗██║  ██║██████╔╝██║ ╚═╝ ██║██║██║ ╚████║
#  ╚═╝     ╚═╝   ╚═╝   ╚══════╝ ╚══▀▀═╝ ╚══════╝╚═╝  ╚═╝╚═════╝ ╚═╝     ╚═╝╚═╝╚═╝  ╚═══╝
# 

# InnoDB related parameters
mysqladmin variables | egrep '(innodb_log_file|innodb_data_file)'

# mysql status - cron entry to record mysql status every minute
mysqladmin status >> /home/status.txt 2>> /home/status_err.txt

# mysql backup utility
mysqlbackup --port=3306 --protocol=tcp --user=dba --password=dba  --with-timestamp  --backup-dir=/tmp/toback/ --slave-info backup-and-apply-log  --innodb_data_file_path=ibdata1:10M:autoextend --innodb_log_files_in_group=2 --innodb_log_file_size=5242880

# check mysql capacity to handle traffic
mysqlslap  --query=/root/select_query_cp.sql --concurrency=10 --iterations=5  --create-schema=cvts1

# check mysql server performance
mysqlslap --query=/home/ec2-user/insert.txt --concurrency=123 --iterations=1  --create-schema=test

Cheatsheets are an excellent complement to other information sources like Linux man-pages, Linux help, or How-To’s and tutorials, as they provide compact and easily accessible information. While man-pages and detailed tutorials often contain comprehensive explanations and extensive guides, cheatsheets summarize the most important options forthe command mysqladmin in a clear format. This allows users to quickly access the needed information for mysqladmin without having to sift through lengthy texts. Especially in stressful situations or for recurring tasks, cheatsheets for mysqladmin are a valuable resource to work efficiently and purposefully.

░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░

  █║▌│║█║▌★ KALI ★ PARROT ★ DEBIAN 🔴 PENTESTING ★ HACKING ★ █║▌│║█║▌

              ██╗ ██╗ ██████╗  ██████╗ ██╗  ██╗███████╗██████╗
             ████████╗██╔══██╗██╔═══██╗╚██╗██╔╝██╔════╝██╔══██╗
             ╚██╔═██╔╝██║  ██║██║   ██║ ╚███╔╝ █████╗  ██║  ██║
             ████████╗██║  ██║██║   ██║ ██╔██╗ ██╔══╝  ██║  ██║
             ╚██╔═██╔╝██████╔╝╚██████╔╝██╔╝ ██╗███████╗██████╔╝
              ╚═╝ ╚═╝ ╚═════╝  ╚═════╝ ╚═╝  ╚═╝╚══════╝╚═════╝

               █║▌│║█║▌ WITH COMMANDLINE-KUNGFU POWER █║▌│║█║▌

░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░

Feedback

Was this page helpful?

Glad to hear it! Please tell us how we can improve.

Sorry to hear that. Please tell us how we can improve.