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.
2
votes
2answers
141 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 ...
1
vote
7answers
703 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 ...
1
vote
2answers
350 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 ...
1
vote
2answers
62 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
2answers
638 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
1k 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 ...
1
vote
1answer
194 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 ...
0
votes
1answer
375 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
285 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 ...
0
votes
1answer
499 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
400 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 ...
0
votes
2answers
137 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
885 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
22 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 ...
0
votes
0answers
37 views
MySQL hangs on restart… Everytime tables need repair (vBulletin)
I was seeking an advice in forums about a problem that we face last days. We have a vBulletin forum, we never had any problems in general, but the last couple of days MySQL server hangs and when we ...
0
votes
1answer
139 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
283 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
...
-1
votes
0answers
18 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 ...
