Solved

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

Posted on 2016-09-05
4
89 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 250 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 109

Assisted Solution

by:Ray Paseur
Ray Paseur earned 250 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
how can i gnupg encrypt a PDF document? 12 32
Dynamic varibles 5 32
How to update the value of duplicated records (except latest one) 2 20
maybe no no httpd.conf 6 47
Build an array called $myWeek which will hold the array elements Today, Yesterday and then builds up the rest of the week by the name of the day going back 1 week.   (CODE) (CODE) Then you just need to pass your date to the function. If i…
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
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 …

772 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