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
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
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
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