0
votes
1answer
119 views

nginx and Mysql Server Load limits (depend on Server config)

my server config is Technology: Ivy Bridge Processor: Intel Xeon E3 1245v2 Intel Smart Cache: 8MB Cores: 4 Threads: 8 Frequency: 3.4GHz+ Turbo Boost: 3.8GHz Virtualization: yes ...
1
vote
1answer
349 views

Mysql remote connections logging

I need to allow remote connections to my mysql server running on latest stable CentOS. I don't like this idea at all so I want at least to collect as much relevant information as possible. To be ...
13
votes
1answer
19k views

What value of thread_cache_size should I use?

I'm using Asp.Net together with MySQL. In the .Net connection string, I have set Max Pool Size to 150. If I run the following I get these values: SHOW GLOBAL STATUS LIKE 'max_used_connections'; ...
0
votes
2answers
1k views

Very large number open connections from web to DB server

I run 2 servers, 1 web (nginx/php), 1 database (mysql). Nginx has about 1500 active processes per second, and mysql status shows about 15 currently option connections on average. Now today i started ...
0
votes
1answer
1k views

jboss 5.1 mysql connection pooling

I am using JBOSS 5.1.0.GA, MySQL 5.5 and Hibernate 3.3.1 GA (included with JBOSS) + Spring. My question is do I need to add c3p0 as a data source in my spring/hibernate configuration for connection ...
7
votes
3answers
760 views

mysql “Too many connections” killed the network?

So I'm pretty confused here, figured I'd throw this out here and see if anyone else has any good ideas. We suffered a pretty big outage two nights ago, and I'm still searching for the root cause. I ...
0
votes
3answers
209 views

Splitting a MySQL DB in two may ease server from “Too many connetions”? I don't think so

I was requested to split a MySQL in two, it's kind of a horizontal partition, in which some rows correspond to one site, and some other correspond to another site. But they want to split it in two DBs ...
1
vote
2answers
316 views

Mysql : Number of connections in a given duration

How do I find out how many connections were made to the mysql server in a given duration?