My.cnf is the file used by MySQL to load its configuration. This file may exist in various locations, and the location determines whether the my.cnf options are per-user or global.

learn more… | top users | synonyms

1
vote
1answer
155 views

my.cnf being ignored (fedora)

Because I'm getting errno=24 on a few queries in my testing environment (Fedora 18 running mysql-server.x86_64 5.5.31-1.fc18), I'm trying to increase the open files limit for mysqld. I have already ...
0
votes
1answer
150 views

After editing my.cnf MySQL fails to restart

I want to edit the /etc/my.cnf file. I've tried to use this as the file content: [mysqld] set-variable = max_allowed_packet=24M set-variable = max_connections=300 log-slow-queries safe-show-database ...
0
votes
2answers
103 views

mysql 5.5 general_log won't stay turned off

I recently discovered that my general_log was turned on and it had generated a 400gb log file. OUCH.. Then I tried to turn it off. while running I entered "SET GLOBAL general_log = OFF" and sure ...
1
vote
2answers
428 views

FreeBSD default MySQL basedir, port, etc., for my.cnf

I'm working on a FreeBSD 9.2 server and have run mysqltuner.pl to check the memory and cache needs of MySQL. Now I need to add a my.cnf file to FreeBSD so it uses that instead of the auto cnf file. I ...
3
votes
3answers
444 views

MySQL Not Reading Symlinks for Options Files my.cnf

I'm running MySQL 5.5 on Ubuntu. There is a my.cnf file in /etc/mysql/ where I would expect it to be. - Great! For debian installations of mysql it is recommended that you do not edit the my.cnf ...
0
votes
0answers
90 views

my.cnf doesn't work in my server

now i am using percona server 5.6 on CentOS 6.5. I wanna change query cache setting. I tried to change setting /etc/my.cnf. but it didn't applied. To investigate whether my.cnf is read correctly,all ...
1
vote
3answers
3k views

mysql my.cnf ignored

The Issue I'm trying to modify a my.cnf value on my production server but the changes aren't taking effect after a sudo service mysql restart, using an exact copy of the my.cnf (downloaded and ...
0
votes
1answer
307 views

MySQL on Debian, unknown variable 'set-variable=local-infile=0'

I have a dedicated server which is running MySQL. In the my.cnf configuration file, I added this configuration a long time ago : set-variable=local-infile=0 It was working fine, but since ...
3
votes
2answers
251 views

I can't connect to mysql on a remote server

I'm trying to connect from an Ubuntu server to a RHEL6 server using mysql. I've tried telneting into the server as well as trying to connect with mysql. I've tried commenting out the bind-address but ...
-4
votes
4answers
234 views

my.cnf for big wordpress installation [closed]

My website using wordpress with more than 150K posts & using auto posts publish feature with more than 2K daily posts I need to configure my.cnf settings to speed up my website actually the ...
1
vote
2answers
3k views

MySQL Strict Mode Stuck On

After upgrading to MySQL 5.5 from the Remi-DB (CentOS 6) we've been getting an issue where every reboot our SQL server will set itself back to strict mode: mysql> SELECT @@GLOBAL.sql_mode; ...
0
votes
1answer
39 views

Can't find mysql config

I uses CentOS on my server that installed from hosting distributive. System works well, but i can't find mysql config to fix some things. I can see only mysql log file named as hostingname.err in ...
-1
votes
1answer
51 views

Reloading MySQL my.cnf changes

Do you have to restart MySQL to edit changes? Or can you edit them on the fly and restart MySQL or make the changes inside MySQL? This server runs 100s of website that are active and I don't really ...
1
vote
2answers
401 views

PHP can't connect to MySQL after changing datadir

I have changed my MySQL datadir and socket location in my /etc/my.cnf as follows: [mysqld] #--default datadir #datadir=/var/lib/mysql #--new datadir datadir=/data/lib/mysql #--default socket ...
1
vote
1answer
555 views

Centos MySQL optimization 4gb ram

I am using Centos 6 64bit on vps with 4gb ram. 1 wordpress website and 2 wallpapers script websites. Wordrpess have 10k visits daily. Site is slow. My.cnf # Example mysql config file for large ...
1
vote
1answer
1k views

Unable to edit/delete/move /etc/my.cnf - Permission denied

I am trying to edit /etc/my.cnf as root user via ssh and I get following error while trying to save it I ma making changes to my.cnf as I want to tweak some values in my.cnf to meet Magento ...
2
votes
2answers
3k views

my.cnf missing on all directories after new mysql installtion

Title says it all. I previously had mysql version 5.1 on my CENTOS 6 x86_64 OS. I attempted to remove mysql 5.1 and replace it with an install of mysql 5.6. Here is my uninstall process for mysql ...
1
vote
2answers
689 views

mysql my.cnf shows InnoDB as disabled “skip-innodb”. Should I enable it for large Magento DB?

The MySQL my.cnf file on our centOS server shows skip-innodb as present. We are looking to optimize my.cnf for a large Magento database. The server has 12GB of memory and 5 Xeon Processors. Would it ...
0
votes
1answer
214 views

MySQL causes iowait's since 5.5 - optimal my.cnf wanted

I upgraded my MySQL server from 5.1 to 5.5 on CentOS (with 2 cores and 2GB RAM). With my old my.cnf the mysql service doesn't start anymore (complains about a PID file), so I use an almost empty ...
0
votes
1answer
732 views

How to bind mysql server to a certain IP?

In remote mysql 5.5 server I tried to add bind-address = 11.22.33.44 Where bind-address = 127.0.0.1 has commented out and 11.22.33.44 is the Ip of the web server communicating with the database ...
0
votes
1answer
498 views

Can't access Kloxo after restarting MySQL 5.0?

I've made some changes to My.cnf to configure Mysql server as below: innodb_buffer_pool_size = 50M innodb_log_file_size = 15M bulk_insert_buffer_size=25M log-slow-queries = mysql-inja-slow.log ...
0
votes
1answer
878 views

Please help me reduce high CPU load, Wordpress website

I have a dedicated server. Ever since I upgraded Wordpress to latest version from 2.8.4, I see very high CPU usage. Also I updated the plugins. I use wp super cache. Compression enabled, cache expires ...
0
votes
1answer
1k views

Your applications are not closing MySQL connections properly [closed]

When I run mysqltuner it is showing the error in the title. Please help me to solve it. -------- General Statistics -------------------------------------------------- [--] Skipped version check for ...
0
votes
1answer
705 views

mysql my.cnf for innodb with 128GB RAM server

I have a server with 128GB RAM but the CPU always show more than 100% (sometimes >1000%) in top command for mysqld process Here is part of configuration for innodb in my.cnf Please advise how do I ...
1
vote
7answers
2k views

MySQL where's the my.cnf path?

I've managed to locate my install directory for MySQL: /usr/local/mysql/ Where can I find the path to my.cnf to know where I should configure the server? I've tried creating a /etc/my.cnf(as shown ...