Large Size of MySQL Database

[SuchMuch]

Hi,
My forum consists of:
Members: 69
Discussions: 231
Messages: 1,714
MySQL database size is 347,7 Mb

It seems to me the MySQL database size is too large. What should be done to keep it optimized?

 

[rdn]

I guess your large tables are:
xf_search_index and xf_bb_code_parse_cache
and that's normal.

 

[SuchMuch]

I guess your large tables are:
xf_search_index and xf_bb_code_parse_cache
and that's normal.

How can I reduce those tables?

 

[SuchMuch]

By the way, could smiles be a reason of larger database size?

 

[Martok]

By the way, could smiles be a reason of larger database size?

No. Smilies are stored as files on your server, not in your database.

 

[SuchMuch]

Thnks Martok!

Should I ever be concerned about MySQL database maintenance? or should I leave it alone?

 

[Paul B]

How can I reduce those tables?

You can disable 'Cache BB Code output' in the options.

 

[SuchMuch]

You can disable 'Cache BB Code output' in the options.

Are these Xenforo Forum options or should they be disabled in PHPadmin panel? What affects disabling 'Cache BB Code output' will bring to the forum?

 

[Paul B]

It's an XF option in the ACP.

Disabling it won't cause any noticeable difference to the operation of the forum.
In some cases it can speed up displaying pages which have a lot of bb code.

 

[SuchMuch]

It's an XF option in the ACP.

Disabling it won't cause any noticeable difference to the operation of the forum.
In some cases it can speed up displaying pages which have a lot of bb code.

I checked it, this option was not enabled.

 

[Paul B]

There's likely not much more you can do to reduce the size then.
You could disable some of the logging options (APC -> Options -> Logging Options) but it's not going to make a significant difference.