How to Set MySQL Long Query Time Value for log-slow-queries

Saturday, July 3rd, 2010 85 views

If you enable slow queries log of MySQL database server, you will notice that from the slow query log file contains only SQL statements and queries that took more than query_time of 10 seconds to execute or run. This is the default value or query time threshold for log_slow_queries function, which is 10 seconds. 10 [...]

Posted in MYSQL | No Comments »

How to Enable Remote Access To MySQL Database Server?

Thursday, June 24th, 2010 199 views

By default remote access to MySQL database server is disabled for security reasons. However, some time you need to provide remote access to database server from home or a web server. MySQL Remote Access You need type the following commands which will allow remote connections. Step # 1: Login Using SSH (if server is outside [...]

Posted in Apache server, How to, Knowledge, Linux system | No Comments »