在VPC中的subnets與Security Groups確認SMTP (25) outbound 是否有開啟?
2.安裝 snedmail:
sudo apt-get install sendmail
參考資料:
http://stackoverflow.com/questions/19858457/send-mail-using-amazon-ec2-instance
slow_query_log
: To create the slow query log, set to 1. The
default is 0.general_log
: To create the general log, set to 1. The default is
0.log_output
: To write the general and slow query logs to the file
system, set to FILE
. The default is TABLE
, which
writes general queries to the mysql.general_log
table, and slow
queries to the mysql.slow_log
table. To disable logging, set to
NONE
.long_query_time
: To prevent fast-running queries from being
logged in the slow query log, specify a value for the shortest query
execution time to be logged, in seconds. The default is 10 seconds, the
minimum is 0. If log_output = FILE, you can specify a floating point value
that goes to microsecond resolution. If log_output = TABLE, you must specify
an integer value with second resolution. Only queries whose execution time
exceeds the long_query_time
value are logged. For
example, setting long_query_time
to 0.1 prevents any
query that runs for less than 100 milliseconds from being logged.log_queries_not_using_indexes
: To log all queries that do not use
an index to the slow query log, set to 1. The default is 0. Queries that do
not use an index are logged even if their execution time is less than the
value of the long_query_time
parameter.Variable_name | Value | |
---|---|---|
slow_query_log | OFF | |
slow_query_log_file | /usr/local/mysql/data/server-slow.log |
Command-Line Format | --log-queries-not-using-indexes | ||
System Variable Name | log_queries_not_using_indexes | ||
Variable Scope | Global | ||
Dynamic Variable | Yes | ||
Permitted Values | |||
Type | boolean | ||
Default | OFF |