PhpDig.net

Go Back   PhpDig.net > PhpDig Forums > Troubleshooting

Reply
 
Thread Tools
Old 10-09-2003, 12:15 AM   #1
druesome
Orange Mole
 
Join Date: Oct 2003
Posts: 30
Unhappy MySQL Connections

Hi again... this wouldn't exactly count as a 'troubleshooting' message... but anyway, i'm currently under a hosting plan that measures my mysql usage. and last check i made, i've exceeded my monthly limit and racked up $50 in charges!!! well, the only suspect this points to is phpdig (but i don't blame you, this is a great software!)... my question is, does the spidering process involve a lot of database connections? Here is my host's take on it:

Quote:
Generally, we include from 5 to 30 million conueries a month. If you require more, each extra million (per month) costs $5. However, you may upgrade your plan at any time to get more conueries whenever you'd like to avoid any overage charges.

We've instituted these limits in order help insure quality database service to all of our users. If you have heavy database requirements for your site, please contact our Support Team and let them know, and we'll do our best to work with you towards a long-term cost-effective solution for your site.
What should I do now? I want to continue using this software without paying extra! Is PhpDig too good to be true? Hope to hear from all of you. Thanks..
druesome is offline   Reply With Quote
Old 10-09-2003, 07:23 AM   #2
rayvd
Green Mole
 
Join Date: Oct 2003
Location: Mesa, AZ
Posts: 15
Well, I just ran phpdig for the first time on a one moderately sized site last night. 630,000 queries. There are quite a few that happen when keywords are inserted into the database (one query per keyword), so multiply that times the number of pages and the avg number of words per page and it can add up.

I would think this would be fairly typical of any spidering software using keywords in a relational database like MySQL.
rayvd is offline   Reply With Quote
Old 10-09-2003, 11:40 AM   #3
druesome
Orange Mole
 
Join Date: Oct 2003
Posts: 30
D*mn, this is really sad. I guess what I should do now is to make a strict and conservative spidering schedule then. I've contacted my webhost about this problem.... will keep you updated. Thanks.
druesome is offline   Reply With Quote
Old 10-09-2003, 05:34 PM   #4
Charter
Head Mole
 
Charter's Avatar
 
Join Date: May 2003
Posts: 2,539
Hi. This is not anything against your host - they could be the best in the world for all I know - but you might try checking out Servlets.com for written reviews about some other hosting companies.
__________________
Responses are offered on a voluntary if/as time is available basis, no guarantees. Double posting or bumping threads will not get your question answered any faster. No support via PM or email, responses not guaranteed. Thank you for your comprehension.
Charter is offline   Reply With Quote
Old 10-10-2003, 01:18 AM   #5
druesome
Orange Mole
 
Join Date: Oct 2003
Posts: 30
Hi Charter, I guess you've figured out who my host is on your own. Actually if you just search for the word conueries in Google you'll know instantly since they claim to have invented the word.

Right now, moving to another host is out of the question, since I have done so much and just the idea of it sounds like a nightmare. I have contacted my webhost and told them that it was deceitful of them not to have informed us about these conueries. I have been with this webhost for five years but I have yet to receive or read an announcement concerning this issue. I also stated that I will not pay the $50 they have charged me until we have settled this issue amicably.

In the meantime, I am trying to find out ways to reduce the number of connections involved in my spidering. I've read about 'persistent connections' but I really don't know how to go about it with phpdig. Any ideas? Thanks..
druesome is offline   Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL smallint(6)... Maskime Mod Submissions 0 03-28-2008 07:52 AM
MySQL Question jackpod How-to Forum 1 09-21-2006 09:30 PM
Problem with MySQL 4.1 machek Bug Tracker 0 08-05-2006 04:28 AM
Error Mysql noel Troubleshooting 3 11-01-2005 04:41 PM
Reduce number of connections druesome Troubleshooting 1 10-14-2003 08:42 AM


All times are GMT -8. The time now is 07:48 AM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright © 2001 - 2005, ThinkDing LLC. All Rights Reserved.