how to turn off all mysql logs because mysql is using too many resources. I turned slow queries log and there is no slow queries here is what I want to turn off the logs maybe this is causing mysql to high load ?
View 2 RepliesI had Configured a MySQL Master-Slave replication.It seems that the binary logs steals so much space of My storage.
i.)My Master
show master status;
+------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000144 | 475823 | | |
+------------------+----------+--------------+------------------+
1 row in set (0.00 sec)
ii.)My Slave.
mysql> SHOW SLAVE STATUSG;
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 10.277.55.141
[code]....
If i remove all binary files up tp mysql-bin.000144 using "PURGE",will it affect my existing database/any data loss.
I used to know a command to turn off various logs that run in the background of Debian. I using lenny on CF on an embedded board, that why I need the logs off, to stop writes.
View 1 Replies View RelatedHow do I turn off Pidgin notification balloons when a buddy logs on or off? I've looked through the application's preferences like 3 times; is there some sort of system control for notification balloons?
View 9 Replies View RelatedI try to log all my iptable logs to mysql instead just a logfile. The setup is as followed:
[Code].....
[red]Problem[/red] rsyslog logs everything correct, except it does not log to db, it logs to /var/log/messages. As I am brand new to the whole Linux experience, I don't get it. My /etc/rsyslog.conf is setup with $ModLoad onmysql.
i am using liferay5.2(mysql included in the download pack) on fedora. while liferay is working fine but i cannot connect to mysql.i am getting the error
[
[root@localhost ~]# ln -s /var/lib/mysql/mysql.sock /tmp
[root@localhost ~]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.
[code]....
i didnt find the mysql.sock file in the location /var/lib/mysql/mysql.sock. i cannot find the portal-ext.properties file also to make intial settings.
I have Ubuntu 9.04, and a HP laserjet 1018 printer.
I install the printer using:
And when it ask me about plugin I give the path to it. (the 3.9.2 version of the plugin, because Ubuntu 9.04 has the 3.9.2 version of hplip)
well I install the printer, everything works perfectly.....but, when I turn off the PC, and turn it on again, the printer does NOT work!, I send work for being printed but mothing happens , Ubuntu tells me that the job was printed but ... no case, my printer does not print it.
I have to install it again since cero. what can I don to stop install it every time I turn off the computer ?
How do I create a new mysql user and a mysql database at the shell prompt?
View 1 Replies View RelatedMysql starting problem after changing mysqladmin password.I tried all the solutions available on forums, but not solve the problem.At last I restored the mysql db backup, this make mysql service start, but till other databases not showing all tables.
View 1 Replies View RelatedI have install mysql on my fedora12. My different mysql server is located in us. I want to check health status and hits per seconds everything. Is it possible with mysql-administrator command.
now a these days i am connect through ssh and excuting below command
#mytop mysql -u root -p <passwd>
In my mysql db i have added the userip & passwd (allowed the privileages for that ip)
If i use mysql-administrator i am getting below error
MySQL Error Nr. 2003
Can't connect to MySQL server on '66.98.152.64' (111)
I have tried many different ways to interact with the mysql to reset the root mysql pass. This is what I got to right now
Code:
#!/bin/sh
newpass=$1
service mysqld stop
mysqld_safe --skip-grant-tables --skip-networking &
echo "use mysql;" >> /tmp/mysql_pass_reset.txt
echo "update user set password=PASSWORD("$newpass") where User="root";" >> /tmp/mysql_pass_reset.txt
[Code]...
policy is to backup mysql with mysql-zrm.However at a certain stage it hangs forever. This is at the "flush logs". I tried this manually and it gave the same result. Even after restarting mysql and the host. After some googling and trying I found out "flush tables with read lock" gives the same result. The tables seem to be MyIsam. I tried with a mysqldump on one server and restore it on a test vm. I used the same config and flush logs still hangs. ALso I tried to change some configuration directives... but with the same result
Edit: btw, I checked the logfile and didn't found anything (/var/log/mysqld.log)
Edit2: I also did myisamchk -s *.MYI (in all direcoties with db files;actually did it with find command) and it did not return anything so datafiles seem ok.
When I try to login as me - it gets pretty far but then something happens and automatically logs out. This happens in Gnome, Kde too. Now - I have no problem logging in a Root. Is there a way I can try to stop the login process before it kicks me out, or is there a way to look at some files to tell me what's going on?
View 3 Replies View RelatedI think this goes here, but I'm not sure. I decided that XAMPP had been troublesome enough. MySQL never worked. So I decided to instal the LAMP stack offered by YaST. I went about installing it thinking that it would all work. But it seems that I was wrong. So I try to start mysql, and here's what I get:
Code:
the-matrix:~ # mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) or
Code:
the-matrix:~ # rcmysql start
Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds
chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory
[Code]...
On our app server the logs from the Sybase Mobilink service get logged to /var/log because of that I did a chmod a+rx /var/log and all is well until.... the next day QA logs in goes to check the logs and gets:
Quote:
qa@dwdb [~]$ ls /var/log
ls: /var/log: Permission denied
qa@dwdb [~]$
Ubuntu one does not synchronize files since I upgraded from 9.10 to 10.04. The preferences panel keeps showing "Synchronization in progress...", but files are not downloaded from the repository. It does not show any error message.
Where do I find the programm logs, where I can investigate my problem?
How to get the Q2 patching logs of particular server (Linux 2.6.9-100.EL)
View 1 Replies View RelatedI have a server with logs running. People connect to server. This server is running the same application as a failover just in case it stops. I have a doubt that some clients are connecting from different places as the nodeID is changed SO I need to make a script which reads both logs that are called server1.log and server2.log and where it finds a nodeID which does not match in both logs it action with fail2ban
I don't know whether this can be done directly via fail2ban since it is the program which I know that reads between logs but as far as I know it cannot match data with another log
This is an Example:
Code:
Log 1
03:00:08.905 client qwe696s@894b226f7846d9df, running version 2.1
Log 2
03:00:08.905 client qwe696s@894b226f7846d9dd, running version 2.1
Quote:
qwe696s is the username
894b226f7846d9df is the NODEID
AS you can see from the logs nodeid is different
where kernel logs are stored in linux
View 5 Replies View RelatedI have captured a file in my linux showing logs captured from many modules concurrently. Please find attached a sample of the file. As you see, there are logs from individual modules that have been captured concurrently. For example, there are logs from IPTR,SNMP,HLR,TCAP,XAPP,and SCCP modules but they are coming concurrently.Each log has the header name of its accompanied module in the beginning. I need to have the log of each modules separately. Can you please show me the power of linux on how to separate individual module's logs from the whole?
View 3 Replies View RelatedI have been following the link:[URL]for understanding the log4sh.How can I put it to work for my jboss GC logs?I dont want to use log4j for some reason.
View 1 Replies View RelatedI need with JBoss application Server.All I have JBOSS running without any issue.All I want is leading the Jboss logs to be deposited at /var/log/jboss.Say, if there are more than one instance running then create a seperate logs like /var/log/jboss-insta1, /var/log/jboss-insta2 etc.
View 2 Replies View RelatedI'm trying to find out where the logs from slapd.conf (loglevel -1) go? I know in RH is /var/log/ldap.log cant find it on Debian. Its probably too late
Btw. does Debian have something like /etc/syslog.conf. If yes where?
Is there a tool already out there that will split error logs based on the virtual host they belong to? Or perhaps a somewhat simple way to write a script that can do this? I'll keep looking for a solution but I thought I'd ask in case someone here has one to offer.
View 2 Replies View RelatedI recently installed Suse Linux enterprise Desktop 11 on my box. I created an user and logged in first time into a GNOME session without any problems. Last time I logged in I selected the session as TWM and that got me into the T windows manager just fine. Now when I log out and try to log back into a GNOME session, it will still log me into the TVM sessionI have tried restarting the boxHowever, when I remote log in to the machine it will let me get on the GNOME session just fine. I'm guessing this is probably a really simple fix, however I am a Linux newbie and doing a google search isn't yielding me what I'm looking for.
View 1 Replies View RelatedI'm using pidgin on both, windows and linux on several pc. To sync my log, I use dropbox. For linux, it's easy. Just a matter of symlink. However, I don't know how to sync it on windows, without manual copy-paste once I'm done on windows.
backup and delete current log (it's located at C:Users{your user name}Roaming.purplelogs)
mklink /D "C:Users{your user name}Roaming.purplelogs" "E:My Dropboxsomepathpurplelogs"
"C:Users{your user name}Roaming.purplelogs" is where you want your symlink at
"E:My Dropboxsomepathpurplelogs" is there you have your dropboxed logs.
I've activated my AdSense account and then I received a confirmation from GoogleJust for curiosity, I connected to my server to snoop the logs and I've found a Russian website doing something :|
Code:
66.249.71.215 - - [12/Jan/2011:14:05:58 -0300] "GET /robots.txt HTTP/1.1" 404 1144
66.249.71.215 - - [12/Jan/2011:14:05:59 -0300] "GET / HTTP/1.1" 302 -
[code]....
I had full backup in mysql. now i added some tables .i got new binary logs. how i can i use these logs to have incremental backup.
View 3 Replies View Relatedi installed php-syslog-ng 2.9.8m in RHEL5 box. I saw logs from the local machine once the cron execute in every one minute.I dont need to appear those in my syslog console. I want to disable these from my linux box.How can i archive this
View 1 Replies View RelatedI am installing RHEL 5.5 to be a syslog server to collects logs from servers (HP-UX, Linux, Windows and Cisco Network Devices). and i can now collect logs from my windows PC on syslog linux server by using Datagram SyslogAgent software. can collect logs from HP-UX 11.23 server. and i configuring the Unix server as in the steps below:
1. Log in as root
2. Go to /etc/syslog.conf
3. Add a line: *.*<tab>@<Sentinel Server IP Address>
*.* @10.15.1.5
4. Save and Close
# netstat -na | grep 514
tcp 0 0 *.514 *.* LISTEN
udp 0 0 *.514 *.*
[code]....