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 ba...@xaprb.com wrote:
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 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?
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 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 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
Install problem: configure --prefix not working
I am trying to install mysql in a non-standard directory - specifically /app/mysql Subsequently, I ran the following configure command: ./configure --prefix=/app/mysql --with-plugins=innobase,myisam There were no problems with the compile, but mysql failed to start. Furthermore, the following output was produced in the nohup.out file -bash-3.2$ cat nohup.out 090211 09:40:35 mysqld_safe Logging to '/var/log/mysqld.log'. mkdir: cannot create directory `/var/lib/mysql': Permission denied chown: cannot access `/var/lib/mysql': No such file or directory chmod: cannot access `/var/lib/mysql': No such file or directory 090211 09:40:35 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql /app/mysql/bin/mysqld_safe: line 96: /var/log/mysqld.log: Permission denied /app/mysql/bin/mysqld_safe: line 133: /var/log/mysqld.log: Permission denied 090211 09:40:35 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended /app/mysql/bin/mysqld_safe: line 96: /var/log/mysqld.log: Permission denied For some reason, the mysql install is looking to /var even though I specificied /app/mysql in the compile. How do I fix this? Thanks! Colin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Install problem: configure --prefix not working
/var/lib/mysql is the standard loation for the data_file_path, the data directory. change it in my.cnf. var/log is the default location for log files, also changeable in the config file. Walter OlinData: Professional services for MySQL Support * Consulting * Administration http://www.olindata.com On Wed, Feb 11, 2009 at 5:35 PM, csego...@gmail.com csego...@gmail.com wrote: I am trying to install mysql in a non-standard directory - specifically /app/mysql Subsequently, I ran the following configure command: ./configure --prefix=/app/mysql --with-plugins=innobase,myisam There were no problems with the compile, but mysql failed to start. Furthermore, the following output was produced in the nohup.out file -bash-3.2$ cat nohup.out 090211 09:40:35 mysqld_safe Logging to '/var/log/mysqld.log'. mkdir: cannot create directory `/var/lib/mysql': Permission denied chown: cannot access `/var/lib/mysql': No such file or directory chmod: cannot access `/var/lib/mysql': No such file or directory 090211 09:40:35 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql /app/mysql/bin/mysqld_safe: line 96: /var/log/mysqld.log: Permission denied /app/mysql/bin/mysqld_safe: line 133: /var/log/mysqld.log: Permission denied 090211 09:40:35 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended /app/mysql/bin/mysqld_safe: line 96: /var/log/mysqld.log: Permission denied For some reason, the mysql install is looking to /var even though I specificied /app/mysql in the compile. How do I fix this? Thanks! Colin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=li...@olindata.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
