Re: breaking the 31 tables in a join limitation, round 2

2001-06-12 Thread Gunnar von Boehn
Hello SixK, Are you sure, that you are running in a join limitiation? I think that just your max-open-tables is per default = 32. Look at /etc/my.cnf set-variable= table_cache=64 Just change this variable to do what you want. As every open table uses resources, an 'infinite' value migh

breaking the 31 tables in a join limitation, round 2

2001-06-11 Thread SixK
Hello, I always have my problem with the 31 tables in a join limitation. In crash-me database comparaison page, I saw that mysqld 3.23.39 could manage up to 63 tables in a join. I didn't see in history log that the limite has been updated from 31 (in 3.23.36 version we use) to