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
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
]
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
.
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
-Original Message-
From: Larry Martell [mailto:larry.mart...@gmail.com]
Sent: Wednesday, July 03, 2013 11: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
On Wed, Jul 3, 2013 at 11:34 AM, Peterson, Timothy R
timothy_r_peter...@uhc.com wrote:
-Original Message-
From: Larry Martell [mailto:larry.mart...@gmail.com]
Sent: Wednesday, July 03, 2013 11:29 AM
To: shawn green
Cc: mysql@lists.mysql.com
Subject: Re: 1 file
On Wed, Jul 3, 2013