Re: iostats per mysql process

iopp but that need >2.6.20 kernel support On Wed, Jul 15, 2009 at 12:32 PM, wrote: > Does anyone has any suggestions on how to get IO stats used by per process > (mysqld) on Linux 2.6.18-53 kernel ... I just need to see  how much reads and > writes mysql is actually doing and what else is causi

iostats per mysql process

Does anyone has any suggestions on how to get IO stats used by per process (mysqld) on Linux 2.6.18-53 kernel ... I just need to see  how much reads and writes mysql is actually doing and what else is causing the IO load..

Re: MYSQL PROCESS

-Paul On Thu, 2008-08-14 at 13:38 +0530, Krishna Chandra Prajapati wrote: > But some of the mysql server(mysql server on debian) shows only one mysql > process. > > On Thu, Aug 14, 2008 at 12:56 PM, Ellison, David < > [EMAIL PROTECTED]> wrote: > > > I may be talkin

Re: MYSQL PROCESS

]> wrote: > >> But some of the mysql server(mysql server on debian) shows only one mysql >> process. >> >> On Thu, Aug 14, 2008 at 12:56 PM, Ellison, David < >> [EMAIL PROTECTED]> wrote: >> >> > I may be talking rubbish here, but is it not thre

Re: MYSQL PROCESS

r they all runing on the same port On 8/14/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote: > > But some of the mysql server(mysql server on debian) shows only one mysql > process. > > On Thu, Aug 14, 2008 at 12:56 PM, Ellison, David < > [EMAIL PROTECTED]>

Re: MYSQL PROCESS

But some of the mysql server(mysql server on debian) shows only one mysql process. On Thu, Aug 14, 2008 at 12:56 PM, Ellison, David < [EMAIL PROTECTED]> wrote: > I may be talking rubbish here, but is it not threading? > > I have seen Linux processes before create more than one

Re: MYSQL PROCESS

On Thu, 14 Aug 2008 10:27:29 +0530, Krishna Chandra Prajapati wrote: > Please help me that what should i do. Nothing. It's just multi-threaded. Everything's fine. -- Matthias Urlichs -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists

RE: MYSQL PROCESS

, similar to top but a little more visually easier, it has an option called tree. Which shows how one process spawns many when/where needed. Dave -Original Message- From: Krishna Chandra Prajapati [mailto:[EMAIL PROTECTED] Sent: 14 August 2008 05:57 To: mysql Subject: MYSQL PROCESS Hi all, I

Re: MYSQL PROCESS

Is it possible to shutdown and restart mysql again, if its not in production. regards anandkl On 8/14/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote: > > Hi all, > > I am running mysql on debian. I didn't understand why there is a lots of > mysql process run

MYSQL PROCESS

Hi all, I am running mysql on debian. I didn't understand why there is a lots of mysql process running. There should be only one mysql process running. Please help me that what should i do. Although there is no problem with mysql server. debian:~# ps axu USER PID %CPU %MEM VSZ RS

Re: mysql process 99.9 percent

On Monday, 26 September 2005 at 9:29:32 +0200, mark carson wrote: > Joeffrey Betita wrote: >> hi >> do you have any idea why the mysql process is 99.9 percent? when i click >> one hyperlink it takes more than 1 minute to load the page. thank you very >> much. > >

Re: mysql process 99.9 percent

Joeffrey Betita wrote: hi Jasper the linux distribution is redhat 9, mysql-4.0.15a-log, apache-2.0.47, php-4.3.3 etc. just clicking one hyperlink and searching for any item. OK, would you mind providing the SQL query that's being executed when you click that hyperlink? You see, MySQL doesn'

Re: mysql process 99.9 percent

logging, rerun selected queries with and without the explain syntax, look at the MySQL administrator process list to see which query is the problem whilst the CPU is 99.9 %. Good news is : 'it is solvable'. Mark Joeffrey Betita wrote: hi do you have any idea why the mysql process is 99

Re: mysql process 99.9 percent

Joeffrey Betita wrote: do you have any idea why the mysql process is 99.9 percent? No. when i click one hyperlink it takes more than 1 minute to load the page. thank you very much. Maybe if you provided some details then someone would be able to help you. We're not psychic.

mysql process 99.9 percent

hi do you have any idea why the mysql process is 99.9 percent? when i click one hyperlink it takes more than 1 minute to load the page. thank you very much. -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.11.6/111 - Release Date: 9/23

MySQL Process

Hi, I run Debian 3.1 with kernel 2.6.8-1-686-smp, I wonder why why I do ps -aux, I only can see 1 MySQL process. mysql 4227 0.0 64.6 1849456 1341912 pts/1 S Sep16 4:57 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql/ --user=mysql --pid-file=/var/lib/mysql//natuna.pid --skip

RE: MySQL process increasing problem..

uot; -Original Message- From: Matt W [mailto:[EMAIL PROTECTED] Sent: Thursday, November 06, 2003 7:22 AM To: Jobs PHP Workshop; [EMAIL PROTECTED] Subject: Re: MySQL process increasing problem.. Hi, Yes, in top, those are threads not processes, as Gerald already said. Not that it reall

Re: MySQL process increasing problem..

"Jobs PHP Workshop" To: <[EMAIL PROTECTED]> Sent: Wednesday, November 05, 2003 11:08 AM Subject: MySQL process increasing problem.. > Hi, > Problem is, Mysql server in our production machine keeps spawning child > processes and it reaches to a level where mysql hangs and th

Re: MySQL process increasing problem..

On Wed, Nov 05, 2003 at 10:38:05PM +0530, Jobs PHP Workshop wrote: > Hi, > > Problem is, Mysql server in our production machine keeps spawning child > processes and it reaches to a level where mysql hangs and the only > solution is to restart our mysql server. That sucks. > I have checked all the

Re: MySQL process increasing problem..

Those are threads, not processes. Each connection gets a thread. Many connections waiting for disk space will give you this problem. Jobs PHP Workshop wrote: Hi, Problem is, Mysql server in our production machine keeps spawning child processes and it reaches to a level where mysql hangs and the on

MySQL process increasing problem..

Hi, Problem is, Mysql server in our production machine keeps spawning child processes and it reaches to a level where mysql hangs and the only solution is to restart our mysql server. I have checked all the databases using "mysqlcheck" command and every table is OK now. Recently, MySQL server suffe

How do I tell which mysql process has a lock?

Greetings. How do I tell which mysql process has a lock on what tables? I'm using mysql 3.23.54-Max with MyISAM tables on Linux 2.4.9-34 (RedHat 7.2). We've got about 20 users and a myriad of automated scripts (Perl DBI, Java JDBC) connecting to the database on a regular basi

Re: mysql process keeps references to files after conn.close()

- Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 15, 2002 4:51 PM Subject: mysql process keeps references to files after conn.close() > Hi. > > I am doing a simple programmatic task. I am opening a connection

mysql process keeps references to files after conn.close()

Hi. I am doing a simple programmatic task. I am opening a connection to a database using connn = DriverManager.getConnection("jdbc:mysql://localhost/dbname") I then do some stuff, and execute a conn.close(). I then try and delete the database files, and I get an error that they are in use

MySQL Process ID & Unix PID

Hi, Is there a way to compare between a mysql process ID showed in top or ps with a process ID from mysqladmin processlist ? I'm asking this because we operate a mysql machine used for webhosting and it has many users and many databases. If users do crazy stuff that result in high usa

Show Tables "Freezing" a MySQL process

Hi Everyone. Here's a VERY unusualy problem. We are running a mod_perl application with MySQL. One of the functions in the program performs a "SHOW TABLE" command. This is performed with apparently great regularity within the program. It has begun locking a process up, at 100% CPU (All held by

Fw: Stalled MySQL process causing high CPU load

of 3 or to version 4? Or should I scrap MySQL and try PostgreSQL? - Original Message - From: Bruno Prior <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, November 21, 2001 10:05 PM Subject: Stalled MySQL process causing high CPU load > I am a MySQL novice, so

Stalled MySQL process causing high CPU load

n the hope that someone might like to take a look to see if I have an obvious problem with my configuration. The output of mysqladmin version, extended-status, variables and processlist are on http://www.summerleaze.co.uk respectively at /mysql-vers.txt, /mysql-status.txt, /mysql-vars.txt and /mysql-pr

RE: mysql process running

nd that updating ModAuthMySQL solved the > problem.. > Hope this helps... > > Simon > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: 26 February 2001 13:27 > To: [EMAIL PROTECTED] > Subject: mysql process running > > >

Re: mysql process running

As far as I know, this is on the wishlist, but has not been implemented - ie, a thread should die if the client disconnects. You'll probably need to run mysqladmin kill xxx, where is the offending thread id. regards, P On 26 Feb 2001 [EMAIL PROTECTED] wrote: > Hi Everybody, > I am a

RE: mysql process running

Hi there Kiran We had the same problme and we found that updating ModAuthMySQL solved the problem.. Hope this helps... Simon -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 26 February 2001 13:27 To: [EMAIL PROTECTED] Subject: mysql process running Hi

mysql process running

Hi Everybody, I am a web developer (Apache ,Perl Mysql) , I am facing a problem , i have a program that runs a query on a text field and displays results , but since the database is huge sometimes apache sends a timeout to the client(browser) but my problem is that when i check the process

Re: starting second mysql process gives "process already exists" error

On Wed, Feb 14, 2001 at 07:15:16PM +0800, Neo Sok Lay wrote: > Hi, > >I need to start 2 mysql server processes on the same box (Redhat Linux > release 6.2), using the following 2 commands: > > bin/safe_mysqld -u root --socket=/tmp/test1.sock --port=9000 & > >and > > bin/safe_my

starting second mysql process gives "process already exists" error

Hi, I need to start 2 mysql server processes on the same box (Redhat Linux release 6.2), using the following 2 commands: bin/safe_mysqld -u root --socket=/tmp/test1.sock --port=9000 & and bin/safe_mysqld -u root --socket=/tmp/test2.sock --port=9020 & Previously I was using m