On Tue, 28 Mar 2006, Jorrit Kronjee wrote: > To: mysql@lists.mysql.com > From: Jorrit Kronjee <[EMAIL PROTECTED]> > Subject: Re: Random 'select permission denied' since upgrade to 5.0.18 > > [EMAIL PROTECTED] wrote: > > On Tue, 28 Mar 2006, Jorrit Kronjee wrote: > > > > > To: mysql@lists.mysql.com > > > From: Jorrit Kronjee <[EMAIL PROTECTED]> > > > Subject: Re: Random 'select permission denied' since upgrade to > > > 5.0.18 > > snip > > > Could this message appear when, for instance, a maximum amount of > > > threads > > > has been spawned or MySQL has reached its connection limit? > > > > Possible - what are your settings for the relevant mysql server > > variables? > > > > You could try something like: > > > > show variables like "max%" \G > > > > I'm not really sure what all the server variables do, but they may be > > relevant to your problem. > > > > Keith > > > > Keith, > > Here's the output: > > mysql> show variables like "max%" \G > *************************** 1. row *************************** > Variable_name: max_allowed_packet > Value: 1047552 > *************************** 2. row *************************** > Variable_name: max_binlog_cache_size > Value: 4294967295 > *************************** 3. row *************************** > Variable_name: max_binlog_size > Value: 1073741824 > *************************** 4. row *************************** > Variable_name: max_connect_errors > Value: 10 > *************************** 5. row *************************** > Variable_name: max_connections > Value: 300 > *************************** 6. row *************************** > Variable_name: max_delayed_threads > Value: 20
is this relevant ? > *************************** 7. row *************************** > Variable_name: max_error_count > Value: 64 > *************************** 8. row *************************** > Variable_name: max_heap_table_size > Value: 16777216 > *************************** 9. row *************************** > Variable_name: max_insert_delayed_threads > Value: 20 ditto > *************************** 10. row *************************** > Variable_name: max_join_size > Value: 4294967295 > *************************** 11. row *************************** > Variable_name: max_length_for_sort_data > Value: 1024 > *************************** 12. row *************************** > Variable_name: max_relay_log_size > Value: 0 > *************************** 13. row *************************** > Variable_name: max_seeks_for_key > Value: 4294967295 > *************************** 14. row *************************** > Variable_name: max_sort_length > Value: 1024 > *************************** 15. row *************************** > Variable_name: max_sp_recursion_depth > Value: 0 > *************************** 16. row *************************** > Variable_name: max_tmp_tables > Value: 32 > *************************** 17. row *************************** > Variable_name: max_user_connections > Value: 0 > *************************** 18. row *************************** > Variable_name: max_write_lock_count > Value: 4294967295 > 18 rows in set (0.00 sec) > > > -- > System Developer > > Infopact Network Solutions > Hoogvlietsekerkweg 170 > 3194 AM Rotterdam Hoogvliet > tel. +31 (0)88 - 4636700 > fax. +31 (0)88 - 4636799 > mob. +31 (0)6 - 14105968 > [EMAIL PROTECTED] > http://www.infopact.nl/ > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]