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?
I 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.
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]
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 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
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)
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)
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 ...........
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
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.
I'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
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 ...
I'm trying to upgrade from MySQL 4 to MySQL 5 for performance reasons. MySQL 4 was working great so I decided to just go ahead and upgrade to MySQL 5 via CPanel. The upgrade appeared to go fine however I now get this error when trying to start MySQL.
/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! mysql has failed, please contact the sysadmin (result was "Warning, no valid mysql.sock file found.mysql has failed").
I went ahead and did a forced re-install of MySQL 5, but that didn't help. Apache has been updated as well since then, but that did no good, and the MySQL process isn't starting at all.
I'd like to upgrade my current mysql 4.1 version to mysl 5, but i can't find a good tutorial or explenation! I've been searching for hours now without any good results. I've downloaded the lastest stable mysql 5 .rpm, and tried to install it with rpm -i mysql.version.rpm, but it says the following:
# rpm -i MySQL-server-standard-5.0.27-0.rhel4.i386.rpm warning: MySQL-server-standard-5.0.27-0.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 error: Failed dependencies: MySQL conflicts with mysql-4.1.20-1.RHEL4.1.i386 MySQL-server conflicts with mysql-server-4.1.20-1.RHEL4.1.i386
I guess that means i have to uninstall mysql 4.1 first.
ok...
# rpm -e mysql-server-4.1.20-1.RHEL4.1.i386 warning: /var/log/mysqld.log saved as /var/log/mysqld.log.rpmsave
Let's try to install it now.
# rpm -i MySQL-server-standard-5.0.27-0.rhel4.i386.rpm warning: MySQL-server-standard-5.0.27-0.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 error: Failed dependencies: MySQL conflicts with mysql-4.1.20-1.RHEL4.1.i386
Ok, let's remove that.
# rpm -e mysql-4.1.20-1.RHEL4.1.i386 error: Failed dependencies: libmysqlclient.so.14 is needed by (installed) perl-DBD-MySQL-2.9004-3.1.i386 libmysqlclient.so.14 is needed by (installed) dovecot-0.99.11-4.EL4.i386 libmysqlclient.so.14 is needed by (installed) php-mysql-4.3.9-3.22.i386 libmysqlclient.so.14(libmysqlclient_14) is needed by (installed) dovecot-0.99.11-4.EL4.i386 libmysqlclient.so.14(libmysqlclient_14) is needed by (installed) php-mysql-4.3.9-3.22.i386 mysql = 4.1.20-1.RHEL4.1 is needed by (installed) mysql-devel-4.1.20-1.RHEL4.1.i386
Does upgrade work?
# rpm -Uvh MySQL-server-standard-5.0.27-0.rhel4.i386.rpm warning: MySQL-server-standard-5.0.27-0.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 error: Failed dependencies: libmysqlclient.so.14 is needed by (installed) perl-DBD-MySQL-2.9004-3.1.i386 libmysqlclient.so.14 is needed by (installed) dovecot-0.99.11-4.EL4.i386 libmysqlclient.so.14 is needed by (installed) php-mysql-4.3.9-3.22.i386 libmysqlclient.so.14(libmysqlclient_14) is needed by (installed) dovecot-0.99.11-4.EL4.i386 libmysqlclient.so.14(libmysqlclient_14) is needed by (installed) php-mysql-4.3.9-3.22.i386