服务器 Gind.cn
  1. 服务器 Gind.cn
  3. Mysql查询日志在启动后是空的
Intereting Posts
Apache / Postfix / Cyrus – 如何限制访问某个域？ 简单的方法来监视多个MS 2003服务器上的磁盘空间 活动目录和Exchange体系结构的问题和问题 奇怪的rsync问题 – 复制和解压缩文件 是否可以从VMware ESXi下的直通式LSI 2008 SAS控制器进行引导？ SoapClient PHP 5.6在IIS 7（FastCgi）中运行缓慢，可以从CLI中调用 2008企业数据中心 Exchange Server与IMAP 删除OWA httpsredirect Powershell：需要Exchange统计信息并运行（输出）限制 我该怎么做才能保持一个共同的文件caching服务器？ NFS是个好主意？ 清理Puppet仪表板中节点的旧域名 如何在debian上停止git-daemon 备份EC2实例 networking安装麻烦，尝试响应外部ping时变得“无法访问”

Mysql查询日志在启动后是空的

我无法弄清楚为什么一般和缓慢的查询日志后电脑重新启动。 使用systemctl重新启动服务器后，日志将被填充。 重新启动后，文件被创build为空。 

$ stat /var/log/mysql/query.log File: '/var/log/mysql/query.log' Size: 0 Blocks: 0 IO Block: 4096 regular empty file Device: 801h/2049d Inode: 6947352 Links: 1 Access: (0660/-rw-rw----) Uid: ( 89/ mysql) Gid: ( 89/ mysql) Access: 2016-04-28 05:04:04.530835820 +0200 Modify: 2016-04-28 05:04:04.530835820 +0200 Change: 2016-04-28 05:04:04.530835820 +0200 Birth: - $ stat /var/log/mysql/slow.log File: '/var/log/mysql/slow.log' Size: 0 Blocks: 0 IO Block: 4096 regular empty file Device: 801h/2049d Inode: 6947484 Links: 1 Access: (0660/-rw-rw----) Uid: ( 89/ mysql) Gid: ( 89/ mysql) Access: 2016-04-28 05:04:04.530835820 +0200 Modify: 2016-04-28 05:04:04.530835820 +0200 Change: 2016-04-28 05:04:04.530835820 +0200 Birth: -

my.cnf文件： 

 # The MariaDB server [mysqld] port = 3306 socket = /run/mysqld/mysqld.sock skip-external-locking key_buffer_size = 16M max_allowed_packet = 1M table_open_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M character-set-server = utf8 general_log = 1 # log every query general_log_file = /var/log/mysql/query.log slow_query_log = 1 long_query_time = 1

系统单元文件： 

 $ cat /etc/systemd/system/multi-user.target.wants/mysqld.service [Unit] Description=MariaDB database server After=syslog.target [Service] User=mysql Group=mysql ExecStart=/usr/bin/mysqld --pid-file=/run/mysqld/mysqld.pid ExecStartPost=/usr/bin/mysqld-post Restart=always PrivateTmp=true [Install] WantedBy=multi-user.target

服务重新启动后，日志将被填充： 

 $ sudo systemctl restart mysqld.service $ stat /var/log/mysql/query.log File: '/var/log/mysql/query.log' Size: 255 Blocks: 8 IO Block: 4096 regular file Device: 801h/2049d Inode: 6947352 Links: 1 Access: (0660/-rw-rw----) Uid: ( 89/ mysql) Gid: ( 89/ mysql) Access: 2016-04-28 05:04:04.530835820 +0200 Modify: 2016-04-28 06:50:52.534122763 +0200 Change: 2016-04-28 06:50:52.534122763 +0200 Birth: - $ stat /var/log/mysql/slow.log File: '/var/log/mysql/slow.log' Size: 171 Blocks: 8 IO Block: 4096 regular file Device: 801h/2049d Inode: 6947484 Links: 1 Access: (0660/-rw-rw----) Uid: ( 89/ mysql) Gid: ( 89/ mysql) Access: 2016-04-28 05:04:04.530835820 +0200 Modify: 2016-04-28 06:50:51.854122769 +0200 Change: 2016-04-28 06:50:51.854122769 +0200 Birth: -