Two weeks have gone by and we still get max_connections and timeout errors. Only have 20 or 25 users at any one time. The host increased connections and file size (for cache). And reduced timeout settings.

Yesterday they restarted IIS to get up back.. but 20 minutes later we were bogged down again.

Are you sure that there isn't any issue with 7.5.4 not closing out processes? Sorry, I had to ask.

Just a thought.
Did you happen to enable
"Use Persistent Connections"
in the ubb control panel?

There are only 2 ways a connection won't get closed.

A. If you have persistent connections turned on (even then it will only have 1 connection per apache process)

B. If there is some other deeper issue going on with php or mysql.

When a PHP script finishes, everything closes along with it. There is nothing you actually need to do to actually close the connection.

What you probably should do is once it's been running for awhile, go into your control panel and then run the following SQL command:



That will show you any processes (connections) that are currently open. That should give you an idea if there are lingering connections hanging around.

You should definitely run that query when you're getting the max_connections error and let us know what you find.

Well I am not sure how IIS deals with persistent connections.
Since the only value in IIS I can reference is concurrent connections.

Ruben -- thanks. I did NOT have persistent_connections turned on. So I just did that.. We'll watch to see what happens.

Rick -- Thanks too. I'll try out the "show processlist" query.

Well I meant it could be causing the problem! Oh Well.

Performance has been better since I turned on "persistent connections"... but I noticed about 25 error messages from an hour ago when the MySQL calls failed due to "maximum_connections" error.

I just went in and saw these three processes running. The first one looks odd to me -- with the comment about copying to a "temp table". Is that unusual? What do you think?

- - - - -SQL LOG - - - - - - - - - - - - - - -
35266 vccachat localhost:4598 vccachat_org_-_chat Query 39 Copying to tmp table SELECT p.POST_ID FROM ubbt_POSTS p LEFT JOIN ubbt_POSTS pp on p.POST_ID=pp.POST_ID, ubbt_TOP

35289 vccachat localhost:4636 vccachat_org_-_chat Query 0 show processlist

35291 vccachat localhost:4638 vccachat_org_-_chat Query 0 Sending data select t1.TOPIC_ID,t1.POST_ID,t2.USER_DISPLAY_NAME,t1.TOPIC_CREATED_TIME,t1.TOPIC_LAST_REPLY_TIME,t
------------------------------------------------------------

That' query is coming from your search. If the result set is larger than your mysql configuration allows then it will have to create a temp table for sorting. I'd check what your maximum search results and search range is set to in the control panel.

Okay, I'm starting to see something here.

There are only 4 or 5 people logged into my forum right now.
I saw the three processes as noted in the previous posting. Then 3 or 4 minutes later I went back in --- and there were 30 processes running. See Picture1 , Picture2 and Picture3 .

As soon as I copied them to a file (approx 1 mintue later) I looked and only had the processes in Picture4 running.

I had Search set to 6 years, 3 characters, 100 results.
I changed it to 5 years, 3 characters, 50 results.

My database is:

Totals=
ROWS: 380591, DATA: 153.1 MB, INDEXES: 68.55 MB