Stack Overflow
Stack Overflow

Questions tagged [my.cnf]

Configuration file for MySQL programs, particularly for the mysqld server.

MySQL programs read one or more option files in .ini format, with sections specific to each program.

The global option file, usually /etc/my.cnf, frequently contains options for the mysqld server and sometimes the mysqldump or isamchk maintenance programs. There are many such options, with complex interactions; fine-tuning them for your specific needs can be out of scope for this site, but ServerFault may be able to help with some general situations.

The user-specific option file, usually ~/.my.cnf, is not often necessary, but can reduce command-line length or help tailor the mysql client to your preferences. For specific advice, SuperUser is probably a better place to look.

234 questions
0
votes
1 answer

Problems Editing MySQL's my.cnf with vi

Possible Duplicate: How can i get more then 50 results to display in excel using mysql? I have a problem: I have a MySQL script getting results and allowing customers to see their results through an Excel export. However, the spreadsheet is…
Crystal Leahy
  • 43
  • 6
0
votes
3 answers

mySQL: editing/saving my.cnf file

I have found the sample configuration files provided with mysql 5.0, but I am not able to save them, when I edit them. I also tried saving using a different file name but I received an error by windows saying that I don't have permission to save…
Peeyush Kushwaha
  • 3,453
  • 8
  • 35
  • 69
-1
votes
2 answers

How should mysql my.cnf settings be? Innodb Mariadb 10 VestaCP

My.cnf [mysql] port = 3306 socket=/var/lib/mysql/mysql.sock [mysqld] # === Required Settings === basedir = /usr bind_address = 127.0.0.1 datadir = /var/lib/mysql max_allowed_packet = 1024M max_connect_errors =…
Sercan GÜLER
  • 1
  • 4
-1
votes
1 answer

Where in MYSQL are data actually stored (innodb)?

I checked the datadir variable inside de conf. file my.cnf and it is /var/lib/mysql.
jimmy_code
  • 51
  • 1
  • 9
-1
votes
1 answer

MySQL Tuning - Advice on actual conf

Good day everybody :) I'm one of the many trying to find a proper setting for his own db server. Actual Setup: CPU: Intel(R) Xeon(R) CPU E5-2640 v4 @ 2.40GHz, 12 cores RAM: 120 GB HD: 3 TB Concurrent Connection: 4.000 MySQL Version: 5.7.25 - From…
Antonio D'Angelo
  • 119
  • 9
-1
votes
1 answer

not able to set bind-address=[ip of my server] in mysql

I want to create a master-slave replication on ubuntu servers. both(master and slave) on different servers. i made my.cnf(without coments) file on master as: !includedir /etc/mysql/conf.d/ !includedir…
vic
  • 29
  • 9
-2
votes
1 answer

MySql Database - Optimizing the my.cnf file for dedicated server

I have the following dedicated server configuration. 2 x Hexa-Core Xeon E5645 2.4GHz w/H (24 CPUs) 16 GB RAM 128 GB SSD CentOS-6.3 (x86_64 Latest version) Linux Kernel Version 3.6.8 Apache Server 2.4.3 PHP 5.4.9 MySQL 5.5.28 WHM/cPanel version:…
user1863586
  • 1
  • 1
-2
votes
1 answer

my.cnf ram eat every 4 hours 1 G ram

please help [mysql_safe] open-files-limit = 16192 skip-name-resolve [mysqld] max_connections=8000 max_user_connections=8000 interactive_timeout=180 wait_timeout=180 connect_timeout=180 local-infile=0 thread_concurrency = 16 key_buffer =…
Michael Atef
  • 93
  • 1
  • 10
-5
votes
1 answer

MySQL operating system cache

We have a dedicated database server (MariaDB 5.5.31) hosting our database used by our java application (accessing the db via hibernate from another server). While our database itself is using about 12gb of RAM, the operating system (CentOS 6.4) is…
tflu
  • 1
  • 1
1 2 3
…
15
16