Classic self-hosted technical help

4,348 topics in this forum

1. 

   Server Setup, Optimization, And Repair

   April 2, 2007 by .CMANNS

   • 0 replies
   • 1.7k views

   Tweaks, please remember I didn't personally write these! Some may contain duplicate/conflicting tweaks! [*]Ineo: Getting max from your hardware. [*]Ineo: Server-level optimizations [*]Client Center KB: Changing Sessions table type to HEAP [*]Using Caching Methods I've been discovering other methods to speed up page views. Using Memcached Tell your sysadmin to install the memcached server set it to use 128mb ram or so and add this bit below in the conf_global.php, of course replace the info with your setup's. You'll also need the pecl memcache module. If you're running a cluster and the mysql server has a lower load I recomend to run memcached server on it. [*]…

   

   Last reply by .CMANNS, April 2, 2007
2. 

   High Server Load

   February 21, 2007 by Guest evoboy

   • 4 replies
   • 683 views

   Another question, sorry! Last night it looks like our dedicated server was attacked by hackers. No data has been lost but has made me notice other things! The forum has 250 odd members but is using up over 6 GIG of bandwidth!!!!!!!! What can I do to find out what's causing this or do I have to rely on my server hosts? Cheers :doh:

   

   Last reply by evoboy, February 21, 2007
3. 

   Tips For Larger Forums 1 2

   March 27, 2006 by Guest Sire_merged

   • 33 replies
   • 2.5k views

   One of my admins was just checking a new member who seemed to be trolling, and ran a search for posts made by the IP # which caused a backlog in mysql while the query ran. In the meantime, I created 2 new indexes which removed this long slow query from causing a bottleneck. It wasn't a huge deal before but now that we've got over 1 million posts it causes the server load to spike and mysql processes to wait for the query to finish. I took the board down briefly, and created 2 new indexes which solved this issue for us. create index ip_address on forums_posts(ip_address); create index ip_address on forums_members(ip_address); This worked well for us anyway. Are there…

   

   Last reply by bfarber, August 27, 2006
4. 

   Are "megathreads" An Issue On Ipb?

   August 10, 2006 by Guest JayX

   • 5 replies
   • 765 views

   On other boards I know they tend to close a thread down when it hits 1,000 posts... something IPB admins need to do, or is this not an issue due to the way the forum runs? I'm not sure the actual reason for this is.. extra server load?

   

   Last reply by Velvet Elvis, August 10, 2006
5. 

   Locked Tables (mysql) And High Server Load: Help!

   July 18, 2006 by Guest Fast Lane!

   • 4 replies
   • 760 views

   I notice that my server loads and memory have been spiking WAY high recently. I have php 4.4.2 and just upgraded to mysql 4.1.19. I have my my.cnf and httpd.conf tweaked and the mysqlreport program shows "a-ok" mysql performance. The issue is when the load (loads of 20+) and memory spike way high I noticed that the mysql and tcp connections sky rocket as well sometimes exceeding my mysql limit (which stops ipb from working). Very quickly after loads and memory return to normal (loads of 2-3). Here is a small portion of the output from the mysql command "show processlist;": (there are well over a hundred of these actually at a time) From the above it may indicate…

   

   Last reply by Fast Lane!, July 19, 2006