Re: Size limitation of user variable?

2009-02-11 Thread Baron Schwartz
Right, my (implied) point was that you have AT LEAST one limitation -- your max_packet_size. And I showed the way the original author can investigate and figure out the rest himself :) On Wed, Feb 11, 2009 at 4:28 AM, Johan De Meersman wrote: > What you just tested, on the other hand, was the li

Re: Size limitation of user variable?

2009-02-11 Thread Johan De Meersman
What you just tested, on the other hand, was the limit of your maxpacket :-) Up that to something unlikely and try again :-) On Tue, Feb 10, 2009 at 9:24 PM, Baron Schwartz wrote: > On Tue, Feb 10, 2009 at 1:29 PM, Cantwell, Bryan > wrote: > > I am trying to put the result of a function that re

Re: Size limitation of user variable?

2009-02-10 Thread Baron Schwartz
On Tue, Feb 10, 2009 at 1:29 PM, Cantwell, Bryan wrote: > I am trying to put the result of a function that returns MEDIUMTEXT into > a user variable in my procedure. I haven't attempted to push the limits > of the MEDIUMTEXT size, but wonder if the user variable can even handle > this? The REPEA

RE: size limitation

2001-03-26 Thread Pascal THIVENT
11 > À: Pascal THIVENT > Cc: [EMAIL PROTECTED] > Objet: Re: size limitation > > > On Fri, Mar 23, 2001 at 11:33:42AM +0100, Pascal THIVENT wrote: > > > > I've got to manage one database. > > This database is made of one table. > > This table w

RE: size limitation

2001-03-26 Thread Sinisa Milivojevic
Pascal THIVENT writes: > Hi, > > the database I would like to managed is constitued by one table. > This table is made of 3 columns, with no primary key > > mysql> CREATE TABLE test ( > id1 int(8) unsigned, > id2 int(4) unsigned, > id3 int(4) unsi

RE: size limitation

2001-03-26 Thread Pascal THIVENT
se of storage limitations). 10 days of lifetime for our datas will be enough :) We make no update in order to be very quick. > -Message d'origine- > De: Heikki Tuuri [mailto:[EMAIL PROTECTED]] > Date: samedi 24 mars 2001 15:31 > À: [EMAIL PROTECTED]; [EMAIL PROTECT

Re: size limitation

2001-03-24 Thread Jeremy D . Zawodny
On Sat, Mar 24, 2001 at 05:30:52PM +0200, Heikki Tuuri wrote: > > MySQL/Innobase may be able to do what you need, but we should have a > real-world test of using a big disk farm. I do not know if any MySQL > user uses a disk farm. Maybe Jeremy Zawodny knows? I don't know of anyone doing that yet.

Re: size limitation

2001-03-24 Thread Heikki Tuuri
Pascal, could you describe what indexes you should have on the data, and how you will add to it and delete from it? >In order to choose a DBMS, i've to check to MySQL is able to support our >requirements. I've got to manage one database. >This database is made of one table. >This table will grow

Re: size limitation

2001-03-23 Thread Jeremy D . Zawodny
On Fri, Mar 23, 2001 at 11:33:42AM +0100, Pascal THIVENT wrote: > > I've got to manage one database. > This database is made of one table. > This table will grow very quickly (we evaluate that we'll have to make > arround 1.000.000.000 inserts per day). What sort of hardware are you planning to