Slow_query_log_file = /var/log/mysql/log_slow_query. Ive just tweaked the my.cnf parameters and now the query speed has. From the system variable, my slow query is still off?I use Cpanel WHM 64.0 on CentOS 7. NB If I try to visit your site then I get an error 502 - Bad Gateway. Therefore it impossible to publish a configuration that will work on another server. Hi, Ive noticed since I updated 1.4.1->1.4.3 that my response upon loading an individual.php has become real slow. Also, unlike apache, which can be configured for a sub-folder, nginx must be configured globally. The reasons for this situation is: MySQL deliberately not let user permissions override my.cnf, default is 644, namely -rw-r-r-, if the permissions that are not 644, will appear this kind of circumstance. If yes then probably I should create my.cnf at /etc/mysql. Is it possible that there is no my.cnf and MySQL works with default values. The above result shows that the my.cnf file on my local computer is located on /usr/local/etc/my.cnf Once you find the. Where is my.cnf file I searched the whole file system and result is empty. Backup the existing my.cnf file using the following command. That's because there are too many variables, and everyone's server is different. I installed MySQL on my machine using instructions mentioned here. Login to server via ssh (Use a client like putty if you are on a windows machine) Putty Download Steps to Login using Putty 2. I wanted to turn on slow query and performance schema, but why after I made changes to the my.cnf (which is in default location, etc/my.cnf) and restarted the server(service mysql restart). I could not find a recommended Nginx config.
0 Comments
Leave a Reply. |