0
votes
1answer
25 views

How to configure my.cnf in 5.6.17?

On production server(linux machine mysql 5.6.17), I tried to find my.cnf to change the system variables, but my.cnf was not in /etc/my.cnf location. It was in usr/ directory. Also that file contains ...
1
vote
1answer
64 views

What does this mean - ~/.my.cnf

When I run $ mysqld --verbose --help | less I got information like Default options are read from the following files in the given order: /etc/mysql/my.cnf /etc/my.cnf ~/.my.cnf As per my ...
0
votes
0answers
422 views

MySQL - Out of memory: Kill process 3046 (mysqld)

We run a MySQL (v5.6.17) dump backup every 4 hours, and today noticed: Apr 19 20:09:30 mysql1 kernel: Out of memory: Kill process 3046 (mysqld) score 970 or sacrifice child Apr 19 20:09:30 mysql1 ...
1
vote
1answer
5k views

Enabling LOAD DATA LOCAL INFILE in mysql

LOAD DATA LOCAL INFILE is not enabled by default. Normally, it should be enabled by placing local-infile=1 in my.cnf. But it does not work for all installations. In my experience, it worked for Debian ...
1
vote
2answers
80 views

Strange issue regarding my.cnf

I'm getting a weird message from phpmyadmin saying: #2006 - MySQL server has gone away What I found online is that I should increase the size of max_allowed_packet witch should be in the my.conf ...