Everything seems fine except for this one query.
I'm not sure quite what the results of top will say or what they mean if
it's a Virtual Private Server environment?
Nothing untoward in /var/log/messages or var/log/httpd/error_log or virtual
host httpd logs.
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 !!
Comments?
Advice?
Thanks
Graham
> -----Original Message-----
> From: Jamie Kinney [mailto:[EMAIL PROTECTED]
> Sent: 11 November 2004 19:25
> To: Graham Cossey
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: Help with query performance anomaly
>
>
> How do the OS statistics look on both boxes. Do top, sar, vmstat or
> iostat show any CPU, memory or I/O performance issues? Does anything
> odd appear in the /var/log/messages file?
>
> -Jamie
>
> On Thu, 11 Nov 2004 18:42:48 -0000, Graham Cossey
> <[EMAIL PROTECTED]> wrote:
> >
> >
> > [big snip]
> >
> > >
> > > These are two different plans. Your development machine is using
> > > the index
> > > yr_mn_pc on the r table and is joining that table last. On your
> > > production
> > > server, the r table is joined second and is joined by the
> index PRIMARY.
> > > Let me know how the ANALYZE TABLE I suggested in a previous
> message works
> > > out to help the statistics.
> > >
> >
> > I have run ANALYZE on all tables on the live server and the result of
> > EXPLAIN is the same as before.
> >
> > Any further suggestions? I'm off to double check the create
> table stuff once
> > more...
> >
> > Thanks for your help (and patience!!)
> >
> > Graham
> >
> >
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
