On Wed, Jul 3, 2013 at 11:34 AM, Peterson, Timothy R
>> -----Original Message-----
>> From: Larry Martell [mailto:larry.martell@stripped]
>> Sent: Wednesday, July 03, 2013 11:29 AM
>> To: shawn green
>> Cc: mysql@stripped
>> Subject: Re: 1 file
>> On Wed, Jul 3, 2013 at 9:51 AM, shawn green <shawn.l.green@stripped>
>> > Hello Larry,
>> > On 7/3/2013 11:27 AM, Larry Martell wrote:
>> >> We recently changed from in memory files to InnoDB files. Today we
>> >> noticed that in every server's data dir there is file called '1' that
>> >> seems to get updated every time the iddata1 file gets updated. On some
>> >> servers it's comparable in size to the iddata1 file, on other servers
>> >> it's 10-15x larger, and on others it's 1/2 the size. What is this
>> >> file. Googling revealed nothing about this.
>> > That is not something an official MySQL build would do. Consult with the
>> > person (or group) that compiled your binaries.
>> > Now, if you have enabled --innodb-file-per-table and if you have named
>> > table '1' then that file is probably '1.ibd'. That would be expected. But
>> > that seems unlikely based on your other details.
>> > Did you also enable a separate undo log, perhaps? Although if you had, it
>> > should be 'undo1' not just '1'
>> > http://dev.mysql.com/doc/refman/5.6/en/innodb-
>> > So, that simple '1' file also seems unusual to me.
>> Thanks for the reply.
>> I asked our DBA group and here's the answer I got:
>> The file is currently accessed by mysqld, please don’t delete it.
>> Looking at the file header, it appeared to be an innodb datafile.
>> But no idea how it was created.
> I believe this is due to one of the variables in your my.cnf file.
> You probably set it to 1, thinking this enabled it, but in actuality, the variable
> can be set by just putting it the my.cnf file
> If it has an assignment, then the assignment is the file name to use.
> I think there are several variables that this is the case for
> For example, log and log_error
> If you have log_error=1 or log=1 this would be the file
> There may be others variables, but one of those is where I have seen the 1 file being
> created before
> If it isn't one of those two (which it may not, since you said the header looks to be
I didn't say that - one of my DBA's said that. I didn't have
permission to look at the file. But one of my sysadmins did and she
found that it was ascii text.
> I would review all the variables that are set to =1, and see if that is the proper
I did that and I found it:
log-slow-queries = 1
mysql> show variables like 'slow_query_log_file';
| Variable_name | Value |
| slow_query_log_file | 1 |
1 row in set (0.00 sec)