List:Cluster« Previous MessageNext Message »
From:Stewart Smith Date:November 1 2010 12:15pm
Subject:Re: Very Slow Insert Performance
View as plain text  
On Tue, 05 Oct 2010 03:00:32 +0700, Reza Iskandar Achmad <reza@stripped>
wrote:
> We're performing a database import from standalone MySQL to Cluster. The
> import procedure is using dump file. The problem is insert is very slow,
> takes ages to finish.
> 
> Our Cluster is in Gigabit Network, RAID 5 disks, nbdmtd. How can I
> investigate and find the solution for this situation?

Insert in parallel. A mysqldump is just going to be executed as a single
thread doing one insert after the other.

maatkit has parallel dump and restore for SQL.

you will have to make sure your cluster is configured to be able to take
the write load too.

-- 
Stewart Smith
Thread
Very Slow Insert Performance Reza Iskandar Achmad4 Oct
  • Re: Very Slow Insert PerformanceStewart Smith2 Nov
Re: Very Slow Insert PerformanceReza Iskandar Achmad5 Oct
  • Re: Very Slow Insert PerformanceJohan Andersson5 Oct
    • Re: Very Slow Insert PerformanceReza Iskandar Achmad8 Oct