List:General Discussion« Previous MessageNext Message »
From:李炜(平安科技数据库技术支持部) Date:July 4 2013 1:35am
Subject:答复: 1 file
View as plain text  
Can you hexdump the file and post it the maillist?




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.

--
Shawn Green
MySQL Principal Technical Support Engineer Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql





********************************************************************************************************************************
The information in this email is confidential and may be legally privileged. If you have received this email in error or are not the intended recipient, please immediately notify the sender and delete this message from your computer. Any use, distribution, or copying of this email other than by the intended recipient is strictly prohibited. All messages sent to and from us may be monitored to ensure compliance with internal policies and to protect our business. 
Emails are not secure and cannot be guaranteed to be error free as they can be intercepted, amended, lost or destroyed, or contain viruses. Anyone who communicates with us by email is taken to accept these risks. 

收发邮件者请注意:
本邮件含保密信息,件均受到本公司合规监控。邮件可能发生被截留、被修改、丢失、被破坏或包含计算机病毒等不安全情况。 
********************************************************************************************************************************
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