Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [my.cnf]

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.

47 questions
1
vote
1 answer

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 /var/lib/mysql folder. File search: find / -name…
Kond
  • 11
  • 1
1
vote
1 answer

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 requirement like changing key_buffer_size= to higher value…
FlourishDNA
  • 125
  • 1
  • 5
1
vote
2 answers

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 be best to comment/remove the skip-innodb line? If…
Larry B
  • 261
  • 4
  • 5
  • 18
1
vote
1 answer

Your applications are not closing MySQL connections properly

When I run mysqltuner it is showing the error in the title. Please help me to solve it. -------- General Statistics -------------------------------------------------- [--] Skipped version check for MySQLTuner script [OK] Currently running supported…
Barkat Ullah
  • 145
  • 1
  • 3
  • 9
1
vote
1 answer

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 fine tune the configurations. Thanks …
user1199249
  • 11
  • 1
  • 3
1
vote
2 answers

Running MariaDB server 5.5 and sharing my.cnf on multiple diskless nodes

I'm attempting to install MariaDB Server 5.5 in a diskless image using Redhat Enterprise 7.8. The problem I am running into is having a single diskless image with a single /etc/my.cnf being deployed to all the nodes, which then are all pointed to…
Chad
  • 23
  • 4
1
vote
0 answers

how to disable SSL for samhain when connecting to a mysql database?

I have just compiled samhain from source and I added database connection credentials to the samhainrc file. For some reason, samhain will not write any entries to the mysql database. The db credentials, which connect to a remote Amazon RDS instance,…
S. Imp
  • 526
  • 1
  • 4
  • 19
0
votes
3 answers

mysqltuner wants me to set join_buffer_size > 256.0M?

I have a 16GB dedicated server running 1 wordpress and 1 magento site! For the last month I have been trying to get mysql optimized! [root@server ~]# ./mysqltuner.pl MySQLTuner 1.7.19 - Major Hayden Bug reports, feature requests, and…
user549188
  • 11
  • 1
  • 1
0
votes
1 answer

Postfix local delivery causes recipients to not show

I'm quite new to posting, please help me if I'm in the wrong place. I have a debian email server, which is working for outgoing and incoming with external SMTP service. postfix, dovecot, mariadb, ispconfig3 The small problem I have, involves local…
bma
  • 1
0
votes
1 answer

can't set secure_file_priv on mysql 5.7 Ubuntu 16.04

How do I set a value for secure_file_priv? I found this which tells what settings may be used https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_secure_file_priv The mysql server starts without any command line options.…
Alan
  • 1
  • 1
  • 2
0
votes
1 answer

Couldn't join MariaDB Galera Cluster node back to cluster after software update. wsrep_* options in my.cnf seem to be ignored

I've had run a Galera Cluster for a while, MariaDB version 10.0.20, Galera version 25.3.10, everything over Gentoo. That cluster worked fine, nodes restarted several times for maintenance and so on. When I started mysql on any node, it loaded…
Nikita Kipriyanov
  • 10,947
  • 2
  • 24
  • 45
0
votes
1 answer

I have two Mysql servers running on Centos7 . both using different ports. have to manually boot on start.

I need help . mysql on port 3306 and mysql2 on port 3307. I copied my.cnf to my2.cnf I added the following in my2.cnf: datadir=/var/lib/mysql2 port=3307 cp /etc/init.d/mysql /etc/init.d/mysql2 Added to line 138 in vi /etc/init.d/mysql2: --port=*) …
Lolu911
  • 11
  • 2
  • 8
0
votes
2 answers

MySQL Ram Usage & Improve it with mysqltuner

how can i improve my server ram usage: Server Ram = 1GB after install the mysqltuner , I have this result : [root@server ~]# perl mysqltuner.pl >> MySQLTuner 1.5.0 - Major Hayden >> Bug reports, feature requests, and downloads…
Ashina
  • 3
  • 1
  • 2
0
votes
1 answer

my.cnf file does not reflect changes on ubuntu 12.04

Hello I am running an application install which requires thread_stack = 256k in my.cnf file. The location of the file is etc/mysql/my.cnf and I updated the value and restarted the mysql server,but the value does not get updated even after the…
KillABug
  • 127
  • 1
  • 8
0
votes
0 answers

MySQL read-buffer-size overflow

What will happen if a low value was assigned in my.cnf to any of the per-thread buffers, when it fills? I'm thinking of possible scenarios: MySQL will gracefully call realloc for additional block with the same size. A buffer overflow, causing…
doc_id
  • 1,509
  • 2
  • 12
  • 17
1
2
3 4