Author Topic: Dead slow responding  (Read 4507 times)

Offline marino

  • Newbie
  • *
  • Posts: 33
  • Karma: +5/-1
    • View Profile
Dead slow responding
« on: September 16, 2013, 01:04:13 PM »
When i click anything on the storefront or in the admin panel it takes more then 25seconds to respond.
Even when i try to login to my dashboard or if i just want to go to my homepage.
I added a coupon and after that everything is working dead slow.
p.s. i have cleard the cach i hope that the problem will go away but nothing has changed.

Please Help.

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 1773
  • Karma: +246/-11
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: Dead slow responding
« Reply #1 on: September 16, 2013, 01:14:02 PM »

1. url?
2. server's perfomance? (CPU, RAM, hosting provider)
3. php.ini ?
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline marino

  • Newbie
  • *
  • Posts: 33
  • Karma: +5/-1
    • View Profile
Re: Dead slow responding
« Reply #2 on: September 16, 2013, 01:28:47 PM »
Hosting at hostgator.
The error log:
Code: [Select]
2013-09-16 17:03:15 - warning:  AbanteCart core v.1.1.6 mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections in <b>/home1/marino88/public_html/public_html/core/database/mysql.php</b> on line <b>45</b>
2013-09-16 17:03:15 - database error:  AbanteCart core v.1.1.6 Error: Could not make a database connection using marino88_test@localhost in <b>/home1/marino88/public_html/public_html/core/database/mysql.php</b> on line <b>46</b>
2013-09-16 17:03:51 - warning:  AbanteCart core v.1.1.6 mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections in <b>/home1/marino88/public_html/public_html/core/database/mysql.php</b> on line <b>45</b>
2013-09-16 17:03:51 - database error:  AbanteCart core v.1.1.6 Error: Could not make a database connection using marino88_test@localhost in <b>/home1/marino88/public_html/public_html/core/database/mysql.php</b> on line <b>46</b>
2013-09-16 17:03:52 - warning:  AbanteCart core v.1.1.6 mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections in <b>/home1/marino88/public_html/public_html/core/database/mysql.php</b> on line <b>45</b>
2013-09-16 17:03:52 - database error:  AbanteCart core v.1.1.6 Error: Could not make a database connection using marino88_test@localhost in <b>/home1/marino88/public_html/public_html/core/database/mysql.php</b> on line <b>46</b>
2013-09-16 17:03:57 - warning:  AbanteCart core v.1.1.6 mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections in <b>/home1/marino88/public_html/public_html/core/database/mysql.php</b> on line <b>45</b>
2013-09-16 17:03:57 - database error:  AbanteCart core v.1.1.6 Error: Could not make a database connection using marino88_test@localhost in <b>/home1/marino88/public_html/public_html/core/database/mysql.php</b> on line <b>46</b>
2013-09-16 17:04:13 - warning:  AbanteCart core v.1.1.6 mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections in <b>/home1/marino88/public_html/public_html/core/database/mysql.php</b> on line <b>45</b>
2013-09-16 17:04:13 - database error:  AbanteCart core v.1.1.6 Error: Could not make a database connection using marino88_test@localhost in <b>/home1/marino88/public_html/public_html/core/database/mysql.php</b> on line <b>46</b>
2013-09-16 17:04:16 - warning:  AbanteCart core v.1.1.6 mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections in <b>/home1/marino88/public_html/public_html/core/database/mysql.php</b> on line <b>45</b>
2013-09-16 17:04:16 - database error:  AbanteCart core v.1.1.6 Error: Could not make a database connection using marino88_test@localhost in <b>/home1/marino88/public_html/public_html/core/database/mysql.php</b> on line <b>46</b>
2013-09-16 17:05:42 - warning:  AbanteCart core v.1.1.6 mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections in <b>/home1/marino88/public_html/public_html/core/database/mysql.php</b> on line <b>45</b>
2013-09-16 17:05:42 - database error:  AbanteCart core v.1.1.6 Error: Could not make a database connection using marino88_test@localhost in <b>/home1/marino88/public_html/public_html/core/database/mysql.php</b> on line <b>46</b>
2013-09-16 17:06:47 - warning:  AbanteCart core v.1.1.6 mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections in <b>/home1/marino88/public_html/public_html/core/database/mysql.php</b> on line <b>45</b>
2013-09-16 17:06:47 - database error:  AbanteCart core v.1.1.6 Error: Could not make a database connection using marino88_test@localhost in <b>/home1/marino88/public_html/public_html/core/database/mysql.php</b> on line <b>46</b>
2013-09-16 17:10:29 - warning:  AbanteCart core v.1.1.6 mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections in <b>/home1/marino88/public_html/public_html/core/database/mysql.php</b> on line <b>45</b>
2013-09-16 17:10:29 - database error:  AbanteCart core v.1.1.6 Error: Could not make a database connection using marino88_test@localhost in <b>/home1/marino88/public_html/public_html/core/database/mysql.php</b> on line <b>46</b>
2013-09-16 17:10:37 - warning:  AbanteCart core v.1.1.6 mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections in <b>/home1/marino88/public_html/public_html/core/database/mysql.php</b> on line <b>45</b>
2013-09-16 17:10:37 - database error:  AbanteCart core v.1.1.6 Error: Could not make a database connection using marino88_test@localhost in <b>/home1/marino88/public_html/public_html/core/database/mysql.php</b> on line <b>46</b>
2013-09-16 17:13:00 - warning:  AbanteCart core v.1.1.6 mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections in <b>/home1/marino88/public_html/public_html/core/database/mysql.php</b> on line <b>45</b>
2013-09-16 17:13:00 - database error:  AbanteCart core v.1.1.6 Error: Could not make a database connection using marino88_test@localhost in <b>/home1/marino88/public_html/public_html/core/database/mysql.php</b> on line <b>46</b>

(see pictures for the php.ini and CPU)
« Last Edit: September 16, 2013, 01:44:51 PM by marino »

Offline marino

  • Newbie
  • *
  • Posts: 33
  • Karma: +5/-1
    • View Profile
Re: Dead slow responding
« Reply #3 on: September 16, 2013, 01:29:30 PM »
And more pictures for CPU:

Offline marino

  • Newbie
  • *
  • Posts: 33
  • Karma: +5/-1
    • View Profile
Re: Dead slow responding
« Reply #4 on: September 16, 2013, 01:47:54 PM »
Could it be that the hosting provider is f****** up everything?
Coz i just uploaded a old website i once made it the same problem is with that website, it keeps crashing. So i think, but i am not sure, that it is the fault of hostgator and abantecart is working good.
Still not sure.

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 1773
  • Karma: +246/-11
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: Dead slow responding
« Reply #5 on: September 17, 2013, 04:16:12 AM »
Quote
Could not make a database connection using marino88_test@localhost in...
and
Quote
Too many connections in...

hmmm...it's so suspicious.
i recommend to you to ask hosting provider support about this errors.
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline marino

  • Newbie
  • *
  • Posts: 33
  • Karma: +5/-1
    • View Profile
Re: Dead slow responding
« Reply #6 on: September 17, 2013, 05:36:14 AM »
After waiting for more then 1 hour the conclusion was from Hostgator: " It looks like you are going to have to reduce the number of connections on the databases Marino " and also they said: " It need to be Optimized. "
So what do i do now?

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 1773
  • Karma: +246/-11
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: Dead slow responding
« Reply #7 on: September 17, 2013, 06:00:08 AM »
1. AbanteCart do not do many connections to mysql. Even more, we do not use persistant connect. We do 1 connection per request.
2. you can turn on debug mode in settings and enable showing of debug log on page. You will see all mysql queries below html of your store.
turn it on and give me a link. i can to look too.
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline marino

  • Newbie
  • *
  • Posts: 33
  • Karma: +5/-1
    • View Profile
Re: Dead slow responding
« Reply #8 on: September 17, 2013, 07:15:09 AM »
So this is what i am getting from the error.txt
Code: [Select]
2013-09-16 17:03:15 - warning:  AbanteCart core v.1.1.6 mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections in <b>/home1/marino88/public_html/public_html/core/database/mysql.php</b> on line <b>45</b>
2013-09-16 17:03:15 - database error:  AbanteCart core v.1.1.6 Error: Could not make a database connection using marino88_test@localhost in <b>/home1/marino88/public_html/public_html/core/database/mysql.php</b> on line <b>46</b>
2013-09-16 17:03:51 - warning:  AbanteCart core v.1.1.6 mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections in <b>/home1/marino88/public_html/public_html/core/database/mysql.php</b> on line <b>45</b>
2013-09-16 17:03:51 - database error:  AbanteCart core v.1.1.6 Error: Could not make a database connection using marino88_test@localhost in <b>/home1/marino88/public_html/public_html/core/database/mysql.php</b> on line <b>46</b>
2013-09-16 17:03:52 - warning:  AbanteCart core v.1.1.6 mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections in <b>/home1/marino88/public_html/public_html/core/database/mysql.php</b> on line <b>45</b>
2013-09-16 17:03:52 - database error:  AbanteCart core v.1.1.6 Error: Could not make a database connection using marino88_test@localhost in <b>/home1/marino88/public_html/public_html/core/database/mysql.php</b> on line <b>46</b>
2013-09-16 17:03:57 - warning:  AbanteCart core v.1.1.6 mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections in <b>/home1/marino88/public_html/public_html/core/database/mysql.php</b> on line <b>45</b>
2013-09-16 17:03:57 - database error:  AbanteCart core v.1.1.6 Error: Could not make a database connection using marino88_test@localhost in <b>/home1/marino88/public_html/public_html/core/database/mysql.php</b> on line <b>46</b>
2013-09-16 17:04:13 - warning:  AbanteCart core v.1.1.6 mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections in <b>/home1/marino88/public_html/public_html/core/database/mysql.php</b> on line <b>45</b>
2013-09-16 17:04:13 - database error:  AbanteCart core v.1.1.6 Error: Could not make a database connection using marino88_test@localhost in <b>/home1/marino88/public_html/public_html/core/database/mysql.php</b> on line <b>46</b>
2013-09-16 17:04:16 - warning:  AbanteCart core v.1.1.6 mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections in <b>/home1/marino88/public_html/public_html/core/database/mysql.php</b> on line <b>45</b>
2013-09-16 17:04:16 - database error:  AbanteCart core v.1.1.6 Error: Could not make a database connection using marino88_test@localhost in <b>/home1/marino88/public_html/public_html/core/database/mysql.php</b> on line <b>46</b>
2013-09-16 17:05:42 - warning:  AbanteCart core v.1.1.6 mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections in <b>/home1/marino88/public_html/public_html/core/database/mysql.php</b> on line <b>45</b>
2013-09-16 17:05:42 - database error:  AbanteCart core v.1.1.6 Error: Could not make a database connection using marino88_test@localhost in <b>/home1/marino88/public_html/public_html/core/database/mysql.php</b> on line <b>46</b>
2013-09-16 17:06:47 - warning:  AbanteCart core v.1.1.6 mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections in <b>/home1/marino88/public_html/public_html/core/database/mysql.php</b> on line <b>45</b>
2013-09-16 17:06:47 - database error:  AbanteCart core v.1.1.6 Error: Could not make a database connection using marino88_test@localhost in <b>/home1/marino88/public_html/public_html/core/database/mysql.php</b> on line <b>46</b>
2013-09-16 17:10:29 - warning:  AbanteCart core v.1.1.6 mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections in <b>/home1/marino88/public_html/public_html/core/database/mysql.php</b> on line <b>45</b>
2013-09-16 17:10:29 - database error:  AbanteCart core v.1.1.6 Error: Could not make a database connection using marino88_test@localhost in <b>/home1/marino88/public_html/public_html/core/database/mysql.php</b> on line <b>46</b>
2013-09-16 17:10:37 - warning:  AbanteCart core v.1.1.6 mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections in <b>/home1/marino88/public_html/public_html/core/database/mysql.php</b> on line <b>45</b>
2013-09-16 17:10:37 - database error:  AbanteCart core v.1.1.6 Error: Could not make a database connection using marino88_test@localhost in <b>/home1/marino88/public_html/public_html/core/database/mysql.php</b> on line <b>46</b>
2013-09-16 17:13:00 - warning:  AbanteCart core v.1.1.6 mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections in <b>/home1/marino88/public_html/public_html/core/database/mysql.php</b> on line <b>45</b>
2013-09-16 17:13:00 - database error:  AbanteCart core v.1.1.6 Error: Could not make a database connection using marino88_test@localhost in <b>/home1/marino88/public_html/public_html/core/database/mysql.php</b> on line <b>46</b>
2013-09-16 21:59:48 - warning:  AbanteCart core v.1.1.6 Invalid argument supplied for foreach() in <b>/home1/marino88/public_html/public_html/admin/view/default/template/pages/tool/global_search.tpl</b> on line <b>68</b>
2013-09-17 10:56:26 -
2013-09-17 10:56:32 -

I can't give you the url coz you won't be able to enter the log coz even when i try the link to the error log it forbids me to do so. Do you need something else?

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 1773
  • Karma: +246/-11
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: Dead slow responding
« Reply #9 on: September 17, 2013, 10:26:21 AM »
see #2 above. go to menu settings->system
set:
show debug -> ON
debug level - level5

then open storefront and copy all debug info after footer.
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline marino

  • Newbie
  • *
  • Posts: 33
  • Karma: +5/-1
    • View Profile
Re: Dead slow responding
« Reply #10 on: September 17, 2013, 11:31:12 AM »
Ohh sorry, i got it all wrong.
I am sending you the download link for the entire debug report to your PM the debug report is in .txt
I have tried to post it on the forum but the max is 20000 characters that's why i am giving you this .txt file.

Offline marino

  • Newbie
  • *
  • Posts: 33
  • Karma: +5/-1
    • View Profile
Re: Dead slow responding
« Reply #11 on: September 17, 2013, 05:43:35 PM »
It looks like my hosting provider is messing up thing's.
After i contacted hostgator the website started to work normal again.
I am not sure why did this what happened but i hope this does not happen again.
Thank you again for your support, everyone.

 

Powered by SMFPacks Social Login Mod