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.
Questions tagged [my.cnf]
47 questions
0
votes
1 answer
Mysql reports "unknown variable pass" after upgrading from 5.5.41 -> 5.7.5 on Debian
We have the following problem after upgrading MySQL 5.5.41 (pre-installed on our Debian Wheezy LAMP server from Hetzner) to 5.7.5 version (downloaded from mysql.com).
After updgrading from the default Hetzner configuration to 5.7.5 version, we have…
0
votes
0 answers
Given: iptables entry in place; my.cnf properly set up; MySQL user & permissions properly set - but still cannot access MySQL remotely: Suggestions?
I would like to access MySQL remotely on an Amazon EC2 CentOS instance (I assume it is CentOS because I use yum to update installed applications and libraries).
I believe that iptables is set properly, that my.cnf is set properly, and that the MySQL…
Dan Nissenbaum
- 402
- 2
- 5
- 14
0
votes
1 answer
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
local-infile=0
open_files_limit=3980
then, I've…
Earl
- 7
- 1
- 1
- 1
0
votes
0 answers
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 my.cnf file was deleted and the reboot mysql.
When…
user3636892
- 1
- 2
0
votes
1 answer
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 yesterday, my server started to act strangely, and after a…
Cyril N.
- 624
- 1
- 10
- 36
0
votes
1 answer
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 want to bring mysql down for a restart unless I…
Tiffany Walker
- 6,681
- 14
- 56
- 82
0
votes
2 answers
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 enough, it turned it off. Until the next restart…
0
votes
1 answer
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 my.cnf now.
Now I get iowait warnings all the…
Dylan
- 181
- 1
- 4
0
votes
1 answer
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 server. But after adding the line mysql does not…
alfish
- 3,127
- 15
- 47
- 71
0
votes
1 answer
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 in 10 days. More than 45,000 posts.
Memory usage…
Preetinder Singh
- 1
- 2
0
votes
3 answers
Zabbix agent not using the .my.cnf
I have a server with a zabbix agent installed, this is working fine.
I want to monitor a database on the server, I have followed the documentation of MySQL by Zabbix agent.
I have an error inside the log
mysqladmin: connect to server at '127.0.0.1'…
Gregory Boutte
- 111
- 5
0
votes
2 answers
Improve MariaDB Execution Time
I have a database with one table and three fields (id, hash, creation time).
This table got around 30 million records, the execution time for a query like
SELECT * from `table` WHERE hash='blahblahblah';
This query is taking around 40 seconds to…
Karthik Malla
- 101
- 3
0
votes
2 answers
Default password in .my.cnf for a specific user
We've got a backup script which takes a mysql dump every night, and to authenticate we've got a .my.cnf file with
[mysqldump]
password=somepass
However, every mysql user that doesn't pass in a password seems to inherit this password.
Is it possible…
owenmelbz
- 163
- 3
- 12
0
votes
1 answer
Unable to change tmp_table_size and max_heap_table_size mariadb
I'm running MariaDB 10.1.47 and trying to set:
tmp_table_size = 64M
max_heap_table_size = 64M
I've set it under both the [server] and [mysqld] sections of my.cnf
I've tried setting it in bytes…
steveH
- 148
- 2
- 6
-1
votes
1 answer
my.cnf configuration in mysql 5.6.X
Server information
64GB RAM
Intel(R) Core(TM) i7-3930K CPU @ 3.20GHz
Mysql Server version: 5.6.20-log - MySQL Community Server (GPL)
I have 20 websites on this server like share hosting
my big site has MyIsAM table
Help me to configure this Mysql…
محمد علی پور فتحکوهی
- 101
- 1
- 1
- 7