Zen Cart Logo
Forums / General Questions / Adding more mysql users to avoid query limit by host?

Adding more mysql users to avoid query limit by host?

Locked

Views: 2,407

Results 1 to 6 of 6
This thread is locked. New replies are disabled.
24 Oct 2009, 7:11 PM
#1
surplusoutlet avatar

surplusoutlet

New Zenner

Join Date:
Jun 2007
Posts:
11
Plugin Contributions:
0

Adding more mysql users to avoid query limit by host?

Hello,
Using 1.3.8a version through IPower hosting with mysql 5.0

I am finding we are running into issues with the website slowing down. Upon investigating, I learned that IPower have limits to mysql queries per user.
**
The maximum number of database queries per user is 75,000 per hour.**

I asked if creating multiple users for different functions would work, and they said yes.

Has anyone broken down the admin from the public with two different users to access mysql, or know how to?

24 Oct 2009, 7:22 PM
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Adding more mysql users to avoid query limit by host?

I asked if creating multiple users for different functions would work, and they said yes.
Well as they agreed, it woul seem best to aske them how...

24 Oct 2009, 8:08 PM
#3
cjpinder avatar

cjpinder

Totally Zenned

Join Date:
Apr 2007
Location:
Herts. UK
Posts:
893
Plugin Contributions:
0

Re: Adding more mysql users to avoid query limit by host?

If you look here...
http://www.zen-cart.com/forum/showpost.php?p=144728&postcount=2
...you'll find a post by DrByte detailing how to use multiple MySQL users with Zen Cart.

Regards,
Christian.

26 Oct 2009, 5:09 PM
#4
surplusoutlet avatar

surplusoutlet

New Zenner

Join Date:
Jun 2007
Posts:
11
Plugin Contributions:
0

Re: Adding more mysql users to avoid query limit by host?

Perfect!
Will try that.

26 Oct 2009, 8:41 PM
#5
peytonrm avatar

peytonrm

New Zenner

Join Date:
Jun 2008
Location:
Morrisville, NC
Posts:
47
Plugin Contributions:
0

Re: Adding more mysql users to avoid query limit by host?

Additionally, if you have some programmers available, you might want to have them look at ways to reduce redundant or unnecessary queries.

From having looked at the code myself, I'm positive a skilled programmer could eliminate quite a few queries in only a day or two of work. This would give you a more scalable solution, speed up the store in general, and prevent problems with having too many mysql users that you will eventually run into if you simply keep adding more users.

6 Dec 2009, 1:37 PM
#6
earnest_enterprises avatar

earnest_enterprises

New Zenner

Join Date:
Oct 2009
Location:
Great Northwest
Posts:
80
Plugin Contributions:
0

Re: Adding more mysql users to avoid query limit by host?

I have run across the same issue where my host imposed the 75,000 queries per hour and my store was flat shut down. Could not access the store or my Zen admin. Continued to get the db error of exceeding the query limit. Funny thing is this host OFFERS Zencart as an installable ecommerce option in their cpanel.

I implemented Dr. Byte's fix noted in this thread and it worked perfectly. One thing to note is Dr. Byte mentions making the fix only to the includes/configure.php file. You also have to apply the same fix to the admin/includes/configure.php file, as well, to be able to access your admin.

So far it's working great and my store is back online...:clap: