Database querry number exceeded and dont understand why or how

[itfitz]

Every so often, and its happening more and more, I get this error or my website:

 

1226 - User 'lotions2_p_os1' has exceeded the 'max_questions' resource (current value: 50000)

 

delete from whos_online where time_last_click < '1152552330'

 

[TEP STOP]

 

My webiste gets approx 1300-1500 hits per month and tech support tells me that this resets itself every hour, so the numbers arent quite adding up, unless I am missing something.

 

Total hits for this month are 33645

Total pages are 3635

 

And this is for the month, so if the total pages are 33645 and I am allowed 50000 questions per hour, how can I be over?

My Hosting company (startlogic) told me that the only way to upgrade this would be to go to a dedicated server at $100 a month, which doesnt seem feesable for 1500 hits a month.

 

By the way, the domain is www.lotions2go.com

 

thanks,

shawn

[Guest]

The first task would be to output your current per page query count and optimize that.

 

The second task would be to create another MySQL user (if you host allows) and select a random credential at runtime.

[choosealogin]

This thread should help

 

http://www.oscommerce.com/forums/index.php?sho...119077&st=0

 

And this is an contribution to help you see the numbers of queries being executed

 

http://www.oscommerce.com/community/contri...,output+queries

 

Turning your "show category counts" off would cut quite a few.

[itfitz]

This thread should help

 

http://www.oscommerce.com/forums/index.php?sho...119077&st=0

 

And this is an contribution to help you see the numbers of queries being executed

 

http://www.oscommerce.com/community/contri...,output+queries

 

Turning your "show category counts" off would cut quite a few.

 

 

Ok:

 

I have installed the contrib, however, I cant find the folder where it puts it. It says the location is /var/log/www/tep/page_parse_time.log, but I cant find it.

 

thanks,

shawn

[choosealogin]

Actually, it will show you right at the bottom of the page.

 

In your admin panel, under configuration>>logging....

 

you can use the following settings...

 

Store Page Parse Time - false

 

Log Destination - this isn't important for this contribution

 

Log Date Format - leave it as is

 

Display The Page Parse Time - TRUE

 

Store Database Queries - false

 

Display The Page Parse Time - TRUE is the important one. Once you have the query output debug installed, and turn this setting on, you can see the query output at the bottom, like so

 

Current Parse Time: 0.294 s with 10 queries

 

Then, to see all of the other details. add ?output=1 to the end of your store url, such as

 

*http://yourstore.com/index.php?output=1

 

Then when the page loads next, it will have the query output details at the bottom, below your regular page content.

 

While it's doing that, only you can see that extra output. It will keep outputting everything like that until you turn it off by adding ?output=0 to the end of your the url.

[choosealogin]

Looks like you figured it out. The new update to that must output everything by default. :huh: ...so nevermind on the ?output=1 directions.

[muskokee]

ACK! Shawn, just went to your site. First thing...turn off category counts!! That should drop your queries in half.

 

Sheri

[itfitz]

Ok:

 

I get this error at the bottom:

 

Warning: error_log(/var/log/www/tep/page_parse_time.log): failed to open stream: No such file or directory in /home/lotions2/public_html/ecommerce/os/catalog/includes/application_bottom.php on line 22

Parse Time: 1.801s

Current Parse Time: 1.802 s with 239 queries

[itfitz]

alos, how do I disable the catagory counts? Where is it in admin?

[choosealogin]

To resolve this error, you have 2 choices, either turn off the logging...it's pretty much useless in my opinion, or create the file and specify the path to it. The contribution you installed takes the place of all that. You get much better info from that than the log.

 

admin>>configuration>>logging

 

Store Page Parse Time FALSE

 

Or, open up Notepad or something similar and save an empty text file, named page_parse_time.log and put it in a directory that is writeable. Then put the absolute path the that file in the log destination field (admin..configuration...logging).

 

The only thing that needs to be turned on now is "display the page parse time". Then you can see all the relevant info at the bottom of your catalog pages.

 

 

 

Ok:

 

I get this error at the bottom:

 

Warning: error_log(/var/log/www/tep/page_parse_time.log): failed to open stream: No such file or directory in /home/lotions2/public_html/ecommerce/os/catalog/includes/application_bottom.php on line 22

Parse Time: 1.801s

Current Parse Time: 1.802 s with 239 queries

[choosealogin]

Go to your admin panel >> configuration >> my store >>

 

Show Category Counts ...FALSE

 

And here is a very good thread, which includes instructions on how to properly set up the caching on a shared server. Caching will save a lot of queries too. :) ...but you need to be careful how you set it up, so read this...

 

http://www.oscommerce.com/forums/index.php?showtopic=131040

 

alos, how do I disable the catagory counts? Where is it in admin?

[itfitz]

Go to your admin panel >> configuration >> my store >>

 

Show Category Counts ...FALSE

 

And here is a very good thread, which includes instructions on how to properly set up the caching on a shared server. Caching will save a lot of queries too. :) ...but you need to be careful how you set it up, so read this...

 

http://www.oscommerce.com/forums/index.php?showtopic=131040

 

 

thanks, took it from 239 down to 93 just by disabling the catagoy counts. eliminated 146 and dropped the parse time down to .319 sec.

 

Still more to go though, I want it down to 20 or less and have read the other thread and will keep chugging along at it.

[choosealogin]

Great news. If you need more help, let me know. I worked on this recently and it became sort of a weird obsession...ok, I can eliminate one more :lol: ...ok, one more :lol:

 

I had the category counts off, but I started with 80 on the front page and got it down to 9. I don't have quite as much content and infoboxes like you do, but you should definitely be able to get down to 20. :thumbsup:

[itfitz]

Great news. If you need more help, let me know. I worked on this recently and it became sort of a weird obsession...ok, I can eliminate one more :lol: ...ok, one more :lol:

 

I had the category counts off, but I started with 80 on the front page and got it down to 9. I don't have quite as much content and infoboxes like you do, but you should definitely be able to get down to 20. :thumbsup:

 

 

Ok, I enabled the Cache and now its down to 53 queries. this is great. Now on the more difficult coding sutff.