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.

219 questions
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
  • 445
  • 6
  • 15
0
votes
0 answers

Homebrew mysql config

I had install mysql by this guide http://blog.joefallon.net/2013/10/install-mysql-on-mac-osx-using-homebrew/ and copy my.cnf file to /etc dir, but mysql not started :( mysql.server start Starting MySQL . ERROR! The server quit without updating PID…
Ivan Verevkin
  • 107
  • 6
0
votes
1 answer

Raising mySQL 61 table join limit

I have a Drupal 6 application that requires more joins than that 61 table join mySQL limit allows. I understand that this is an excessive number, but it is ran only once a day, and the results are cached for further reference. Are there any mySQL…
user1732920
  • 21
  • 1
0
votes
0 answers

mysql slow when CPU and memory are free

I'm running some heavy mysql jobs (mysql 5.1.67) on a high performance machine (EC2/c3.8xlarge). the queries are really slow while CPU usage is under 1% and memory usage is under 5%. How can I let MySQL to use more resources? Is that possible?
Kooshiar Azimian
  • 75
  • 1
  • 2
  • 7
0
votes
1 answer

Optimizing mysql configuration?

I have a website with 100k+ daily visitors. We use MySQL 5.1. Serving all these visitors and logging their data specially during rush hours put a lot of load on our server. I just upgraded our server to EC2/c3.8xlarge with vCPU=32, ECU= 108 and…
Kooshiar Azimian
  • 75
  • 1
  • 2
  • 7
0
votes
2 answers

'Error reading from database' in moodle

I am restoring a course 26.2MB in size in moodle 2.5 and am getting an 'Error reading from database' error. I am able to successfully restore a course 1.8MB in size. I have been searching around for solutions to my problem and the closest I came to…
user3353411
  • 1
  • 1
  • 1
0
votes
1 answer

my.cnf couldn't be written - Dropbox - Mamp Pro 2.2 - Mavericks

I am using a project in MAMP Pro in an upgraded installation; I developed it in an old version, now I'm using it in the current version. Two years ago, I had shared the db to dropbox, that's worked perfectly with my db path pointing to the same…
harkor
  • 483
  • 1
  • 5
  • 13
0
votes
1 answer

MySQL not booting with new my.cnf file from Percona Tools

I have been trying some optimizations of the mysql database on the server. I went through the wizard at Percona tools and took the my.cnf they gave me. Everytime I go to restart the mysql with that file it doesn't work. I already changed the…
nwestfall
  • 209
  • 2
  • 4
  • 12
0
votes
2 answers

Which variables to set under which in my.cnf file

I am a newbie to mysql , Just want to know which variables should i set under which blocks , I mean what variables should be under [mysql] What variables under [mysqld],[mysqladmin],... and so on help is appreciated
mviswa
  • 137
  • 1
  • 1
  • 10
0
votes
0 answers

Remote connect to mysql server [PHP]

I manage a file sharing website (like mediafire,hotFile, etc.) and there is a problem when people try to download from one of the servers. It goes like this: I have one main server - there I have the mysql database and the website himself, and I…
HTMHell
  • 4,572
  • 4
  • 30
  • 70
0
votes
2 answers

What if there are more than one my.cnf files on my server?

What if there are more than one my.cnf files on my server? Which configuration file will be looked by MySQL?
Mitesh Mandaliya
  • 1
  • 1
0
votes
0 answers

unable to set max_allowed_packet and net_buffer_length

I got the error in my website while uploading a file.It says that Got a packet bigger than 'max_allowed_packet' bytes So i googled and found i need to set two variables max_allowed_packet and net_buffer_length to a bigger value.So i tried the…
krishna
  • 3,938
  • 2
  • 26
  • 56
0
votes
1 answer

mysql my.cnf config for 6gb ram

I have dedicated server (Intel Quad Core Xeon E5645 VT, 6 GB RAM). But i have problems with mysql. My site have 40-60k unical users every day. I need to config my.cnf for best performance. My currently config: key_buffer =…
Zulfugar Ismayilzadeh
  • 2,047
  • 3
  • 12
  • 22
0
votes
1 answer

MySQL my.cnf -- open-files-limit causing CPU Overload

I got this server Intel Xeon Quadcore E3-1230v2 with 8GBs of DDR3 RAM Round the clock I see that this server is running out of CPU. It looks badly overloaded. After observing "Daily Process Log" I realized that below process is eating 25% of the CPU…
Admin YaCart.com
  • 9
  • 1
  • 1
  • 6
0
votes
1 answer

Tuning MySQL buffer sizes - Mac Mini 2012 with 16GB

I'm configuring mySQL buffer sizes. I find it's really slow. I'm running mySQL on a i5 mac mini with 16GBRAM OS X Mountain Lion. My database size is about 10GB. This is the copy of my.cnf file and I hoped someone could offer some suggestions…
jonnyjandles
  • 3,744
  • 4
  • 24
  • 34
1 2 3
…
14
15