Questions tagged [my.cnf]

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

Filter by
Sorted by
Tagged with
3 votes
2 answers
81 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
user avatar
  • 47
0 votes
0 answers
39 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 --...
user avatar
1 vote
1 answer
2k 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 ...
user avatar
3 votes
2 answers
267 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 ...
user avatar
0 votes
2 answers
178 views

MariaDb mysqldump configurations

We have extremely large database (mariaDB 10.3) and mysqldump taking 2-3 hours to take the full database dump and also causing downgrade in application performance during the dump process. After some ...
user avatar
1 vote
0 answers
1k 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 ...
user avatar
  • 113
0 votes
0 answers
29 views

connection getting lost to mysql

if I update 10 posts in a website simultaneously and connection gets lost after one or two post updates, does this has anything to do with connect_timeout value? currently it is set to 10. After the ...
user avatar
0 votes
1 answer
686 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 ...
user avatar
1 vote
1 answer
59 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 ...
user avatar
2 votes
1 answer
755 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 ...
user avatar
  • 121
0 votes
2 answers
67 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 ...
user avatar
1 vote
2 answers
898 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
48 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 ...
user avatar
  • 2,357
3 votes
1 answer
636 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....
user avatar
-3 votes
1 answer
1k 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 ...
user avatar
  • 13
0 votes
1 answer
791 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 ...
user avatar
0 votes
1 answer
743 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 ...
user avatar
0 votes
1 answer
47 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 ...
user avatar
  • 101
0 votes
0 answers
56 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 ...
user avatar
  • 1
3 votes
0 answers
2k 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 ...
user avatar
1 vote
1 answer
238 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 ...
user avatar
  • 97
-1 votes
3 answers
175 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 ...
user avatar
0 votes
2 answers
183 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 ...
user avatar
0 votes
2 answers
605 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 ...
user avatar
0 votes
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 ...
user avatar
  • 1,690
3 votes
1 answer
966 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] ...
user avatar
1 vote
1 answer
1k 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 ...
user avatar
1 vote
1 answer
2k 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/...
user avatar
0 votes
1 answer
2k 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 ...
user avatar
0 votes
2 answers
330 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 ...
user avatar
0 votes
1 answer
440 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/...
user avatar
  • 1,708
2 votes
1 answer
2k 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 ...
user avatar
  • 121
4 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 ...
user avatar
  • 203
0 votes
0 answers
230 views

MySQL listens at port 3306 even after changing it

I changed MySQL default port from 3306 to 12929 in my.cnf in both client and mysqld sections on Debian. After that I restarted MySQL service. Then I ran netstat -tln and saw that MySQL is still ...
user avatar
1 vote
3 answers
6k 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 ...
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 ...
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: +------------------+...
user avatar
4 votes
4 answers
31k 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 ...
user avatar
0 votes
2 answers
1k 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 ...
user avatar
2 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 ?
user avatar
0 votes
1 answer
256 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 ...
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 /...
user avatar
13 votes
2 answers
39k 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?
user avatar
  • 299
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....
user avatar
  • 121
1 vote
1 answer
975 views

How are multiple my.cnf's loaded by MySQL?

If I want to replicate how the MySQL/Maria client reads ~/.my.cnf, /etc/my.cnf, etc, how would I do it? The MySQL docs give a list of paths and mention "top files are read first, files read later ...
user avatar
  • 173
1 vote
3 answers
4k views

Unable to change innodb_buffer_pool_size MySQL 5.6 in CentOS 6.7

I have searched all over but couldn't find where service mysqld restart picks up the configuration file from: sudo find / -name "*.cnf" | grep my /usr/share/doc/mysql-community-server-5.6.33/my-...
user avatar
2 votes
0 answers
7k views

Aborted connection - Got an error reading communication packets [duplicate]

I'm using MySQL Community Server 5.7.15-log and MySQL Connector/ODBC 5.3.6 on Windows 2012 and getting a lot of these messages: [Note] Aborted connection X to db: 'Y' user: 'Z' host: 'localhost' (...
user avatar
  • 585
2 votes
2 answers
14k views

MySQL Server consuming too much memory

Currently I have the following happening : And : When i run the query i get about 68 entries with most Time set at 0 show full processlist; What I'm doing wrong ? How do i free some memory ? Is it ...
user avatar
  • 123
0 votes
2 answers
325 views

Mysql config for my.cnf make sofware not response

First time i am sorry about my English , but please help me on my.cnf . I read many post about config Mysql for best optimize but not thing to imporve. My server is Data center that contains two ...
user avatar
0 votes
0 answers
105 views

Does mysqlnd expose PDO connection data to process/log files?

So I was trying to figure out how to write an automated backup script for php on a shared webhost to execute using mysqldump, with no root access to core php.ini or mysql config on the remote database ...
user avatar
  • 163