Servlet Web Hosting - MySQL, Java, JSP, Servlet, Tomcat, SSH Blog

316 CHAPTER 10 SECURING AND MAINTAINING PHPBB The bottom of the form contains the options for automatic pruning. To enable it, check the Enabled check box. You can set the maximum age (the default is seven days) and an interval for checking for topic age (the default is every day). Depending on how active you are about archiving topics and how much load your board takes, you may wish to adjust these settings. More frequent pruning will cause less of an immediate impact on your performance than pruning once over a long period of time. To save your changes, click Update. When an administrator visits a forum, the auto-pruning feature will see if it needs to be run. If so, it will check the posts and delete them automatically. Caution Auto-pruning occurs without warning. If you decide to enable this option in your forums, make sure you and your moderators regularly archive posts that you wish to keep, as you won t have any warning when phpBB is about to delete posts. If you are concerned about losing data in a forum, I recommend that you leave this option off and prune manually. Managing Your Database One of the most important tasks in administering phpBB is to keep your database healthy. The database is your bread and butter. Most databases do a fairly good job of taking care of themselves, but just like everything else, they require periodic maintenance. Keeping an eye on the database is quite important because when your database malfunctions, phpBB malfunctions, and your users won t like it one bit! Note This section of this chapter relies on phpMyAdmin for performing some of these tasks. Now is a good time to check with your host provider about the location of your phpMyAdmin (or equivalent) database administration tool, how to log in, and the extent of the functionality available to you. I reference phpMyAdmin 2.6.1 here. Optimizing and Repairing Database Tables Over time, heavily accessed tables in your database will accumulate some sort of overhead. Predictably, this overhead can slow down your database operations a bit, causing it to perform less than optimally. Figure 10-19 illustrates phpMyAdmin showing a table with overhead. Note the overhead of 100 bytes in this table. This is a minor occurrence, but it s worth optimizing anyway. Clicking Optimize table will fix the overhead. It s a good idea to check for this regularly in the
_posts table (where prefixrepresents the database prefix you selected during initial setup, usually phpbb), as that table is written to and Figure 10-19. phpMyAdmin read from incredibly frequently. You can easily optimize all tables that need work by viewing the full database (clicking looking at a table with the name of the database, in bolded black text, in the left
If you are in need for chaep and reliable webhost to host your website, our recommendation is http web server services.

This entry was posted on Wednesday, October 10th, 2007 at 2:10 pm and is filed under MySQL5. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.