Hi, I have a question about how to optimize MySQL performance for a somewhat unusual (I think) usage pattern.
In the first process, I'm summarizing a large amount of time series data (the main table will end up around 5GB, index around 1/3 of that) and storing the summaries to the db. During this period, no reads to the summary tables will occur. In another process, I'm reading the summaries and no writing occurs. I have a reasonable amount of RAM (1GB) and the system is dedicated to the db task. What is the best way to optimize these processes? Using HEAP tables seems to be out because they won't fit completely in memory. How best to take advantage of the no reading/no writing? Thanks, -David --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
