.

MySql design separates query processing with storage engine. MySql design has 3 layers. connection handling,query processing,storage engine Each connection gets its own thread from server and these threads are cached. MySQL parses queries and creates an internal structure(parse tree) and also caches the results of this query. locks types. read locks and write locks.read locks are shared,write locks ar exclusive. If the system spends too much time managing locks instead of storing and retrieving data,performance can suffer. write locks have higher priority than read locks. Lock granularity is an important decision in storage engine design.Ex: table locks ,row locks,row with mvcc In multi version concurrency control(MVCC) mechanism , a snapshot of the data is created and versioned. Isolation levels ,read_uncommitted,read_committed,read_repeatable,serializable. Transaction logging helps to make the requested changes in memory and transmit the changes to the actual storage later.As I/O t

http://www.wisebread.com/can-you-afford-to-follow-your-dreams-can-you-afford-not-to teach and learn,create and earn

Bangalore 719 Rajshekar Hospital # 21 9th Cross Ist Phase J P Nagar Bangalore - 560078 Bangalore 560078 Karnataka 080 - 26911804 /080 - 26642164 /080 - 26911804 26630987 1092 RAJALAKSHMI MULTISPECIALITY HOSPITAL 76-1-1, V R Layout 1st Phase, J P Nagar Bangalore 560082 Karnataka 080 26340729 22457277 1300 Green city hospital 726 17th cross , 6th phase J P nagar Bangalore 78 Bangalore 560078 Karnataka 080 26536222,26536765 41722379 Hyderabad 24 Adithya Hospital Bogulkunta Tilak Road  Hyderabad - 500001 NULL Hyderabad 500001 Andhra Pradesh 040 - 23316494 24754117 58 Apollo Amar Hospitals Basherbagh NULL Hyderabad NULL Andhra Pradesh 040-23223402 / 23222142 NULL 61 Apollo Emergency Clinic Kukatpally NULL Hyderabad NULL Andhra Pradesh 040-23160039 / 23160040 23160040