Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ MySQL 5.6 Open full query log     - MySQL common functions summary (Database)

- Ubuntu 14.04.1 LTS compile and install the new kernel (Linux)

- How Linux Log Analysis (Linux)

- SQL statement to repair SQL Server database (Database)

- Linux file system data file deletion problem space is not freed (Database)

- lack of SWAP space during installation of Oracle (Database)

- Install Redis 2.6 5.5 32 position CentOS error resolved (Linux)

- Puppet centralized configuration management system (Server)

- Linux operating system to solve a serious fault handling (Linux)

- How Linux system password security guarantee (Linux)

- MongoDB 2.6 deployment replica set + partitions (Database)

- Configuring s3c-linux-2.6.28.6-Real6410 appears Unable to find the QT3 installation (Linux)

- Python cause yum upgrade error (Linux)

- C # assembly calls across constants, variables and functions (Programming)

- Install the open source database PostgreSQL 9.4 and phpMyAdmin on Ubuntu (Database)

- Linux 64-bit porting (Programming)

- Learning UNIX good habits (Linux)

- Oracle RMAN-06023 and ORA-19693 errors (Database)

- Git commands (Linux)

- Lua4.0 interpreter entrance (Programming)

 
         
  MySQL 5.6 Open full query log
     
  Add Date : 2016-07-17      
         
         
         
  Today, because of local calls to query a SQL statement in the query log when full production, has been thought to write this in my.cnf as long as:

log = / home / logs / mysql.log

However, when you restart discovery packet Starting MySQL. ERROR! The server quit without updating PID file (/home/data/mysql//localhost.localdomain.pid) Error

I thought it was the question of powers, after the /home/logs/mysql.log permission to modify or not, just add a comment decisively code normal start mysql.

According to this configuration under the above again, that in my.cnf [mysqld] add the following two lines of code:

general_log = ON

general_log_file = / home / logs / mysql.log
     
         
         
         
  More:      
 
- Android Custom View password box example (Programming)
- RabbitMQ tutorial examples: RabbitMQ installation under Windows (Linux)
- CentOS 6.5 installation using a data recovery software extundelete (Linux)
- CentOS7 Kubernetes used on container management (Server)
- Java Generics Introduction --HashMap summary (Programming)
- C ++ constant definition (Programming)
- Ubuntu Tutorial - Manually install Oracle Java JDK 8 (Linux)
- Practical top command (Linux)
- Compression decompression command under Linux (Linux)
- Android memory optimization of the disk cache (Linux)
- Android engineers interview questions (Programming)
- Efficient Linux Shell - Shell special characters Summary (Linux)
- Under CentOS yum install Nginx smooth switch mounted to Tengine (Server)
- The relationship between UNIX and Linux (Linux)
- To build PHP environment (Nginx + MariaDB + PHP7) under CentOS 6.5 (Server)
- To create a Linux server network security (Linux)
- How to install and configure a VNC server on CentOS 7.0 (Server)
- Computer security protection remove local and remote system log files (Linux)
- Installation and configuration under Linux SVN server - Backup - Recovery - Scheduled Tasks (Server)
- Ubuntu install code editor Sublime Text 3 (Linux)
     
           
     
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.