?
Solved

Magento: Once loads on server, then sometimes page shows sql query

Posted on 2016-09-05
4
Medium Priority
?
161 Views
Last Modified: 2016-10-09
Hi Folks,

I've a website built in Magento. But, I got an issue; whenever loads on server then sometimes page shows sql query.

Do you have any experience on it, how to resolve it?

Best Regards,
Mohit Pandit
0
Comment
Question by:MohitPandit
  • 2
4 Comments
 
LVL 1

Accepted Solution

by:
Stefan Hoffmann earned 1000 total points
ID: 41785589
Is the sql statement accompanied by an error message?

Because for me it sounds like you have issues with your mysql database or database connection resulting in problems.

The Magento engine probably thinks there is an issue with the sql and thus shows you the sql to help you finding the problem within the sql statement. But since you are writing that the statement only shows up once in a while its unlikely that it is in fact a sql problem.
0
 
LVL 5

Author Comment

by:MohitPandit
ID: 41785842
I got error, when "Connection gone away" once server load on peak.

I got a solution as earlier packet size was 16 MB of MySQL. I am planning to change with 64 or 128 MB.
Does it work to resolve this problem?

Best Regards
0
 
LVL 111

Assisted Solution

by:Ray Paseur
Ray Paseur earned 1000 total points
ID: 41785917
I got error, when "Connection gone away" once server load on peak.
This sounds like a configuration problem with your hosting company.  They may have overloaded the server, and are not providing enough MySQL support for the population of PHP users.

Who is your hosting company?  Have you asked their tech support about this outage?

Making a larger packet size for MySQL may be helpful, because Magento is a known resource hog.  That is probably the sort of thing that "can't hurt."  But it would be helpful for us to see your entire error message, along with the message numbers and the SQL statement that caused the message.  Debugging without this information is mostly guessing and we might  guess right, or not.
0
 
LVL 5

Author Closing Comment

by:MohitPandit
ID: 41835809
thanks. It was connection issue at sql end.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, I’ll talk about multi-threaded slave statistics printed in MySQL error log file.
Recursive SQL is one of the most fascinating and powerful and yet dangerous feature offered in many modern databases today using a Common Table Expression (CTE) first introduced in the ANSI SQL 99 standard. The first implementations of CTE began ap…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.
Suggested Courses

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question