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
0 answers
593 views

MySQL InnoDB Configuration with 60Gb of Memory

I'm running a large MySQL Database, in the range of 30Gb in size. The MySQL 5.5 server is running on a dedicated server with 60GB of RAM, with no other processes installed apart from monitoring tools, ...
Lincoln's user avatar
  • 11
1 vote
2 answers
251 views

return my.conf values to sane levels (total memory footprint = 220GB)

I recently took over administration responsibilities for one of our databases. The existing my.cnf has some crazy values. I should mention that one table has 1.8 billion rows of mostly unneeded ...
sheepdog's user avatar
  • 345
1 vote
2 answers
5k views

How to configure my.cnf for Mysql 5.1, which is using too much CPU?

I am new Database engineer. I am having trouble in my server which is using too much CPU on database query(simple count statement). I have googled about it, so i found out it depends on system ...
Aamir's user avatar
  • 213
1 vote
2 answers
25k views

How to set Innodb Buffer Pool Size [duplicate]

I have a database using innodb completely. Its now having a innodb_buffer_pool_size at 128MB. Which I know is very less for my user. But no matter what I do it won't change. I have added a value of ...
esafwan's user avatar
  • 133
1 vote
2 answers
171 views

What settings should I use in my.cnf

We have about 5-6 different internal webapps (staff use only) that we will be transferring across to a new virtual server, however I need to setup our my.cnf settings first and I am lost (I am web ...
BuzzMonkey's user avatar
1 vote
2 answers
4k views

Mysql replication - Error No. 1146&1062

short version In master master replication, How to have one master write data with odd IDs and the other one with even IDs? Is it the way to avoid conflict? detailed version I wanted to setup a MySQL ...
mrz's user avatar
  • 205
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
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
2 answers
762 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
0 votes
2 answers
378 views

MySQL Logging Options

I want to know what logging options are available to me in MySQL; I find a lot more results about binary logging than I do about general/error logging and I'm not sure what options are available to me ...
Chuppa Chump's user avatar
0 votes
2 answers
991 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
1 answer
62 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,819
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
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
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
383 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
628 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,920
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
0 votes
2 answers
1k views

Optimization of variables in my.cnf (mysql) for Drupal

I just get a Dedicated Server running UBUNTU and I need to optimize the variables in my.cnf for Drupal 7. I understand that this is tailed job. Then Is there any tool to help me to do this? I am a ...
chefnelone's user avatar
0 votes
2 answers
2k views

After mysql server restarts I cannot see my own database

By mistake I restarted MySQL server in Linux system. But MySQL server was unable to start. I renamed my.cnf to my_bak.cnf. After that MySQL server started. But I can not see my project database. I ...
hema's user avatar
  • 1
0 votes
1 answer
6k views

mysql server is not starting [closed]

mysql server is not starting after modifying configurations key_buffer = 16M max_allowed_packet = 16M thread_stack = 192K thread_cache_size = 8 query_cache_size = 16M after ...
Surjit Sidhu's user avatar
0 votes
1 answer
7k views

Why ".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
2k views

my.cnf validation [closed]

We have moved our server from old 8 GB RAM Server to new 16 GB RAM server so that we could have better performance. The server is still consuming lot of MEMORY. The tables in the database are not ...
user2635016's user avatar
0 votes
1 answer
55 views

All manual settings get wiped out when saved in My.cnf, why? [closed]

When I open my.cnf to enter manual setting like: innodb_buffer_pool_size = 50M innodb_log_file_size = 15M bulk_insert_buffer_size=25M log-slow-queries = mysql-inja-slow.log All of my settings get ...
Alireza's user avatar
  • 3,636
0 votes
1 answer
94 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
333 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
41 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
  • 52
0 votes
0 answers
760 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
0 votes
0 answers
247 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
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
0 votes
1 answer
77 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
67 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
0 votes
1 answer
323 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
349 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 ...
Le Minh Tam's user avatar
0 votes
2 answers
428 views

Proportion of MySQL variables

I made some research on MySQL performance. After doing some tests and verifyed the improvement, (thank you guys) I end up asking myself: "Is there any formula or metric between groups of variables?" ...
UrielUVD's user avatar
  • 103
0 votes
0 answers
44 views

Checking for replication options

I have a master/master setup with one DB in each. DB name and tables in one server are different from the other, and few 'user' tables are being replicated with the option replicate-do-table. (It's ...
Manny Calavera's user avatar
0 votes
0 answers
3k views

MySQL - Out of memory: Kill process 3046 (mysqld)

We run a MySQL (v5.6.17) dump backup every 4 hours, and today noticed: Apr 19 20:09:30 mysql1 kernel: Out of memory: Kill process 3046 (mysqld) score 970 or sacrifice child Apr 19 20:09:30 mysql1 ...
Justin's user avatar
  • 439
0 votes
0 answers
5k views

MySQL: High sort_buffer_size setting value

Thing is I was getting plenty of 131104 20:10:36 [ERROR] /usr/sbin/mysqld: Sort aborted with 256M and rather erratic behaviour in my load test. Now at sort_buffer_size = 1024M ...
kellogs's user avatar
  • 127
0 votes
0 answers
39 views

MySQL: optimal configs / methods for ALTER of large MyISAM table to InnoDB (17gb+) [duplicate]

I have a large MySQL (5.1) MyISAM table (13gb table, 4GB indexes - 40mm+ records) I'm going to be converting this table to InnoDB in a production environment. The DB is on a cloud server with 8GB ...
alex's user avatar
  • 173
0 votes
1 answer
279 views

How to configure my.cnf in 5.6.17?

On production server(linux machine mysql 5.6.17), I tried to find my.cnf to change the system variables, but my.cnf was not in /etc/my.cnf location. It was in usr/ directory. Also that file contains ...
Aamir's user avatar
  • 213
-1 votes
2 answers
672 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
-1 votes
3 answers
278 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
-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
-1 votes
1 answer
3k views

Got error while reverting mysql 5.7 to mysql 5.6

Got error while doing mysql service restart. Googled a lot, but nothing fix my issue. [ERROR] Fatal error: mysql.user table is damaged or in unsupported 3.20 format. 2016-04-23 11:10:38 22185 [...
dileep ch'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

1 2
3