1 (edited by Ole Juul 2013-03-19 08:11)

Topic: MySQL database unproportionally large

I'm running PunBB 1.3.4 and MySQL Improved 5.0.95 and I notice that on this very low traffic forum that the database is much larger than any of my other databases. There are not very many posts, yet the "posts" table is 48.1MB for only 112 records.

What could be causing this and what can I do to fix it?

Two other tables are very large. Search_matches is 48MB with 12,448 records. Also "search_words" is 14MB with 10,040 records. What are those tables for anyway?

2

Re: MySQL database unproportionally large

Have you extensions installed?
Search_ tables are responsible for the Search function. A solution may be Google search engine integration with PunBB.