'Lost connection to MySQL server during query In codeigniter query ,Live site

I'm getting the following error on my live site. "Error Number: 2013 Lost connection to MySQL server during query"

It was working fine before a day but now there is large amount of data, it might be problem.

I tried almost answers related to the error.

How to overcome this problem?

phpmysqlcodeigniter


Solution 1:[1]

You need to use index in mysql database. It is very usefull when large amount of data in database. I have a same problem in live and it was solved by indexing.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Mandip Vora

Related Questions