On Wed, Jul 3, 2013 at 12:36 PM, Rick James <rja...@yahoo-inc.com> wrote: > I once found a slowlog called simply "1". But I did not track down the > cause. Possibly it was a not-so-correct configuration script. > > SHOW VARIABLES LIKE '%dir%'; >
Nothing was set to 1 > ibdata1 grows (never shrinks) when data is added, ALTER is done, etc. It > will reuse free space within itself. > > innodb_file_per_table=1 is recommended > > Having an explicit PRIMARY KEY on InnoDB tables is recommended. (MEMORY did > not care much.) > >> -----Original Message----- >> From: Larry Martell [mailto:larry.mart...@gmail.com] >> Sent: Wednesday, July 03, 2013 9:29 AM >> To: shawn green >> Cc: mysql@lists.mysql.com >> Subject: Re: 1 file >> >> On Wed, Jul 3, 2013 at 9:51 AM, shawn green <shawn.l.gr...@oracle.com> >> 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_i >> > nnodb_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. >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: http://lists.mysql.com/mysql > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
