The manual says that this variable should be as low as possible. At the moment, its value is growing slowly but steadily in my database, and I'm trying to check where the problem is. I have inserted counters into each program module, so I can tell which queries are being executed.
To the best of my knowledge, I have created indexes for every field which features in a 'where' or 'join' statement, but there is obviously something not being covered. Is there any systematic way of finding out which queries are causing 'select_full_join' to grow? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]