Plesk 9.5.3
Red Hat 8
MySQL version 3.x (default with plesk).
I need MySQL version 4.0x
I have absolutely no idea how to do it.
Can someone point me to a good step-by-step guide? Or perhaps is anyone willing to upgrade it for me (I will pay, if interested, my aim is manfrincp).
im scanning my site via Acunetix vulnerability scanner and see that it has high risk vulnerability "Mysql enterprise server 5.0"
It says upgrade to 5.1.How to do it in UBUNTU 8.04?
how to upgrade mysql 4.0 to 4.1 on cpanel server? Is there any script there?
View 2 Replies View RelatedI'm running a message board and it looks like I've outgrown the low end xeon 3040 1.86GHz dual core server, and the bulk of the CPU load is going to mysqld. I'm debating between offloading the DB to a dedicated server vs upgrading the existing server and hosting the web server and db on the same machine.
Any thoughts on the better approach? fwiw, the load from apache seems next to nothing right now, but I am also planning on adding an SMTP server for user registrations and general support email.
I'm also not super familiar with dual-core and dual processor machines. Does shifting mysql to a dual core or dual proc machine help (vs a single core/single proc machine)? since there is just one mysql daemon, does having a second core or proc. buy me anything?
I have a number of web sites on a dedicated server. Some of these web sites are a few years old. Are there any issues upgrading from MySQL 4.1 to 5.x? Are there web sites that may have compatibility issues?
View 6 Replies View Relatedwe have cpanel server and how to upgrade from mysql 5.0.45 to 5.0.77?
View 2 Replies View RelatedI am running the op Centos and also have got Cpanel installed on my VPS.
Yesterday I just upgraded MYSQL from 4 to 5 using the Cpanel script. And when I run mysql -v it says that I am running Mysql 5.
When I run phpinfo it displays that I am still running mysql 4.
I have tired rebuilding php 5 by running:-
PHP Code:
./configure --with-mysqli --with-mysql=/usr
Make
But I am keeping on getting the follow error message:-
gcc: /usr/lib/mysql/libmysqlclient.so: No such file or directory
When I check in the direct, all I have got is libmysqlclient.a, libmysqlclient.la*, libmysqlclient_r.a, libmysqlclient_r.la
So how can I check extactly what has been installed for MYSQL 5 and where it been installed and see what could be missing? Because all I did was to run it from the cpanel mysql 5 upgrade.
Do you recommend MYSQL upgrade from 4 to 5?
Note that the server Contain about 200 accounts and alot of databases
Currently I have:
Quote:
PHP 4.3.9
Âåðñèÿ MySQL 4.1.20
Shall I upgrade either MySQL or PHP to boost performance of vbulletin forum?
i wanted LXADMIN HIAB they had to install CENTOS 4.5 32bit for me
so i ended up with older versions of mysql and php.
my php wasnt even compiled with GD support
mysql: 4.1.20
php: 4.3.9
how come lxadmin is running on lighttpd while all the contents of my website shows its running on apache 2.0.52?
my VPS only has php version 4.3.9 and i would like php 5. also it only a mysql 4 and i would like mysql .
The os is CentOS 4.4
How do i upgrade it?
how to upgrade php and mysql in ssh ?
View 12 Replies View RelatedWhat is the best, easiest, painless way of upgrading from one version of MySQL to another?
Currently I have 5.0.24a and I would like to upgrade to the latest (5.0.5, I think).
I would rather do it myself than bother my host.
FYI, if this might help:
MySQL version:
Quote:
mysql Ver 14.12 Distrib 5.0.24a, for redhat-linux-gnu (i686) using readline 5.0
I am running CentOS 4.4-32.
Yesterday I went to run an upgrade on MySQL from 3.23 to 4.1.
The upgrade went fine, but after that was completed, I could no longer access Plesk.
After a lot of hassle I finally went to reinstall Plesk, well during that somewhere down the line everything crumbled horribly.
I can no longer access any of my sites on 80, httpd fails to start.
When I type
Quote:
/etc/init.d/httpd start
I get
Code:
[rtusrgd@nuinspiration rtusrgd]$ sudo su
[root@nuinspiration rtusrgd]# /etc/init.d/httpd start
Starting httpd: (98)Address already in use: make_sock: could not bind to address [::]:80
no listening sockets available, shutting down
Unable to open logs
[FAILED]
[root@nuinspiration rtusrgd]#
And when I try to run
Quote:
/etc/init.d/pssa start
I get
Code:
[root@nuinspiration /]# /etc/init.d/psa restart
PSA is down, performing full restart.
Starting psa-spamassassin service: [ OK ]
websrvmng: Service /etc/init.d/httpd failed to start
websrvmng: Service /etc/init.d/httpd failed to start
/usr/local/psa/admin/bin/httpsdctl start: httpd started
Starting Plesk: [ OK ]
Starting up drwebd: Dr.Web (R) daemon for Linux/Plesk Edition v4.33 (4.33.0.09211)
Copyright (c) Igor Daniloff, 1992-2005
Doctor Web, Ltd., Moscow, Russia
Support service: [url]
To purchase: [url]
Daemon version: 4.33.0 <API:2.1>
Engine version: 4.33 <API:2.1>
Loading /var/drweb/bases/drwtoday.vdb - Ok, virus records: 1105
Loading /var/drweb/bases/drw43371.vdb - Ok, virus records: 2370
Loading /var/drweb/bases/drw43370.vdb - Ok, virus records: 2022
Loading /var/drweb/bases/drw43369.vdb - Ok, virus records: 687
Loading /var/drweb/bases/drw43368.vdb - Ok, virus records: 1099
Loading /var/drweb/bases/drw43367.vdb - Ok, virus records: 1834
Loading /var/drweb/bases/drw43366.vdb - Ok, virus records: 4015
Loading /var/drweb/bases/drw43365.vdb - Ok, virus records: 1342
Loading /var/drweb/bases/drw43364.vdb - Ok, virus records: 1335
Loading /var/drweb/bases/drw43363.vdb - Ok, virus records: 1152
Loading /var/drweb/bases/drw43362.vdb - Ok, virus records: 1006
Loading /var/drweb/bases/drw43361.vdb - Ok, virus records: 878
Loading /var/drweb/bases/drw43360.vdb - Ok, virus records: 988
Loading /var/drweb/bases/drw43359.vdb - Ok, virus records: 1205
Loading /var/drweb/bases/drw43358.vdb - Ok, virus records: 1139
Loading /var/drweb/bases/drw43357.vdb - Ok, virus records: 1302
Loading /var/drweb/bases/drw43356.vdb - Ok, virus records: 1332
Loading /var/drweb/bases/drw43355.vdb - Ok, virus records: 2456
Loading /var/drweb/bases/drw43354.vdb - Ok, virus records: 1283
Loading /var/drweb/bases/drw43353.vdb - Ok, virus records: 795
Loading /var/drweb/bases/drw43352.vdb - Ok, virus records: 2016
Loading /var/drweb/bases/drw43351.vdb - Ok, virus records: 941
Loading /var/drweb/bases/drw43350.vdb - Ok, virus records: 1020
Loading /var/drweb/bases/drw43349.vdb - Ok, virus records: 1008
Loading /var/drweb/bases/drw43348.vdb - Ok, virus records: 1096
Loading /var/drweb/bases/drw43347.vdb - Ok, virus records: 707
Loading /var/drweb/bases/drw43346.vdb - Ok, virus records: 1428
Loading /var/drweb/bases/drw43345.vdb - Ok, virus records: 1358
Loading /var/drweb/bases/drw43344.vdb - Ok, virus records: 694
Loading /var/drweb/bases/drw43343.vdb - Ok, virus records: 1186
Loading /var/drweb/bases/drw43342.vdb - Ok, virus records: 744
Loading /var/drweb/bases/drw43341.vdb - Ok, virus records: 841
Loading /var/drweb/bases/drw43340.vdb - Ok, virus records: 822
Loading /var/drweb/bases/drw43339.vdb - Ok, virus records: 1071
Loading /var/drweb/bases/drw43338.vdb - Ok, virus records: 989
Loading /var/drweb/bases/drw43337.vdb - Ok, virus records: 855
Loading /var/drweb/bases/drw43336.vdb - Ok, virus records: 1297
Loading /var/drweb/bases/drw43335.vdb - Ok, virus records: 1195
Loading /var/drweb/bases/drw43334.vdb - Ok, virus records: 900
Loading /var/drweb/bases/drw43333.vdb - Ok, virus records: 1381
Loading /var/drweb/bases/drw43332.vdb - Ok, virus records: 1340
Loading /var/drweb/bases/drw43331.vdb - Ok, virus records: 2735
Loading /var/drweb/bases/drw43330.vdb - Ok, virus records: 2078
Loading /var/drweb/bases/drw43329.vdb - Ok, virus records: 2490
Loading /var/drweb/bases/drw43328.vdb - Ok, virus records: 743
Loading /var/drweb/bases/drw43327.vdb - Ok, virus records: 958
Loading /var/drweb/bases/drw43326.vdb - Ok, virus records: 793
Loading /var/drweb/bases/drw43325.vdb - Ok, virus records: 713
Loading /var/drweb/bases/drw43324.vdb - Ok, virus records: 655
Loading /var/drweb/bases/drw43323.vdb - Ok, virus records: 655
Loading /var/drweb/bases/drw43322.vdb - Ok, virus records: 778
Loading /var/drweb/bases/drw43321.vdb - Ok, virus records: 846
Loading /var/drweb/bases/drw43320.vdb - Ok, virus records: 808
Loading /var/drweb/bases/drw43319.vdb - Ok, virus records: 764
Loading /var/drweb/bases/drw43318.vdb - Ok, virus records: 838
Loading /var/drweb/bases/drw43317.vdb - Ok, virus records: 363
Loading /var/drweb/bases/drw43316.vdb - Ok, virus records: 730
Loading /var/drweb/bases/drw43315.vdb - Ok, virus records: 627
Loading /var/drweb/bases/drw43314.vdb - Ok, virus records: 824
Loading /var/drweb/bases/drw43313.vdb - Ok, virus records: 842
Loading /var/drweb/bases/drw43312.vdb - Ok, virus records: 830
Loading /var/drweb/bases/drw43311.vdb - Ok, virus records: 862
Loading /var/drweb/bases/drw43310.vdb - Ok, virus records: 853
Loading /var/drweb/bases/drw43309.vdb - Ok, virus records: 733
Loading /var/drweb/bases/drw43308.vdb - Ok, virus records: 708
Loading /var/drweb/bases/drw43307.vdb - Ok, virus records: 839
Loading /var/drweb/bases/drw43306.vdb - Ok, virus records: 930
Loading /var/drweb/bases/drw43305.vdb - Ok, virus records: 759
Loading /var/drweb/bases/drw43304.vdb - Ok, virus records: 721
Loading /var/drweb/bases/drw43303.vdb - Ok, virus records: 638
Loading /var/drweb/bases/drw43302.vdb - Ok, virus records: 806
Loading /var/drweb/bases/drw43301.vdb - Ok, virus records: 504
Loading /var/drweb/bases/drw43300.vdb - Ok, virus records: 24
Loading /var/drweb/bases/drwebase.vdb - Ok, virus records: 78674
Loading /var/drweb/bases/dwrtoday.vdb - Ok, virus records: 405
Loading /var/drweb/bases/dwr43301.vdb - Ok, virus records: 697
Loading /var/drweb/bases/drwrisky.vdb - Ok, virus records: 1271
Loading /var/drweb/bases/dwntoday.vdb - Ok, virus records: 582
Loading /var/drweb/bases/dwn43306.vdb - Ok, virus records: 781
Loading /var/drweb/bases/dwn43305.vdb - Ok, virus records: 752
Loading /var/drweb/bases/dwn43304.vdb - Ok, virus records: 793
Loading /var/drweb/bases/dwn43303.vdb - Ok, virus records: 766
Loading /var/drweb/bases/dwn43302.vdb - Ok, virus records: 850
Loading /var/drweb/bases/dwn43301.vdb - Ok, virus records: 772
Loading /var/drweb/bases/drwnasty.vdb - Ok, virus records: 4867
Total virus records: 171891
Key file: /opt/drweb/drweb32.key - Key file not found!
A path to a valid license key file does not specified.
Plesk authorization failed: HTTP request error [7]
Error: Plesk Software not running.
[FAILED]
[root@nuinspiration /]#
I can still access my sites via ftp, just not via web browsing.
GoDaddy is my server host and after speaking to them, the only advice they were able to give me, was that the only solution they see is to format the drive and start from fresh. The only issue is I have about 93 sites on the server itself and not all have hard backups.
Is there any utility from which we can migrate Older mysql dbs into a Latest version?
View 4 Replies View RelatedI went to run an upgrade on MySQL from 3.23 to 4.1.
The upgrade went fine, but after that was completed, I could no longer access Plesk.
After a lot of hassle I finally went to reinstall Plesk, well during that somewhere down the line everything crumbled horribly.
I can no longer access any of my sites on 80, httpd fails to start.
When I type
Quote:
/etc/init.d/httpd start
I get
Code:
[rtusrgd@nuinspiration rtusrgd]$ sudo su
[root@nuinspiration rtusrgd]# /etc/init.d/httpd start
Starting httpd: (98)Address already in use: make_sock: could not bind to address [::]:80
no listening sockets available, shutting down
Unable to open logs
[FAILED]
[root@nuinspiration rtusrgd]#
And when I try to run
Quote:
/etc/init.d/pssa start
I get
Code:
[root@nuinspiration /]# /etc/init.d/psa restart
PSA is down, performing full restart.
Starting psa-spamassassin service: [ OK ]
websrvmng: Service /etc/init.d/httpd failed to start
websrvmng: Service /etc/init.d/httpd failed to start
/usr/local/psa/admin/bin/httpsdctl start: httpd started
Starting Plesk: [ OK ]
Starting up drwebd: Dr.Web (R) daemon for Linux/Plesk Edition v4.33 (4.33.0.09211)
Copyright (c) Igor Daniloff, 1992-2005
Doctor Web, Ltd., Moscow, Russia
Support service: http://support.drweb.com
To purchase: http://buy.drweb.com
Daemon version: 4.33.0 <API:2.1>
Engine version: 4.33 <API:2.1>
Loading /var/drweb/bases/drwtoday.vdb - Ok, virus records: 1105
Loading /var/drweb/bases/drw43371.vdb - Ok, virus records: 2370
Loading /var/drweb/bases/drw43370.vdb - Ok, virus records: 2022
Loading /var/drweb/bases/drw43369.vdb - Ok, virus records: 687
Loading /var/drweb/bases/drw43368.vdb - Ok, virus records: 1099
Loading /var/drweb/bases/drw43367.vdb - Ok, virus records: 1834
Loading /var/drweb/bases/drw43366.vdb - Ok, virus records: 4015
Loading /var/drweb/bases/drw43365.vdb - Ok, virus records: 1342
Loading /var/drweb/bases/drw43364.vdb - Ok, virus records: 1335
Loading /var/drweb/bases/drw43363.vdb - Ok, virus records: 1152
Loading /var/drweb/bases/drw43362.vdb - Ok, virus records: 1006
Loading /var/drweb/bases/drw43361.vdb - Ok, virus records: 878
Loading /var/drweb/bases/drw43360.vdb - Ok, virus records: 988
Loading /var/drweb/bases/drw43359.vdb - Ok, virus records: 1205
Loading /var/drweb/bases/drw43358.vdb - Ok, virus records: 1139
Loading /var/drweb/bases/drw43357.vdb - Ok, virus records: 1302
Loading /var/drweb/bases/drw43356.vdb - Ok, virus records: 1332
Loading /var/drweb/bases/drw43355.vdb - Ok, virus records: 2456
Loading /var/drweb/bases/drw43354.vdb - Ok, virus records: 1283
Loading /var/drweb/bases/drw43353.vdb - Ok, virus records: 795
Loading /var/drweb/bases/drw43352.vdb - Ok, virus records: 2016
Loading /var/drweb/bases/drw43351.vdb - Ok, virus records: 941
Loading /var/drweb/bases/drw43350.vdb - Ok, virus records: 1020
Loading /var/drweb/bases/drw43349.vdb - Ok, virus records: 1008
Loading /var/drweb/bases/drw43348.vdb - Ok, virus records: 1096
Loading /var/drweb/bases/drw43347.vdb - Ok, virus records: 707
Loading /var/drweb/bases/drw43346.vdb - Ok, virus records: 1428
Loading /var/drweb/bases/drw43345.vdb - Ok, virus records: 1358
Loading /var/drweb/bases/drw43344.vdb - Ok, virus records: 694
Loading /var/drweb/bases/drw43343.vdb - Ok, virus records: 1186
Loading /var/drweb/bases/drw43342.vdb - Ok, virus records: 744
Loading /var/drweb/bases/drw43341.vdb - Ok, virus records: 841
Loading /var/drweb/bases/drw43340.vdb - Ok, virus records: 822
Loading /var/drweb/bases/drw43339.vdb - Ok, virus records: 1071
Loading /var/drweb/bases/drw43338.vdb - Ok, virus records: 989
Loading /var/drweb/bases/drw43337.vdb - Ok, virus records: 855
Loading /var/drweb/bases/drw43336.vdb - Ok, virus records: 1297
Loading /var/drweb/bases/drw43335.vdb - Ok, virus records: 1195
Loading /var/drweb/bases/drw43334.vdb - Ok, virus records: 900
Loading /var/drweb/bases/drw43333.vdb - Ok, virus records: 1381
Loading /var/drweb/bases/drw43332.vdb - Ok, virus records: 1340
Loading /var/drweb/bases/drw43331.vdb - Ok, virus records: 2735
Loading /var/drweb/bases/drw43330.vdb - Ok, virus records: 2078
Loading /var/drweb/bases/drw43329.vdb - Ok, virus records: 2490
Loading /var/drweb/bases/drw43328.vdb - Ok, virus records: 743
Loading /var/drweb/bases/drw43327.vdb - Ok, virus records: 958
Loading /var/drweb/bases/drw43326.vdb - Ok, virus records: 793
Loading /var/drweb/bases/drw43325.vdb - Ok, virus records: 713
Loading /var/drweb/bases/drw43324.vdb - Ok, virus records: 655
Loading /var/drweb/bases/drw43323.vdb - Ok, virus records: 655
Loading /var/drweb/bases/drw43322.vdb - Ok, virus records: 778
Loading /var/drweb/bases/drw43321.vdb - Ok, virus records: 846
Loading /var/drweb/bases/drw43320.vdb - Ok, virus records: 808
Loading /var/drweb/bases/drw43319.vdb - Ok, virus records: 764
Loading /var/drweb/bases/drw43318.vdb - Ok, virus records: 838
Loading /var/drweb/bases/drw43317.vdb - Ok, virus records: 363
Loading /var/drweb/bases/drw43316.vdb - Ok, virus records: 730
Loading /var/drweb/bases/drw43315.vdb - Ok, virus records: 627
Loading /var/drweb/bases/drw43314.vdb - Ok, virus records: 824
Loading /var/drweb/bases/drw43313.vdb - Ok, virus records: 842
Loading /var/drweb/bases/drw43312.vdb - Ok, virus records: 830
Loading /var/drweb/bases/drw43311.vdb - Ok, virus records: 862
Loading /var/drweb/bases/drw43310.vdb - Ok, virus records: 853
Loading /var/drweb/bases/drw43309.vdb - Ok, virus records: 733
Loading /var/drweb/bases/drw43308.vdb - Ok, virus records: 708
Loading /var/drweb/bases/drw43307.vdb - Ok, virus records: 839
Loading /var/drweb/bases/drw43306.vdb - Ok, virus records: 930
Loading /var/drweb/bases/drw43305.vdb - Ok, virus records: 759
Loading /var/drweb/bases/drw43304.vdb - Ok, virus records: 721
Loading /var/drweb/bases/drw43303.vdb - Ok, virus records: 638
Loading /var/drweb/bases/drw43302.vdb - Ok, virus records: 806
Loading /var/drweb/bases/drw43301.vdb - Ok, virus records: 504
Loading /var/drweb/bases/drw43300.vdb - Ok, virus records: 24
Loading /var/drweb/bases/drwebase.vdb - Ok, virus records: 78674
Loading /var/drweb/bases/dwrtoday.vdb - Ok, virus records: 405
Loading /var/drweb/bases/dwr43301.vdb - Ok, virus records: 697
Loading /var/drweb/bases/drwrisky.vdb - Ok, virus records: 1271
Loading /var/drweb/bases/dwntoday.vdb - Ok, virus records: 582
Loading /var/drweb/bases/dwn43306.vdb - Ok, virus records: 781
Loading /var/drweb/bases/dwn43305.vdb - Ok, virus records: 752
Loading /var/drweb/bases/dwn43304.vdb - Ok, virus records: 793
Loading /var/drweb/bases/dwn43303.vdb - Ok, virus records: 766
Loading /var/drweb/bases/dwn43302.vdb - Ok, virus records: 850
Loading /var/drweb/bases/dwn43301.vdb - Ok, virus records: 772
Loading /var/drweb/bases/drwnasty.vdb - Ok, virus records: 4867
Total virus records: 171891
Key file: /opt/drweb/drweb32.key - Key file not found!
A path to a valid license key file does not specified.
Plesk authorization failed: HTTP request error [7]
Error: Plesk Software not running.
[FAILED]
[root@nuinspiration /]#
I can still access my sites via ftp, just not via web browsing.
GoDaddy is my server host and after speaking to them, the only advice they were able to give me, was that the only solution they see is to format the drive and start from fresh. The only issue is I have about 93 sites on the server itself and not all have hard backups.
I am planning on upgrading to php 5. I really don't need to upgrade to mysql 5 but do you guys think I will face problems with PHP 5.2.9 and Mysql 4.1.20 working together...
I am planning on doing the upgrade like this (if I decide to upgrade PHP and MYSQL all together)
1. STEP
nano /etc/yum.repos.d/CentOS-Base.repo
2. STEP
change the enabled=0 to 1 as follows
[centosplus]
name=CentOS-$releasever - Plus
mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=centosplus
#baseurl=http://mirror.centos.org/centos/$releasever/centosplus/$basearch/
gpgcheck=1
enabled=1
gpgkey=http://mirror.centos.org/centos/RPM-GPG-KEY-centos4
priority=2
protect=1
4.STEP
yum install php-xml
5.STEP
yum update httpd* php* mysql*
and restart the server do you guys think I will face any problems.
If I am only upgrading the php to latest I am planning on doing
1.STEP
I will do the 2.STEP above
2.STEP
wget -q -O - http://www.atomicorp.com/installers/atomic.sh |sh
yum install php-xml php-pdo
yum install php-pear
mv /etc/php.ini.rpmnew /etc/php.ini
and reboot
I am planning on upgrading to php 5. I really don't need to upgrade to mysql 5 but do you guys think I will face problems with PHP 5.2.9 and Mysql 4.1.20 working together...
I am planning on doing the upgrade like this (if I decide to upgrade PHP and MYSQL all together)
1. STEP
nano /etc/yum.repos.d/CentOS-Base.repo
2. STEP
change the enabled=0 to 1 as follows
[centosplus]
name=CentOS-$releasever - Plus
mirrorlist=[url]
release=$releasever&arch=$basearch&repo=centosplus
#baseurl=[url]
gpgcheck=1
enabled=1
gpgkey=[url]
priority=2
protect=1
4.STEP
yum install php-xml
5.STEP
yum update httpd* php* mysql*
and restart the server do you guys think I will face any problems.
If I am only upgrading the php to latest I am planning on doing
1.STEP
I will do the 2.STEP above
2.STEP
wget -q -O - [url]
yum install php-xml php-pdo
yum install php-pear
mv /etc/php.ini.rpmnew /etc/php.ini
and reboot
it was very fast until mysql upgraded to 5.0.45 it was 4.. i can’t even turn my forum if it is a busy time cos it is so slow i get page not found after a while but when it is quiet it is not too bad... but it was alot more faster with mysql 4 i don't really want to downgrade please give me some ideas to fix this issue ...........
View 3 Replies View RelatedHow to upgrade mySQL from version 5.1 to version 5.5 on linux. We're running CentOS version 6.3 with Plesk 11.09.
The approach outlined here [URL] .... seems like the way to go. I want to be sure that I don't adversely affect our installation.
If it is at all relevant we're running a Joomla 2.5 site.
In order to install moodle, I need to upgrade MySQL from 5.1 to 5.5. I have gone through one of the KB articles [URL], but it's not very clear.
Can I upgrade it through Add/remove Components from Install and update products just like it can be done for PHP?? I see MySQL Server 2005, 2008 and 2012,
We have a dedicated server and we host 4 news portals based on e107 and joomla.
My partner on Sunday has upgraded mysql from version 4 to 5. Now the server experiences very high CPU usage and query time on portals has been increased very much.
We used to have query times lower than 1 sec for the main page of [url](which is a site that receives about 2000 visits/day) and now query times are 5-15sec !
Does anybody know if this is makes sense ?
Below is the server Status from WHM :
-------------------------------------
cpdavd up
cpsrvd up
exim (exim-4.69-15.1_cpanel_maildir) up
ftpd up
httpd (2.2.11 (Unix)) up
imap up
interval up
mysql (5.0.67-community-log) up
named (9.3.4) up
pop up
rsyslogd up
spamd up
syslogd up
Server Load 6.97 (1 cpu)
Memory Used 49.4 %
Swap Used 0.23 %
Disk /dev/hda3 (/tmp) DMA+ 70 %
Disk /dev/hda5 (/) DMA+ 22 %
Disk /dev/hda1 (/boot) DMA+ 14 %
Below is the Server Information from WHM :
------------------------------------------
Processor #1 Vendor: GenuineIntel
Processor #1 Name: Intel(R) Core(TM)2 Duo CPU E4600 @ 2.40GHz
Processor #1 speed: 2394.068 MHz
Processor #1 cache size: 2048 KB
Memory Information
Memory: 2064420k/2087424k available (2091k kernel code, 21752k reserved, 846k data, 236k init, 1169920k highmem)
System Information
Linux server.aktoweb.biz 2.6.20-1.2319.fc5 #1 Mon May 21 19:52:13 EDT 2007 i686 i686 i386 GNU/Linux
Physical Disks
hda: WDC WD3200AAJB-00TYA0, ATA DISK drive
hda: hw_config=600d
hda: hw_config=600d
hda: max request size: 512KiB
hda: 625142448 sectors (320072 MB) w/8192KiB Cache, CHS=38913/255/63<6>hda: hw_config=600d
hda: cache flushes supported
Current Memory Usage
total used free shared buffers cached
Mem: 2066428 1756324 310104 0 339576 486636
-/+ buffers/cache: 930112 1136316
Swap: 1052248 2428 1049820
Total: 3118676 1758752 1359924
Current Disk Usage
Filesystem Size Used Avail Use% Mounted on
/dev/hda5 288G 60G 213G 22% /
/dev/hda1 99M 13M 82M 14% /boot
tmpfs 1009M 0 1009M 0% /dev/shm
/dev/hda3 494M 215M 254M 46% /tmp
Below is the CPU/Memmory/Mysql Usage from WHM :
-------------------------------------------------
mysql42.707.300.0
Top Process%CPU 42.7/usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/server.aktoweb.biz.pid --skip-external-locking
Top Process%CPU 42.6/usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/server.aktoweb.biz.pid --skip-external-locking
giaprakigiapraki.com2.7012.111.7
Top Process%CPU 1.3httpd [urll] [/e107_plugins/pm/pm.php?inbox]
Top Process%CPU 1.1httpd [url] [/e107_plugins/forum/forum_viewforum.php?87]
Top Process%CPU 1.0httpd [url] [/e107_plugins/chatbox_menu/chatbox_iframe.php]
adsnetadsnet.gr1.177.900.7
Top Process%CPU 0.5httpd [adsnet.gr] [/www/delivery/lg.php?bannerid16&campaignid4&zoneid5&chan]
Top Process%CPU 0.4httpd [adsnet.gr] [/www/delivery/lg.php?bannerid50&campaignid6&zoneid15&cha]
Top Process%CPU 0.3httpd [adsnet.gr] [/www/delivery/lg.php?bannerid183&campaignid77&zoneid1&ch]
r40r40.gr1.073.340.0
Top Process%CPU 1.1httpd [r40.gr] [/index.php?optioncom_fireboard&Itemid188&funcshowcat&cat]
Top Process%CPU 0.5httpd [r40.gr] [/images/fbfiles/avatars/s_64.png]
Top Process%CPU 0.3httpd [r40.gr] [/index2.php?optioncom_jim&taskxml&no_html1]
root0.278.532.0
Top Process%CPU 0.2[kjournald]
alex123alexandroupoli.net0.030.270.0
Top Process%CPU 0.1httpd [alexandroupoli.net] [/e107_images/banners/banner468x60-alexandroupolinet.gif]
galfasgalfas.gr0.030.270.0
Top Process%CPU 0.1httpd [galfas.gr] [/racing/images/galfas_R40_banner.jpg]
eximstats0.000.000.3
nobody0.001.100.0
mailnull0.000.000.0
unauthenticated0.000.000.0
named0.000.10
we've currently got a 2 server setup, apache+mysql
Mysql server is a Xeon 3.2Ghz with 2Gb ram, scsi 73gb raid1 disks
Server has been running a while, steadily increasing in traffic. whilst 90% of the time it's running ok (load around 0.5 - 1.0, cpu around 25-50% busy mainly mysql, disk i/o around 3% busy) during heavy traffic times everything slows right down
At the moment the mysql box is only running mysql so we've allocated about 1.5gb out of the 2gb to mysql.
At present, when we get busy the apache server is queing up requests as it waits for the mysql server. Query log shows most queries are <1sec, any other's are being optimised but due to the nature of our website there are a few pesky queries (only occasionally being slow though).
question is, can this config be tuned any more or is it time for an upgrade - mainly ram to add more innodb buffers?
Here's the result of tuning-primer.sh
Code:
SLOW QUERIES
The slow query log is enabled.
Current long_query_time = 2 sec.
You have 9 out of 159346 that take longer than 2 sec. to complete
Your long_query_time seems to be fine
BINARY UPDATE LOG
The binary update log is enabled
The expire_logs_days is not set.
The mysqld will retain the entire binary log until RESET MASTER or PURGE MASTER LOGS commands are run manually
Setting expire_log_days will allow you to remove old binary logs automatically
See http://dev.mysql.com/doc/refman/4.1/en/purge-master-logs.html
WORKER THREADS
Current thread_cache_size = 384
Current threads_cached = 15
Current threads_per_sec = 0
Historic threads_per_sec = 0
Your thread_cache_size is fine
MAX CONNECTIONS
Current max_connections = 150
Current threads_connected = 4
Historic max_used_connections = 18
The number of used connections is 12% of the configured maximum.
Your max_connections variable seems to be fine.
MEMORY USAGE
Max Memory Ever Allocated : 1 G
Configured Max Per-thread Buffers : 5 G
Configured Max Global Buffers : 803 M
Configured Max Memory Limit : 6 G
Physical Memory : 1.99 G
Max memory limit exceeds 90% of physical memory
KEY BUFFER
Current MyISAM index space = 82 K
Current key_buffer_size = 5 M
Key cache miss rate is 1 : 1862
Key buffer fill ratio = 100.00 %
Your key_buffer_size seems to be fine
QUERY CACHE
Query cache is supported but not enabled
Perhaps you should set the query_cache_size
SORT OPERATIONS
Current sort_buffer_size = 16 M
Current read_rnd_buffer_size = 7 M
Sort buffer seems to be fine
JOINS
Current join_buffer_size = 4.00 M
You have had 0 queries where a join could not use an index properly
Your joins seem to be using indexes properly
join_buffer_size >= 4 M
This is not advised
OPEN FILES LIMIT
Current open_files_limit = 11095 files
The open_files_limit should typically be set to at least 2x-3x
that of table_cache if you have heavy MyISAM usage.
Your open_files_limit value seems to be fine
TABLE CACHE
Current table_cache value = 5467 tables
You have a total of 732 tables
You have 155 open tables.
The table_cache value seems to be fine
TEMP TABLES
Current max_heap_table_size = 255 M
Current tmp_table_size = 256 M
Of 21109 temp tables, 35% were created on disk
Effective in-memory tmp_table_size is limited to max_heap_table_size.
Perhaps you should increase your tmp_table_size and/or max_heap_table_size
to reduce the number of disk-based temporary tables
Note! BLOB and TEXT columns are not allow in memory tables.
If you are using these columns raising these values might not impact your
ratio of on disk temp tables.
TABLE SCANS
Current read_buffer_size = 7 M
Current table scan ratio = 929 : 1
read_buffer_size seems to be fine
TABLE LOCKING
Current Lock Wait ratio = 1 : 117
You may benefit from selective use of InnoDB.
If you have long running SELECT's against MyISAM tables and perform
frequent updates consider setting 'low_priority_updates=1'
Server is mainly Innodb due to previous row-locking issues.
Plesk has mysql installed with it to run properly and I need to upgrade that version to the latest. Now I am not talking about the mysql server that it provides for me to create databases on. I am talking about the version it uses to run.
View 3 Replies View RelatedI'm still using Plesk 11.5.30 and MySql 5.5.39. That was discribed here how to update. But i need to have a MySql 5.6.5 (minimum) for some software (This version is over 2 years old). I'm using CentOs 6.5. and PHP 5.4.33
how to do this, whitout breaking plesk 11.5.30??
I see that Plesk 12 supports MySQL 5.6, but the server I am running is Ububtu 14.04 LTS and comes with 5.5.
I need to make 5.6 available but I can see no way of doing it without breaking Plesk (I already tried just installing it from command line with apt-get install and had to restore the whole server from backup!) - there is no option for MYSQL in Plesks updates & upgrades menu ...