Hi,
from my slow queries logfile:
# Query_time: 17 Lock_time: 6 Rows_sent: 207550 Rows_examined: 207550
SELECT ID FROM sys_users;
1 row = 1 user. mySQL gets queried through PHP.
I'd like to optimize this. 17 seconds is too much. How do you guys judge
the actual CPU impact of the process tha
Hi David,
I've seen a similar behavior on our machine. We had someone re-write the
code for a particular PHP site that was producing tons of slow queries
(while the CPU was 100% idle the script would still take 15 seconds to
run its queries) and the problem was (sort of) fixed.
Have a constant lo
Hi,
mySQL 3.23.49 on Debian GNU/Linux 3.0, Kernel 2.4.19 on a Xeon 2 Ghz (1
CPU) and 2 GB DDR-RAM. The following problem arises:
All mysqld processes (UNIX) consume too much CPU power. There are
usually a 4-10 active processes that want 30% to 99.9% of CPU power -
EACH of them. "top" just showed
