Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2010
    Posts
    5

    Unanswered: insert is slower when DataFile size increases

    Hi,
    I have a noticed the following behavior...
    when the DB is clean and fresh... our DB handles a very high rate of inserts (~1200 per second), butwith time, when the datafile (think thats the reason but might be any other thing... maybe indexes?) increases - the rate is going down. Right now the rate of inserts per second is around 500 per second (around 40% from the starting rate).
    Does anyone has any idea why is that happen? How can I solve that problem?
    Thanks,
    Ori Raz

  2. #2
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    Is your data being inserted in order? Do you need to occasionally reorg the object?
    Dave

  3. #3
    Join Date
    Feb 2010
    Posts
    5
    Thanks for the fast reply...
    but in both cases my answer will be negative...
    I insert the data with regular insert - no ordering.
    There is no reorg on the object
    once in a while (user request) there is a query to get info from table, but even without it the rate is going down...
    Thanks,
    Ori

  4. #4
    Join Date
    Oct 2009
    Posts
    3
    Hi !
    What version of MySQL are you using , and what Storage Engine ?
    Is it possible to post an EXPLAIN and if possible a SHOW PROFILE ALL of your queries ?

    Thanks !

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •