[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
*************************** 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
*************************** 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]
