At random times I seem to get DB connection errors .... Below is whats shown .... Can anyone help me understand what the issue could be please?
Thanks in advance :)
Debug backtrace:
Array
(
[1] => Array
(
[file] => /var/www/vhosts/socialmunch.com/httpdocs/inc/classes/BxDolDb.php
[line] => 82
[function] => error
[class] => BxDolDb
[object] => BxDolDb Object
(
[error_checking] => 1
[error_message] =>
[host] => localhost
[port] =>
[socket] =>
[dbname] => ************
[user] => *****
[password] => *****
[link] =>
[current_res] =>
[current_arr_type] => 1
[oParams] =>
[oDbCacheObject] =>
[_error] =>
)
[type] => ->
[args] => Array
(
[0] => Database connect failed
[1] => 1
)
)
[2] => Array
(
[file] => /var/www/vhosts/socialmunch.com/httpdocs/inc/classes/BxDolDb.php
[line] => 58
[function] => connect
[class] => BxDolDb
[object] => BxDolDb Object
(
[error_checking] => 1
[error_message] =>
[host] => localhost
[port] =>
[socket] =>
[dbname] => ************
[user] => *****
[password] => *****
[link] =>
[current_res] =>
[current_arr_type] => 1
[oParams] =>
[oDbCacheObject] =>
[_error] =>
)
[type] => ->
[args] => Array
(
)
)
[3] => Array
(
[file] => /var/www/vhosts/socialmunch.com/httpdocs/inc/db.inc.php
[line] => 25
[function] => BxDolDb
[class] => BxDolDb
[object] => BxDolDb Object
(
[error_checking] => 1
[error_message] =>
[host] => localhost
[port] =>
[socket] =>
[dbname] => ************
[user] => *****
[password] => *****
[link] =>
[current_res] =>
[current_arr_type] => 1
[oParams] =>
[oDbCacheObject] =>
[_error] =>
)
[type] => ->
[args] => Array
(
)
)
[4] => Array
(
[file] => /var/www/vhosts/socialmunch.com/httpdocs/inc/classes/BxDolAlerts.php
[line] => 20
[args] => Array
(
[0] => /var/www/vhosts/socialmunch.com/httpdocs/inc/db.inc.php
)
[function] => require_once
)
[5] => Array
(
[file] => /var/www/vhosts/socialmunch.com/httpdocs/inc/header.inc.php
[line] => 177
[args] => Array
(
[0] => /var/www/vhosts/socialmunch.com/httpdocs/inc/classes/BxDolAlerts.php
)
[function] => require_once
)
[6] => Array
(
[file] => /var/www/vhosts/socialmunch.com/httpdocs/browse.php
[line] => 21
[args] => Array
(
[0] => /var/www/vhosts/socialmunch.com/httpdocs/inc/header.inc.php
)
[function] => require_once
)
)
Called script: /browse.php Request parameters:
Array
(
)
DedicatedServer4You.com -- BIGGEST Range of Dedicated Servers at the Lowest Price! |
anyone have a idea what might cause DB connection failed errors please ? DedicatedServer4You.com -- BIGGEST Range of Dedicated Servers at the Lowest Price! |
This right here.
[0] => Database connect failed
I can think of only two posibilities.
1) Database server down 2) Database overloaded or at maxinium number of allowed connections.
Give that you said that it's random, then reason 2 is most likley.
https://www.deanbassett.com |
I'm going to throw something out here..
looks like it's from the browse.php page.
Looking at that page, you have some "extra" members blocks down the right side. Try removing them one by one maybe. Who made those.?
ManOfTeal.COM a Proud UNA site, six years running strong! |
what are your
max_connections max_user_connections
settings in my.cnf??
you could use tuning_primer or MySQLTuner to check your mysql configuration ...
http://www.boonex.com/market/posts/paansystems - your resource for Dolphin Pro |
hey man :) well this happens at random times for random pages .... also happened to me on member.php
Oh and EU30 (i think that's the right developer)
I'm going to throw something out here..
looks like it's from the browse.php page.
Looking at that page, you have some "extra" members blocks down the right side. Try removing them one by one maybe. Who made those.?
DedicatedServer4You.com -- BIGGEST Range of Dedicated Servers at the Lowest Price! |
that file shows following stuff ...I would also be happy if you can advise on other changes I should make bearing in mind I have a very active network:-
skip-external-locking key_buffer = 384M max_allowed_packet = 1M max_connections = 300 max_user_connections = 35 wait_timeout=40 connect_timeout=10 table_cache = 512 sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 8M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size = 32M thread_concurrency = 4
max_connections = 300 max_user_connections = 35
what are your
max_connections max_user_connections
settings in my.cnf??
you could use tuning_primer or MySQLTuner to check your mysql configuration ...
DedicatedServer4You.com -- BIGGEST Range of Dedicated Servers at the Lowest Price! |
can you advise how I check and change this if required ??
I will try and research this info also ... thanks
"2) Database overloaded or at maxinium number of allowed connections".
This right here.
[0] => Database connect failed
I can think of only two posibilities.
1) Database server down 2) Database overloaded or at maxinium number of allowed connections.
Give that you said that it's random, then reason 2 is most likley.
DedicatedServer4You.com -- BIGGEST Range of Dedicated Servers at the Lowest Price! |
Save this mysql-tuner script and run it on your machine (assuming you have shell access):
https://raw.github.com/rackerhacker/MySQLTuner-perl/master/mysqltuner.pl
Then check out the results... specificly:
[OK] Highest usage of available connections: 73% (147/200)
The longer your MySQL daemon has been up and running the better...
|
run it but don't have a clue what I'm looking at ... :(
Am still looking !
Save this mysql-tuner script and run it on your machine (assuming you have shell access):
https://raw.github.com/rackerhacker/MySQLTuner-perl/master/mysqltuner.pl
Then check out the results... specificly:
[OK] Highest usage of available connections: 73% (147/200)
The longer your MySQL daemon has been up and running the better...
DedicatedServer4You.com -- BIGGEST Range of Dedicated Servers at the Lowest Price! |
I don't see anything like this there ...
Highest usage of available connections: 73% (147/200)
DedicatedServer4You.com -- BIGGEST Range of Dedicated Servers at the Lowest Price! |
*shrug* not sure what to say... Here's a snip from mine:
-------- Performance Metrics -------------------------------------------------
[--] Up for: 7d 2h 41m 23s (93M q [151.779 qps], 1M conn, TX: 37B, RX: 25B)
[--] Reads / Writes: 94% / 6%
[--] Total buffers: 212.0M global + 2.7M per thread (200 max threads)
[OK] Maximum possible memory usage: 749.5M (20% of installed RAM)
[OK] Slow queries: 0% (3K/93M)
[OK] Highest usage of available connections: 73% (147/200)
Perhaps your user doen't have enough privileges for that query??
|
can anyone tell me if the following looks right OR should be adjusted in anyway for best performance of server please:
skip-external-locking key_buffer = 384M max_allowed_packet = 1M max_connections = 300 max_user_connections = 35 wait_timeout=40 connect_timeout=10 table_cache = 512 sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 8M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size = 32M thread_concurrency = 4
DedicatedServer4You.com -- BIGGEST Range of Dedicated Servers at the Lowest Price! |
I suggest to use the following perl script to optimize your MySQL parameters - http://mysqltuner.com/
can anyone tell me if the following looks right OR should be adjusted in anyway for best performance of server please:
skip-external-locking key_buffer = 384M max_allowed_packet = 1M max_connections = 300 max_user_connections = 35 wait_timeout=40 connect_timeout=10 table_cache = 512 sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 8M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size = 32M thread_concurrency = 4
Rules → http://www.boonex.com/terms |
Same as the link I posted above :)
I suggest to use the following perl script to optimize your MySQL parameters - http://mysqltuner.com/
|
DAMN ..... every now and then and for different things my members are getting DB connection failed errors ?!
This is a new issue for my network! I have never had a issue with such prior to this thread ..........
Anyone advise further with this please !
Same as the link I posted above :)
I suggest to use the following perl script to optimize your MySQL parameters - http://mysqltuner.com/
DedicatedServer4You.com -- BIGGEST Range of Dedicated Servers at the Lowest Price! |
anyone ?!
DAMN ..... every now and then and for different things my members are getting DB connection failed errors ?!
This is a new issue for my network! I have never had a issue with such prior to this thread ..........
Anyone advise further with this please !
Same as the link I posted above :)
I suggest to use the following perl script to optimize your MySQL parameters - http://mysqltuner.com/
DedicatedServer4You.com -- BIGGEST Range of Dedicated Servers at the Lowest Price! |
this does not give me any recommendations ?!
I run it several times and still same result ...
I suggest to use the following perl script to optimize your MySQL parameters - http://mysqltuner.com/
can anyone tell me if the following looks right OR should be adjusted in anyway for best performance of server please:
skip-external-locking key_buffer = 384M max_allowed_packet = 1M max_connections = 300 max_user_connections = 35 wait_timeout=40 connect_timeout=10 table_cache = 512 sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 8M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size = 32M thread_concurrency = 4
DedicatedServer4You.com -- BIGGEST Range of Dedicated Servers at the Lowest Price! |
Sorry crack_foo, I didn't noticed this.
@Detective08 - try to change
max_connections = 300
to
max_connections = 1000
Rules → http://www.boonex.com/terms |