| Question: |
say I have Apache as a module or PHP as cgi?The site gives an error maybe this is the reason? |
| Question: |
http://ntv-plus.armavir.tv/ |
| Answer: |
Hello. php is running as cgi. In the folder of the website http://ntv-plus.armavir.tv/ no files. download them |
| Question: |
yeah thanks! |
| Answer: |
ok
|
| Question: |
the website will not rabotayesh Access denied for user `roland15_amoba`@`localhost` (using password: YES)yesterday re-pressed to splice database and polzovatelnitsa, it took a couple of hours opati not hotelpersonal again srastetsya not working pesetas denied for user `roland15_amoba`@`localhost` (using password: YES) |
| Question: |
asked your password to work, scibetta the password for the user? |
| Answer: |
Hello. we see that queries to the database create a very Vysokov load that can crash the server
| 469084 | roland15_amoba | localhost | roland15_amoba | Query | 0 | Copying to tmp table | SELECT jb_board.id AS board_id, jb_board.id_category, jb_board.price, jb_board.title jb_board.param |
| 469087 | roland15_amoba | localhost | roland15_amoba | Query | 1 | Sending data | SELECT SUM(hits) as value FROM jb_board WHERE user_id=\"
ask what You have a cms and what`s the reason for vysokogo number of queries? no optimization work with the database we can not guarantee the normal operation of the site. please kindly to check it out , and set up work with database |
| Question: |
You don`t sabotage people?remote entry into the database is missing too |
| Question: |
what is very high? |
| Question: |
just something I began to doubt that you MENA transplanted it on a vps, all vps you can go via ssh In the console |
| Question: |
in zebras about a very high load? |
| Question: |
remote mysql chopped? |
| Question: |
why disabled remote sql? |
| Answer: |
please Wait, the request is sent to the administrator. |
| Answer: |
in numbers, it 2421 mysql 20 0 7860m 3.4 g 5896 S 225.9% 10.8 298:00.31 mysqld
| 487671 | roland15 | localhost | | Sleep| 174 | | |
| 487672 | roland15 | localhost | | Query | 174 | Writing to net | SELECT * FROM `roland15_amoba`.`jb_board` |
| 487683 | roland15_amoba | localhost | roland15_amoba | Query | 171 | Waiting for table level lock | UPDATE jb_board SET hits=hits+1 WHERE id=1289996790 LIMIT 1 |
| 487696 | roland15_amoba | localhost | roland15_amoba | Query | 170 | Waiting for table level lock | SELECT jb_user.avatar, jb_board.title jb_board.id_category, jb_board.city, jb_board.text AS text_ad |
| 487827 | roland15_amoba | localhost | roland15_amoba | Query | 164 | Waiting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.date_add) as unix_time, DATE_FORMAT(jb_board |
| 487925 | roland15_amoba | localhost | roland15_amoba | Query | 158 | Waiting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.date_add) as unix_time, DATE_FORMAT(jb_board |
| 488073 | roland15_amoba | localhost | roland15_amoba | Query | 149 | Waiting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.date_add) as unix_time, DATE_FORMAT(jb_board |
| 488090 | roland15_amoba | localhost | roland15_amoba | Query | 148 | Waiting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.date_add) as unix_time, DATE_FORMAT(jb_board |
| 488249 | roland15_amoba | localhost | roland15_amoba | Query | 138 | Waiting for table level lock | SELECT jb_board.id jb_board.id_category, jb_board.price, jb_board.title jb_board.text jb_board.ci |
| 488274 | roland15_amoba | localhost | roland15_amoba | Query | 137 | Waiting for table level lock | SELECT jb_board.id jb_board.id_category, jb_board.price, jb_board.title jb_board.text jb_board.ci |
| 488328 | roland15_amoba | localhost | roland15_amoba | Query | 132 | Waiting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.date_add) as unix_time, DATE_FORMAT(jb_board |
| 488339 | roland15_amoba | localhost | roland15_amoba | Query | 132 | Waiting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.date_add) as unix_time, DATE_FORMAT(jb_board |
| 488524 | DELAYED | localhost | roland15_xf | Delayed insert | 115 | Waiting for INSERT | |
| 488533 | roland15_amoba | localhost | roland15_amoba | Query | 114 | Waiting for table level lock | SELECT jb_board.id jb_board.id_category, jb_board.price, jb_board.title jb_board.text jb_board.ci |
| 488546 | roland15_amoba | localhost | roland15_amoba | Query | 113 | Waiting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.date_add) as unix_time, DATE_FORMAT(jb_board |
| 488731 | roland15_amoba | localhost | roland15_amoba | Query | 97 | Waiting for table level lock | SELECT jb_board.id jb_board.id_category, jb_board.price, jb_board.title jb_board.text jb_board.ci |
| 488763 | roland15_amoba | localhost | roland15_amoba | Query | 96 | Waiting for table level lock | SELECT jb_board.id jb_board.id_category, jb_board.price, jb_board.title jb_board.text jb_board.ci |
| 488829 | roland15_amoba | localhost | roland15_amoba | Query | 92 | Waiting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.date_add) as unix_time, DATE_FORMAT(jb_board |
| 489004 | roland15_amoba | localhost | roland15_amoba | Query | 79 | Waiting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.date_add) as unix_time, DATE_FORMAT(jb_board |
| 489116 | roland15_amoba | localhost | roland15_amoba | Query | 72 | Waiting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.date_add) as unix_time, DATE_FORMAT(jb_board |
| 489252 | roland15_amoba | localhost | roland15_amoba | Query | 64 | Waiting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.date_add) as unix_time, DATE_FORMAT(jb_board |
| 489305 | roland15_amoba | localhost | roland15_amoba | Query | 60 | Waiting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.date_add) as unix_time, DATE_FORMAT(jb_board |
| 489351 | roland15_amoba | localhost | roland15_amoba | Query | 57 | Waiting for table level lock | SELECT jb_board.id jb_board.id_category, jb_board.price, jb_board.title jb_board.text jb_board.ci | ask about remote connection what is it? |
| Question: |
I don`t know what you pokazale now I copied a backup of the database when you copy always website lies |
| Question: |
in numbers, this 2421 mysql 20 0 7860m 3.4 g 5896 S 225.9% 10.8 298:00.31 mysqldэто what? |
| Answer: |
we showed You all the queries running at the same time 495976 | roland15 | localhost | | Sleep| 70 | | |
| 495977 | roland15 | localhost | | Query | 70 | Writing to net | SELECT * FROM `roland15_amoba`.`jb_board` |
| 495991 | roland15_amoba | localhost | roland15_amoba | Query | 68 | Waiting for table level lock | UPDATE jb_board SET hits=hits+1 WHERE id=7545 LIMIT 1 |
| 496045 | roland15_amoba | localhost | roland15_amoba | Query | 66 | Waiting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.date_add) as unix_time, DATE_FORMAT(jb_board |
| 496073 | roland15_amoba | localhost | roland15_amoba | Query | 64 | Waiting for table level lock | SELECT jb_board.id jb_board.id_category, jb_board.price, jb_board.title jb_board.text jb_board.ci |
| 496180 | roland15_amoba | localhost | roland15_amoba | Query | 55 | Waiting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.date_add) as unix_time, DATE_FORMAT(jb_board |
| 496314 | roland15_amoba | localhost | roland15_amoba | Query | 46 | Waiting for table level lock | SELECT jb_board.id jb_board.id_category, jb_board.price, jb_board.title jb_board.text jb_board.ci |
| 496406 | roland15_amoba | localhost | roland15_amoba | Query | 39 | Waiting for table level lock | SELECT jb_board.id jb_board.id_category, jb_board.price, jb_board.title jb_board.text jb_board.ci |
| 496501 | roland15_amoba | localhost | roland15_amoba | Query | 33 | Waiting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.date_add) as unix_time, DATE_FORMAT(jb_board |
| 496570 | roland15_amoba | localhost | roland15_amoba | Query | 28 | Waiting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.date_add) as unix_time, DATE_FORMAT(jb_board |
| 496634 | DELAYED | localhost | roland15_xf | Delayed insert | 24 | Waiting for INSERT | |
| 496637 | roland15_amoba | localhost | roland15_amoba | Query | 24 | Waiting for table level lock | SELECT jb_board.id jb_board.id_category, jb_board.price, jb_board.title jb_board.text jb_board.ci |
| 496687 | roland15_amoba | localhost | roland15_amoba | Query | 20 | Waiting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.date_add) as unix_time, DATE_FORMAT(jb_board |
| 496943 | roland15_amoba | localhost | roland15_amoba | Query | 3 | Waiting for table level lock | SELECT jb_board.id jb_board.id_category, jb_board.price, jb_board.title jb_board.text jb_board.ci |
| 496945 | roland15_amoba | localhost | roland15_amoba | Query | 3 | Waiting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.date_add) as unix_time, DATE_FORMAT(jb_board |
| 496973 | roland15_amoba | localhost | roland15_amoba | Query | 1 | Waiting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.date_add) as unix_time, DATE_FORMAT(jb_board | what kind of queries? why are so many of them. you will eeto to fix it? what kind of remote access is PEQ? from what ip you connect? For ssh access, you need a transfer. |
| Question: |
what is the transfer? you wrote I have moved to a vps? to move where you want? |
| Question: |
what to fix exactly?to fix just that there are no queries or what? |
| Question: |
you copy-paste something I don`t understand it? |
| Answer: |
we show you the lice processes . it all requests to your site. which create problem for your website. it all requests to a mysql database. Yes, correct nornal that would be less queries. they adversely affect the site speed and overload the server. why so many?
| 502752 | roland15_amoba | localhost | roland15_amoba | Query | 253 | Waiting for table level lock | UPDATE jb_board SET hits=hits+1 WHERE id=525449765 LIMIT 1 |
| 502758 | roland15 | localhost | | Sleep| 254 | | |
| 502759 | roland15 | localhost | | Query | 254 | Writing to net | SELECT * FROM `roland15_amoba`.`jb_board` |
| 502950 | roland15_amoba | localhost | roland15_amoba | Query | 242 | Waiting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.date_add) as unix_time, DATE_FORMAT(jb_board |
| 503111 | roland15_amoba | localhost | roland15_amoba | Query | 231 | Waiting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.date_add) as unix_time, DATE_FORMAT(jb_board |
| 503117 | roland15_amoba | localhost | roland15_amoba | Query | 231 | Waiting for table level lock | SELECT jb_board.id jb_board.id_category, jb_board.price, jb_board.title jb_board.text jb_board.ci |
| 503135 | roland15_amoba | localhost | roland15_amoba | Query | 230 | Waiting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.date_add) as unix_time, DATE_FORMAT(jb_board |
| 503219 | roland15_amoba | localhost | roland15_amoba | Query | 226 | Waiting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.date_add) as unix_time, DATE_FORMAT(jb_board |
| 503267 | roland15_amoba | localhost | roland15_amoba | Query | 222 | Waiting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.date_add) as unix_time, DATE_FORMAT(jb_board |
| 503319 | roland15_amoba | localhost | roland15_amoba | Query | 218 | Waiting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.date_add) as unix_time, DATE_FORMAT(jb_board |
| 503340 | roland15_amoba | localhost | roland15_amoba | Query | 216 | Waiting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.date_add) as unix_time, DATE_FORMAT(jb_board |
| 503662 | roland15_amoba | localhost | roland15_amoba | Query | 197 | Waiting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.date_add) as unix_time, DATE_FORMAT(jb_board |
| 504026 | roland15_amoba | localhost | roland15_amoba | Query | 179 | Waiting for table level lock | SELECT jb_board.id jb_board.id_category, jb_board.price, jb_board.title jb_board.text jb_board.ci |
| 504060 | roland15_amoba | localhost | roland15_amoba | Query | 177 | Waiting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.date_add) as unix_time, DATE_FORMAT(jb_board |
| 504350 | roland15_amoba | localhost | roland15_amoba | Query | 159 | Waiting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.date_add) as unix_time, DATE_FORMAT(jb_board |
| 504416 | roland15_amoba | localhost | roland15_amoba | Query | 155 | Waiting for table level lock | SELECT jb_board.id jb_board.id_category, jb_board.price, jb_board.title jb_board.text jb_board.ci |
| 504562 | roland15_amoba | localhost | roland15_amoba | Query | 146 | Waiting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.date_add) as unix_time, DATE_FORMAT(jb_board |
| 504658 | roland15_amoba | localhost | roland15_amoba | Query | 141 | Waiting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.date_add) as unix_time, DATE_FORMAT(jb_board |
| 504821 | roland15_amoba | localhost | roland15_amoba | Query | 132 | Waiting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.date_add) as unix_time, DATE_FORMAT(jb_board |
| 504834 | roland15_amoba | localhost | roland15_amoba | Query | 132 | Waiting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.date_add) as unix_time, DATE_FORMAT(jb_board |
| 504891 | roland15_amoba | localhost | roland15_amoba | Query | 129 | Waiting for table level lock | SELECT jb_board.id jb_board.id_category, jb_board.price, jb_board.title jb_board.text jb_board.ci |
| 505210 | roland15_amoba | localhost | roland15_amoba | Query | 111 | Waiting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.date_add) as unix_time, DATE_FORMAT(jb_board
|
| Question: |
I did a backup of basiese again I say,the whole site in certapro go to the database every hour |
| Answer: |
did You make a backup every 5 minutes? these queries are executed continuously. if they were every hour problems nebylo. Here is the process of backup ?
| 511135 | roland15 | localhost | | Sleep| 32 | | |
| 511136 | roland15 | localhost | | Query | 32 | Writing to net | SELECT * FROM `roland15_amoba`.`jb_board` |
| 511150 | roland15_amoba | localhost | roland15_amoba | Query | 29 | Waiting for table level lock | UPDATE jb_board SET hits=hits+1 WHERE id=569646923 LIMIT 1 |
| 511198 | roland15_amoba | localhost | roland15_amoba | Query | 29 | Waiting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.date_add) as unix_time, DATE_FORMAT(jb_board |
| 511214 | roland15_amoba | localhost | roland15_amoba | Query | 28 | Waiting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.date_add) as unix_time, DATE_FORMAT(jb_board |
| 511245 | roland15_amoba | localhost | roland15_amoba | Query | 26 | Waiting for table level lock | SELECT jb_board.id jb_board.id_category, jb_board.price, jb_board.title jb_board.text jb_board.ci |
| 511357 | roland15_amoba | localhost | roland15_amoba | Query | 18 | Waiting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.date_add) as unix_time, DATE_FORMAT(jb_board |
|
| Question: |
you can specify what kako transfer and where you govorili I began to pay you more and you forced me to upgrade to vps and the site of over 1500 users does not pull, now have you just begun to cut off sql |
| Question: |
I`m doing a backup now |
| Question: |
you write for vps, You will need a carry,so I Shas is still not a vps? It turns out |
| Answer: |
on the current server cannot provide ssh access, i.e. with full administration. if You need root access it will be another server. the migration is done by us. you only change DNS. we explained the problem and what to do. if You think we are wrong and You can do it better on their own driving serverom, we will provide you with the opportunity |
| Question: |
remote sql is not rabotaetsya disabled? |
| Answer: |
we do not cut off the third time, please tell what is the problem with sql remote you now also makes bekap? | 535514 | roland15 | localhost | | Sleep | 573 |
|
|
| 535515 | roland15 | localhost | | Query | 573 | Wr
iting to net | SELECT * FROM `roland15_amoba`.`jb_board`
|
| 535523 | roland15_amoba | localhost | roland15_amoba | Query | 571 | Wa
iting for table level lock | UPDATE jb_board SET hits=hits+1 WHERE id=504016183 LIMIT
1 |
| 535543 | roland15_amoba | localhost | roland15_amoba | Query | 571 | Wa
iting for table level lock | SELECT jb_user.avatar, jb_board.title jb_board.id_categ
ory, jb_board.city, jb_board.text AS text_ad |
| 535557 | roland15_amoba | localhost | roland15_amoba | Query | 571 | Wa
iting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.
date_add) as unix_time, DATE_FORMAT(jb_board |
| 535656 | roland15_amoba | localhost | roland15_amoba | Query | 565 | Wa
iting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.
date_add) as unix_time, DATE_FORMAT(jb_board |
| 535751 | roland15_amoba | localhost | roland15_amoba | Query | 559 | Wa
iting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.
date_add) as unix_time, DATE_FORMAT(jb_board |
| 535755 | roland15_amoba | localhost | roland15_amoba | Query | 559 | Wa
iting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.
date_add) as unix_time, DATE_FORMAT(jb_board |
| 535784 | roland15_amoba | localhost | roland15_amoba | Query | 558 | Wa
iting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.
date_add) as unix_time, DATE_FORMAT(jb_board |
| 535898 | roland15_amoba | localhost | roland15_amoba | Query | 554 | Wa
iting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.
date_add) as unix_time, DATE_FORMAT(jb_board |
| 535899 | roland15_amoba | localhost | roland15_amoba | Query | 554 | Wa
iting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.
date_add) as unix_time, DATE_FORMAT(jb_board |
| 535934 | roland15_amoba | localhost | roland15_amoba | Query | 552 | Wa
iting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.
date_add) as unix_time, DATE_FORMAT(jb_board |
| 536186 | roland15_amoba | localhost | roland15_amoba | Query | 542 | Wa
iting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.
date_add) as unix_time, DATE_FORMAT(jb_board |
| 536295 | roland15_amoba | localhost | roland15_amoba | Query | 538 | Wa
iting for table level lock | SELECT jb_board.id AS board_id, UNIX_TIMESTAMP(jb_board.
date_add) as unix_time, DATE_FORMAT(jb_board | |
| Answer: |
Yes, sorry for the inaccuracy of DNS when you migrate will not change. would be just another bar. the migration is done by us. initial configuration of the server as well |
| Question: |
Remote SKL earned, thanks! Yes had a backup it was probably so long |
| Answer: |
well |
| Answer: |
ok
|
| Question: |
remote sql and not working, that was a mistake thought he earned |
| Answer: |
Inform the IP through which you are connected? |
| Question: |
46.173.188.91 |
| Answer: |
added the IP to trusted. Please check now. |
| Question: |
Again cut off remote mscl?my IP 46.173.188.91 |
| Answer: |
Hello. please Wait, the request is transferred to administratoru. |
| Question: |
why crap all the time? |
| Answer: |
We do not Gadim. The request is sent to the administrator. |
| Answer: |
ip added to trusted. to which server you connect? server address vandaloff.ru |
| Question: |
Yes |
| Question: |
why clean all the time*? |
| Answer: |
we do not remove. why do we need it? You have connected? |
| Question: |
no not working |
| Answer: |
to which server you connect? |
| Question: |
It worked, thank you! |
| Answer: |
Thank you, that appealed to customer support. |
|
