Skip to content

Instantly share code, notes, and snippets.

@JeansBolong
Last active July 26, 2021 01:46
Show Gist options
  • Save JeansBolong/58e5ad4187ad7c38157e701cf0311c25 to your computer and use it in GitHub Desktop.
Save JeansBolong/58e5ad4187ad7c38157e701cf0311c25 to your computer and use it in GitHub Desktop.
AWS

restart aws server

sudo /opt/bitnami/ctlscript.sh restart

php.ini bitnami location

/opt/bitnami/php/etc/php.ini

To Enable them just follow below steps:

step1: Go to this file (/etc/mysql/conf.d/mysqld_safe_syslog.cnf) and remove or comment those line.

step2: Go to mysql conf file (/etc/mysql/my.cnf) and add following lines

To enable error log add following

[mysqld_safe]
log_error=/var/log/mysql/mysql_error.log

[mysqld]
log_error=/var/log/mysql/mysql_error.log
To enable general query log add following

general_log_file        = /var/log/mysql/mysql.log
general_log             = 1
To enable Slow Query Log add following

log_slow_queries       = /var/log/mysql/mysql-slow.log
long_query_time = 2
log-queries-not-using-indexes

step3: save the file and restart mysql using following commands

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment