[RSS Feed/News] Compress some tables?

Status
Not open for further replies.

XenForo

Administrative
  • Thread starter
  • Admin
  • #1
@Chris D
From the point of view of the XF developers, does something speak against using the following in MySQL?
Is this possible?

innodb_file_per_table = ON
innodb_file_format = Barracuda
ALTER TABLE xf_post ROW_FORMAT = COMPRESSED KEY_BLOCK_SIZE = 8;

stackoverflow.com

MySQL row_format compressed vs dynamic

I've changed "innodb_file_format" from "Antelope" to "Barracuda" bcoz of following reasons. To avoid row size limit To avoid column index size limit While doing file format change i chosen "row_...
stackoverflow.com
stackoverflow.com


ادامه مطلب...
 
Status
Not open for further replies.
Back
Top Bottom