MySQL Forums
Forum List  »  Performance

Re: Static, 120GB, InnoDB table is unusuable
Posted by: Rick James
Date: June 02, 2013 08:33PM

> if I were to use multiple connections on the client side and make read-only requests, would MySQL run the read requests sequentially or would it allow multiple simultaneous reads on a table?

Short queries -- not worth the code complexity.

Long queries -- Does your application language let you do multiple threads? If not, there is no way in the mysql API for you to say "Start this SELECT, but return control before it finishes".

Long queries -- you _might_ get some benefit.

Long queries -- If they are I/O bound, then the I/O might be the limiting factor, thereby effectively not getting much parallelism.

But, it you have quite a few users, you already have some parallelism.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Static, 120GB, InnoDB table is unusuable
975
June 02, 2013 08:33PM


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.