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 query | Mike Spreitzer | 27 Jul |
• Re: idle query | Dan Nelson | 27 Jul |
• Re: idle query | Mike Spreitzer | 27 Jul |
• Re: idle query | Dan Nelson | 27 Jul |
• Re: idle query | Mike Spreitzer | 27 Jul |
• Re: idle query | Dan Nelson | 27 Jul |
• Re: idle query | Mike Spreitzer | 27 Jul |
• Re: idle query | Dan Nelson | 27 Jul |
• Re: idle query | Dan Nelson | 27 Jul |
• Re: idle query | Mike Spreitzer | 28 Jul |
• RE: idle query | Jerry Schwartz | 27 Jul |
• Re: idle query | Mike Spreitzer | 11 Aug |
• STRAIGHT JOIN vs. field names | Mike Spreitzer | 11 Aug |
• Re: STRAIGHT JOIN vs. field names | Michael Dykman | 11 Aug |
• Re: STRAIGHT JOIN vs. field names | Mike Spreitzer | 11 Aug |
• Re: idle query | Mike Spreitzer | 12 Aug |
• Re: idle query | MySQL) | 18 Aug |