Re: 1 file

2013-07-04 Thread shawn green
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

Re: 1 file

2013-07-04 Thread Larry Martell
On Wed, Jul 3, 2013 at 9:51 AM, shawn green 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 th

Re: 1 file

2013-07-03 Thread Larry Martell
On Wed, Jul 3, 2013 at 11:34 AM, Peterson, Timothy R 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

RE: 1 file

2013-07-03 Thread Peterson, Timothy R
> -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 > wrote: > > Hello

RE: 1 file

2013-07-03 Thread Rick James
Cc: mysql@lists.mysql.com > Subject: Re: 1 file > > On Wed, Jul 3, 2013 at 9:51 AM, shawn green > wrote: > > Hello Larry, > > > > > > On 7/3/2013 11:27 AM, Larry Martell wrote: > >> > >> We recently changed from in memory files to InnoDB f

Re: 1 file

2013-07-03 Thread Larry Martell
ssage- >> 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 >> wrote: >>

Re: (1) File Storage (2) CMPs

2002-04-04 Thread Egor Egorov
Ang, Thursday, April 04, 2002, 4:21:10 PM, you wrote: AHK> Is MySQL capable of storing files (*.doc *.zip etc)? If YES, AHK> - is there a limit to the size? AHK> - what is the data type to use? BLOB? Yes, you should use BLOB types (TINYBLOB, BLOB, MEDIUMBLOB, LONGBLOB). You can read about