Re: Load Data slowing down the server
You could try to reduce some cache sizes and max_heap_table_size. The latter has to do with temporary tables created during joins. If this size is exceeded, the result tables are converted into MyISAM tables. So you use less memory but more I/O.
Ingo Strüwing, Senior Software Developer - Storage Engines
MySQL AB, www.mysql.com
Subject
Views
Written By
Posted
2644
May 16, 2006 08:35AM
1620
May 16, 2006 07:02PM
1585
May 18, 2006 09:31AM
Re: Load Data slowing down the server
1513
May 22, 2006 04:03AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.