INCREASE MEMORY LIMIT, LOG FILE SIZE, AND SOME TRICKS ON MYSQL SERVICE


If you are facing the following error


Or even, if you just want to increase the memory limit in order to avoid further pains in you head, you just need to add the following lines.

Moreover, you could be facing this other problem:


which is owing to lack of memory in mysql service.

That could be solved as simple as adding the following lines on my.cfg (to get it path, you can do “sudo find / -name my.cnf”)


Or you can do it termorarily such as

If you are running the 64bit server, there was a little bug in the 64bit version, and you would see those errors at the end of your backup script(source of mysql dump):


To fix it, you need to do the following:


Or you can try adding at the top of your dump file, the following code:

 

If you see the following error:


you need to increase the rows limits of your table, to do so, lets run the following:

You have to specify AVG_ROW_LENGTH only for tables with BLOB or TEXT columns.