问新的MySQL服务器比旧的慢

EN

key_buffer              = 128M
max_allowed_packet      = 16M
thread_stack            = 192K
thread_cache_size       = 8
max_connections         = 350 
read_rnd_buffer_size    = 2M
read_buffer_size        = 1M
sort_buffer_size        = 2M
join_buffer_size        = 3M 
bulk_insert_buffer_size = 8M
table_open_cache        = 4096
table_definition_cache  = 2048 
thread_cache_size       = 32
max_heap_table_size     = 64M 
tmp_table_size          = 64M 
query_cache_limit       = 4M
query_cache_size        = 128M

default-storage-engine  = innodb
innodb_buffer_pool_size = 81920M
innodb_additional_mem_pool_size = 20M
innodb_buffer_pool_instances = 4 
innodb_log_file_size    = 256M  
innodb_log_buffer_size  = 4M 
innodb_thread_concurrency = 12
innodb_flush_method     = O_DIRECT  
innodb_flush_log_at_trx_commit = 2  
innodb_file_format      = barracuda
innodb_support_xa       = 0         
innodb_file_per_table   = true
innodb_max_dirty_pages_pct=75 
innodb_read_io_threads  = 8
innodb_write_io_threads = 8
innodb_io_capacity      = 500

SELECT 
sql_calc_found_rows 
Q.*,D.MktDlrCode,GetLastOrder(Q.CustId,D.StoreId,Q.Timestamp) As       LastOrder
FROM 
((SELECT
Zonal.ID,Zonal.CustId,Zonal.SID,'' As  Lane,Zonal.RFIDtag,ANT.Antenna,ANT.Location,ANT.Direction,Timestamp,DATE_FORMAT(Timestamp,'%c/%d/%y %l:%i:%s %p') As DateTimestamp
FROM Portal.Log_RFID_Zonal As Zonal 
INNER JOIN Portal.Log_RFID_Antennas As ANT ON
ANT.Antenna=Zonal.LocationCode AND
ANT.SID=Zonal.SID AND
ANT.IgnoreFlag=0
WHERE
Zonal.Timestamp>=STR_TO_DATE('08/01/2015','%m/%d/%Y') AND
Zonal.Timestamp<DATE_ADD(STR_TO_DATE('08/01/2015','%m/%d/%Y'), INTERVAL 1     day)
ORDER BY Zonal.Timestamp DESC
)
UNION
(SELECT
RFID.ID,RFID.CustId,RFID.SID,RFID.Lane,RFID.RFIDtag,ANT.Antenna,ANT.Location,ANT.Direction,Timestamp,DATE_FORMAT(Timestamp,'%c/%d/%y %l:%i:%s %p') As DateTimestamp
FROM Portal.Log_RFID_WebService As RFID 
INNER JOIN Portal.Log_RFID_Antennas As ANT ON
ANT.Antenna=RFID.LocationCode AND
ANT.SID=RFID.SID AND
ANT.IgnoreFlag=0 
WHERE
RFID.Timestamp>=STR_TO_DATE('08/01/2015','%m/%d/%Y') AND
RFID.Timestamp<DATE_ADD(STR_TO_DATE('08/01/2015','%m/%d/%Y'), INTERVAL 1 day)
ORDER BY RFID.Timestamp DESC
)
ORDER BY
Timestamp DESC
) As Q
INNER JOIN Stores As D ON
D.StoreId=Q.SID AND
D.ReportFlag=1
LIMIT 0,25;

Id SelType      Table        Type    Key       Rows    Extra
1 PRIMARY      <derived>    ALL               300     Using where;Using Index
1 PRIMARY      D            ref     StoreId   1       Using Where
2 DERIVED      Zonal        range   ix1       6368    Using where
2 DERIVED      ANT          eq_ref  PRIMARY   1       Using where
3 UNION        RFID         range   ix1       938     Using where
3 UNION        ANT          eq_ref  PRIMARY   1       Using where
  UNION RESULT              ALL               0       Using filesort