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]