Open source SQL database often used on Linux with Apache and PHP (LAMP)
[mysqld]set-variable=long_query_time=1log-slow-queries=/var/log/mysql/log-slow-queries.loglog-slow-queries = slow.log long_query_time = 20 log-queries-not-using-indexes
You must create the file manually and change owners this way:
mkdir /var/log/mysqltouch /var/log/mysql/log-slow-queries.logchown mysql.mysql -R /var/log/mysql
To index 3 charater words add the following to the /etc/my.cnf file at the end of the [mysqld] section.
Then restart the mysql service, and run the following sql.