List:General Discussion« Previous MessageNext Message »
From:Timothy R Peterson Date:July 3 2013 5:34pm
Subject:RE: 1 file
View as plain text  

> -----Original Message-----
> From: Larry Martell [mailto:larry.martell@stripped]
> Sent: Wednesday, July 03, 2013 11:29 AM
> To: shawn green
> Cc: mysql@strippedysql.com
> Subject: Re: 1 file
> 
> On Wed, Jul 3, 2013 at 9:51 AM, shawn green <shawn.l.green@stripped>
> wrote:
> > 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
> your
> > 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-
> parameters.html#sysvar_innodb_undo_tablespaces
> >
> > 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.
> 
> Sigh.
> 
> --

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 innodb), I would review all the variables that are set to =1, and see if that is the proper assignment
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql
> 


This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity
to which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately.
Thread
1 fileLarry Martell3 Jul
  • Re: 1 fileshawn green3 Jul
    • Re: 1 fileLarry Martell3 Jul
      • RE: 1 fileTimothy R Peterson3 Jul
        • Re: 1 fileLarry Martell3 Jul
      • RE: 1 fileRick James3 Jul
        • Re: 1 fileLarry Martell3 Jul
    • 答复: 1 file李炜(平安科技数据库技术支持部)4 Jul