Re: Size limitation of user variable?
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 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 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 REPEAT() function helps here:
>>
>> mysql> set @var := repeat('a', 1024 * 1024);
>> Query OK, 0 rows affected (0.05 sec)
>>
>> mysql> select length(@var);
>> +--+
>> | length(@var) |
>> +--+
>> | 1048576 |
>> +--+
>> 1 row in set (0.01 sec)
>>
>> So it accepts a mebibyte, let's see if we can notch that up :)
>>
>> mysql> set @var := repeat('a', 1024 * 1024 * 1024);
>> Query OK, 0 rows affected, 1 warning (0.00 sec)
>>
>> mysql> show warnings;
>>
>> +-+--+--+
>> | Level | Code | Message
>> |
>>
>> +-+--+--+
>> | Warning | 1301 | Result of repeat() was larger than
>> max_allowed_packet (16777216) - truncated |
>>
>> +-+--+--+
>> 1 row in set (0.00 sec)
>>
>> --
>> Baron Schwartz, Director of Consulting, Percona Inc.
>> Our Blog: http://www.mysqlperformanceblog.com/
>> Our Services: http://www.percona.com/services.html
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:http://lists.mysql.com/mysql?unsub=vegiv...@tuxera.be
>>
>
>
>
> --
> Celsius is based on water temperature.
> Fahrenheit is based on alcohol temperature.
> Ergo, Fahrenheit is better than Celsius. QED.
>
--
Baron Schwartz, Director of Consulting, Percona Inc.
Our Blog: http://www.mysqlperformanceblog.com/
Our Services: http://www.percona.com/services.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Size limitation of user variable?
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 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 REPEAT() function helps here:
>
> mysql> set @var := repeat('a', 1024 * 1024);
> Query OK, 0 rows affected (0.05 sec)
>
> mysql> select length(@var);
> +--+
> | length(@var) |
> +--+
> | 1048576 |
> +--+
> 1 row in set (0.01 sec)
>
> So it accepts a mebibyte, let's see if we can notch that up :)
>
> mysql> set @var := repeat('a', 1024 * 1024 * 1024);
> Query OK, 0 rows affected, 1 warning (0.00 sec)
>
> mysql> show warnings;
>
> +-+--+--+
> | Level | Code | Message
> |
>
> +-+--+--+
> | Warning | 1301 | Result of repeat() was larger than
> max_allowed_packet (16777216) - truncated |
>
> +-+--+--+
> 1 row in set (0.00 sec)
>
> --
> Baron Schwartz, Director of Consulting, Percona Inc.
> Our Blog: http://www.mysqlperformanceblog.com/
> Our Services: http://www.percona.com/services.html
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?unsub=vegiv...@tuxera.be
>
>
--
Celsius is based on water temperature.
Fahrenheit is based on alcohol temperature.
Ergo, Fahrenheit is better than Celsius. QED.
Re: Size limitation of user variable?
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 REPEAT() function helps here:
mysql> set @var := repeat('a', 1024 * 1024);
Query OK, 0 rows affected (0.05 sec)
mysql> select length(@var);
+--+
| length(@var) |
+--+
| 1048576 |
+--+
1 row in set (0.01 sec)
So it accepts a mebibyte, let's see if we can notch that up :)
mysql> set @var := repeat('a', 1024 * 1024 * 1024);
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> show warnings;
+-+--+--+
| Level | Code | Message
|
+-+--+--+
| Warning | 1301 | Result of repeat() was larger than
max_allowed_packet (16777216) - truncated |
+-+--+--+
1 row in set (0.00 sec)
--
Baron Schwartz, Director of Consulting, Percona Inc.
Our Blog: http://www.mysqlperformanceblog.com/
Our Services: http://www.percona.com/services.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
