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

learn more… | top users | synonyms

18
votes
3answers
13k views

How do you calculate mysql max_connections variable?

How do you calculate mysql max_connections ? What do you take into consideration ?
7
votes
2answers
11k views

MySQL 5.1 InnoDB Configuration / 24GB RAM - bi-xeon high load

i'm running a facebook app which currently has 300 - 600 concurrent users (and growing). To get the hardware ready for growing i changed my i7 / 12gb ram / 2x 80gb intel x25 ssd's (debian 5.0 / mysql ...
6
votes
2answers
26k views

How to configure global charset on MySQL

I tried to change the charset for our MySQL via my.cnf and it failed. I added the charset settings listed below: # The MySQL server [mysqld] port = 3306 socket = ...
5
votes
2answers
2k views

Insert-heavy InnoDB table won't use all my CPU

I have a packet log database, which is almost never queried. It just needs to be fast on inserts. I'm using InnoDB because I'd like to maintain ACID compliance, since even losing a single packet could ...
5
votes
1answer
415 views

Tools for cnf management, generation?

Does anyone know of any good tools for cnf configuration management? It's often the case I have a group of machines that has a very similar config except for a few differences such as server id or ...
5
votes
1answer
288 views

Installing and enabling both master and slave semisynchronous plugins on same server

I want to run a semisynchronous replication setup, and for simplicity I'd like to not have to INSTALL and UNINSTALL plugins when a slave is promoted to a master. So I'm wondering if I'll experience ...
4
votes
2answers
8k views

What happened to my-*.cnf in MySQL 5.6.8?

Up to MySQL 5.6.7, the official RPM was shipping with these files: /usr/share/mysql/my-innodb-heavy-4G.cnf /usr/share/mysql/my-medium.cnf /usr/share/mysql/my-huge.cnf /usr/share/mysql/my-large.cnf ...
4
votes
2answers
631 views

Read mysql config (my.cnf) using mysql console

I have a mysql server that is not under my control (I don't have ssh on that machine). I only have access to one database using mysql client. How can I have access to config options that are declared ...
4
votes
2answers
2k views

How to optimize the my.cnf of a MySQL server that mixes InnoDB and MyISAM tablespaces?

I have a database that, because of some issues, I needed to convert some tables from MyISAM to InnoDB. I basically did this: set sql_log_bin = 0; set sql_mode = 'STRICT_ALL_TABLES'; ALTER TABLE ...
4
votes
2answers
5k views

Is my.cnf for mysql 5.5 is suitable and well tuned for below hardware spec?

My Hardware Spec Technology: Ivy Bridge CPU: Intel Xeon E3 1245v2 Intel Smart Cache: 8MB Cores / Threads: 4 / 8 Frequency: 3.4GHz+ / 3.8GHz Turbo Boost RAM: 32 GB DDR3 Hard disk: 2x 2TB SATA3 Raid 1 ...
4
votes
1answer
1k views

MySQL: Can't find .ibd files after turning on innodb_file_per_table

Question: This a question about MySQL. Let me give the specifics of my setup: Mac OSX 10.6.8 MySQL 5.5.28 Workbench 5.2.44 for all administration InnoDB engine exclusively In order to manage ...
3
votes
3answers
11k views

Where does my.cnf get stored in Linux?

I am new to linux, and i just installed MySQL-server-5.1.59-1.glibc23.i386.rpm in my linux machine. I wanted to know where my.cnf file gets stored..? Will my.cnf gets created with the installation ...
3
votes
3answers
3k views

Confirm that my.cnf file has loaded OK

Does anyone know if there is a way to confirm if any my.cnf file is being read by MySQL? I only have the one my.cnf on the machine (and there are no my.ini files) which I have in /etc/my.cnf. When I ...
3
votes
2answers
3k views

Creating and editing my.cnf by MySQL Workbench?

I just installed MySQL Server and MySQL Workbench on a clean Snow Leopard MacBook. I hooked up Workbench with the server and was able to start the MySQL Server from within the Workbench. I enter the ...
3
votes
1answer
3k views

Mysql fulltext search my.cnf optimization

I have open a question on http://serverfault.com/questions/353888/mysql-full-text-search-cause-high-usage-cpu Some user recommended asking here. We built a news site. Every day we will input tens of ...
3
votes
2answers
93 views

optimal size of innodb buffer pool

I read a lot of optimal number of innodb_buffer_pool_size and people say it must be larger with 10% than the innodb tables size, what is 60M. Accordyngly this the optimal size of the buffer is about ...
3
votes
1answer
696 views

How to set datadir to different values based on the hostname in my.cnf?

How to set datadir to different values based on the hostname in my.cnf? I want to use the same my.cnf file on a Linux machine and a Mac OS X machine where the datadir should have different values.
3
votes
2answers
4k views

MySQL “server has gone away” using SQLyog

I'm trying to copy a database from a server to my local machine, I've installed Wamp 2.2, mysql 5.5.16, but during copying db I m getting "mysql server has gone" 2006, I've tried to fix it by changing ...
2
votes
3answers
3k views

innodb_buffer_pool_size not changed

I use MySQL 5.5.23-1~dotdeb.0 (Debian) and here is the relevant part of my.cnf default-storage-engine = innodb innodb_buffer_pool_size = 3G innodb_log_file_size = 256M innodb_thread_concurrency = 8 ...
2
votes
1answer
1k views

Reloading MySQL my.cnf changes

Do you have to restart MySQL to edit changes? Or can you edit them on the fly and restart MySQL or make the changes inside MySQL? This server runs 100s of website that are active and I don't really ...
2
votes
1answer
93 views

Need help tuning my.cnf file

I need help tuning mysql. Currently it is using a lot of CPU. I dont find any query that last longer than 3 seconds in SHOW PROCESSLIST and there are only around 20-25 running most of the time. Still ...
2
votes
1answer
430 views

“set-variable = innodb_thread_concurrency=4” or “innodb_thread_concurrency=4”

Based on this question, the asker wrote: set-variable = innodb_buffer_pool_size=2M set-variable = innodb_additional_mem_pool_size=500K set-variable = innodb_log_buffer_size=500K set-variable = ...
2
votes
1answer
280 views

MySQL: bind-address 0.0.0.0 in my.cnf does not work?

I'm new to mysql. I want to connect to mysql server using whatever ip I want. I read that all I have to do is to add to my.cnf file the line bind-address = 0.0.0.0. That's what I did. I restarted ...
2
votes
1answer
313 views

Drupal 7 Uses InnoDB, so do I need other configs?

If I'm optimizing a database that will be delivering multiple Drupal 7 websites, all using InnoDB, do I need to worry about [myisamchk] & [isamchk] sections, or can I just worry about the stuff ...
2
votes
2answers
3k views

The best MySQL configuration for my server

I'm little newbie in configuring mysql and I need some advices. Few days ago I made little home server on Ubuntu Server 12.04 with samba, mysql 5.5, apache 2.2, PHP 5.4.6 etc. I'm using it to ...
2
votes
0answers
156 views

mariadb out of memory crash

I have recently migrated from mysql (5.5.36 MySQL Community Server (GPL)) to MariaDB (10.0.10-MariaDB-1~wheezy), along with switching my cloud hosting provider. Both machines have 2GB RAM and 1GB ...
2
votes
1answer
8k views

MySQL my.cnf vs my-huge.cnf

I've recently installed MySQL server and client 5.5.28 through rpm packages on an openSUSE machine, and I was not able to locate my.cnf file. I look into all directories mysql --verbose --help | grep ...
2
votes
3answers
11k views

How to initiate MySQL on Mac OS X 10.6.8?

I followed this tutorial to install MySQL on Mac OS X 10.6.8. Now I get he following errors: $ mysqladmin version /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: ...
1
vote
1answer
412 views

For 768M RAM server is 617M allocation in my.cnf good or bad?

I have a write-intensive web app, and I bought a VDS with 768M RAM Is this my.cnf good for my purposes? I specified bulk_insert_buffer_size to 126M and some other parameters as below: ...
1
vote
1answer
4k views

Enabling LOAD DATA LOCAL INFILE in mysql

LOAD DATA LOCAL INFILE is not enabled by default. Normally, it should be enabled by placing local-infile=1 in my.cnf. But it does not work for all installations. In my experience, it worked for Debian ...
1
vote
1answer
2k views

What is wrong with table_cache hit rate?

In my.cnf I have: table_cache = 524288 open_files_limit = 65535 Both are at max allowed value for mysql config. Both are less than max open file limit: # cat ...
1
vote
2answers
75 views

Strange issue regarding my.cnf

I'm getting a weird message from phpmyadmin saying: #2006 - MySQL server has gone away What I found online is that I should increase the size of max_allowed_packet witch should be in the my.conf ...
1
vote
1answer
3k views

16 Cores 12 GB RAM server MySql Configuration - my.cnf

The server takes 20+ seconds (wait time/slow IO response time) to response to a HTTP request even with memcached and APC installed. I believe this has something to do with MYSQL since the site as lots ...
1
vote
1answer
165 views

Mysql 5.5 InnoDB growing CPU - Going crazy

Good morning, I'm currently facing a problem where CPU usage keeps going up until the server crash. I've tried multiple best practices proposed in this forum and on Percona, reinstalled the server ...
1
vote
1answer
48 views

What does this mean - ~/.my.cnf

When I run $ mysqld --verbose --help | less I got information like Default options are read from the following files in the given order: /etc/mysql/my.cnf /etc/my.cnf ~/.my.cnf As per my ...
1
vote
1answer
206 views

For a InnoDB only DB, which of these elements can be removed?

So, I'm trying to set up a Drupal 7 my.conf file that's combining best practices from various performance blogs. I'm realizing though that some of them are older than others, and many aren't assuming ...
1
vote
1answer
1k views

MySQL 5.6 OS X 10.8: how tell if my.cnf read?

With mysqld running, I expect to see that /etc/my.cnf has been used by at least one of the commands ps aux | grep mysql | grep -v grep mysqladmin variables | grep defaults-file showing the value ...
1
vote
1answer
209 views

some InnoDB settings in My.cnf are messing up everything, why?

When I edit my.cnf in MySQL 5.0 in filemanager and add the following settings, I get logged out automatically from Kloxo and when I remove these line and restart server everything is ok then: ...
1
vote
1answer
249 views

What is the difference between setting the directive default-character-set under [client] as opposed to [mysqld]?

Reference: http://stackoverflow.com/a/8690422/784637 Correct me if I'm wrong, but the best answer suggests a way to force everything being inputted into the database to be encoded in utf-8 and ...
1
vote
1answer
1k views

How to update mysql my.cnf without getting error?

I updated the MySQL my.conf file and and restarted my server without a problem. As soon as I tried to access a table I received the error mysql #1033 - Incorrect information in file: I reverted ...
1
vote
1answer
743 views

mysql error log issue

I have mysql server running successfully. The error log location is as.. mysql> show variables like '%log_erro%'; +---------------+------------------------+ | Variable_name | Value ...
1
vote
1answer
722 views

MySQL not reading my.cnf in MAMP

Running MAMP (not PRO) 2.0.5, MySQL 5.5.9, locally on OS X and I cannot get MySQL to read a my.cnf file. I've tried throwing it in the following directories with no results: /Applications/MAMP/conf ...
1
vote
2answers
91 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 ...
1
vote
2answers
956 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 ...
0
votes
2answers
592 views

My.cnf with 64GB RAM

May the following my.cnf file be fine for a dedicated server with 64GB of RAM (on Debian)? I'm running just one website on the server and on high load data insert in some table takes centuries...it ...
0
votes
1answer
54 views

How do I make binlog-format=ROW the start up default in the /etc/my.cnf file?

I can run the query SET GLOBAL binlog_format = 'ROW' and it works for that session. How do I make this setting stick after stopping and restarting MySQL? NOTE: I am on version 5.5.19 of MySQL ...
0
votes
1answer
205 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 ...
0
votes
1answer
336 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 ...
0
votes
2answers
52 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 ...
0
votes
1answer
187 views

MySql - set my.cnf location at server start

I want to have two MySql servers running on the same system (for master-slave replication tests purposes). To be able to do this I need both servers read different my.cnf files. As I see at startup ...