[snip]
>
> Have just run 'top' on the live server...
>
> Before running the query I get:
>
> 13:56:09 up 45 days, 11:47, 1 user, load average: 0.00, 0.28, 0.44
> 24 processes: 23 sleeping, 1 running, 0 zombie, 0 stopped
> CPU0 states: 0.0% user 0.0% system 0.0% nice 0.0% iowait 100.0%
> idle
> CPU1 states: 0.0% user 0.0% system 0.0% nice 0.0% iowait 100.0%
> idle
> CPU2 states: 0.0% user 0.1% system 0.0% nice 0.0% iowait 99.4%
> idle
> CPU3 states: 0.0% user 0.0% system 0.0% nice 0.0% iowait 100.0%
> idle
> Mem: 6203744k av, 6194148k used, 9596k free, 0k shrd, 304848k
> buff
> 1948476k active, 3601304k inactive
> Swap: 4192956k av, 1876604k used, 2316352k free 4081216k
> cached
>
> PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
> 7622 xxxxxxxx 15 0 904 904 748 R 0.1 0.0 0:00 2 top
> 1 root 9 0 468 440 420 S 0.0 0.0 2:58 1 init
> 1733 root 9 0 548 516 480 S 0.0 0.0 0:35 1 syslogd
> 2242 root 8 0 808 736 684 S 0.0 0.0 0:11 0 xinetd
> 3393 root 8 0 576 552 512 S 0.0 0.0 0:21 1 crond
> 15329 root 9 0 1284 1156 1088 S 0.0 0.0 0:27 2 sshd
> 3264 root 8 0 3676 1548 1488 S 0.0 0.0 0:37 2 httpd
> 15296 apache 9 0 9904 8872 4752 S 0.0 0.1 0:00 2 httpd
> 4576 apache 9 0 9876 8804 4344 S 0.0 0.1 0:01 1 httpd
> 8992 root 9 0 1000 1000 848 S 0.0 0.0 0:00 1
> mysqld_safe
> 10433 mysql 9 0 17036 16M 2012 S 0.0 0.2 0:00 2 mysqld
> 11360 mysql 8 0 17036 16M 2012 S 0.0 0.2 0:00 2 mysqld
> 11395 mysql 9 0 17036 16M 2012 S 0.0 0.2 0:00 0 mysqld
> 11425 mysql 9 0 17036 16M 2012 S 0.0 0.2 0:00 2 mysqld
> 11456 mysql 9 0 17036 16M 2012 S 0.0 0.2 0:00 3 mysqld
> 11491 mysql 9 0 17036 16M 2012 S 0.0 0.2 0:00 2 mysqld
> 12128 mysql 9 0 17036 16M 2012 S 0.0 0.2 0:00 2 mysqld
> 12162 mysql 9 0 17036 16M 2012 S 0.0 0.2 0:00 0 mysqld
> 12193 mysql 9 0 17036 16M 2012 S 0.0 0.2 0:00 2 mysqld
> 12224 mysql 9 0 17036 16M 2012 S 0.0 0.2 0:00 1 mysqld
> 32418 mysql 9 0 17036 16M 2012 S 0.0 0.2 0:00 2 mysqld
> 5284 xxxxxxxx 9 0 2288 2244 2068 S 0.0 0.0 0:00 3 sshd
> 5538 xxxxxxxx 9 0 1292 1292 984 S 0.0 0.0 0:00 1 bash
>
> Now, I don't know if it's coincidental or not but after setting the query
> running and re-issuing the top command I get:
>
> 13:59:49 up 45 days, 11:51, 1 user, load average: 0.98, 0.61, 0.53
> 26 processes: 24 sleeping, 2 running, 0 zombie, 0 stopped
> CPU0 states: 75.0% user 25.0% system 0.0% nice 0.0% iowait 0.0%
> idle
> CPU1 states: 76.0% user 24.0% system 0.0% nice 0.0% iowait 0.0%
> idle
> CPU2 states: 63.0% user 36.0% system 0.0% nice 0.0% iowait 0.0%
> idle
> Floating point exception
>
> ^^^^^^^^^^^^^^^^^^^^^^^^ Does not look good to me !!
>
[snip]
I have now managed to get a top while the query is running:
14:29:52 up 45 days, 12:21, 1 user, load average: 0.69, 0.28, 0.39
25 processes: 23 sleeping, 2 running, 0 zombie, 0 stopped
CPU0 states: 71.1% user 28.0% system 0.0% nice 0.0% iowait 0.0%
idle
CPU1 states: 68.0% user 31.0% system 0.0% nice 0.0% iowait 0.0%
idle
CPU2 states: 71.0% user 28.0% system 0.0% nice 0.0% iowait 0.0%
idle
CPU3 states: 80.0% user 19.0% system 0.0% nice 0.0% iowait 0.0%
idle
Mem: 6203744k av, 5764148k used, 439596k free, 0k shrd, 257900k
buff
1839520k active, 3282316k inactive
Swap: 4192956k av, 1881496k used, 2311460k free 3687672k
cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
19462 mysql 14 0 19968 19M 2016 R 95.4 0.3 0:38 0 mysqld
25248 xxxxxxxx 10 0 1004 1004 748 R 0.3 0.0 0:00 3 top
1 root 9 0 468 440 420 S 0.0 0.0 2:58 1 init
1733 root 9 0 548 516 480 S 0.0 0.0 0:35 3 syslogd
2242 root 8 0 808 736 684 S 0.0 0.0 0:11 3 xinetd
3393 root 9 0 576 552 512 S 0.0 0.0 0:21 2 crond
15329 root 9 0 1284 1156 1088 S 0.0 0.0 0:27 0 sshd
3264 root 9 0 3676 1548 1500 S 0.0 0.0 0:37 1 httpd
15296 apache 9 0 10632 9608 4768 S 0.0 0.1 0:01 0 httpd
4576 apache 9 0 10036 8964 4344 S 0.0 0.1 0:01 3 httpd
8992 root 9 0 1000 1000 848 S 0.0 0.0 0:00 1
mysqld_safe
10433 mysql 9 0 19968 19M 2016 S 0.0 0.3 0:00 1 mysqld
11360 mysql 9 0 19968 19M 2016 S 0.0 0.3 0:00 2 mysqld
11395 mysql 9 0 19968 19M 2016 S 0.0 0.3 0:00 0 mysqld
11425 mysql 9 0 19968 19M 2016 S 0.0 0.3 0:00 2 mysqld
11456 mysql 9 0 19968 19M 2016 S 0.0 0.3 0:00 3 mysqld
11491 mysql 9 0 19968 19M 2016 S 0.0 0.3 0:00 2 mysqld
12128 mysql 9 0 19968 19M 2016 S 0.0 0.3 0:00 2 mysqld
12162 mysql 9 0 19968 19M 2016 S 0.0 0.3 0:00 0 mysqld
12193 mysql 9 0 19968 19M 2016 S 0.0 0.3 0:00 2 mysqld
12224 mysql 9 0 19968 19M 2016 S 0.0 0.3 0:00 0 mysqld
4769 xxxxxxxx 9 0 2288 2244 2068 S 0.0 0.0 0:00 2 sshd
5440 xxxxxxxx 9 0 1304 1304 992 S 0.0 0.0 0:00 1 bash
20257 apache 9 0 3876 1908 1788 S 0.0 0.0 0:00 2 httpd
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
