Possible solutions of your questions

  hosting
<< Previous       error 508

Question: Hello!on the website new.impulsi.ru error Resource Limit Is ReachedРІ log last 300 error mention about this site at all. Than he was so loaded that turned off? Can you tell me?
Answer:

Hello.

you Have multiple processes. Here is the log:

  38689 ozonelab  20   0  279m  13m 8560 S  0.0  0.0   0:00.05 /usr/bin/php /home/ozonelab/public_html/new-impulsi.ru/tov.php
  39519 ozonelab  20   0  279m  12m 7936 S  0.0  0.0   0:00.05 /usr/bin/php /home/ozonelab/public_html/new-impulsi.ru/tov.php
  39762 ozonelab  20   0  279m  12m 7936 S  0.0  0.0   0:00.04 /usr/bin/php /home/ozonelab/public_html/new-impulsi.ru/tov.php
  40584 ozonelab  20   0  279m  12m 7936 S  0.0  0.0   0:00.05 /usr/bin/php /home/ozonelab/public_html/new-impulsi.ru/tov.php
  42387 ozonelab  20   0  279m  12m 7936 S  0.0  0.0   0:00.05 /usr/bin/php /home/ozonelab/public_html/new-impulsi.ru/index.php
  43073 ozonelab  20   0  279m  12m 7936 S  0.0  0.0   0:00.05 /usr/bin/php /home/ozonelab/public_html/new-impulsi.ru/tov.php
 192776 ozonelab  20   0  279m  12m 7936 S  0.0  0.0   0:00.05 /usr/bin/php /home/ozonelab/public_html/new-impulsi.ru/index.php
 196866 ozonelab  20   0  279m  12m 7936 S  0.0  0.0   0:00.04 /usr/bin/php /home/ozonelab/public_html/new-impulsi.ru/tov.php
 197597 ozonelab  20   0  279m  12m 7936 S  0.0  0.0   0:00.05 /usr/bin/php /home/ozonelab/public_html/new-impulsi.ru/index.php
 198068 ozonelab  20   0  279m  12m 7936 S  0.0  0.0   0:00.05 /usr/bin/php /home/ozonelab/public_html/new-impulsi.ru/index.php
 198677 ozonelab  20   0  279m  12m 7936 S  0.0  0.0   0:00.04 /usr/bin/php /home/ozonelab/public_html/new-impulsi.ru/index.php
 198692 ozonelab  20   0  279m  12m 7936 S  0.0  0.0   0:00.04 /usr/bin/php /home/ozonelab/public_html/new-impulsi.ru/index.php
 199866 ozonelab  20   0  279m  12m 7936 S  0.0  0.0   0:00.05 /usr/bin/php /home/ozonelab/public_html/new-impulsi.ru/tov.php
 200005 ozonelab  20   0  279m  12m 7936 S  0.0  0.0   0:00.04 /usr/bin/php /home/ozonelab/public_html/new-impulsi.ru/tov.php
 201318 ozonelab  20   0  279m  12m 8488 S  0.0  0.0   0:00.04 /usr/bin/php /home/ozonelab/public_html/new-impulsi.ru/index.php
 203893 ozonelab  20   0  279m  12m 7936 S  0.0  0.0   0:00.04 /usr/bin/php /home/ozonelab/public_html/new-impulsi.ru/index.php
 216649 ozonelab  20   0  279m  12m 7936 S  0.0  0.0   0:00.04 /usr/bin/php /home/ozonelab/public_html/new-impulsi.ru/index.php
 217926 ozonelab  20   0  279m  13m 8560 S  0.0  0.0   0:00.05 /usr/bin/php /home/ozonelab/public_html/new-impulsi.ru/tov.php
 218612 ozonelab  20   0  279m  12m 7936 S  0.0  0.0   0:00.04 /usr/bin/php /home/ozonelab/public_html/new-impulsi.ru/tov.php
 219875 ozonelab  20   0  279m  12m 7936 S  0.0  0.0   0:00.04 /usr/bin/php /home/ozonelab/public_html/new-impulsi.ru/tov.php
 221521 ozonelab  20   0  279m  12m 7936 S  0.0  0.0   0:00.04 /usr/bin/php /home/ozonelab/public_html/new-impulsi.ru/index.php
 223178 ozonelab  20   0  279m  12m 8524 S  0.0  0.0   0:00.04 /usr/bin/php /home/ozonelab/public_html/new-impulsi.ru/index.php
 225962 ozonelab  20   0  279m  12m 7936 S  0.0  0.0   0:00.05 /usr/bin/php /home/ozonelab/public_html/new-impulsi.ru/index.php
 226269 ozonelab  20   0  279m  12m 7928 S  0.0  0.0   0:00.04 /usr/bin/php /home/ozonelab/public_html/new-impulsi.ru/page.php
 246887 ozonelab  20   0  279m  12m 8524 S  0.0  0.0   0:00.05 /usr/bin/php /home/ozonelab/public_html/new-impulsi.ru/index.php
 252485 ozonelab  20   0  279m  13m 8600 S  0.0  0.0   0:00.05 /usr/bin/php /home/ozonelab/public_html/new-impulsi.ru/page.php
 263853 ozonelab  20   0  279m  13m 8600 S  0.0  0.0   0:00.05 /usr/bin/php /home/ozonelab/public_html/new-impulsi.ru/page.php
 275436 ozonelab  20   0  127m  26m 3004 S  0.0  0.1   0:00.02 cpaneld - serving IP
 901635 ozonelab  20   0  129m  27m 3492 S  0.0  0.1   0:00.06 cpaneld - serving IP 906820 ozonelab  20   0  236m  19m 7768 S  0.0  0.1   0:00.19 /usr/local/cpanel/3rdparty/php/54/bin/php-cgi /usr/local/cpanel/base/3rdparty/phpMyAdmin
 910619 ozonelab  20   0  129m  26m 3220 S  0.0  0.1   0:00.01 cpaneld - serving IP
 910650 ozonelab  20   0  137m  14m 7188 S  0.0  0.0   0:00.07 /usr/local/cpanel/3rdparty/php/54/bin/php-cgi /usr/local/cpanel/base/3rdparty/phpMyAdmin

Question: that means multiple processes? Yes, these scripts show the directory home page and regular page. They hang? Not complete or require a lot of memory? the reason for blocking some specific script? Can you tell?
Answer:

It`s not a lock, the process hung.
please Check now.

Question: no. Does not open the website ((An error occurred.Sorry, the page you are looking for is currently unavailable.Please try again later.If you are the system administrator of this resource then you should check the error log for details.
Answer:

Now processes less:

 364950 ozonelab  20   0  281m  13m 8632 S  0.0  0.0   0:00.05 /usr/bin/php /home/ozonelab/public_html/new-impulsi.ru/recycle.php
 384461 ozonelab  20   0  279m  13m 8584 S  0.0  0.0   0:00.04 /usr/bin/php /home/ozonelab/public_html/new-impulsi.ru/page.php
 385095 ozonelab  20   0  279m  13m 8600 S  0.0  0.0   0:00.05 /usr/bin/php /home/ozonelab/public_html/new-impulsi.ru/page.php

Question: why this error now?Page does not open (
Answer:

What changes did you do on the website? You have the process fail.

Question: today no did not.just tested everything. Was looking through the catalog, create orders.
Answer:

here is a query that will ondelay?

33596980 | ozonelab | localhost | ozonelab_imp | Query | 9958 | Waiting for table metadata lock | ALTER TABLE `tov` ADD `pr
ice_sale` DOUBLE(16,2) NOT NULL DEFAULT `0` AFTER `price2` |
| 33640051 | ozonelab_imp | localhost | ozonelab_imp | Query | 7242 | Waiting for table metadata lock | select count(fld_key3) c f
rom tov where tov.price>0 and fld_key2=67535316 |
| 33675635 | ozonelab_imp | localhost | ozonelab_imp | Query | 4930 | Waiting for table metadata lock | select concat(`/catalog/`,
replace(site_grp.url `.html`, \"),`/`,grp.url,`/`,sgrp.url,`/`,tov.url`. |
| 33678928 | ozonelab_imp | localhost | ozonelab_imp | Query | 4717 | Waiting for table metadata lock | select count(fld_key3) c f
rom tov where tov.price>0 and fld_key2=44315924 |
| 33679962 | ozonelab_imp | localhost | ozonelab_imp | Query | 4655 | Waiting for table metadata lock | select concat(`/catalog/`,
replace(site_grp.url `.html`, \"),`/`,grp.url,`/`,sgrp.url,`/`,tov.url`. |
| 33684708 | ozonelab_imp | localhost | ozonelab_imp | Query | 4363 | Waiting for table metadata lock | select concat(`/catalog/`,
replace(site_grp.url `.html`, \"),`/`,grp.url,`/`,sgrp.url,`/`,tov.url`. |
| 33685913 | ozonelab_imp | localhost | ozonelab_imp | Query | 4290 | Waiting for table metadata lock | select concat(`/catalog/`,
replace(site_grp.url `.html`, \"),`/`,grp.url,`/`,sgrp.url,`/`,tov.url`. |
| 33688308 | ozonelab_imp | localhost | ozonelab_imp | Query | 4130 | Waiting for table metadata lock | select concat(`/catalog/`,
replace(site_grp.url `.html`, \"),`/`,grp.url,`/`,sgrp.url,`/`,tov.url`. |
| 33705762 | ozonelab_imp | localhost | ozonelab_imp | Query | 2982 | Waiting for table metadata lock | select good, tov.count res
t, recycle.price, recycle.count, recycle.name, (select image from note_tov |
| 33708976 | ozonelab_imp | localhost | ozonelab_imp | Query | 2732 | Waiting for table metadata lock | select good, tov.count res
t, recycle.price, recycle.count, recycle.name, (select image from note_tov |
| 33712486 | ozonelab_imp | localhost | ozonelab_imp | Query | 2452 | Waiting for table metadata lock | select concat(`/catalog/`,
replace(site_grp.url `.html`, \"),`/`,grp.url,`/`,sgrp.url,`/`,tov.url`. |
| 33712631 | ozonelab_imp | localhost | ozonelab_imp | Query | 2444 | Waiting for table metadata lock | select concat(`/catalog/`,
replace(site_grp.url `.html`, \"),`/`,grp.url,`/`,sgrp.url,`/`,tov.url`. |
| 33715009 | ozonelab_imp | localhost | ozonelab_imp | Query | 2270 | Waiting for table metadata lock | select concat(`/catalog/`,
replace(site_grp.url `.html`, \"),`/`,grp.url,`/`,sgrp.url,`/`,tov.url`. |
| 33715118 | ozonelab_imp | localhost | ozonelab_imp | Query | 2263 | Waiting for table metadata lock | select concat(`/catalog/`,
replace(site_grp.url `.html`, \"),`/`,grp.url,`/`,sgrp.url,`/`,tov.url`. |
| 33715143 | DELAYED | localhost | eximstats | Delayed insert | 42 | Waiting for INSERT |
|
| 33717341 | ozonelab_imp | localhost | ozonelab_imp | Query | 2119 | Waiting for table metadata lock | select concat(`/catalog/`,
replace(site_grp.url `.html`, \"),`/`,grp.url,`/`,sgrp.url,`/`,tov.url`. |
| 33717533 | ozonelab_imp | localhost | ozonelab_imp | Query | 2105 | Waiting for table metadata lock | select concat(`/catalog/`,
replace(site_grp.url `.html`, \"),`/`,grp.url,`/`,sgrp.url,`/`,tov.url`. |
| 33736013 | ozonelab_imp | localhost | ozonelab_imp | Query | 811 | Waiting for table metadata lock | select concat(`/catalog/`,
replace(site_grp.url `.html`, \"),`/`,grp.url,`/`,sgrp.url,`/`,tov.url`. |
| 33748194 | eurolub_tk1 | localhost | eurolub_tk1 | Sleep | 10

Question: ALTER TABLE `tov` ADD `price_sale` DOUBLE(16,2) NOT NULL DEFAULT `0` AFTER `price2` | is via phpmyadmin I field to the table added
Answer:

why do so many queries go?

Question: perhaps due to the fact the first Alter table podvisli all.. and the opening pages just hang in the queue perhaps? It can be removed from the implementation?
Answer:

we removed the queries. don`t do naprawienie queries to the database

Question: alter table created from phpmyadmin the problem is it was eventually or not?
Answer:

the problem was the number of requests

Question: thank You for the prompt response!
Answer:


ok


<< Previous