Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [my.cnf]

my.cnf is the configuration file for MySQL server, client programs, and utilities.

Filter by
Sorted by
Tagged with
1 vote
1 answer
175 views

Change server_uuid in MySQL

I want to know if there is any way to update server_uuid; I am trying master-slave replication, and I need different server_uuid. FYI - I don't have server_uuid in my my.cnf file, and when I update it ...
datascinalyst's user avatar
1 vote
1 answer
67 views

Almost identical MySQL server totally different performance

I have two servers which differ in mysql version Server 1 runs with mysql 5.7 2 cores Intel(R) Xeon(R) Gold 6248R CPU @ 3.00GHz and 6GB RAM Server 2 runs with mysql 8.0 4cores CPU Intel(R) Xeon(R) ...
kekw's user avatar
  • 111
0 votes
1 answer
131 views

Slow select queries but CPU usage always less than 1%

We recently moved to a bigger server (64G, 16core Amazon EC2) and I was hoping some increased performance. However, there are plenty of slow queries (some even 50ms) but CPU usage remains very very ...
JM John's user avatar
  • 13
0 votes
0 answers
363 views

Please guide upon optimize my.cnf of MariaDB 10.6.14 on Wordpress Woocommerce site

Before post, I read post at InnoDB tables in an 8GB RAM server: Are these settings optimized?, but it seems not fully relevant to my case. It would be great if any MariaDB expert could guide me based ...
alexlii's user avatar
0 votes
1 answer
44 views

Can't connect to MySQL services after changing socket directory in my.cnf file

I have changed the location of the socket file in my.cnf, however, when I try to login to mysql, I get the error "Can't connect to local MySQL server through socket 'prev/sock'" (I am using ...
dbafix's user avatar
  • 62
1 vote
2 answers
365 views

Tuning MYSQL 8.0.32 for my server

EDIT: User @mustaccio let me acknowledge that I must present the problem that motivates the need for the tuning: There are querys running faster in an older server, less powerful, MySQL Version 5.7....
lio89's user avatar
  • 21
1 vote
1 answer
90 views

InnoDB Database Using All Disk Space

I have a database for an app, that is currently using MariaDB with about 220 InnoDB tables. The entire database is about 30GB of data. However when attempting to move it to a new server that has the ...
atrljoe's user avatar
  • 111
0 votes
2 answers
1k views

MariaDB my.cnf optimization 8 Core 16GB Ram [closed]

What would be the most optimized mariadb settings for my server below? E5-2699 V4 CPU(8 Core)- 16GB DDR4 - 100GB NVME SSD Current [mysqld] performance-schema=ON slow_query_log = 1 query_cache_size = ...
user avatar
0 votes
0 answers
797 views

/etc/my.cnf conflict when trying to install mysql

I am pretty new with Linux, so please be patient :) Ran into database connection problem and decided to reinstall/update mysql Now I get the following error message: Transaction check error: file /etc/...
Johan Twelli's user avatar
3 votes
2 answers
278 views

mysql backup password without root home

What's the best way to provide a MySql root password (~/.my.cnf) to cron job without root to have the home folder? the server I'm using is centos
Rait's user avatar
  • 47
0 votes
0 answers
257 views

Which option should I use to avoid error #2006 on MySQL (Docker Compose)

I am getting error #2006 - MySQL server has gone away while trying to restore a 11.9 mb database using PhpMyAdmin. It worked with a 4.70 mb database, but not with this one I thought that if I put --...
LuisEnMarroquin's user avatar
1 vote
1 answer
4k views

unknown variable 'lower_case_table_names=1'

I want enable lowercase table names so i have added to etc/mysql/my.cnf also etc/mysql/mariadb.cnf lower_case_table_name = 1 restart the service sudo service mysql restart I can acces service from ...
Ade Supriyadi's user avatar
3 votes
2 answers
2k views

Importing a 16 GB MySQL file silently fails

I've looked at a lot answers here MySQL any way to import a huge (32 GB) sql dump faster? and on Server Fault but haven't found a solution to not being able to import a 16 GB MySQL file completely; it ...
BlueDogRanch's user avatar
-1 votes
2 answers
724 views

What is the best practise for MariaDB mysqldump configurations of large databases?

Problem We have a large database (MariaDB 10.3) and mysqldump takes 2-3 hours to complete a full database dump, and it's also causing downgrade in application performance during the dump process. ...
EternalSunShine's user avatar
2 votes
0 answers
2k views

What is the default my.cnf on debian's mariadb server?

I'm trying to set default-time-zone on mariadb server Server version: 10.3.25-MariaDB-0+deb10u1 Debian 10 To do such things, in mysql, I used to simply modify /etc/mysql/my.cnf but here I have a ...
zumba's user avatar
  • 123
1 vote
1 answer
1k views

MySQL 5.7 High Memory usage Killed by OOM

i upgrade my WHM server / Cent-OS 7 from MySQL 5.6 to 5.7. after that upgrade every few hours my server memory full by MySQL which after hours of MySQL restart it exceed 80% of whole memory. i ...
Bilal H's user avatar
  • 11
2 votes
1 answer
169 views

Adjusting the my.cnf file for DB servers after an instance resize

I am trying to optimize the DB server of one of our production environments (MySQL DB, centos7), and I've noticed that there is a very high memory consumption of the DB. After further investigation I ...
Alex Drago's user avatar
4 votes
1 answer
2k views

Restore MySQL dump to a container fails with ERROR 1114 "The table is full"

I am trying to restore a MySQL dump of size around 18GB to another MySQL server, which is running inside a container using this command: mysql -h example.com -u user -p matomo < dump.sql But it ...
undefined's user avatar
  • 151
0 votes
2 answers
95 views

Poorly configurated mysql server

Recently I took all MySQL servers that we had over a few servers and put in a single VPS dedicated to MySQL. As a source of information, I used Aurimas Mikalauskas ebook "Speedemy - MySQL ...
IamRichter's user avatar
1 vote
2 answers
1k views

What is the recommended my.cnf settings for 32 GB Server

I am just moving my website to a new server and ı want to know what is the recommended settings for 32 GB server? Mysql tunning for my old server (16 GB) https://pastecode.xyz/view/577e824e
user avatar
0 votes
1 answer
65 views

MariaDB: Connecting from LAN on Centos

I have a working MariaDB 10.2 running on my CentOS 6 server. I can connect to the DB from another machine on the LAN. Out of curiosity, I wanted to revisit how this was made possible. Everything I ...
Manngo's user avatar
  • 2,839
3 votes
1 answer
2k views

what's `/etc/mysql/mariadb.cnf` used for? (i.e. `my.cnf` vs `mariadb.cnf`)

I'm trying to better understand how MariaDB is configured. From mysqld --help --verbose I can see that my mariadb server daemon uses /etc/mysql/my.cnf. But I'm curious about the /etc/mysql/mariadb....
Elliptical view's user avatar
-3 votes
1 answer
2k views

What is the optimal configuration for MariaDB ? (CentOS 8, MariaDB 10.5)

Hello i have MariaDB 10.5 on a Centos 8 Server configuration 18cores 32 threads and 32gb ram I have plenty of free ram but I am trying to optimize for CPU less CPU work and more ram usage How I do ...
Wed's user avatar
  • 13
0 votes
1 answer
1k views

my.cnf for 16 GB Ram Server [MariaDB]

I am very new to this stuff. I just wanted to ask if somebody has a good my.cnf for my MariaDB database because every time i have more than 1000 connections to my website it starts to have hight load ...
3rKaN_BRATTE's user avatar
0 votes
1 answer
2k views

Why “sudo vim /etc/my.cnf” file is empty?

I want to edit some of InnoDB variables ,I go to the .my.cnf which is located in home/.my.cnf I found the file just empty. And when I check SHOW VARIABLES in MySQL it gives me all the variables and ...
gopinath's user avatar
0 votes
1 answer
79 views

MySQL server upgrade, how to adapt variables?

I am about to upgrade my MySQL server because I have currently used it mainly with a couple of people in the development stage. Before we launch, however, we would like more capacity to avoid the ...
PennyWise's user avatar
  • 101
0 votes
0 answers
68 views

Mysql Shell doesn't change the configuration of my database for group replication

I am attempting to use a preexisting database on multiple nodes in a group replication setting. I am using mysqlsh 8.0.16, mysql server 5.7.24 and ubuntu 16.04 as the host. When I attempt to ...
gabwil's user avatar
  • 1
3 votes
0 answers
5k views

MySQL RDS Incompatible Restore while creating read replica

We have multiple m5 generation MySQL RDS instance. The problem we are facing is that while creating read replica for these instances we are repeatedly getting 'incompatible-restore' error. In the ...
Subrata Das's user avatar
2 votes
1 answer
290 views

Show a Warning on logon in MariaDB

I pretend to show a personalized message at login in MariaDB ver. 10.1.37 , in accordance with the data in one table. My idea was to use a stored procedure as shown in fromdual.com but i can't find ...
Ezeq's user avatar
  • 107
-1 votes
3 answers
285 views

Less traffic, But Mysql Still Hit upto 200%

I Run WordPress On my with with Less traffic, 5 or 6 online, but mysql till hits upto 200%, though sometimes it come down to 100 or less, but it still goes up to 200% again, the funniest thing is that ...
Godwin Alex Ogbonda's user avatar
0 votes
2 answers
214 views

MySQL Server Sparks up to 400% Please help!

Please I need help, my server spec is 6 cores and 16gb ram on a Vps plan, and my sql is giving a lot of problem. somethings it spark up to 400%. I have tried to configure it many times but it will ...
Godwin Alex Ogbonda's user avatar
0 votes
2 answers
770 views

Mysql Percona 5.6 Configuration File

I've just installed a Percona instance of Mysql on an Amazon server and can not find the my.cnf file anywhere. I found auto.cnf in /var/lib/mysql but there is nothing in that file like what I have ...
user3783243's user avatar
1 vote
1 answer
4k views

Where should I store a custom ".my.cnf" file?

I am working in a Vagrant box (for development) and I have a provisioner script written in Bash. The script does install MySQL and setup a few things: basically it does what mysql_secure_installation ...
ReynierPM's user avatar
  • 1,764
3 votes
1 answer
1k views

Override database option in a user-specific .my.cnf config file

Using MariaDB 10.2.15 (Linux Debian Stretch) I have created a ~/.my.cnf config file in my home directory in order to set a default database at connection time for all local client tools: [client] ...
Nicolas Payart's user avatar
1 vote
1 answer
2k views

MySQL configuration with 256GB [closed]

I need suggestions for my.cnf optimization. Currently I have a server with 256GB Ram and 40(CPUs) along with website hosted on this server. My Wordpress database size is around 1GB and using myISAM ...
user1656831's user avatar
1 vote
1 answer
3k views

table_open_cache increase issue - MariaDB 10.2

I'm trying to increase to 9000 but MariaDB sets it at 4895 automatically. Here is my simple config https://pastebin.com/raw/4eFiuFSv MySQLTuner output: Control warning line(s) into /var/lib/mysql/...
user3446664's user avatar
0 votes
1 answer
3k views

Next step to configuring MariaDB after successful installation

In addition to the formal documentation (i.e. https://mariadb.com/resources/blog/installing-mariadb-10-centos-7-rhel-7, etc), there are countless tutorials on installing MariaDB, however, not one of ...
user1032531's user avatar
0 votes
2 answers
389 views

MariaDB 5.5-56 not reading the my.cnf file and taking default values [closed]

Permissions are correct. I actually went ahead and opened the file up to everyone (I know... big no-no but it's a closed off lab) any idea why MariaDB 5.5-56 wouldn't read the my.cnf file and just ...
J Miller's user avatar
0 votes
1 answer
640 views

Error - enabling bin log in mysql [closed]

I have a mysql server with 5.5. I tried to enable the binlog using the below config file. # BINARY LOGGING # server_id = 1 log_bin = /mysql/binlog/...
TheDataGuy's user avatar
  • 1,940
2 votes
1 answer
3k views

MySQL fails to start after editing my.cnf

I am trying to optimize memory usage (eating up more than 500MB by default) of MySQL using my.cnf, but I am having some trouble. The service is not starting after placing my custom my.cnf. It goes ...
Spero's user avatar
  • 121
5 votes
1 answer
2k views

Passwordless mysqldump via shell script in /etc/cron.daily

I'm aware that there are dozens of questions similar to this, but it seems none has a definitive answer to my problem, so that's why I'm posting this... I hope in the right place. The problem: I ...
Vila's user avatar
  • 223
1 vote
3 answers
7k views

MySQL using 100% of CPU with 1500 active connections

I'm having a problem with MySQL. I have a system that runs some cron jobs and these create lots of database connections. When it reaches about 1500 active connections the cpu usage goes to 100% but ...
CentosMrqst's user avatar
1 vote
1 answer
2k views

InnoDB Read and Write speed constantly spikes

I am not a dedicated mysql admin but my friend and I have been working hard to fix the badly configured mysql files. We have reduced our number of pools to 2 from 20 and increased pool size to 90GB ...
ODelibalta's user avatar
-1 votes
1 answer
1k views

Slave Connection 1130

So I have a CentOS server that I have started to configure replication on my local machine. When I take a look at the master server with show master status;, I get the following: +------------------+...
David Rhoderick's user avatar
4 votes
4 answers
42k views

Mariadb default logs location & --log-error

I am using mariadb and I to investigate some issue I wanted to check the logs. To my surprise, log file is not generated for mariadb. I suspect this cannot be the case so I am doubting my search ...
Bhupesh Pant's user avatar
0 votes
2 answers
2k views

Need help with my.cnf: 32GB RAM and 3GB of InnoDB tables

I have a Joomla app that takes my MySQL instance down all the time. It uses too much CPU and performs too many queries without using indexes, queries very large tables and is using non-optimized ...
Augusto Will's user avatar
3 votes
1 answer
2k views

wait_timeout kills session in SLEEP MODE or all connection ?`

Do wait_timeout session clear all running session or only sessions which are in SLEEP mode for specified seconds ?
simplifiedDB's user avatar
0 votes
1 answer
326 views

Do Log_Slave_Updates in MySQL 5.7 fail the replication in Linux?

I have a Master Master replication setup in RHEL for 2 Nodes.One server is acting as Master as well as slave for another Server ( which is also Master and Slave ) Let us say A server and B server I ...
simplifiedDB's user avatar
0 votes
2 answers
2k views

Mariadb configuration is not loaded from my.cnf

My mariadb configuration in my.cnf is not getting loaded for "log-error" and "pid-file". I have checked other configurations params are loaded. [root@kvm10 ~]# cat /etc/my.cnf [mysqld] !includedir /...
Bhupesh Pant's user avatar
15 votes
2 answers
53k views

MySQL difference between wait_timeout and connect_timeout

I have a my.cnf file. In it I see wait_timeout as well as connect_timeout. What's the difference between these 2?
Goose's user avatar
  • 319