mysqladmin -u sky -ppwd -h localhost
ping
mysqladmin -u sky -ppwd -h localhost status
mysqladmin -u sky -ppwd -h localhost processlist
mysql -u root -p123456 -BNe
"select host,count(host) from processlist group by host;"
information_schema
mysql -e
"SHOW STATUS LIKE '%uptime%'"
|
awk
'/ptime/{ calc = $NF / 3600;print $(NF-1), calc"Hour" }'
mysql -u root -p123456-e
'select table_schema,round(sum(data_length+index_length)/1024/1024,4) from information_schema.tables group by table_schema;'
mysql -u <user> --password=<password> -e
"SHOW COLUMNS FROM <table>"
<database> |
awk
'{print $1}'
|
tr
"\n"
","
|
sed
's/,$//g'
mysql -u user-name -p password < script.sql
mysqldump -uroot -T
/tmp/mysqldump
test
test_outfile --fields-enclosed-by=\" --fields-terminated-by=,
mysqlimport --user=name --password=
pwd
test
--fields-enclosed-by=\" --fields-terminated-by=,
/tmp/test_outfile
.txt
LOAD DATA INFILE
'/tmp/test_outfile.txt'
INTO TABLE test_outfile FIELDS TERMINATED BY
'"'
ENCLOSED BY
','
;
ps
-ef |
grep
"mysqld_safe"
|
grep
-
v
"grep"
ps
-ef |
grep
"mysqld"
|
grep
-
v
"mysqld_safe"
|
grep
-
v
"grep"
mysql -u root -p123456 -e
'show status'
mysqlcheck -u root -p123456 --all-databases
mysql -u root -p123456 -e
'SHOW /*!50000 GLOBAL */ STATUS LIKE "Questions"'
mysql -u root -p123456 -e
'SHOW /*!50000 GLOBAL */ STATUS LIKE "Queries"'
mysql -u root -p123456 -e
'SHOW /*!50000 GLOBAL */ STATUS LIKE "Key%"'
mysql -u root -p123456 -e
'SHOW /*!50000 GLOBAL */ STATUS LIKE "Innodb_buffer_pool_read%"'
mysql -u root -p123456 -e
'SHOW /*!50000 GLOBAL */ STATUS LIKE "Qcache%"'
mysql -u root -p123456 -e
'SHOW /*!50000 GLOBAL */ STATUS LIKE "Open%"'
mysql -u root -p123456 -e
'SHOW /*!50000 GLOBAL */ STATUS LIKE "Thread%"'
mysql -u root -p123456 -e
'SHOW /*!50000 GLOBAL */ STATUS LIKE "%lock%"'
mysql -u root -p123456 -e
'SHOW SLAVE STATUS'
mysql -u root -p123456 -e
'SHOW /*!50000 GLOBAL */ STATUS LIKE "Created_tmp%"'
mysql -u root -p123456 -e
'SHOW /*!50000 GLOBAL */ STATUS LIKE "Binlog_cache%"'
mysql -u root -p123456 -e
'SHOW /*!50000 GLOBAL */ STATUS LIKE "Innodb_log_waits'