Speed issue/mySQL

[Don Chambers]

Thanks again for the explanation guys.

Judebert - my s9y IS in the root of my domain. The directory /stats/ is password protected and the contents of that directory were placed there by godaddy, not me. I might be able to get a .htaccess file in there, but I do not want to open any security hole. Is that one line suggestion of yours going to cause any problems?

Also - I do not see a server stats tab in myphpadmin... I suspect they do not make that available for their shared server customers.

Garvin - thanks for the explanation. It is impossible that 30-50 people would be hitting my site simultaneously. It isn't really a normal blog!!! ) However, godaddy seems to be suggesting that maybe connections are not being closed properly. Is this possible?

I'll try to get some access stats once I get this .htaccess thing figured out.

[garvinhicking]

Hi!

Garvin - thanks for the explanation. It is impossible that 30-50 people would be hitting my site simultaneously. It isn't really a normal blog!!! ) However, godaddy seems to be suggesting that maybe connections are not being closed properly. Is this possible?

As explained, connections via PHP can only be shared via persistent connections. Since you don't use them, there should be no way that after a PHP request a connection is not closed.

See here:

http://de.php.net/mysql_close

Using mysql_close() isn't usually necessary, as non-persistent open links are automatically closed at the end of the script's execution. See also freeing resources.

You can quote that to your support

Best regards,
Garvin

[Don Chambers]

Thanks again Garvin. I passed along your info to tech support. They completely sidestepped the issue and, despite repeated requests, have never provided me with a way to determine the number of concurrent connections. They claimed all along that was the problem, yet will not supply any evidence to back up the claim.

However, since first reporting a problem, I have noticed my speed issues have been completely eliminated. They claim to have discovered no problem on their side, but they definitely changed something!! If it wasn't for their Superbowl commercials, I would probably use a different host!

[judebert]

No, the .htaccess shouldn't cause a security hole. Make sure you check for an existing .htacess, though. If it's there, and it doesn't have any RewriteRule lines, just add the one-liner at the top.

[Don Chambers]

I'm a little between a rock and a hard place here. There is no .htaccess file in that directory yet.... however, the only way to get one there at the moment, is to "publish" the file via MS Frontpage. I have been systematically removing all FrontPage functionality from my site, but I still have a few minor things to get fully into s9y.

FrontPage has no way to set permissions, and that is necessary for me to get anything into this particular directory. I cannot FTP anything to my site because doing so will break everything about the site that is FrontPage.

One final problem is that the entire contents of the directory /stats/ is overwritten every day, which means I would need to write the .htaccess file every time I wanted to view the stats!!!

Is there any way to accomplish my objective just using the .htaccess file in my root, which I have complete access to??

[judebert]

I'd be a little surprised if the .htaccess was overwritten in the stats/ directory, but I suppose it could happen.

Regardless, try adding this at the top of your .htaccess in the main directory:

Code: Select all

RewriteRule /stats/.* - [L]

Essentially, this says that if the URL starts with /stats/, do no substitution and stop checking rules. Make sure it comes before any other RewriteRule or RewriteCondition line in the file.

I can't guarantee it'll work, but it's worth a shot.

[Don Chambers]

Thanks Judebert. I found another way to get to my stats without any of this .htaccess stuff. I appreciate your followup though!

[judebert]

Anything we can pass on to other readers, or something specific to your webhoster?

[Don Chambers]

Sorry about that Judebert - you are right, I should have specifically said what it was.

Go daddy tells their customers that you need only hit your domain at www.yourdomain.com/stats/. Even trying to launch your stats from your account page on godaddy's site will only supply this path to the stats directory. As discussed above, s9y will redirect that request back to my homepage.

However, if I hit www.mydomain.com/stats/index.html, all is good and no .htaccess modifications are necessary.