As many probably already know, PBXT is the first MySQL Storage
Engine to use a log-based architecture. Log-based means that data
that would normally first be written to the transaction log, and
then to the database tables, is just written to the log, and the
log becomes part of the database.
This result is that data is only written once, and is always
written sequentially. The advantage when writing is obvious, but
there is a down side (as always). The data is written to the disk
in write order, which is seldom the order in which the data is
retrieved. So this results in a lot of random reads to the disk
when accessing the data later.
Placing the data logs on a Solid State Drive would solve this
problem, because SSDs have no seek time. But the problem with
this solution is that SSDs are still way to expense to base all
your storage needs on such hardware.
The solution: an SSD-based 2nd Level Cache.
…
Showing entries 1 to 1
Jul
16
2010
Showing entries 1 to 1