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 ba...@xaprb.com wrote:
On Tue, Feb 10, 2009 at 1:29 PM, Cantwell, Bryan
bcantw...@firescope.com wrote:
I am trying to
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 vegiv...@tuxera.be wrote:
What you just tested, on the
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:
On Tue, Feb 10, 2009 at 1:29 PM, Cantwell, Bryan
bcantw...@firescope.com 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
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
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
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
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
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, but it
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 master_id NOT IN (;
$q .= join(',', @masteridarray);
$q .= ')';
$dbi_dbh
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. If you
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 from the
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 PROTECTED]
Objet: Re: size limitation
Pascal,
could you describe
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 will grow very quickly (we evaluate that we'll
have to make
arround 1.000.000.000
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 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...
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
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
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 the
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 to me...
20 matches
Mail list logo