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
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
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
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?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/
Thanks to all that responded to my questions about Full Text Searching.
Being caught up in that paradigm I overlooked the simpler answer :)
I am now experiencing a problem with pulling data from a Text (longvarchar)
field in MySql. The data is entered into a TEXTAREA field on a web page and
f
On 21-Jun-01 Chris Petersen wrote:
>> here, @ids is the array, delete in chunks of 64:
>> while ( my(@id)= splice(@ids,0,64)) {
>> $qry="DELETE FROM master WHERE master_id in (".join(',',@id).")";
>> SQLQuery($qry);
>> }
>
> I thought about this, too.. But Mark said that he needed to delete
> here, @ids is the array, delete in chunks of 64:
> while ( my(@id)= splice(@ids,0,64)) {
> $qry="DELETE FROM master WHERE master_id in (".join(',',@id).")";
> SQLQuery($qry);
> }
I thought about this, too.. But Mark said that he needed to delete from the
table where the ID's don't match.
gt; To: Chris Petersen
> Cc: [EMAIL PROTECTED]; Mark A. Sharkey
> Subject: Re: any size limitation as to the size of a query statement?
>
>
>
> On 21-Jun-01 Chris Petersen wrote:
> > Why not do something like:
> >
> > my $q = "DELETE FROM master WHERE mast
On 21-Jun-01 Chris Petersen wrote:
> Why not do something like:
>
> my $q = "DELETE FROM master WHERE master_id NOT IN (";
> $q .= join(',', @masteridarray);
> $q .= ')';
> $dbi_dbh->do($q);
>
> Though this will obviously fall into the same size limitations that you were
> doing
My code generates a large query. I had to increase the size of
"max_allowed_packet" so that this query would work.
I have this in my /etc/my.cnf file:
set-variable = max_allowed_packet=2097152
-bill
-
Before posting, please
Why not do something like:
my $q = "DELETE FROM master WHERE master_id NOT IN (";
$q .= join(',', @masteridarray);
$q .= ')';
$dbi_dbh->do($q);
Though this will obviously fall into the same size limitations that you were
doing, but it should execute a lot faster, and be a bit sma
Hello,
I have a table with approximately 68,000 records. I then get a file
uploaded to the server with approximately 68,000 master_id's listed in it.
If the master_id's in our MySQL table are not one of the master_id's listed
in the file, they need to be deleted from the MySQL table.
Right now,
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
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
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
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.
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
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
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 very quickly (we evaluate that we'll have to make
arround 1.000.000.000 inserts per day).
I want to be sure that MySQ
i'm sorry to have to ask for the 3rd time the same question but i'm
quite sure there is an answer, whether yes or no!
is it possible at installation time or at configuration time, to state a
limit for the size of the databases created.
ie.
if i give one database per user i dont want any user to
David Hodgkinson wrote:
>
> marko milovanovic <[EMAIL PROTECTED]> writes:
> > how would it be possible to set a limitation in the size of the
> > databases at the creation time so that a user couldn-t build any
> > databases greater than, say, 20 MB?
> Smells like using quotas at the OS level t
Tõnu Samuel wrote:
>
> marko milovanovic wrote:
> >
> > uh! i already posted this message a while ago!
> > could anyone please help me?
> >
> > i could find some informations about increasing the size of the
> > databases, but not about limitations to their size.
> >
> > how would it be possible
marko milovanovic wrote:
>
> uh! i already posted this message a while ago!
> could anyone please help me?
>
> i could find some informations about increasing the size of the
> databases, but not about limitations to their size.
>
> how would it be possible to set a limitation in the size of th
marko milovanovic <[EMAIL PROTECTED]> writes:
> uh! i already posted this message a while ago!
> could anyone please help me?
>
> i could find some informations about increasing the size of the
> databases, but not about limitations to their size.
>
> how would it be possible to set a limitatio
uh! i already posted this message a while ago!
could anyone please help me?
i could find some informations about increasing the size of the
databases, but not about limitations to their size.
how would it be possible to set a limitation in the size of the
databases at the creation time so that a
25 matches
Mail list logo
