Print Page - Exceeded the 'max_questions' resource

Title: Exceeded the 'max_questions' resource - DB connection error (3)
Post by: metmusic on March 13, 2015, 11:45:27 AM

Hi All,

I have issue with my Joomla / VM instalation. From time to time my server (hosting company) is blocking my site (Database connection error (3)) due "exceeded the 'max_questions' resource". Current value is 50000. How to investigate what part of Page/VM is asking so many questions to DB (SELECT)? Amount of users / products and pupularity is not highest (1000 users, 200 products, 1-2 purchases per day).

Result: Database connection error (3): Could not connect to database
Log:
140826 10:35:42 [Warning] Aborted connection 3693263 to db: 'unconnected' user: XXXXX' host: 'localhost' (init_connect command failed)
140826 10:35:42 [Warning] User 'mdesopl_madrona' has exceeded the 'max_questions' resource (current value: 50000)
140826 10:36:17 [Warning] Aborted connection 3693441 to db: 'unconnected' user: 'XXXXX' host: 'localhost' (init_connect command failed)
140826 10:36:17 [Warning] User 'mdesopl_madrona' has exceeded the 'max_questions' resource (current value: 50000)

Joomla 2.5.14
VM 2.0.22a

Thanks for help in advance

Marcin

Title: Re: Exceeded the 'max_questions' resource - DB connection error (3)
Post by: jenkinhill on March 13, 2015, 12:21:44 PM

http://forum.virtuemart.net/index.php?topic=79799.0

Title: Re: Exceeded the 'max_questions' resource - DB connection error (3)
Post by: metmusic on March 13, 2015, 12:26:15 PM

So? I used search tool and didn't find solution for my issue...

VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: metmusic on March 13, 2015, 11:45:27 AM