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

  • From: Coalmont, BC, Canada
  • Registered: 2010-04-15
  • Posts: 129

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?

Ole Juul's Website

2 Reply by Trace

  • Trace
  • Trace
  • PunBB senior member
  • Offline
  • Registered: 2012-07-01
  • Posts: 560

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.