Messages

31

Varnish / Is there a default.vcl that is good for lowering the load?

« on: March 16, 2018, 07:22:58 PM »

Is there a default.vcl that is good for lowering the load?

do you have, or do you have any suggestion?
I did a lot of experimentation. but no good results were found.

==================================================
There are 282 online. load 15 !

http://prntscr.com/is6ve0

There was no such problem in front of varnish. now nginx is on the front. how do I get it back?

32

MySQL / Re: Mysql CPU Load Problem

« on: February 28, 2018, 02:33:05 AM »

http://prntscr.com/ikpat7

and also. I installed mysqltuner and tuning-primer. The two of them have different results. Which one is better for you?
I played with my.cnf file a bit. I think the problem has been solved a bit. I don't really know what I'm doing.

33

MySQL / Re: Mysql CPU Load Problem

« on: February 21, 2018, 10:53:33 PM »

http://prntscr.com/ii1ewi

there seems to be no problem. but the load is rising. What are friends becoming? The entire site is attached to the cloudflare.

34

MySQL / Mysql CPU Load Problem

« on: February 21, 2018, 12:09:45 PM »

there are a total of 10k hits. but sometimes MySQL is doing CPU Load. what could be the problem? and cwp has recently started to update very often. Could it be related to this?

http://prntscr.com/ihrws6
__________________________________
Apache version: Apache/2.4.29
PHP version: 5.6.33
MySQL version: 10.1.31-MariaDB
FTP version: 1.0.30

35

CentOS 6 Problems / Re: admin panel - 502 Bad Gateway error

« on: February 20, 2018, 10:14:57 AM »

cd /scripts
./restart_cwpsrv

should fix it

thank you. it is working now

36

CentOS 6 Problems / admin panel - 502 Bad Gateway error

« on: February 20, 2018, 09:25:32 AM »

There was no problem at night. but when I wake up I see that there is an error. I can not enter the admin pane.

http://prntscr.com/ih8hw0

how can i solve it?

37

Nginx / Re: Starting nginx: nginx: [emerg] bind() to 163.1xx.xxx.xxx:80 failed (98: Address

« on: February 13, 2018, 04:31:52 PM »

What errors are showing exactly?

there is no problem at the moment. but as I said, I set up a new server. again the above mentioned error. If nginx works varnish gives an error. nginx was giving an error if varnish tried.

38

Nginx / Re: Starting nginx: nginx: [emerg] bind() to 163.1xx.xxx.xxx:80 failed (98: Address

« on: February 10, 2018, 10:30:10 AM »

I installed a new server. I have this error again. Please bring a solution to the authorities. thanks

39

Nginx / Re: Starting nginx: nginx: [emerg] bind() to 163.1xx.xxx.xxx:80 failed (98: Address

« on: February 07, 2018, 06:41:27 PM »

when you restart nginx what error it throws?

I solved the problem.
sudo fuser -k 80/tcp
service nginx start
service nginx restart
service httpd restart
service varnish restart
Thank you for the help.

40

Nginx / Re: Starting nginx: nginx: [emerg] bind() to 163.1xx.xxx.xxx:80 failed (98: Address

« on: February 07, 2018, 06:31:30 PM »

What error varnish is throwing?

Better goto select webserver --> select only apache and compile

Then select nginx --> apache --> varnish and compile it again.

I did what you said. but it happened again.

http://prntscr.com/ibileh
varnish is working, nginx is giving an error.
nginx is working, varnish is giving an error.

41

Nginx / Starting nginx: nginx: [emerg] bind() to 163.1xx.xxx.xxx:80 failed (98: Address

« on: February 07, 2018, 05:54:39 PM »

Hello
I restarted the services. then this error came to fruition.

Starting nginx: nginx: [emerg] bind() to 163.1xx.xxx.xxx:80 failed (98: Address

sudo fuser -k 80/tcp

I am correcting with. then varnish gives an error.

how do I solve this problem?

42

MySQL / Re: /var/lib/mysql = du -sh = 175G / I want to clear them

« on: January 21, 2018, 11:42:45 PM »

you should connect to your SQL server using SQL root login,

Code: [Select]

#mysql -u root -p
then execute command in SQL console (172 was used as example)

Code: [Select]

mysql>PURGE BINARY LOGS TO ‘mysql-bin.172’;
then leave SQL console

Code: [Select]

mysql>exit
If you disable binary logging, yes, you can delete this files with rm command when MySQL stopped

Thank you so much. I deleted it with "rm -rf file name".

43

MySQL / Re: /var/lib/mysql = du -sh = 175G / I want to clear them

« on: January 21, 2018, 08:31:30 PM »

https://dev.mysql.com/doc/refman/5.7/en/purge-binary-logs.html

You need to use phpMyAdmin or mysql console client to do this.
Don’t delete this files using OS shell!

Thank you, but I do not know exactly what I need to do.

I closed this line with "#" in the file "log-bin = mysql-bin" in /etc/my.cnf.
later, I did "service mysqld restart".
and now can I manually delete those files? >> rm -rf mysql-bin.*

44

MySQL / /var/lib/mysql = du -sh = 175G / I want to clear them

« on: January 21, 2018, 07:57:10 PM »

Hello
cd var/lib/mysql

http://prntscr.com/i3lu4l

I want to clean these files securely. how can I do that ? and I do not want to keep the log. can you help me ?
MySQL version: 10.1.30-MariaDB
centos 6
Apache version: Apache/2.4.29
PHP version: 5.6.31
thanks

45

PHP / Re: Phpmyadmin "502 Bad Gateway" Error

« on: October 22, 2017, 10:36:47 AM »

check that your packages are update and then restart the server
yum -y update

if the issue continues try this
yum reinstall cwpsrv
yum reinstall cwpphp
....after that again restart of the services or reboot

I did it, but it still does not work.