Re: Static, 120GB, InnoDB table is unusuable
> 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.
Subject
Views
Written By
Posted
2312
June 01, 2013 09:24AM
831
June 01, 2013 09:49PM
891
June 01, 2013 10:51PM
1011
June 01, 2013 11:29PM
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.