From: Andrés Tello Date: August 6 2010 3:27pm Subject: Re: Moving from one MySQL server to three MySQL servers? List-Archive: http://lists.mysql.com/mysql/222454 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=00151748db02414f8a048d294ee7 --00151748db02414f8a048d294ee7 Content-Type: text/plain; charset=ISO-8859-1 Any kind of optimization you need works. I would use a explain sql statements istead to import without indexes, that will shed more light... Even if u optimize the report, if you have concurrent access demanding a bunch load of data you will other operations get stuck... for that is a good reason to have a master/write server and slave/read servers... if you make a row level block or table level block at a slave/read server, master/write still can work. And mysql is kinda greedy with the ram once it has it. Tries to keep index information, select cache, etc, as long as possible, which is a good thing... and if the client is willing to trow more hardware to the issue, trow more RAM to those servers... --00151748db02414f8a048d294ee7--