Mysqld Restart
Nov 15, 2008
I just bought new DS 3 days ago : Intel Core2Duo 2.33 GHz, 2GB DDR2 RAM , 250 GB.
Today mysql automatic stop and not auto restart :|
I checked cron job: has no cron job there. I have just only one site on this server.
I check Check mysql error log:
081115 10:47:52 [Note] /usr/sbin/mysqld: Normal shutdown
081115 10:47:52 InnoDB: Starting shutdown...
081115 10:47:54 InnoDB: Shutdown completed; log sequence number 0 72782
081115 10:47:54 [Note] /usr/sbin/mysqld: Shutdown complete
081115 10:47:54 mysqld ended
081115 10:47:55 mysqld started
/usr/sbin/mysqld: File '/var/log/mysql-slow-queries.log' not found (Errcode: 13)
081115 10:47:55 [ERROR] Could not use /var/log/mysql-slow-queries.log for logging (error 13). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it.
081115 10:47:55 InnoDB: Started; log sequence number 0 72782
081115 10:47:56 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)
my.cnf file ....
View 8 Replies
ADVERTISEMENT
Dec 13, 2008
Can I delete mysqld.log
Can I delete or empty mysqld.log
Its currently 850MB
If I can do I have to stop MYSQL first;?
View 6 Replies
View Related
Apr 10, 2007
I've got a strange situation here. We have some software which we run on multiple servers. As of today the software is using 100 percent (sometimes more) of the cpus.
Here is the result from top. It's usually far worse using 100 percent of both cpu's almost all of the time. I just restarted, but the server load is climbing to 20+. Any idea how I can figure out what is going on? The same software on two other identically configured servers runs fine. This server has had no problems for over 6 months, but suddenly this started today. The server is a dual opteron with 4GB of ram. The databases are innodb thus the high memory usage for mysql (innodb buffer pool size)
top - 13:52:54 up 3:14, 2 users, load average: 3.39, 4.42, 6.86
Tasks: 121 total, 4 running, 108 sleeping, 9 stopped, 0 zombie
Cpu(s): 66.1% us, 1.7% sy, 32.2% ni, 0.0% id, 0.0% wa, 0.0% hi, 0.0% si
Mem: 4090568k total, 3077004k used, 1013564k free, 52748k buffers
Swap: 2096440k total, 56k used, 2096384k free, 1796632k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
11871 mysql 15 0 2581m 1.0g 3844 S 96 26.2 13:05.73 mysqld
7569 root 39 19 8048 2024 1304 R 65 0.0 32:27.49 http
11984 apache 15 0 152m 14m 5860 S 12 0.4 0:24.27 httpd
11990 apache 15 0 152m 17m 8376 S 9 0.4 0:14.31 httpd
12002 apache 16 0 153m 15m 5408 R 6 0.4 0:08.60 httpd
12040 apache 15 0 152m 17m 8524 S 5 0.4 0:03.86 httpd
11966 apache 15 0 153m 17m 8280 S 3 0.4 0:22.99 httpd
View 14 Replies
View Related
Apr 28, 2009
I'm setting a local server on my network. Leopard 10.5.6
I went to mysql.com and installed the intel 32-bit version of mysql (package).
After install, i try to run mysqladmin command, but it returns command not found.
I search the location using
which mysql
nothing returns.
I find the install here:
/usr/local/mysql-5.1.34-osx10.5-x86/bin
even when i check the file and its there, running the command returns
mysqladmin: command not found
View 1 Replies
View Related
Aug 23, 2007
My server was having a high load so I stop httpd and mysqld. I tried to restart both service but only httpd is starting and mysqld failed. It keeps timing out.
service mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]
It was working and I only trying to restart it.
The load on my server now is 0 because the website is down.
View 8 Replies
View Related
Nov 6, 2009
we have set logrotate for rotate mysqld.log daily
file is compress, deleted and created from logrotate but mysql not write anything
Any idea about why?
View 1 Replies
View Related
Apr 19, 2007
How can we start mysqld with --skip-name-resolve? Syntax Or Command?
View 7 Replies
View Related
May 15, 2007
I have 3 questions.
1.) I have a user that's kinda knows a lot about linux. More than me. He has a lot of stuff on the system which I have no idea what it is. Is there any way I can install a SSH log, so I can monitor what he does in shell?
2.) My server seems REALLY sluggish. I ran a top in shell, and mysqld was taking up from 70% to 110% of the cpu. Is there any way to fix this or find out why? I've restarted the server, and it's fluctuating between 50% and 90% now.
3.) I think this MIGHT be related to the sqld issue, but I've received about 12 emails saying
Quote:
"[statscheck] Stats/Server Overload on my server". "MPORTANT: Do not ignore this email.
This is cPanel stats runner on server1.cewxp.com!
While processing the log files for user cewxp, the cpu has been
maxed out for more than a 6 hour period. The current load/uptime line on the server at the time of this email is 15:49:16 up 5 days, 10:52, 2 users, load average: 27.59, 31.36, 31.83"
and also another email
Quote:
IMPORTANT: Do not ignore this email.
This is cPanel stats runner on server1.cewxp.com!
While processing the log files for user vegapunk, the cpu has been maxed out for more than a 6 hour period. The current load/uptime line on the server at the time of this email is 12:34:26 up 5 days, 7:37, 2 users, load average: 19.90, 17.59, 17.97
View 3 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
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
Oct 13, 2009
i am having an issue with my vps recently my ftp is down and i cant restart my ftp not sure how i can get this fix.
View 8 Replies
View Related
May 28, 2009
how to restart lighthttpd?
I was asked to restart lighthttpd at my friend host, he has 6 sites running, and of the site is down, host has asked him to restart the server, as he is away, he wanted me to restart, but I have no clue how to restart lighthttpd,
It will be really helpful if u can guide me for : if possible for the domain alone, else for the entire server
current options available :
lxadmin - hypervm
ssh connection
let me know the steps and code if any.
View 4 Replies
View Related
Jul 17, 2009
We are unable to restart apache on our server, as a result no sites are accessible in the browser. Our host states we need to clear out the following files:
[root@server1 logs]# ls -lAh|grep -v ' 0 '
total 1.9G
-rw-r--r-- 1 root root 92M Jul 17 07:55 access_log
-rw-r----- 1 root root 463K Dec 9 2007 audit_log
-rw-r--r-- 1 root root 1.2G Jul 17 07:57 error_log
-rw-r--r-- 1 root root 6 Jul 17 07:42 httpd.pid
-rw-r--r-- 1 root root 92K Feb 18 2008 ssl_engine_log
-rw-r--r-- 1 root root 535M Jul 17 07:46 suexec_log
-rw-r--r-- 1 root root 10 Jul 17 03:21 suexec_log.offset
-rw------- 1 root nobody 5.6M Dec 10 2007 suphp_log
Is it ok to simply delete these files? If so, will they recreate
themselves?
View 14 Replies
View Related
May 23, 2008
after restarting my server i tried to start my shoutcast servers whicj right now its not working...i am getting an error when i am trying to start them again "error opening source socket! FATAL ERROR! Some other process is using this port!"
View 2 Replies
View Related
Mar 14, 2008
I have a few domains in a DA server whose stats stop working for a few months, any idea how to restart these few domains Webalizer? The rest of the domains' stats are working properly though
View 3 Replies
View Related
Jan 22, 2008
when my clients log in into the webmail... they cant access Horde.. it just dont load.. if you go for squirrelmail it loads perfectly..
how can i restart horde from ssh(putty)?
View 8 Replies
View Related
Sep 12, 2007
[root@server1 /]# ps -aux |grep httpd
Warning: bad syntax, perhaps a bogus '-'? See /usr/share/doc/procps-3.2.3/FAQ
apache 26023 0.5 0.9 12064 8744 ? S 05:28 0:04 /usr/sbin/lighttpd -f /etc/lighttpd/lighttpd.conf
root 32333 0.7 2.5 24456 22772 ? S 05:39 0:00 /usr/local/cpanel/whostmgr/bin/whostmgr ./reshttpd
root 32384 0.0 0.0 2152 524 pts/1 S+ 05:39 0:00 grep httpd
i want removed "lighttpd"
how may?
i don`t want killed it
View 0 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
Jul 1, 2007
I have configured the iptables ruleset to fit my taste, however after I did a reboot, my server still loaded the old one, any steps did I missed ?
What i did was :
1. edit rules
2. iptables-save > firewall.log
3. service iptables save
4. reboot
View 2 Replies
View Related
May 6, 2007
I'm running Apache 2.0.52 on a CentOS 4.4 server.
Running two static sites and one CMS.
I have no trouble logging in through SSH
Also no problem accessing webmin on port 10000
I've tried to restart Apache httpd
And tried to reboot the server...
Nothing.
I recently did a Yum Update,
also removed ISPconfig - it's probably the latter thats the problem, although I haven't used it - at all - just playing around setting up PHPmyadmin, Squirrelmail and a couple of email accounts.
But the only error log output I get is that there are no virtual servers for 88.198.81.186:80 and 88.198.81.187:80 and Unable to open logs | unable to start piped log program
Since the update and removal of ISPconfig 4-5 days ago there hasn't been any issues. I haven't done anything. Yet I do think might be some of the old ISPconfig settings acting up.
View 4 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 18, 2007
I'm on my first VPS with Virtuozzo / WHM and I'm wondering about what some general guidelines regarding best practices are in regards to restarting services and or the server. Specifically, I'm wondering what a good time frame it to restart the server and sevices.
I've been told VZ doesn't need to be restarted, but I figured that by restarting VZ, I restart everything at once... is this bad? How often should I do this or not do this?
Alternatively, if I just restart specific services, what is your experience on a good timeline and what services are important to restart?
I've read that mysql doesn't need to be restarted, but am wondering EXIM, http server, dns server, pop3 server, imap server, etc.... specifically what good schedule would be regarding restarting.
I'm simply trying to avoid issues that may occur due to not restarting and trying to be proactive as my clients are extremely important to me... ...
View 3 Replies
View Related
Sep 30, 2007
I'm having problems with Apache 2.0.54 on my Debian server. The command "apache2ctl restart" will not work properly. Let me explain. Whenever I run "apache2ctl restart" Apache will tell me it's running with no problems while it actually isn't. I run "apache2ctl start" and it tells me that httpd is already running according to a PID.
When I need to restart Apache I need to go and run "apache2ctl stop" and "apache2ctl start" which seems to work effectively. I tried recoding the system to run these two commands in the Perl backend of my web hosting control panel, but these two commands don't work since they seem to run at the same time.
So my question is this: how can I get the "apache2ctl restart" command to work again? Or better yet, how do I get Perl to run the "apache2ctl stop" and "apache2ctl start" commands without having them being run simultaneously?
View 14 Replies
View Related
Mar 11, 2007
maildir is enabled
1) Restore system to mbox (non-maildir) state.
2) Request Technical Support
3) Convert partially converted mail accounts
*) Exit
Enter Selection---] 3
quotaoff: quotactl on /dev/sda3 [/]: No such process
[1]+ Stopped /scripts/convert2maildir
root@server [~]#
The above just freezes and does nothing, had to manually stop after 5 minutes.
Restarting pop3 via whm gives this error:
cppop has failed, please contact the sysadmin.
Restart imap gives this:
imap has failed, please contact the sysadmin (result was "couriertcpd is not runningauthdaemond is not running").
I ran:
/scripts/courierup --force
/scripts/eximup --force
Did nothing, still cannot restart pop3/imapd
root@server [~]# /scripts/restartsrv_cppop
/etc/init.d/courier-imap: line 19: /usr/lib/courier-imap/etc/imapd: No such file or directory
/etc/authlib/authdaemonrc does not exist, forgot make install-configure?
root@server [~]# /scripts/restartsrv_imap
/etc/init.d/courier-imap: line 19: /usr/lib/courier-imap/etc/imapd: No such file or directory
/etc/authlib/authdaemonrc does not exist, forgot make install-configure?
I changed maildir=1 to 0 in cpanel.config file and ran convert2maildir again,
I got at the very end when it halted:
Unable to install courier. at /usr/local/cpanel/bin/maildirupdate line 51.
I tried to restart exim:
root@server [~]# /scripts/restartsrv_exim
Starting clamd: [ OK ]
Starting exim: 2007-03-11 10:25:37 Exim configuration error in line 670 of /etc/exim.conf:
option "maildir_format" unknown
[FAILED]
Starting exim-smtps: 2007-03-11 10:25:37 Exim configuration error in line 670 of /etc/exim.conf:
option "maildir_format" unknown
[FAILED]
Starting antirelayd: [ OK ]
Starting antirelayd: [ OK ]
View 1 Replies
View Related
Jun 3, 2008
We changed our SSH port (for the slight added security that this offers) and updated our CSF config with the new port so that we can accept connections on this port.
We restarted CSF and we could connect successfully on the new port. When the server is rebooted connections are refused on the port until we *RESTART* CSF then it's all good again.
I would think being that we opened the port in CSF's config that on reboot the port would be opened back up but this is not happening and any time the server is rebooted we have to restart the firewall.
Does anybody have any suggestions on how to "fix" this or at least make it so we don't have to manually restart the firewall?
View 6 Replies
View Related
Feb 7, 2006
When you set up a new domain you have to write a new virtual host to httpd.conf... then you have to restart the Apache... Is their a way to do this without the restart. Surely a big ISP doesn't restart Apache every time a new domain is added.
View 9 Replies
View Related
Apr 30, 2009
i had just wake up and see my vps server witch work under centOS 5.2 wont up my domains ... just i can ping my domain and when i open my domains name its give me
Network Error (tcp_error)
even i cannot logged in my ssh account so i give it a hard reboot from my slice manager and after that i can log , i turn my firewall of .. restart my apache and my sqlserver
and same error ..
i can restart my sql fine .. stop my firewall and modsecurity fine , but when i restart my httpd server its wont , its give me FAILED
View 10 Replies
View Related
Jun 12, 2009
I need a script that check the service sql, php-pfm and nginx if working fine and if is start. So if is stop, the script do automatic restart the service.
i have cron a restart each houar of php but same time, in the houar of much visits of my sites php crash and stop..
View 8 Replies
View Related
