Re: Persistent MySQL Process
Hi, It seems to be the second issue (I/O) load. Here's a snippet from top: PID USER PR NI VIRT RES SHR S %CPU %MEMTIME+ COMMAND 22178 mysql 20 0 416m 119m 7456 S 31 3.0 137:12.52 mysqld I know there needs to be a mysqld process but this does not look right? On Monday, 8 October 2012 22:50:03 UTC+1, Sven Hartge wrote: Daniel Latter wrote: I did as you suggested and found evidence in the second command, but the only that stood out was the Debian start up script that I have already commented out and restarted MySQL, I'm going to try a server reboot, but I'm not 100% that will get rid of the process. Umm, why do you have MySQL installed when you don't want to use it? If course will there be a running mysqld-process, because MySQL needs a running mysqld to function, there is now way to prevent this and _still_ be able to use a MySQL-DB. I fail to grasp your problem. If the mysqld crashes your server, then you need to investigate why. Foremost you need to define (and tell this list) what you mean by crashes the server. Does it run out of free RAM? Does it create a heavy I/O load and thus slowing down everything else? Grüße, Sven. -- Sigmentation fault. Core dumped. -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org Archive: http://lists.debian.org/8650c525-1647-485d-b90b-b51158dcf...@googlegroups.com
Re: Persistent MySQL Process
On Tuesday, 9 October 2012 02:00:02 UTC+1, Christofer C. Bell wrote: On Mon, Oct 8, 2012 at 2:48 PM, Daniel Latter wrote: Hi, Thanks for the reply. I did as you suggested and found evidence in the second command, but the only that stood out was the Debian start up script that I have already commented out and restarted MySQL, I'm going to try a server reboot, but I'm not 100% that will get rid of the process. Would you suggest anything else? Do you by any chance use KDE? -- Chris Hi, I do not use KDE myself but my colleague does, but its just to browse to a web address, can I ask what you are alluding to? Thanks. -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org Archive: http://lists.debian.org/e6c4bad7-894c-4a49-a094-3a1140144...@googlegroups.com
Re: Persistent MySQL Process
On Tue, Oct 9, 2012 at 5:11 AM, Daniel Latter dan.lat...@gmail.com wrote: On Tuesday, 9 October 2012 02:00:02 UTC+1, Christofer C. Bell wrote: Do you by any chance use KDE? I do not use KDE myself but my colleague does, but its just to browse to a web address, can I ask what you are alluding to? KDE depends on MySQL embedded for Akonadai, Nepomuk, and Amarok. Normal use of KDE will cause a mysqld process to be running on your machine, one that is not started via the system init scripts (and that runs as your user). I was thinking this might be why your system is running MySQL without your explicit knowledge. -- Chris -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org Archive: http://lists.debian.org/CAOEVnYudjbdu3K42EBpZ=RthXpfryzB=5odjq7a_p89mzsq...@mail.gmail.com
Re: Persistent MySQL Process
Hi, Thanks for the reply. I did as you suggested and found evidence in the second command, but the only that stood out was the Debian start up script that I have already commented out and restarted MySQL, I'm going to try a server reboot, but I'm not 100% that will get rid of the process. Would you suggest anything else? Thanks -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org Archive: http://lists.debian.org/110e7a4c-1a66-4aaf-a4ee-4f94ecea4...@googlegroups.com
Re: Persistent MySQL Process
Daniel Latter dan.lat...@gmail.com wrote: I did as you suggested and found evidence in the second command, but the only that stood out was the Debian start up script that I have already commented out and restarted MySQL, I'm going to try a server reboot, but I'm not 100% that will get rid of the process. Umm, why do you have MySQL installed when you don't want to use it? If course will there be a running mysqld-process, because MySQL needs a running mysqld to function, there is now way to prevent this and _still_ be able to use a MySQL-DB. I fail to grasp your problem. If the mysqld crashes your server, then you need to investigate why. Foremost you need to define (and tell this list) what you mean by crashes the server. Does it run out of free RAM? Does it create a heavy I/O load and thus slowing down everything else? Grüße, Sven. -- Sigmentation fault. Core dumped. -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org Archive: http://lists.debian.org/39625rqps...@mids.svenhartge.de
Re: Persistent MySQL Process
On Mon, Oct 8, 2012 at 2:48 PM, Daniel Latter dan.lat...@gmail.com wrote: Hi, Thanks for the reply. I did as you suggested and found evidence in the second command, but the only that stood out was the Debian start up script that I have already commented out and restarted MySQL, I'm going to try a server reboot, but I'm not 100% that will get rid of the process. Would you suggest anything else? Do you by any chance use KDE? -- Chris -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org Archive: http://lists.debian.org/CAOEVnYsOd=KLY9n8wSZ�nvek7bn-rq10en_gtm-4_9phw...@mail.gmail.com
Re: Persistent MySQL Process
On Fri, Oct 05, 2012 at 11:27:07AM -0700, Daniel Latter wrote: Hi All, System: cat /etc/issue Debian GNU/Linux 6.0 I have a long running MySQL process that runs for days and eventually crashes the server. I googled about and discovered that Debian has it's own MySQL start up script that runs a check tables command, so I commented this out and restarted, but the process immediately started again. I have webmin installed and when I view the process information it has a parent process of init[2]? Also, when I view the files and programs related to the persistent process in question, it lists ibdata files (innodb data files), one being 8GB in size! I am wondering if this has anything to do with it? Any help or pointers would be greatly appreciated. grep mysql /etc/inittab grep mysql /etc/init.d/* If it shows up in the first, pull it out and reboot. If it shows up more than once in the second, look for the offending script. -dsr- -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org Archive: http://lists.debian.org/20121007022706.gn4...@randomstring.org
Persistent MySQL Process
Hi All, System: cat /etc/issue Debian GNU/Linux 6.0 I have a long running MySQL process that runs for days and eventually crashes the server. I googled about and discovered that Debian has it's own MySQL start up script that runs a check tables command, so I commented this out and restarted, but the process immediately started again. I have webmin installed and when I view the process information it has a parent process of init[2]? Also, when I view the files and programs related to the persistent process in question, it lists ibdata files (innodb data files), one being 8GB in size! I am wondering if this has anything to do with it? Any help or pointers would be greatly appreciated. Also, regarding webmin I have turned off the db module. Thanks Daniel. -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org Archive: http://lists.debian.org/e6969273-43d4-48bd-a5d1-d23610f59...@googlegroups.com
