MySQL Forums
Forum List  »  MySQL Administrator

Re: Problems with remote connections
Posted by: Interim Service
Date: October 19, 2009 07:43AM

We've changed the config to this:

max_allowed_packet = 16M
thread_stack = 1M
thread_cache_size = 64
query_cache_limit = 8M
query_cache_size = 256M
query_cache_type = 1
max_connections = 1000
join_buffer_size = 2M
table_cache = 1024
sort_buffer_size = 2M
read_rnd_buffer_size = 4M
sort_buffer_size = 8M
key_buffer_size = 1G
thread_concurrency = 4
max_connect_errors = 18446744073709547520
net_read_timeout = 60
max_write_lock_count = 20

# Added
wait_timeout = 10
connect_timeout = 15

still doesn't work.

Here's a question though, in php.ini, we have:

memory_limit = 128M
post_max_size = 12M
upload_max_filesize = 12M

Now.. if we set the max packet size to say, 16M, and the memory limit in php is 128M, will php potentially try to pass 128M to MySQL? Would that (over time) cause some degradation .. so where the db stops responding?

Also, of note, I can still query the db from command line when the site stops responding. If I attach a second db to the site though, it doesn't respond.



Options: ReplyQuote

Written By
Re: Problems with remote connections
October 19, 2009 07:43AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.