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?
ADVERTISEMENT
MySQL Error: Can't Create/write To File '/dev/shm/MYxQT8lz'
May 19, 2008one of my site shows this error
MySQL Error: Can't create/write to file '/dev/shm/MYxQT8lz'
I checked space on the server is still 25 GB free,
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;?
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.
Log Rotation How To
Apr 2, 2009how to setup automated log rotation on a Cpanel box?
I need to automatically rotate logs for mail (exim), domains, apache, etc.
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
Plesk 11.x / Linux :: Where Are Old Access Log Files After Log Rotation
May 14, 2014In Plesk 11.5 I set log rotation to once a day and to keep 365 files. But I can only find 13 files (only one access_log) in /var/www/vhosts/mydomain/log. But Plesk tells me that 100 GB are used for the logs (the 13 files only have about 3 GB). Where are the files? In previous versions (before 11.5) I always had the files (named .1, .2 etc) in the same log directory.
View 3 Replies View RelatedApache :: WAMP Config - 2.4.4 Access Log Rotation
Jun 6, 2014I have put up a WAMP server that is based on Apache2.4.4. I am trying to utilize the rotatelogs.exe to rotate my access log every night. I have this working on IBM HTTP installations. IBM's HTTP is based on Apache 2.2. why the CustomLog command is not working? The command under my Virtual Hosts that I am using is:
<VirtualHost *:80>
ServerName xxxxxxxx
DocumentRoot C:wampwww
[Code]....
Apache :: Log Rotation Setup - Directory Path Has Spaces
Sep 23, 2013I am trying to set up log rotation on my Apache Server on Windows 2008 using the rotatelogs.exe executable. I believe I am having issues because my directory path has spaces.
From my understanding, a full path is needed for the ErrorLog but not for the CustomLog
ErrorLog "|"C:/Program Files (x86)/Apache Software Foundation/Apache2/bin/rotatelogs.exe" "C:/Program Files (x86)/Apache Software Foundation/Apache2/logs/Error/Error_%Y-%M-%D.log" 86400"
CustomLog "|bin/rotatelogs.exe logs/Access/Access_%Y-%M-%D.log 86400" common
The error that I get is:
C:Program Files (x86)Apache Software FoundationApache2.2bin>httpd.exe -k start
The system cannot find the path specified.
VPS Providers! What's Your Take On "write Back" & "write Through"
Oct 9, 2009I recently worked on an issue involving a severe performance issue between "write back" and "write through" caching on the RAID/HD.
Long story short, we purchased 12 IBM x3550 M2s came with LSI SAS1068E/SR-BR10i (gimp redheaded stepchild of the MR series. No BBU, no onboard DIMM.) RAID controller and had very bad and inconsistent write throughput with it. Sometimes it writes out 300-400MB/s (dd test, I know... don't flame. I know dd is NOT a good test.), somethings as low as 30MB/s. The server is configured with 2.5" SATA 500GB on HW RAID-1.
From dmesg log it was default to "write through" on sda. I figured out via lsiutil, you can set the drives to "write back". Once we did that, the write performance is more consistent. NOTE, this enables write back on the SATA drives, NOT the controller itself.
I loop out lspci on all our VPS servers. Found out those with LSI (SAS 8344ELP) cards have sda set to "write through w/ FUA". Those are already all RAID-10s, and I have not heard a single complaint from any customer stating poor I/O performance.
I believe the 8344ELP do have a BBU, I can double-check with DC. The DC is on UPS as well. So that rules out the shortcomings of enabling write back caching.
I want to ask those of you using Xen (3.3 & 3.4). Do you guys have better I/O performance with "write back" or "write through" caching? I'm actually looking for real world results. Where you guys actually deployed production VPS server with clients on it.
Plesk 12.x / Linux :: Missing Log Rotation Configuration File For Domain
May 7, 2015When I specify log rotation settings for domain xyz.com in Plesk panel I expect them to be saved in /etc/logrotate.d/xyz.com file, at least this is the expected behaviour according to Plesk12 Admin Guide: [URL] ....
Apparently, it doesn't happen and I don't have xyz.com file in /etc/logrotate.d/
Log rotation doesn't seem to work either, at least it doesn't work for error.log
I read somewhere that log rotation feature has to be specially enabled in Plesk but I couldn't find specifics anywhere.
Plesk 12.x / Linux :: Backup Errors - Dump Rotation Failed
Jun 20, 2014All domains were offline this morning. Plesk showed the following error message. It seems we are beta testing the software. I am on Suse 13.1, clean install.
Unable to rotate dump: The dump rotation is failed with code '1' at /usr/local/psa/admin/bin/plesk_agent_manager line 1041.
Warning: domain "abc.com"
The domain 'abc.com' may be inaccessible after backup. Please, resume it manually!
Warning: domain "abc.com"
Cannot resume domain 'abc.com' (ErrorCode: 255, STDOUT [Error:].
Plesk 12.x / Linux :: Log Rotation For Particular Domain - Restrict File Size?
Feb 12, 2015For a particular domain I've got it set to:
Log rotation condition: By size (1024 KB)
Maximum number of log files: 5
Compress log files: Yes
...however the access_log.processed is at 20.4MB. Is this correct? I would have thought it could only get to 5MB in total?
How do I restrict the size of access_log.processed?
Plesk 12.x / Linux :: Keep Permanent Record Of All Mail Inbound And Outbound - Log Rotation Settings
Nov 19, 20141/ What is the difference between maillog and maillog.processed? I want to keep a permanent record of all mail inbound and outbound even if delivery is deferred by the gray listing. I'm not sure which one is the best to keep.
2/ I would like to change the way that the mail logs get log rotated. I am struggling to work out exactly what happens at the moment but I would like to rotate the log out every day regardless of size. I think currently that the maillog.processed is rotated daily if it is over a specific size.
Config.php To Not Have Write
Mar 11, 2007config.php to not have write permissions for everyone? I am running cpanel 10x with whm/extras Here is full report when i try and load fantastico scripts. You must secure this program. Insecure permissions on config.php While installing CSLH you might of needed to change the permissions of config.php so that it is writable by the web server. config.php no longer needs to be written to so please chmod config.php to not have write permissions for everyone. you can do this by UNCHECKING the box that reads write permissions for the file:
Where can i find the box it is talking about?
/tmp Create/write LINUX
Jun 21, 2009when i am trying to use php my admin i am getting
#1 - Can't create/write to file '/tmp/#sql_bba_0.MYI' (Errcode: 30)
when i am trying to delete a file from /tmp i am getting
rm: cannot remove `sess_***': Read-only file system
i have Linux box with cpanel,
How To Write A Good Survey
Jun 20, 2008I want to make a survey for my small business company (domain names, hosting, web design).
I don't know what is the roadmap to do it. some help link or documentation
Plesk 12.x / Linux :: Unable To Rotate Dump - The Dump Rotation Is Failed With Code 121
Feb 4, 2015I have enabled the backup rotation of some websites to my "Personal FTP Repository", the problem is that Plesk is unable to do it due this error:
Code:
Unable to rotate dump: The dump rotation is failed with code '121' at /usr/local/psa/admin/bin/plesk_agent_manager line 1041.
I read here [URL] .... that it should be solved but I have the version 12.0.18 Update #33, why does it persist?
How To Write Cookie Data To Web Log File
Jun 21, 2007I use a persistent and session cookie in order to help track return visitors, latent conversions and keyword tracking. My problem is that my hosting company, BlueHost, does not allow me to write the cookie data to my raw access log which would enable me to analyze this information.
Does anyone have any experience with using a script in order to get around this issue and write the cookie data to my log file....or as an alternative can people recommend a good hosting company which enables this functionality?
BlueHost has generally worked fine, so a work-around would be preferred, but if needed I may switch.
Raid Card - Write Caché - SAS 5/iR
Oct 8, 2007I have bought 4 servers with DELL SAS 5/iR.
All is fine but the writes are very slow; I supose it's because write cache not enabled.
I have enable it and make some test and there is a lot of difference:
[url]
I'm worried about enabling it because if the server goes down I think it can cause disk corruption and loose data and maybe the OS. What do you think about that? Data is a priority!
Disks have this technology: Seagate-exclusive IRAW (Idle Read After Write) enhances data
protection by verifying—during drive idle time—that data in thedrive buffer was properly written.
The servers are on a datacenter and have RAID 1 with Cheetah® 15K.5 SAS 3Gb/s 146.8-GB Hard Drive - ST3146855SS
[url]
I'm also VERY worried about the coments about this card:
[url]
Is it true that the raid don't get rebuilded? If it is like this I don't know why I'm running raid.
Apache :: Write HTAccess File For A 301
Apr 15, 2013I have learned some bits of regular expressions for simple scripting, writing a .htaccess file is, uh, syntaxically daunting.
THE CASE :
The URLs of my site used to be of the form [URL] ... . They are now of the form [URL]......
I am trying to perma-redirect (301) the old format (affiche_fiche.php) to the new format (fiche.php) using a .htaccess.
So far all I have achieved is a hatred of punctuation signs. What's the correct syntax to have a .htaccess that does the redirect ?
THE CONTEXT : The format change took place more than six months ago, but the Google Webmaster Tools still spits 450 problems a day with 404s on URLs using the old format. I had assumed that these would just fade away, but they don't. So I guess that 301'ing them is cleaner. Or would be, if I understood the syntax.
Apache :: How To Write Dynamic Image Url
Mar 15, 2013how can I rewrite a dynamic image url? URL....
View 3 Replies View RelatedHigh Iowait : Write Access Request
Nov 22, 2008diagnosing my server which currently experiencing high iowait for weeks, I'm still figuring the root cause.
total used free shared buffers cached
Mem: 4051 3653 398 0 341 2847
-/+ buffers/cache: 464 3587
Swap: 8191 0 8191
The server spec as follow :
HP DL 380 G5
4G RAM
2.6.18-53.el5PAE
the load is around 1 or 2 , but iowait have been on the high side even the server currently is under utilized
I'm running LVM and hardware RAID 1 on the server.
BirdHosting - Worth My Time To Write A Review
Dec 18, 2008BirdHosting - worth my time to write a review
I just completed my latest site launch with BirdHosting.com and I have to say Mike knows how to operate this hosting company. I've been with ourinternet.us (spare me ever again---please), HostMySite, and GoDaddy. Godaddy was my latest host until I moved it over to Bird. Godaddy didn't give me much flexibility with their VPS windows hosting plans. I needed more then 10 gigs on a windows host.
A buddy of mine referred me to Mike from BirdHosting and Mike had me up and going before I even gave him a credit card. He really wanted to impress and meet all my needs. I now have a 50 gig / 1gig windows vps for a super great monthly price. I enjoy the personal attention I get when something goes wrong.
BirdHosting also helped me pick out two servers for where I work at too. Mike spent over 45 minutes on the phone with me answering questions I had. Godaddy would NEVER do that.
Anyways - I'm enjoying super FAST up time since going over to the birds nest. worth a look at if you are considering hosting companies.