proxySQL設定チート


#プロセス操作
| init script run                                          | systemd                                                            | Admin>           | 
| -------------------------------------------------------- | ------------------------------------------------------------------ | ---------------- | 
| service proxysql start                                   | systemctl start proxysql                                           |                  | 
| service proxysql stop                                    | systemctl stop proxysql                                            | proxysql stop    | 
| service proxysql restart                                 | systemctl restart proxysql                                         | proxysql restart | 
| /etc/init.d/proxysql initial<br>service proxysql initial | systemctl start proxysql-initial<br>service proxysql-initial start |




##テーブル一覧とコピペ用コマンド

|RUNTIME|MEMORY|LOAD and Save|SELECT|DELETE|
|----|----|----|----|----|
|runtime_global_variables|global_variables|LOAD MYSQL VARIABLES TO RUNTIME;SAVE MYSQL VARIABLES TO DISK|SELECT * FROM global_variables;|DELETE * FROM global_variables;|
|runtime_mysql_aws_aurora_hostgroups|mysql_aws_aurora_hostgroups| |SELECT * FROM mysql_aws_aurora_hostgroups;|DELETE * FROM mysql_aws_aurora_hostgroups;|
|runtime_mysql_firewall_whitelist_rules|mysql_firewall_whitelist_rules| |SELECT * FROM mysql_firewall_whitelist_rules;|DELETE * FROM mysql_firewall_whitelist_rules;|
|runtime_mysql_firewall_whitelist_sqli_fingerprints|mysql_firewall_whitelist_sqli_fingerprints| |SELECT * FROM mysql_firewall_whitelist_sqli_fingerprints;|DELETE * FROM mysql_firewall_whitelist_sqli_fingerprints;|
|runtime_mysql_firewall_whitelist_users|mysql_firewall_whitelist_users| |SELECT * FROM mysql_firewall_whitelist_users;|DELETE * FROM mysql_firewall_whitelist_users;|
|runtime_mysql_galera_hostgroups|mysql_galera_hostgroups| |SELECT * FROM mysql_galera_hostgroups;|DELETE * FROM mysql_galera_hostgroups;|
|runtime_mysql_group_replication_hostgroups|mysql_group_replication_hostgroups| |SELECT * FROM mysql_group_replication_hostgroups;|DELETE * FROM mysql_group_replication_hostgroups;|
|runtime_mysql_query_rules|mysql_query_rules|LOAD MYSQL QUERY RULES TO RUNTIME;SAVE MYSQL QUERY RULES TO DISK;|SELECT * FROM mysql_query_rules;|DELETE * FROM mysql_query_rules;|
|runtime_mysql_query_rules_fast_routing|mysql_query_rules_fast_routing| |SELECT * FROM mysql_query_rules_fast_routing;|DELETE * FROM mysql_query_rules_fast_routing;|
|runtime_mysql_replication_hostgroups|mysql_replication_hostgroups| |SELECT * FROM mysql_replication_hostgroups;|DELETE * FROM mysql_replication_hostgroups;|
|runtime_mysql_servers|mysql_servers|LOAD MYSQL SERVERS TO RUNTIME;SAVE MYSQL SERVERS TO DISK;|SELECT * FROM mysql_servers;|DELETE * FROM mysql_servers;|
|runtime_mysql_users|mysql_users|LOAD MYSQL USERS TO RUNTIME;SAVE MYSQL USERS TO DISK;|SELECT * FROM mysql_users;|DELETE * FROM mysql_users;|
|runtime_proxysql_servers|proxysql_servers| |SELECT * FROM proxysql_servers;|DELETE * FROM proxysql_servers;|
|runtime_restapi_routes|restapi_routes| |SELECT * FROM restapi_routes;|DELETE * FROM restapi_routes;|
|runtime_scheduler|scheduler| |SELECT * FROM scheduler;|DELETE * FROM scheduler;|





### コンフィグ確認
```
cat /etc/proxysql.cnf
```

### ログ確認
```
less /var/lib/proxysql/proxysql.log
```