Optimize Your Database

Weblog Tools Collection has a tip for optimizing your WordPress database tables. As Mark mentions several times, backup your data first.

My database currently holds 1,174,948 records and is 167 MB. I don’t use any spam recording plugins so this does not include any spam records. It’s mostly traffic stats. Crazy.

Categories: WordPress Tips

Comments

  1. Zo says: 4/6/2005

    Yeah, traffic stats are horrible. Go third party for traffic, man. Too much time and energy goes into massive backups of stats.

  2. John says: 4/6/2005

    Who do you suggest? I have tried a few of the free ones but they usually have traffic limits.

  3. Mark says: 4/7/2005

    I use nedstat(Free) for long term stats and Statcounter (free but has limits) for short term analysis.