Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Pages: [1]
1
MySQL / Re: Can not update MariaDB
« on: August 18, 2024, 10:42:18 AM »
Thank you so much , your replies helped ot 
2
MySQL / Can not update MariaDB
« on: August 17, 2024, 10:34:34 PM »
Hello, I want to update MariaDB from 10.4 to 10.11
i followed the Wiki steps and got this error:
[root@panel ~]# yum -y update "MariaDB-*"
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
Could not retrieve mirrorlist http://mirrorlist.centos.org/?release=7&arch=x86_64&repo=os&infra=stock error was
14: curl#6 - "Could not resolve host: mirrorlist.centos.org; Unknown error"
epel/x86_64/metalink | 5.1 kB 00:00:00
Could not retrieve mirrorlist http://mirrorlist.centos.org/?release=7&arch=x86_64&repo=extras&infra=stock error was
14: curl#6 - "Could not resolve host: mirrorlist.centos.org; Unknown error"
One of the configured repositories failed (Unknown),
and yum doesn't have enough cached data to continue. At this point the only
safe thing yum can do is fail. There are a few ways to work "fix" this:
1. Contact the upstream for the repository and get them to fix the problem.
2. Reconfigure the baseurl/etc. for the repository, to point to a working
upstream. This is most often useful if you are using a newer
distribution release than is supported by the repository (and the
packages for the previous distribution release still work).
3. Run the command with the repository temporarily disabled
yum --disablerepo=<repoid> ...
4. Disable the repository permanently, so yum won't use it by default. Yum
will then just ignore the repository until you permanently enable it
again or use --enablerepo for temporary usage:
yum-config-manager --disable <repoid>
or
subscription-manager repos --disable=<repoid>
5. Configure the failing repository to be skipped, if it is unavailable.
Note that yum will try to contact the repo. when it runs most commands,
so will have to try and fail each time (and thus. yum will be be much
slower). If it is a very temporary problem though, this is often a nice
compromise:
yum-config-manager --save --setopt=<repoid>.skip_if_unavailable=true
Cannot find a valid baseurl for repo: extras/7/x86_64
i followed the Wiki steps and got this error:
[root@panel ~]# yum -y update "MariaDB-*"
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
Could not retrieve mirrorlist http://mirrorlist.centos.org/?release=7&arch=x86_64&repo=os&infra=stock error was
14: curl#6 - "Could not resolve host: mirrorlist.centos.org; Unknown error"
epel/x86_64/metalink | 5.1 kB 00:00:00
Could not retrieve mirrorlist http://mirrorlist.centos.org/?release=7&arch=x86_64&repo=extras&infra=stock error was
14: curl#6 - "Could not resolve host: mirrorlist.centos.org; Unknown error"
One of the configured repositories failed (Unknown),
and yum doesn't have enough cached data to continue. At this point the only
safe thing yum can do is fail. There are a few ways to work "fix" this:
1. Contact the upstream for the repository and get them to fix the problem.
2. Reconfigure the baseurl/etc. for the repository, to point to a working
upstream. This is most often useful if you are using a newer
distribution release than is supported by the repository (and the
packages for the previous distribution release still work).
3. Run the command with the repository temporarily disabled
yum --disablerepo=<repoid> ...
4. Disable the repository permanently, so yum won't use it by default. Yum
will then just ignore the repository until you permanently enable it
again or use --enablerepo for temporary usage:
yum-config-manager --disable <repoid>
or
subscription-manager repos --disable=<repoid>
5. Configure the failing repository to be skipped, if it is unavailable.
Note that yum will try to contact the repo. when it runs most commands,
so will have to try and fail each time (and thus. yum will be be much
slower). If it is a very temporary problem though, this is often a nice
compromise:
yum-config-manager --save --setopt=<repoid>.skip_if_unavailable=true
Cannot find a valid baseurl for repo: extras/7/x86_64
3
CentOS 7 Problems / i can't log in the admin panel
« on: November 15, 2023, 03:14:18 PM »
Hello, the NGINX service stoped, i don't know why, then i restarted the server from reboot button in server settings.
Now i can't log in and all my websites are down
, please help
image: https://www12.0zz0.com/2023/11/15/15/583482951.png
Now i can't log in and all my websites are down
, please helpimage: https://www12.0zz0.com/2023/11/15/15/583482951.png
5
Apache / i want to add port to my domain
« on: August 16, 2021, 03:16:37 AM »
Hello everyone, my domain is https://wiki-eg.com/ , and i want it to be https://wiki-eg.com:2053/ .
i tried to make webserver Domain Conf Nginx > Varnich > apache > proxy (custom port) and set custom port 2053. like image 1 : https://imgur.com/WuRyZvZ .
but when i go to https://wiki-eg.com/ i get this error : https://imgur.com/r4yTPOk ,
when i go to https://wiki-eg.com:2053/ , i get this error : https://imgur.com/TwWHr4g
i am using Cloudflare Full SSL , webserver : Nginx & Varnish & Apache and PHP FPM .
can you help me please !
i tried to make webserver Domain Conf Nginx > Varnich > apache > proxy (custom port) and set custom port 2053. like image 1 : https://imgur.com/WuRyZvZ .
but when i go to https://wiki-eg.com/ i get this error : https://imgur.com/r4yTPOk ,
when i go to https://wiki-eg.com:2053/ , i get this error : https://imgur.com/TwWHr4g
i am using Cloudflare Full SSL , webserver : Nginx & Varnish & Apache and PHP FPM .
can you help me please !
6
CentOS 7 Problems / Re: Mysql High CPU , all my Websites are down
« on: August 19, 2019, 11:22:40 AM »
thank you for your help 
i think your answer is the most right answer . i will disable it for two days and see what will happen.
But what if it was the problem, how can i fix this, i am totally depending on it in my website !!
thanks advanced
i think your answer is the most right answer . i will disable it for two days and see what will happen.
But what if it was the problem, how can i fix this, i am totally depending on it in my website !!
thanks advanced
7
CentOS 7 Problems / Re: Mysql High CPU , all my Websites are down
« on: August 17, 2019, 11:06:35 PM »
thank you very much ,
recently, i have found that :
when i am running the server on php5 nothing happen , no problem at all except the high CPU usage of phpfm.
And when i change it to php7 CPU load became very low and every thing is very good for about 8 hours and suddenly the query run and my websites go down.
So, the problem is between my website and php7 .
The Query : https://imgur.com/a/7lZXjc2
this is my active plugins : https://imgur.com/u7hshya
Theme : Publisher Version 7.6.0
i am using the same theme and plugins on both websites , but only the one with 30000 posts is making the problem.
recently, i have found that :
when i am running the server on php5 nothing happen , no problem at all except the high CPU usage of phpfm.
And when i change it to php7 CPU load became very low and every thing is very good for about 8 hours and suddenly the query run and my websites go down.
So, the problem is between my website and php7 .
The Query : https://imgur.com/a/7lZXjc2
this is my active plugins : https://imgur.com/u7hshya
Theme : Publisher Version 7.6.0
i am using the same theme and plugins on both websites , but only the one with 30000 posts is making the problem.
8
CentOS 7 Problems / Re: Mysql High CPU , all my Websites are down
« on: August 03, 2019, 11:37:12 PM »
that is the process or the queries when it run my sites stopped and CPU load became full :\
https://imgur.com/NGPmKxy
Any one can help me please !
https://imgur.com/NGPmKxy
Any one can help me please !
9
CentOS 7 Problems / Re: Mysql High CPU , all my Websites are down
« on: July 31, 2019, 03:32:22 PM »/etc/my.cnf.d/server.cnf :
Code: [Select]
#
# These groups are read by MariaDB server.
# Use it for options that only the server (but not clients) should see
#
# See the examples of server my.cnf files in /usr/share/mysql/
#
# this is read by the standalone daemon and embedded servers
[server]
# this is only for the mysqld standalone daemon
[mysqld]
#
# * Galera-related settings
#
[galera]
# Mandatory settings
#wsrep_on=ON
#wsrep_provider=
#wsrep_cluster_address=
#binlog_format=row
#default_storage_engine=InnoDB
#innodb_autoinc_lock_mode=2
#
# Allow server to accept connections on all interfaces.
#
#bind-address=0.0.0.0
#
# Optional setting
#wsrep_slave_threads=1
#innodb_flush_log_at_trx_commit=0
# this is only for embedded server
[embedded]
# This group is only read by MariaDB servers, not by MySQL.
# If you use the same .cnf file for MySQL and MariaDB,
# you can put MariaDB-only options here
[mariadb]
# This group is only read by MariaDB-10.1 servers.
# If you use the same .cnf file for MariaDB of different versions,
# use this group for options that older servers don't understand
[mariadb-10.1]
10
CentOS 7 Problems / Re: Mysql High CPU , all my Websites are down
« on: July 31, 2019, 03:14:05 PM »
thank you for your reply ,
that is my my.cnf file :
it just the normal one , i didn't change anything to it.
that is my my.cnf file :
Code: [Select]
#
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]
#
# include all files from the config directory
#
!includedir /etc/my.cnf.d
it just the normal one , i didn't change anything to it.
11
CentOS 7 Problems / Mysql High CPU , all my Websites are down
« on: July 30, 2019, 10:05:57 PM »
hi , i have a contabo vps which have DDOS attacks protection and cloudflare with the main domain, VPS specs:
CPU Model: Intel(R) Xeon(R) CPU E5-2630 v4 @ 2.20GHz
CPU Details: 4 Core (2200 MHz)
Ram : 8GB
Distro Name: CentOS Linux release 7.6.1810 (Core)
Kernel Version: 3.10.0-957.21.3.el7.x86_64
i run CWP Pro.
i have installed 3 wordpress sites , there is one with about 35000 posts.
Now, the CPU usage is 100% and all my websites are down because of mysqld service
there are some screenshots of the CWP processes and mysql queries.
https://imgur.com/Q8yK9A7
https://imgur.com/uzFLNm3
https://imgur.com/577yZ5V
please help me , how can i optimize mysql for better performance?
CPU Model: Intel(R) Xeon(R) CPU E5-2630 v4 @ 2.20GHz
CPU Details: 4 Core (2200 MHz)
Ram : 8GB
Distro Name: CentOS Linux release 7.6.1810 (Core)
Kernel Version: 3.10.0-957.21.3.el7.x86_64
i run CWP Pro.
i have installed 3 wordpress sites , there is one with about 35000 posts.
Now, the CPU usage is 100% and all my websites are down because of mysqld service
there are some screenshots of the CWP processes and mysql queries.
https://imgur.com/Q8yK9A7
https://imgur.com/uzFLNm3
https://imgur.com/577yZ5V
please help me , how can i optimize mysql for better performance?
12
CentOS 7 Problems / Re: PHP-FPM high CPU and Mysqld
« on: May 31, 2019, 12:50:41 PM »
i am using wordpress , and publishing posts nearly one post every five minutes.
how can i check SQL queries (mysqladmin pr) please?!
how can i check SQL queries (mysqladmin pr) please?!
13
CentOS 7 Problems / Re: PHP-FPM high CPU and Mysqld
« on: May 30, 2019, 08:51:57 PM »
unfortunately nothing changed, is it normal that mysqld time looks like that in the photo : https://imgur.com/NmEa9mr
i have these performance issues in PhpMyAdmin Advisor in this photo : https://imgur.com/Lj7Yoqm
i fix them but when i restart Mysql every thing became the same. how can i make these changes to still in mysql settings ?
i have these performance issues in PhpMyAdmin Advisor in this photo : https://imgur.com/Lj7Yoqm
i fix them but when i restart Mysql every thing became the same. how can i make these changes to still in mysql settings ?
14
CentOS 7 Problems / PHP-FPM high CPU and Mysqld
« on: May 30, 2019, 09:33:39 AM »
can you please help me to know what is the best configuration for php-fpm and mysql .
My VPS specs:
Intel(R) Xeon(R) CPU E5-2630 v4 @ 2.20GHz
Ram : 8 G
Disk: 150 G SSD
Apache version: Apache/2.4.39
PHP version: 5.6.21
MySQL version: 10.1.40-MariaDB
i have only one user
i attached a photo of live monitor , where there was only 30 visitor on my sites at the same time , and the stats doesn't change if they are 30 or 300 .
Photo : https://imgur.com/4Nn3TIL
My VPS specs:
Intel(R) Xeon(R) CPU E5-2630 v4 @ 2.20GHz
Ram : 8 G
Disk: 150 G SSD
Apache version: Apache/2.4.39
PHP version: 5.6.21
MySQL version: 10.1.40-MariaDB
i have only one user
i attached a photo of live monitor , where there was only 30 visitor on my sites at the same time , and the stats doesn't change if they are 30 or 300 .
Photo : https://imgur.com/4Nn3TIL
15
CentOS 7 Problems / Re: Can you help me plzz
« on: May 30, 2019, 09:23:32 AM »
I had the same issue , this code saved me.
login using SSH and paste the code:
# systemctl stop mysqld
#systemctl set-environment MYSQLD_OPTS="--skip-grant-tables"
# systemctl start mysqld
i hope it works for you
login using SSH and paste the code:
# systemctl stop mysqld
#systemctl set-environment MYSQLD_OPTS="--skip-grant-tables"
# systemctl start mysqld
i hope it works for you
Pages: [1]
