Hosting for multiple Pligg sites

[cmiddlebrook]

I have 21 sites build on Pligg and I am struggling with my server host that hosts them. They get quite a lot of traffic and that tends to hammer MySql quite heavily but I have recently upgraded to a dedicated server which is an i7 processor & 8 Gb Ram but it still has problems hosting the sites.

Does anyone else host a lot of sites and if so, which hosting company do you use and what kind of server spec do you have? I have a feeling it is just a problem with the company I am using because they support system seems very poor but they keep trying to tell me that the sites are simpy doing too much yet I am having a hard time believe that this high spec server can't handle 21 pligg sites! My sites get around 500 submissions a day on average.

[UnderDogg]

I have a feeling it is just a problem with the company I am using because they support system seems very poor but they keep trying to tell me that the sites are simpy doing too much

Unfortunately the truth is right in the middle, meaning that Pligg has some queries that can cause heavy load on the servers.
Here's 1 thread about it:
SQL Query Caused the Load on Server
(only shows the SQL query, but you'll get the idea)
Here's another thread:
Pligg Page Load Speed Issue
Unfortunately the real solution is figuring out which exact queries cause the heavy load on the server and then try to make the load on the server less impact.

I do have a piece of code for a Database class, but it doesn't fit the current class at the moment.
Therefore it's semi-code:

$limit_query_time = '0.001'; //change this value if necessary
        $query_time = 0;
        $query_error = NULL;
        $query_message = NULL;

// You need a timer class for this piece of code
            $this->startTime('query_time', false);


            $result =& mysql_query($sql, $this->conn);


            $this->stopTime('query_time');

            $query_time = sprintf('%f', $this->dumpTime('query_time'));

// So ... now you know how long the query took        

        if ($query_time > $limit_query_time)
        {
            $query_error = sprintf('QUERY TAKING MORE THAN %f SECONDS',$limit_query_time);
            $query_message = $query_time;
        }

You can also put those long queries into a log. Thing is that you need to analyze the query (use MySQL DESCRIBE statement) and then post on the forum

[cmiddlebrook]

Surely though, with a CMS as well established and developed as Pligg, if there was a simple query optimisation that could be done it would have already been done by the developers? My host tech guys keep saying the same kind of thing - the code must be buggy or you have an inefficient script but if that's the case then surely nobody would be able to host more than a handful of sites and that's what I am having trouble believing.

So, I want to know if there are other people out there who host multiple standard Pligg sites on a single server without issue. Surely that's possible?

[Yankidank]

Could you PM me login details to your server root? We may be able to have someone analyze your sites so that we could take a look at what bits need to be optimized. Then we could apply any changes to the next release to try to address some of the queries.