GNU Info

Info Node: (mysql.info)Design Limitations

(mysql.info)Design Limitations


Next: Portability Prev: Optimize Overview Up: Optimize Overview
Enter node , (file) or (file)node

MySQL Design Limitations/Tradeoffs
----------------------------------

Because MySQL uses extremely fast table locking (multiple readers /
single writers) the biggest remaining problem is a mix of a steady
stream of inserts and slow selects on the same table.

We believe that for a huge number of systems the extremely fast
performance in other cases make this choice a win. This case is usually
also possible to solve by having multiple copies of the table, but it
takes more effort and hardware.

We are also working on some extensions to solve this problem for some
common application niches.


automatically generated by info2www version 1.2.2.9