Can I Delete Mysqld.log
Dec 13, 2008Can I delete mysqld.log
Can I delete or empty mysqld.log
Its currently 850MB
If I can do I have to stop MYSQL first;?
ADVERTISEMENT
Mysqld Restart
Nov 15, 2008I 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 ....
Mysqld Using 100 Percent Of Cpu
Apr 10, 2007I'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
OS X 10.5 - Mysqld: Command Not Found
Apr 28, 2009I'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
Mysqld Unable To Start
Aug 23, 2007My 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.
After Rotation Mysql Don't Write Mysqld.log
Nov 6, 2009we 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?
Starting Mysqld With The --skip-name-resolve
Apr 19, 2007How can we start mysqld with --skip-name-resolve? Syntax Or Command?
View 7 Replies View RelatedMonitoring A User's SSH? Also... Mysqld Running At 103%cpu & Stats Overload Emails
May 15, 2007I 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
Delete VPS From Hypervm
Apr 1, 2009i've created VPS with OpenVZ.And there is some problem i have access the vps and it's show some error
Code:
VM creation has failed. Reason: Private area already exists in /vz/private/250
.At the moment i forgot my SSH details..only i know my hypervm "root" details..where i log with admin password.I need to fix this because some clients of my hosting company is waiting and my number of VPS is limited.
Cant Delete Files
Jul 12, 2009im try to delete some file from cpanel but everytime i delete nad refresh they come back
also if i try to change the perms it does not let me?
How To Delete A Directory Through Ssh
Aug 20, 2008I'm trying to use SSH to delete a directory. It won't delete via FTP.
I've tried variations of the below but nothing seems to work;
rm -f [folder]
rm /-f [folder]
the directory that should be deleted is test.crossroadsclub.net, so I use that as the folder.
How To Delete Files
Aug 13, 2008i have installed the Domain Technologie Control Panel on Debian Etch, and have 2 folders that will not delete via FTP
I was wondering if anyone had a tutorial or could tell me how to be able to delete them....
Delete /dev/sda4
Jul 14, 2008[root@d7 ~]# fdisk -l
Disk /dev/sda: 160.0 GB, 160041885696 bytes
255 heads, 63 sectors/track, 19457 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System
/dev/sda1 * 1 57 457821 83 Linux
/dev/sda2 58 15355 122881185 83 Linux
/dev/sda3 15356 15616 2096482+ 82 Linux swap / Solaris
/dev/sda4 15617 19457 30852832+ 8e Linux LVM
i want removed/deleted /dev/sda4
Can We Delete Sql Logs
Jul 7, 2008Can we delete sql logs ? as it occupies 2.97gb
All the log is under a single file, occupying huge amount of space on our server
use lxadmin for the vps
we are unable to even open up the file, as we have almost run out of space, we would atleast like to delete around old logs older than a month, this logs are from 3 months, so please help us in solving this problem
if we delete the sql log, will a new log be created automatically or it gives an error?
Nobody Folders And Delete
Jun 29, 2008when people run a forum and the template and forumdate folders may created some files with nobody permission,
the user could not delete them by the user themself,
and need admin login as root with ssh to delete those,
and let the files permission can run as the user instead of nobody.
the server is centos with cpanel and suexec.
Delete Command
Feb 24, 2008can i activate the deletion command for 10 or 30 mins and then stop it? i think by this way we cant delete some files from the dir and not all the files so i can edit my files
i want to do this because my server doesnt respond to any file system command because my hardisk is full! so i need to remove some files by any way
/var/log/mysql - Can I Delete It
Jul 22, 2007Question: Is it safe to delete the files in /var/log/mysql ? Also, is there some way I can disable logging so that this folder does not get filled up again?
Explanation:
Last night I started running a Perl script to process the data contained in some files, and then do a series of INSERTs to put them in a MySQL database. When I checked on it this morning, I found that it was very close to being done, but had locked up. I had trouble doing anything at all, actually, until I realized that 100% of the disk space on my hard drive had now been used. I went to investigate, and I quickly realized that my /var/log/mysql folder was over 120GB!
My intuition tells me that this folder is just used to store logs of what MySQL is doing. However, I have no need for these logs, and seeing as they are (unnecessarily) using over 120GB of my hard drive space, I would like to delete everything in that folder. But I'm still fairly new to Linux, and I'm not sure if this is safe. Can I just delete these files? And also, to prevent this from happening again, is there some way I can disable MySQL from creating such enormous log files?
Can I Delete These Folders From My Ftp
Mar 17, 2007I heard the following folders were used by frontpage.
_private
_vti_bin
_vti_cnf
_vti_log
_vti_pvt
_vti_txt
I was wondering can i delete these folders if i'm not using frontpage ?
Delete Files In /var/log
Aug 3, 2007I am currently freeing up some space on my VPS and want to know if it ok for me to delete the following files in: /var/log/
apf_log.3
apf_log.4
boot.log.3
boot.log.4
cron.3
cron.4
exim_mainlog.3.gz
exim_mainlog.4.gz
exim_paniclog
exim_paniclog.3.gz
exim_paniclog.4.gz
exim_rejectlog.3.gz
exim_rejectlog.4.gz
maillog.3
maillog.4
messages.3
messages.4
rpmpkgs.3
rpmpkgs.4
secure.3
secure.4
spooler.3
spooler.4
Delete A Cronjob Via SSH
Mar 23, 2007I have a cronjob that is still entered in my server, but due to my own lack of knowledge i deleted the domain from my server without removing the cronjob and now i keep getting the emails from my server
Code:
/bin/sh: line 1: /home/userID_Removed/public_html/cgi-bin/script-removed/cron.cgi: No such file or directory
I just need to know how to remove the cronjob via SSH, i logged in as Root to my SSH and then did crontab -l and I see the two cronjobs I want to remove, but can't find the code to do so anywhere via Google.
There is 3 total that I want to remove but there is about 10 cronjobs setup there so i want to remove those three and make sure the other 7 stay running as they should.
My.cnf Have Delete The Table
May 9, 2007i have update my.cnf with the following configuration and now i have a lor of customer that have lost him table, seem that this configuration have delete in random .Myi files, i would put this my.cnf also on others server but i would undestand which setting in this .cnf make problem for the table.
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
#skip-networking
safe-show-database
query_cache_limit=1M
query_cache_size=96M ## 32MB for every 1GB of RAM
query_cache_type=1
max_user_connections=200
max_connections=500
interactive_timeout=10
wait_timeout=20
connect_timeout=20
thread_cache_size=128
key_buffer=384M ## 128MB for every 1GB of RAM
join_buffer=1M
max_connect_errors=20
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=3M ## 1MB for every 1GB of RAM
read_buffer_size=3M ## 1MB for every 1GB of RAM
read_rnd_buffer_size=3M ## 1MB for every 1GB of RAM
thread_concurrency=2 ## Number of CPUs x 2
myisam_sort_buffer_size=64M
server-id=1
log_slow_queries=/var/log/mysql-slow-queries.log
long_query_time=2
collation-server=latin1_general_ci
[mysql.server]
user=mysql
#basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192
[mysqldump]
quick
max_allowed_packet=16M
[mysql]
no-auto-rehash
#safe-updates
[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[mysqlhotcopy]
interactive-timeout
How To Delete None Empty Dir
Jan 28, 2007I am trying to delete none empty directory using this command...
rmdir dirname
but system say directory not empty.. how I can delete directory with all directory/files under it
How To Delete Backup Files
Oct 25, 2009I have files on offsite backup from a previous server - I can login via putty ot winscp.
Putty login shows:
Quote:
FreeBSD 6.1-RELEASE-p3 (BACKUP3)
i want to delete them all - how can I do this in the most secure manner with the access I have?
Unable To Delete Folders In Ftp
Mar 28, 2009im using fireftp and i chmod the folders to 777 but it seems that im still unable to delete the folders as i get the message 550 directory not empty etc.
View 9 Replies View RelatedHow Can I Delete Much Emails In Cpanel
Apr 27, 2008my control panel is: Cpanel
when somebody send me a wrong email , that will go to my Default address
example , my website name is : "test.com" and my website user : "test"
now , if somebody send a mail to 4444442342343@test.com that mail will go to my default address: " test "
i have a 50.000 emails in my default address
how can i delete complete that emails?
is there anyway for delete much email?
Delete Everything On Server Before Cancelling
Mar 21, 2008I am currently transferring from a VPS to a dedicated server.
After you have made the transition, do you delete everything on your previous server? Or can I expect that everything be deleted anyway when my subscription runs out?
I bring this up because there sometimes is sensitive data stored there (ie. databases with personal info) and I'm wondering how much I should delete. Obviously I'll get rid of the DBs, but what about essential stuff like the operating system?
Safe To Delete These Files
Feb 12, 2008I am running my VPS on direct admin panel, my disk space is going low, so i am deleting few junk / log files
Kindly let me know
1) is it safe to delete data of this directory -
/var/log/httpd/domains
The File names in above directory are such as - " domain.com.bytes "
As it is occupying 600 MB space
2) where can i delete much junk / temp files, to free up space.
WHM: Can You Delete Entries In SSL Key/Crt Manager
Aug 14, 2008how to delete the excessive SSL keys / CRT's from WHM?
I have so many of these freakin' things (from doing it WRONG the first few times) that I want to clean it up.
how do you clear out the KEYS / CRTS / Signing Requests from WHM?
DOS/Cmd.exe Command To Delete Subdir
May 22, 2008and its file.
i tried del c: emp*.*
but that didn't work and if i try rmdir c emp, it removed c: emp directory or maybe i'm not looking hard enough.
basically i want to copy a folder with many subdirectory under it, zip it up the folder and delete all the subfolder and the files in the subfolder but not the parent folder where it store all temp data.
i already got xcopy and zipping work but i can't seem to figure out how to remove all the folder inside the parent folder without deleting the parent folder.
i'm creating a batch file to run this task.
Plesk Not Delete Domain
May 27, 2007When i try to erase a domain from the Plesk it can't be erased and it gives the following error, i have read a lot of writings about this problem but i still didn't succeed. When at last i tried to erase it again it gave the following problem.
Error;
Domains not delete : Problems occured while removing domains: Unable to turn
the domain OFF: domainsmng failed : Execute usermng access off failed : Unable to get the user (kenthosting)
home: (2221) The user name could not be found
