XenForo
Administrative
- Thread starter
- Admin
- #1
Just stumbled across the InnoDB Row_format setting.
Anyone running row_format=compressed?
row_format=compact is the default for legacy reasons, and looks like there's nothing but upside to switching to 'Dynamic'.
For VPS servers which are tight on RAM but plenty of CPU, read-heavy workloads, and text-heavy tables, seems like it might beneficial to switch to 'Compressed' because you can stick more of your DB in the buffer pool.
Curious if anyone's actually tried this in...
Read more
ادامه مطلب...
Anyone running row_format=compressed?
row_format=compact is the default for legacy reasons, and looks like there's nothing but upside to switching to 'Dynamic'.
For VPS servers which are tight on RAM but plenty of CPU, read-heavy workloads, and text-heavy tables, seems like it might beneficial to switch to 'Compressed' because you can stick more of your DB in the buffer pool.
Curious if anyone's actually tried this in...
Read more
ادامه مطلب...