I am having a problem where I cannot seem to increase the max_join_size
of 4.1.18 above a hard limit that is way too low for my use. Has anyone
run into this and know of a solution that does not involve upgrading to
5.x.x? (That is presently not an option for another month or so.) I also
want to avoid using SET SQL_BIG_SELECTS=1. I know in earlier versions
(perhaps 4.0.x?) I could increase the value to what I wanted.
I will happily add the output from "show variables" if that will help.
Thanks in advance for your help.
--Bill
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 26460 to server version: 4.1.18-standard-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> select @@max_join_size;
+-----------------+
| @@max_join_size |
+-----------------+
| 705032704 |
+-----------------+
1 row in set (0.00 sec)
mysql> SET sql_max_join_size=5000000000;
Query OK, 0 rows affected (0.00 sec)
mysql> select @@max_join_size;
+-----------------+
| @@max_join_size |
+-----------------+
| 705032704 |
+-----------------+
1 row in set (0.00 sec)
mysql> SET sql_max_join_size=5000;
Query OK, 0 rows affected (0.00 sec)
mysql> select @@max_join_size;
+-----------------+
| @@max_join_size |
+-----------------+
| 5000 |
+-----------------+
1 row in set (0.00 sec)
mysql> SET sql_max_join_size=DEFAULT;
Query OK, 0 rows affected (0.00 sec)
mysql> select @@max_join_size;
+-----------------+
| @@max_join_size |
+-----------------+
| 705032704 |
+-----------------+
1 row in set (0.00 sec)
mysql>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
