List:General Discussion« Previous MessageNext Message »
From:Nick Adams Date:June 14 2008 2:03am
Subject: Re: Very slow inserts into InnoDB tables
View as plain text  
hdparm -Tt /dev/sdX     ?

Ian Simpson wrote:
> That's pretty much what I've been doing to get that the drive is running
> at 100% bandwidth.
> 
> What I'd like is something that just gives the bandwidth of the device
> in terms of Mb/s: you can probably work it out using that iostat
> command, seeing how much it wrote and what percentage of the bandwidth
> it's using, and then doing a calculation with those numbers to get the
> 100% value, but I don't know if that's valid, since there are generally
> a number of other operations going on at the same time.
> 
> Thanks
> 

Thread
Very slow inserts into InnoDB tablesIan Simpson13 Jun
  • Re: Very slow inserts into InnoDB tablesAlex Arul Lurthu13 Jun
    • Re: Very slow inserts into InnoDB tablesIan Simpson13 Jun
      • Re: Very slow inserts into InnoDB tablesAnanda Kumar13 Jun
        • Re: Very slow inserts into InnoDB tablesAlex Arul Lurthu13 Jun
          • Re: Very slow inserts into InnoDB tablesIan Simpson13 Jun
            • Re: Very slow inserts into InnoDB tablesAlex Arul Lurthu13 Jun
            • RE: Very slow inserts into InnoDB tablesJerry Schwartz13 Jun
              • RE: Very slow inserts into InnoDB tablesIan Simpson13 Jun
                • RE: Very slow inserts into InnoDB tablesJerry Schwartz13 Jun
                  • RE: Very slow inserts into InnoDB tablesIan Simpson13 Jun
                    • RE: Very slow inserts into InnoDB tablesWm Mussatto13 Jun
                      • RE: Very slow inserts into InnoDB tablesIan Simpson13 Jun
                        • Re: Very slow inserts into InnoDB tablesNick Adams15 Jun