Comment 1 for bug 1277986

Revision history for this message
Paul Namuag (paul-namuag) wrote : Re: Empty GRA_*_*.log file generated after closing a MySQL session that was used to insert rows on a MEMORY table

Verified this as well in Centos.

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 5.6.15-56-log Percona XtraDB Cluster (GPL), Release 25.3, Revision 706, wsrep_25.3.r4034

Copyright (c) 2009-2013 Percona LLC and/or its affiliates
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> select @@general_log;
+---------------+
| @@general_log |
+---------------+
| 1 |
+---------------+
1 row in set (0.00 sec)

mysql> use memtables;
Database changed
mysql> create table mem1(a int not null auto_increment primary key, b int null) engine=memory;
Query OK, 0 rows affected (0.00 sec)

mysql> insert into mem1(b) values(1),(2),(3);
Query OK, 3 rows affected (0.01 sec)
Records: 3 Duplicates: 0 Warnings: 0

mysql> quit
Bye

[root@node1 mysql]# ls -alth .
total 237M
drwxr-xr-x 6 mysql mysql 4.0K Feb 11 06:02 .
-rw-rw---- 1 root root 0 Feb 11 06:02 GRA_11_-1.log
-rw-r----- 1 root root 26K Feb 11 06:02 node1.err
-rw-rw---- 1 root root 6.5K Feb 11 06:02 node1.log
-rw-rw---- 1 root root 104 Feb 11 06:02 grastate.dat
drwx------ 2 root root 4.0K Feb 11 06:02 memtables
-rw------- 1 root root 129M Feb 11 06:02 galera.cache
-rw-rw---- 1 root root 3.6K Feb 11 05:52 innobackup.backup.log
-rw-rw---- 1 mysql mysql 48M Feb 11 05:45 ib_logfile0
-rw-rw---- 1 mysql mysql 12M Feb 11 05:45 ibdata1
-rw-rw---- 1 root root 5 Feb 11 05:45 node1.pid
srwxrwxrwx 1 root root 0 Feb 11 05:45 mysql.sock
-rw-rw---- 1 mysql mysql 56 Feb 11 03:49 auto.cnf
-rw-r--r-- 1 root root 120 Feb 11 03:49 RPM_UPGRADE_HISTORY
-rw-r--r-- 1 mysql mysql 120 Feb 11 03:49 RPM_UPGRADE_MARKER-LAST
drwx------ 2 mysql mysql 4.0K Feb 11 03:49 mysql
drwx------ 2 mysql mysql 4.0K Feb 11 03:49 performance_schema
-rw-rw---- 1 mysql mysql 48M Feb 11 03:49 ib_logfile1
drwx------ 2 mysql mysql 4.0K Feb 11 03:49 test
drwxr-xr-x. 25 root root 4.0K Feb 11 03:49 ..

[root@node1 mysql]# uname -a
Linux node1 2.6.32-358.el6.x86_64 #1 SMP Fri Feb 22 00:31:26 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux

[root@node1 mysql]# lsb_release -a
LSB Version: :base-4.0-amd64:base-4.0-noarch:core-4.0-amd64:core-4.0-noarch
Distributor ID: CentOS
Description: CentOS release 6.4 (Final)
Release: 6.4
Codename: Final