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

table_open_cache not working mariadb

today i was optimizing my mariadb since my website was running too slow My machine is a Centos 7 , 4 gbs ram 3 cpu i runned a script called mysql_tuner.pl and the results were: -- MYSQL PERFORMANCE TUNING PRIMER -- - By: Matthew…
EchO
  • 1,274
  • 1
  • 10
  • 17
0
votes
1 answer

AWS EC2 - MySQL Event Scheduler Not Starting on Server Restart With Event_Scheduler = ON

I currently have event_scheduler = ON in my my.cnf file on my EC2 instance at /etc/my.cnf If the MySQL instance restarts, the event scheduler does not start up automatically. What could be preventing the event scheduler from starting…
Lloyd Banks
  • 35,740
  • 58
  • 156
  • 248
0
votes
1 answer

Change default mysql storage engine using ~/.my.cnf

I am using MySQL 5.5 and trying to change they default storage engine for myself only. I tried creating a .my.cnf file in my home directory as per instructions I found…
Selah
  • 7,728
  • 9
  • 48
  • 60
0
votes
0 answers

slow mysql remote access (direct ethernet link between two servers)

i have two servers (one mysql db server, one client server) with direct ethernet link. The "remote" access used to be lighting fast (neglectable latency for query), no matter using IP addr or DNS. to fine tune the performance, i modified my.cnf…
leo
  • 317
  • 1
  • 9
0
votes
1 answer

How to connect to Mysql from Lua with local-infile=1

I am connecting to a mysql database from lua using : mysql = require "luasql.mysql" local env = mysql.mysql() local conn = env:connect(database,userName,password) but the option local-infile is not activated so my requests using LOAD DATA don't…
guadoc
  • 1
  • 2
0
votes
1 answer

MySQL my.cnf user defined global variable with set-variable

I use MySql 5.6 on Ubuntu 12.04. I try to add a user defined global variable, that will be accessible across multiple sessions: in ~/.my.cnf I have: [mysqld] lower_case_table_names=2 set-variable=my_global_variable=my_string_value Then I restarted…
rapt
  • 11,810
  • 35
  • 103
  • 145
0
votes
2 answers

Do I need the text "_size" in the my.cnf file for mysql 5.1?

This is a pretty simple question about setting parameters in the my.cnf file for mysql 5.1. This page gives me the parameters I can tune: http://dev.mysql.com/doc/refman/5.0/en/server-parameters.html and so I think I would need to…
chongman
  • 2,447
  • 4
  • 21
  • 23
0
votes
1 answer

Set CENTOS 6 mysql character sets to UTF8

I have a website, and I realised when you copy some characters(*,' " - _) from specific applications like Microsoft word, into a search box on my website, it returns this error: ERROR org.hibernate.util.JDBCExceptionReporter - Illegal mix of…
Arty
  • 819
  • 3
  • 13
  • 24
0
votes
1 answer

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 only comments like - # Remove leading # and set to…
Aamir
  • 738
  • 2
  • 17
  • 41
0
votes
2 answers

sed fails to match, delete and then insert

I'm running the following sed commands to edit a my.cnf with specific parameters. However it gets to the last two values I need to check for and amend and fails to do them despite the syntax being no different to the previous values which were…
David Doleman
  • 3
  • 1
0
votes
1 answer

Use PHP to Read Mysql my.cnf

PHP's ini_get function is really useful for double-checking my settings for me. Example: How can PHP read the my.cnf settings file? I've looked for a similar function that can…
coffeemonitor
  • 12,780
  • 34
  • 99
  • 149
0
votes
1 answer

Tried to create DB with Django by mistake

So I read somewhere that Django doesn't create the DB in production on MySQL. It only created the tables and you have to create the DB in MySQL before you can do syncdb. However, I made the mistake of doing syncdb when the database with the name in…
maahd
  • 672
  • 2
  • 9
  • 30
0
votes
1 answer

Mysql my.cnf for linux 4core/8thread 64gb memory

I just moved server and am working on the my.cnf to optimize it for my pc, if someone can give a review on it, as the site is loading very slow on initial connect. In Pingdom, it shows it as "WAIT", and it starts loading site after about 8 seconds.…
Jasmeet Kaur
  • 15
  • 5
0
votes
1 answer

How can i optimize MariaDB's my.cnf file? (with mysqltuner result)

I am using MariaDB & Apache (LAMP) and my VPS Ram is 512MB. Now the problem is sometimes when i use top, the MariaDB process is using 506MB of RAM so i want to optimize my MariaDB. Here is my ./mysqltuner.pl's result: [!!] Currently running…
He Yifei 何一非
  • 2,592
  • 4
  • 38
  • 69
0
votes
1 answer

CentOS 6.5 mysql use alotof memory

i am trying to set up my VM via vagrant, the VM OS is CentOS 6.5 when i install mysql 5.6 : - MySQL-server-5.6.17-1.el6.x86_64.rpm - MySQL-client-5.6.17-1.el6.x86_64.rpm - MySQL-shared-compat-5.6.17-1.el6.x86_64.rpm -…
Makio
  • 465
  • 6
  • 15
1 2 3
…
15 16