MySQL Restart On CentOS - Chown
Sep 18, 2007
I have a lot of tables, being that I host multi forums. One thing I noticed when doing a mysql start up or restart is that it takes at least 15 minutes to do it. The server isn't bad, it's a Pentium D with 3GB of RAM and it runs perfectly fine. What I noticed is that after I do an SQL restart, I checked "top." The command that was running is "chown" and it sat at the top of the list, and kept going. Until finally mysql started and it stopped.
I imagine that all of the files in the data folder are being CHOWNed... and that's why it takes forever. If this is the case, how can I stop this, if at all? I don't see why they need to be CHOWNed?
View 4 Replies
ADVERTISEMENT
Jun 16, 2008
For some reason mysql wont start, i have tried restarting mysql but it wont, it says FAILED. The mysql.sock file seems to have disappeared and i cannot find it anywhere.
View 5 Replies
View Related
Jun 10, 2008
Sometimes my apache gets hanged due to memory leak or persistence connection, then needs to be restarted manually, how can I make this process automatic, that is it get restarted whenever it got hanged or shutdown?
View 9 Replies
View Related
Mar 16, 2007
I'm on FreeBSD 6.2 dedicated server with root access control-panel Directadmin
Today i check that i cann't login into directadmin. at the same time ftp and ssh access are live.
try to do restart and after this mysql service is down too.
all my attempts to do restart aren't successful.
1. don't have http access to DA
2. have ftp access, but cann't overwrite files
3. have ssh access
4. mysql service is stoped
try to do mysql restart with this command
/usr/local/etc/rc.d/mysql-server.sh stop
but there isn't such file
try to connect to mysql and get such output
Warning: mysql_connect() [function.mysql-connect]: Can't connect to local
MySQL server through socket '/tmp/mysql.sock' (2) in
View 9 Replies
View Related
Mar 16, 2007
I'm on FreeBSD 6.2 dedicated server with root access
control-panel Directadmin
Today i check that i cann't login into directadmin. at the same time ftp and ssh access are live.
try to do restart and after this mysql service is down too.
all my attempts to do restart aren't successful.
1. don't have http access to DA
2. have ftp access, but cann't overwrite files
3. have ssh access
4. mysql service is stoped
try to do mysql restart with this command
/usr/local/etc/rc.d/mysql-server.sh stop
but there isn't such file
try to connect to mysql and get such output
Warning: mysql_connect() [function.mysql-connect]: Can't connect to local
MySQL server through socket '/tmp/mysql.sock' (2) in
View 1 Replies
View Related
Dec 5, 2008
Is anyone experiencing that cpanel automatically restarts mysql at 2AM?
I'm curious is that new feature or something has gone wrong?
This has started after cpanel upgrade mysql to 5.0.67 version.
I'm not so good with cpanel so please can somebody tell me where cpanel holds its crons?
I cannot find nothing in /etc/cron.* or in cron -l, and I want to turn this option off.
View 2 Replies
View Related
Nov 23, 2008
How to set up cron job automatic restart mysqld at specified time. My case, mysqld will auto restart every 23 hours running.
How to set up this cron job?
View 12 Replies
View Related
Apr 12, 2009
My vps is run well, then i reboot and i see mysql no longer working. I check in WHM
mysql (5.0.67-community) failed
And when restart (by WHM )
Restarting MySQL Server
whmappname='Restarting Service'; if (self['update_ui_status']) { update_ui_status('MySQL Server'); } Waiting for mysql to restart..............finished.
mysqld_safe (/bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/server.xxxx.com.pid) running as root with PID 5275
mysql has failed, please contact the sysadmin (result was "mysql has failed").
My VPS in unmanaged, i can't access mysql.
View 4 Replies
View Related
Jun 1, 2008
One of our servers mysql daemon is restarting most of the time and got the error message in the message file. Did anyone see similar error message?
Jun 1 05:46:44 kernel: audit(1212317204.342:6991): avc: denied { read } for pid=17286 comm="mysqld" name="/" dev=loop0 ino=2 scontext=user_uystem_r:mysqld_t0 tcontext=system_ubject_r:file_t0 tclass=dir
Jun 1 05:46:44 kernel: audit(1212317204.343:6992): avc: denied { getattr } for pid=17286 comm="mysqld" path="/tmp" dev=loop0 ino=2 scontext=user_uystem_r:mysqld_t0 tcontext=system_ubject_r:file_t0 tclass=dir
Jun 1 05:46:44 kernel: audit(1212317204.346:6993): avc: denied { read } for pid=17286 comm="mysqld" name="time_zone_leap_second.frm" dev=hda2 in
View 1 Replies
View Related
Nov 22, 2007
I am not being able to restart the server, or MySQL or httpd via SSH.
PHP Code:
root@server [~]# /etc/init.d/httpd fullstatusLooking up localhostMaking HTTP connection to localhostAlert!: Unable to connect to remote host.lynx: Can't access startfile http://localhost/server-statusroot@server [~]#
PHP Code:
root@server [~]# /etc/init.d/mysql reload/etc/init.d/mysql: line 244: kill: (3375) - No such processtouch: cannot touch `/var/lib/mysql/server.lubnan.us.pid': Read-only file system
View 14 Replies
View Related
Jan 29, 2009
Anyone know a good script that I can run with cron or something? Mysql seems to be the #1 problem with a lot of my web sites, a restart usually fixes it right away for me, but I can't keep restarting my servers everyday manually.
View 1 Replies
View Related
Jun 5, 2014
What could I fix by trying to start mysql server, recieve following errors:
plesk interface:
Code:
Failed to restart the "mysql" service.
Cannot start/stop/restart service: Rather than invoking init scripts through /etc/init.d, use the service(8)
utility, e.g. service mysql restart
Since the script you are attempting to invoke has been converted to an
Upstart job, you may also use the stop(8) and then start(8) utilities,
e.g. stop mysql ; start mysql. The restart(8) utility is also available.
start: Job failed to start
from the console:
Code:
sudo service mysql start
start: Job failed to start
Code:
mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
output of plesk_11.5.30_reset_instance_data.log:
[Code] ...
View 4 Replies
View Related
Mar 1, 2007
When ever my users upload something it get automaticaly nobody ownership. ( 99 )
any way to fix it?
View 6 Replies
View Related
May 23, 2007
how to chown a file/directory from a client server through NFS connectivity?
View 6 Replies
View Related
Apr 1, 2008
I have just restored an account to my directadmin box and it appears to have restored with the wrong owner / group.
Easy I thought, a quick 'chmod secure.secure -R *' should crack that but how wrong was I.
After running that I get the error: chown: invalid option -- o
Now - both the user and the group exist, so why won't the files change owner and group?
View 6 Replies
View Related
May 22, 2007
I'm currently running SAMBA on one my linux servers, and wanting to connect to it from another linux server.
1. Do I need to install SAMBA on the connecting server (client-side)?
2. I can see/mount the SAMBA folder just fine, I can delete,make,etc. The only thing I can't do on the client side is change ownership of a file or folder... even if I'm logged in as root.
View 3 Replies
View Related
Apr 1, 2008
How do I Move Files & Sub directory without changing Chown & Chmod them?
Situation:
I need to move /home/user/public_html/blog (all files & subdir) into /home/user/public_html
View 8 Replies
View Related
Mar 13, 2007
Setting up a storage and web server.
For transferring files from the storage to the web server, i was planning on streaming it over a private gigabit network line.
FreeBSD would be the best choice in terms of network thorouput correct?
Would FreeBSD also be a good choice for the web server as well? ( web + database on 15k scsi drives )
I've been reading a few posts on google about MySQL performance on FreeBSD but am not sure how well those results are substantiated - so I'm looking for a bottom line comparison between FreeBSD and CentOS in terms of network thoroughput and MySQL performance.
View 2 Replies
View Related
May 28, 2009
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
View 4 Replies
View Related
May 28, 2009
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
View 2 Replies
View Related
Jul 11, 2009
I have a server running CentOS with PHP 5.2 and I'm trying to figure out how to enable PDO with the MySQL extension. I had thought PDO always came enabled with 5.2, but that apparently isn't so with this box. I am only familiar with Ubuntu/Debian, and am not sure how things are done on CentOs.
View 2 Replies
View Related
Aug 5, 2008
I have some server with OS: CentOS 5.x
one day, I have to replicate 2 servers together. so, I have to stop webserver and use MySQL Administrator GUI Tool to backup it. My steps follow: (i work directly on Server 2 and i wantna to use mysql administrator gui to monitor and config replication).
1. Server 2: ssh to server 1-> connect mySQL -> add any host to root access
2. Server 2: use mySQL Administrator connect to server 1 with root
3. Server 2: backup from server 1 on Desktop location
4. Server 2: Restore it use mysql administrator tool.
It works well but when i click Restore button, MySQL Administrator GUI Tool disappear!
What's problem with this tools or server 2?
View 4 Replies
View Related
Jul 8, 2007
I have one bare server and installed everything myself. however, I found apache, mysqld can not automatically start after reboot, may I know how to enable them to automatically start after reboot?
View 5 Replies
View Related
May 27, 2014
I need a command way of backing up my website files and Mysql databases. I no longer have access to the static ip to access the panel.
View 1 Replies
View Related
Oct 1, 2007
What is the difference between CentOs 5.0 and Centos 4.5? (Both contains Plesk)
Would CentOS 5 contain more updates and fixes? CentOS 4.5 be more stable?
View 0 Replies
View Related
Jul 3, 2007
I have directory shared by NFS on server1 this directory mounted at startup on server2.
problem happened when twice servers restarted and server2 started before server1. directory not mounted I must mount it manually.
View 4 Replies
View Related
Jul 19, 2007
One of my server's http daemon is restarting more often and it doesn't have any control panel. How can I checked the load or memory usage history?
View 3 Replies
View Related
May 8, 2009
Since my /var partition is full, so I moved /var/lib/mysql to /backup/mysql/.
Seems all the files are copied and I changed my.cnf reboot mysql, but all the web sites using db is not working anymore..
View 4 Replies
View Related
Aug 31, 2006
I get the following message via SSH when i try named restart
named: symbol lookup error: named: undefined symbol: dns_resolver_setudpsize
All my sites are currently down but the server is up and bind wont restart either in WHM or SSH
i am using WHM 10.6.0 cPanel 10.8.0-R8
CentOS 4.3 i686 - WHM X v3.1.0
Linux ***.server.com 2.6.9-11.EL #1 Wed Jun 8 16:59:52 CDT 2005 i686 i686 i386 GNU/Linux
I spoke to live support at nexpoint but they told me to email their dedicated server support but I havent had a reply in the last few hours.
View 5 Replies
View Related
Apr 23, 2008
I have 8 apache servers that is sharing one httpd.conf file... When changes made in the httpd.conf, you have you restart httpd... How can I restart all 8 servers at the same time instead of logging into each server and do it manually?
View 2 Replies
View Related
