hi
just moved site to a larger server, everything went OK however when I start to import the site wont load, its as if the import is stopping the site from connecting to the database, as soon as the import has finished the site is OK. I am using the same systems as the old server, any ideas what could be wrong. Ther is only this script on this server so nothing else could be affecting it.
Thanks
Brent
Hi Brent,
This could be a function of the high performance of the server - if that's the case we can look at ways of preventing it from hogging the server, but first it would be wise to check the MySQL configuration for the maximum number of simultaneous connections. Here's a script to show your current MySQL configuration - run this from your Price Tapestry installation directory as it uses the database include to run the query:
mysqlconfig.php:
<?phprequire("includes/common.php");
$sql = "SHOW VARIABLES";
if (database_querySelect($sql,$rows))
{
print "<table border='1'>";
foreach($rows as $row)
{
print "<tr>";
print "<th align='left'>".$row["Variable_name"]."</th>";
print "<td>".$row["Value"]."</td>";
print "</tr>";
}
print "</table>";
}
?>
Check the values for max_connections - it should be around about 100...
Cheers,
David.