Geek Answers Handbook

Grails / Hibernate database loading failed: unable to connect (even when merging)

I have an application in Grails. I use Hibernate to access the database (according to the standard grails rules) I use MySql and the site is up and running (for 6 months).

I am doing load testing and recently discovered that the database rejects connections at startup.

Using MySQL Server 5, I see that related threads are connected around 20. Thought I jump between 11-30.

mysql> show status like '%con%';
+--------------------------+-------+
| Variable_name            | Value |
+--------------------------+-------+
| Aborted_connects         | 72    |
| Connections              | 65539 |
| Max_used_connections     | 101   |
| Ssl_client_connects      | 0     |
| Ssl_connect_renegotiates | 0     |
| Ssl_finished_connects    | 0     |
| Threads_connected        | 1     |
+--------------------------+-------+
7 rows in set (0.00 sec)

My database configuration is standard. (MySql server is installed locally, not shown)

dataSource {
    pooled = false
    driverClassName = "com.mysql.jdbc.Driver"
    username = "username"
    password = "secret"

    maxIdle = 15
    maxActive = 100        
}

Should I research C3P0? Or do I need to increase the maximum to 1000 and hope for the best?

+5
2

Grails, ? -? ?

, ? , ..

, , Grails . , . , Grails DB .

+4

mysql (/etc/mysql.conf ), ; , mysql, grails.

0

More articles:


All Articles