MySQL to blame? (was Re: Command-line PHP script, MySQL CPU usage goes sky-high, stays there--why?)

2007-12-20 Thread M5
I'm really not sure what to try next. ps -aux shows MySQL as hogging the CPU, not PHP or Terminal: When this happens, do a 'SHOW PROCESSLIST' in mysql to see what it's doing. I have, and I can't see anything unusual. There are a few scripts that loop with very slow overhead (with

Command-line PHP script, MySQL CPU usage goes sky-high, stays there--why?

2007-12-10 Thread René Fournier
Hello, I have a command-line PHP script--called Listener--that is designed to run indefinitely with a predictable CPU usage and memory footprint. In a nutshell, it's a multi-client socket server that waits for incoming connections, processes incoming data, stores results in a MySQL

mysql cpu usage

2005-02-26 Thread sirisha gnvg
hi everybody, PLATFORM: MySQL 4.1.8 version,OS:windowsXP We are working on a project that requires MySQL database monitoring. As part of it we monitor the network traffic to and from MySQL,harddisk space used by Mysql ,primary memory used by it and so on.As part of it we need to

MySQL CPU usage skyrocketing

2002-11-07 Thread Bogdan TARU
Hi, I am running MySQL 3.23.41 on a FreeBSD 4.4, and I experience very high loads of the machine, without any apparent reason. We have a new project using this MySQL engine, with lots of inserts/deletes. But it happens that in the mornings, when nobody makes any kind of access to the

RE: MySQL CPU usage skyrocketing

2002-11-07 Thread Simon Green
See links form mail list. http://jeremy.zawodny.com/blog/archives/000203.html#000203 http://jeremy.zawodny.com/blog/archives/000264.html#000264 Simon -Original Message- From: Bogdan TARU [mailto:bgd;icomag.de] Sent: 07 November 2002 10:35 To: [EMAIL PROTECTED] Subject: MySQL CPU

RE: MySQL CPU usage skyrocketing

2002-11-07 Thread Grigor, Peter
. Peter ^_^ -Original Message- From: Simon Green [mailto:sgreen;eurobell.net] Sent: Thursday, November 07, 2002 6:04 AM To: 'Bogdan TARU'; [EMAIL PROTECTED] Subject: RE: MySQL CPU usage skyrocketing See links form mail list. http://jeremy.zawodny.com/blog/archives/000203.html#000203

Re: MySQL CPU usage skyrocketing

2002-11-07 Thread Jeremy Zawodny
On Thu, Nov 07, 2002 at 08:48:15AM -0500, Grigor, Peter wrote: Ok, we know that FreeBSD has problems with its thread implementation; however, I'd like to know if the MySql guys know exactly what causes the problems to which Mr Zawodny refers. The problem is the MySQL (by default) uses name