Questions tagged [my.cnf]
my.cnf is the configuration file for MySQL server, client programs, and utilities.
144
questions
1
vote
1
answer
60
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) ...
- 111
0
votes
1
answer
36
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 ...
- 13
0
votes
0
answers
242
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 ...
- 1
0
votes
1
answer
30
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 ...
- 54
1
vote
2
answers
213
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....
- 21
1
vote
1
answer
71
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 ...
- 111
0
votes
2
answers
803
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 = ...
user3030909
0
votes
0
answers
653
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/...
3
votes
2
answers
250
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
- 47
0
votes
0
answers
232
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 --...
- 101
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 ...
3
votes
2
answers
1k
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 ...
- 83
-1
votes
2
answers
601
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.
...
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 ...
- 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 ...
- 11
2
votes
1
answer
117
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 ...
- 21
3
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 ...
- 141
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 ...
- 45
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
H.Burak
0
votes
1
answer
58
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 ...
- 2,779
3
votes
1
answer
1k
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....
- 143
-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 ...
- 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 ...
0
votes
1
answer
1k
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 ...
- 1
0
votes
1
answer
69
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 ...
- 101
0
votes
0
answers
66
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 ...
- 1
3
votes
0
answers
4k
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 ...
- 418
2
votes
1
answer
278
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 ...
- 107
-1
votes
3
answers
264
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 ...
0
votes
2
answers
211
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 ...
0
votes
2
answers
743
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 ...
- 149
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 ...
- 1,710
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]
...
- 2,338
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 ...
- 11
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/...
- 13
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 ...
- 133
0
votes
2
answers
377
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 ...
- 1
0
votes
1
answer
606
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/...
- 1,910
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 ...
- 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 ...
- 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 ...
- 11
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 ...
- 259
-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:
+------------------+...
- 101
4
votes
4
answers
39k
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 ...
- 165
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 ...
- 101
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 ?
- 669
0
votes
1
answer
312
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 ...
- 669
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 /...
- 165
14
votes
2
answers
51k
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?
- 309
2
votes
0
answers
1k
views
How to unlock / repair mysql.sock
My issues have spawned from file permission changes leading to the popular ERROR! MySQL server PID file could not be found! error. However, I believe I've repaired them, but still cannot restart MySQL....
- 121