Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
11 Cards in this Set
- Front
- Back
Syntax to show all unique variables in the config table. |
select distinct variable from config.config; or select * from config.config group by variable; |
|
Steps to pull config database from snapshot. |
1. mysql 2. DROP DATABASE config; 3. /home/product/code/firmware/current/web/cgi-bin/index.cgi or just mysql_recreate.sh |
|
Mysql not starting upon restart of mysql |
Check to see if problem is stuck PID 1. touch /tmp/nowatchdog 2. service msyql stop 3. ps aux | grep mysqld 4. kill any remaining PID's 5. rm /tmp/nowatchdog 6. service mysql start |
|
show connections |
show status where variable_name like '%conn%';
|
|
mysql error file |
/mail/mysql/..err |
|
find unknown variable |
1. tail -f /mail/log/gui 2. change value in gui |
|
Cluster variables |
cluster_systems[0] <--IP address or hostname
cluster_systems_mode[0] <--Active or standby cluster_systems_serial[0] <--Serial number |
|
Allow customer to view changes to database |
Web Interface systlog: Advanced > Advanced Networking |
|
Understand when and how to do a mysql recreate. Identify when MySQL cannot be revived. |
|
|
Identify the different databases used on the Barracuda.
|
config pu_pref stats message_log mysql information_schema test |
|
Move output into outfile |
select distinct(scope_data) from config where scope_data like '%@qgtb.com' into outfile '/tmp/output.txt'; |