Too many connections

[Robert9]

Since some weeks i get (less) errors that i have too many connections to the database.
The forum has around 4000 daily visitors.
I have asked my provider how this could be possible.
The answer was, i should change the mysql-version back to an older one, because the newer version cant have so many connections than the older ones.

Is there any information about that?

 

[JonathanW]

Since some weeks i get (less) errors that i have too many connections to the database.
The forum has around 4000 daily visitors.
I have asked my provider how this could be possible.
The answer was, i should change the mysql-version back to an older one, because the newer version cant have so many connections than the older ones.

Is there any information about that?

That doesn't sound right. What version of MySQL are you on and how much do you have dedicated to it in terms of resources? A copy of your /etc/my.cnf file would be very helpful.

 

[Xon]

Sounds like pre-fork apache running into MySQL connection limits

 

[Robert9]

My hoster tells me now, that mysql 5.7 has much less possible connections than mysql 5.5.
He tells me also i should change back from 5.7. to 5.5.

I dont want to believe that 5.7 should be such a weak system that some thousand users in a day can bring it down.

 

[Robert9]

show variables

shows one million of lines in phpMyAdmin.
Which variables are important to show here, please?

Some of them are:

max_binlog_size     1073741824
max_binlog_stmt_cache_size     18446744073709547520
max_connect_errors     100000
max_connections     36100
max_delayed_threads     20
max_digest_length     1024
max_error_count     64
max_execution_time     0
max_heap_table_size     16777216
max_insert_delayed_threads     20
max_join_size     18446744073709551615
max_length_for_sort_data     1024
max_points_in_geometry     65536
max_prepared_stmt_count     16382
max_relay_log_size     0