XF 1.5 Is it normal to have a database size of 900mb for 340 user forum?

[TheVingard]

Is it normal to have a database size of 900mb for 340 user forum? My database grew by 100MB in about two days.

 

[Paul B]

It depends on the content and options.

Use phpMyAdmin and sort on the table size to see which tables are the largest.

 

[TheVingard]

It depends on the content and options.

Use phpMyAdmin and sort on the table size to see which tables are the largest.

I would if PhpAdmin didn't give me a 500 error as my database is too big.

 

[Chris D]

I would get on to your host about that.

I've used PhpMyAdmin on databases that are in excess of 50GB in size with no problems.

 

[TheVingard]

I would get on to your host about that.

I've used PhpMyAdmin on databases that are in excess of 50GB in size with no problems.

Seems to be xf_search, is it ok to drop the contents of it?

 

[Paul B]

That table should be cleared out periodically.

There must be a significant number of searches occurring for it to be a very large size.

You can truncate it.

 

[Chris D]

Searches older than one day are cleared out every 24 hours automatically.