I upgraded to Mysql 5.0.42 from 4.1.14 yesterday. Afterwards, a query the I
run every day to capture data on nodes that have increased backup load the
most in TSM, seems to be ignoring my "order by" statement. Here is the query
and the output:
mysql> select occupancy.node_name as NodeName,nodetrend.occupancy/1024 as
"Occupancy on 09/24/2006 (GB)",sum(occupancy.physical_mb)/1024 as "Occupancy
Today (GB)",(sum(occupancy.physical_mb) - nodetrend.occupancy)/1024 as
"Occupancy Increase (GB)" from nodetrend,occupancy where
nodetrend.date="2006-09-24"
and occupancy.stgpool_name='BACKUPPOOL' and
nodetrend.node_name=occupancy.node_name group by occupancy.node_name order
by "Occupancy Increase (GB)" desc limit 10;
+-------------+------------------------------+----------------------+-------------------------+
| NodeName | Occupancy on 09/24/2006 (GB) | Occupancy Today (GB) |
Occupancy Increase (GB) |
+-------------+------------------------------+----------------------+-------------------------+
| AMHFP01 | 213.378672 | 188.096826|
-
25.281846 |
| AMHFP01-S | 15.284570 | 25.520684|
10.236113 |
| AMHROCP01 | 8.740791 | 15.711035|
6.970244 |
| ANDYC | 2.503848 | 2.503848|
0.000000 |
| BHSCAFAS01 | 7.057617 | 11.109980|
4.052363 |
| BJC11101828 | 5.401748 | 3.433613|
-
1.968135 |
| BJC11113758 | 15.911094 | 15.911094|
0.000000 |
| BJCAMSQL01 | 72.650596 | 102.609326|
29.958730 |
| BJCAMWEB01 | 3.703057 | 8.468467|
4.765410 |
| BJCBCA01 | 22.580410 | 33.760918|
11.180508 |
+-------------+------------------------------+----------------------+-------------------------+
10 rows in set (0.24 sec)
Any suggestions? I can try backing off to 5.0.41 if anyone thinks that would
help.
Thanks
--
Andy Carlson
---------------------------------------------------------------------------
Gamecube:$150,PSO:$50,Broadband Adapter: $35, Hunters License: $8.95/month,
The feeling of seeing the red box with the item you want in it:Priceless.
