List:General Discussion« Previous MessageNext Message »
From:Mike Spreitzer Date:July 27 2010 4:14am
Subject:Re: idle query
View as plain text  
Thanks for the clues.  In this case the storage is not on a SATA disk, 
rather is it on a GPFS (
http://en.wikipedia.org/wiki/IBM_General_Parallel_File_System) mount. This 
thing is capable of quite a lot more I/O bandwidth.  I invoked `wc` on a 
large file and it took the "bi" stat of `vmstat` over 16000.  The iostat 
utility is not installed there, I will look into that.

Regarding your suggestions how to improve, I suspect I will not be able to 
put fldrcv in a RAM table.  "SHOW TABLE STATUS" says the data_length of 
fldrcv is about 2 GB.  I will look into your other suggestions.

Thanks!
Mike Spreitzer

Thread
idle queryMike Spreitzer27 Jul
  • Re: idle queryDan Nelson27 Jul
    • Re: idle queryMike Spreitzer27 Jul
      • Re: idle queryDan Nelson27 Jul
        • Re: idle queryMike Spreitzer27 Jul
          • Re: idle queryDan Nelson27 Jul
            • Re: idle queryMike Spreitzer27 Jul
              • Re: idle queryDan Nelson27 Jul
            • Re: idle queryDan Nelson27 Jul
              • Re: idle queryMike Spreitzer28 Jul
    • RE: idle queryJerry Schwartz27 Jul
    • Re: idle queryMike Spreitzer11 Aug
      • STRAIGHT JOIN vs. field namesMike Spreitzer11 Aug
        • Re: STRAIGHT JOIN vs. field namesMichael Dykman11 Aug
          • Re: STRAIGHT JOIN vs. field namesMike Spreitzer11 Aug
      • Re: idle queryMike Spreitzer12 Aug
        • Re: idle queryMySQL)18 Aug