my.cnf is the configuration file for MySQL server, client programs, and utilities.
14
votes
3answers
8k views
How do you calculate mysql max_connections variable?
How do you calculate mysql max_connections ?
What do you take into consideration ?
6
votes
2answers
7k 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 ...
5
votes
2answers
1k 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
349 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 ...
4
votes
2answers
2k 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
1answer
100 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 ...
3
votes
3answers
5k 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
2answers
12k 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 = ...
3
votes
2answers
336 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 ...
3
votes
2answers
1k 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
2answers
653 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 ...
3
votes
1answer
2k 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
1answer
369 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
1answer
210 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
2answers
2k 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
1answer
36 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
3answers
1k 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
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 ...
2
votes
3answers
2k 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 ...
2
votes
1answer
277 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
77 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
1k 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
3answers
7k 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
300 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
1k 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
84 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
171 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
152 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
184 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
784 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
596 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
58 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
167 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 ...
1
vote
1answer
2k 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 ...
1
vote
1answer
358 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 ...
0
votes
3answers
223 views
Mysql optimization help
I've tried optimizing mysql as good as I could, but apparently I'm not to good at it :-)
So I come to you guys for help.
Server specs are:
AMD Opteron CPU 8 cores
16 GB RAM
2x2.000 GB HDD 7.200 RPM ...
0
votes
1answer
36 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 ...
0
votes
1answer
46 views
Errors while creating multiple mysql-5.5 instances
I have installed 3rd mysql instance on my testing server.
2 instances already running without any issues.
When I installed 3rd instance by mysql-5.5.30 zip source, it installed successfully but when ...
0
votes
3answers
37 views
MySQL is running but not working
In an attempt to tune MySQL to make it work with a recent installation of Drupal I had to modify the MySQL settings on my server. After modifying the configuration file for MySQL (/etc/my.cnf) MySQL ...
0
votes
0answers
23 views
Problems Making Configuration File Changes
I use MySQL 5.5 on both Mac OSX (10.6.8) and Windows 7; in both contexts I use Workbench for my administrative needs. I've recently started tinkering with the configuration files (my.cnf/my.ini), and ...
0
votes
0answers
7 views
ibdata deleted and innodb error [duplicate]
By accident I have deleted ibdata1 file in MySQL directory because the MySQL wasn't functioning correctly so after reading so many forums I found a post asking to delete the 3 files in MySQL directory ...
0
votes
0answers
50 views
InnoDB errors after having deleted “ibdata1”
By accident, I have deleted the ibdata1 file in the MySQL directory because MySQL wasn't functioning correctly.
After reading so many forums, I found a post that recommended deleting the 3 files ...
0
votes
0answers
41 views
MySQL “hangs” after every restart.. corrupted tables every now and then.. (5.1.68-cll)
I was seeking an advice in forums about a problem that we face last days. We have a vBulletin forum, we never had any problems in general, but the last couple of days MySQL server hangs and when we ...
0
votes
0answers
42 views
MySQL max_connections Changed Without Notice
I'm running a Linux (512MB of RAM) server with MySQL 5.1.
I host an app that is used by a small # of users (less than 50). Everything has been working fine until yesterday, connecting to my DB would ...
0
votes
0answers
30 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 ...
0
votes
1answer
269 views
How can I set a default session sql_mode for a given user?
I want to have a default session sql_mode that is different from the global sql_mode.
I can set it manually, but I'd like to do it automatically.
I thought I could add it to .my.cnf, but that ...
