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

learn more… | top users | synonyms

1
vote
1answer
153 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
301 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
5k 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
238 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
285 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

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
865 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
26 views

I want to set lower_case_variables to 1 but I'm unable to locate my.cnf

MySQL was started with service mysql start only, but it is not showing the default path of my.cnf: [root@localhost home]# ps -ef|grep mysql root 23505 1 0 19:23 pts/4 00:00:00 /bin/sh ...
1
vote
0answers
25 views

Connection timed out & MySQL server has gone away with innodb engine

I have created chat application which ping server every sec for messages. Currently I have done load test with httperf, with 500 request/sec. "Connection timed out & MySQL server has gone away ...
1
vote
2answers
2k views

Mariadb on Centos 7 not changing max connections based on my.cnf

The following configuration in my.cnf is not being followed. Max_connections go back to 151. please help as i have 16gb of dedicated ram that i would like to use properly. [mysqld] ...
1
vote
0answers
171 views

MySQL InnoDB Configuration with 60Gb of Memory

I'm running a large MySQL Database, in the range of 30Gb in size. The MySQL 5.5 server is running on a dedicated server with 60GB of RAM, with no other processes installed apart from monitoring tools, ...
1
vote
2answers
125 views

return my.conf values to sane levels (total memory footprint = 220GB)

I recently took over administration responsibilities for one of our databases. The existing my.cnf has some crazy values. I should mention that one table has 1.8 billion rows of mostly unneeded ...
1
vote
2answers
12k views

How to set Innodb Buffer Pool Size [duplicate]

I have a database using innodb completely. Its now having a innodb_buffer_pool_size at 128MB. Which I know is very less for my user. But no matter what I do it won't change. I have added a value of ...
1
vote
2answers
129 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
2k 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
1answer
608 views

Of the multiple cnf files in /etc/mysql/conf.d/ dir, which would be the last one to be read (and will enventually take precedence)?

For some reasons (and only for some days to come) we are going to have 2 cnf files in /etc/mysql/conf.d directory, apart from the default one /etc/mysql/my.cnf. Now I know this can be disastrous, and ...
0
votes
2answers
202 views

Optimization of variables in my.cnf (mysql) for Drupal

I just get a Dedicated Server running UBUNTU and I need to optimize the variables in my.cnf for Drupal 7. I understand that this is tailed job. Then Is there any tool to help me to do this? I am a ...
0
votes
2answers
338 views

After mysql server restarts I cannot see my own database

By mistake I restarted MySQL server in Linux system. But MySQL server was unable to start. I renamed my.cnf to my_bak.cnf. After that MySQL server started. But I can not see my project database. I ...
0
votes
1answer
2k 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
947 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
100 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
634 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 ...
0
votes
3answers
1k 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
49 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
0answers
21 views

my cnf for big table MyISAM

I have a database about 1750GB in size. It's all MyISAM. Runs high availability on virtual server raid 5 SDD. I can add more cores and ram without problem. Now we are tuning cnf files. I think ...
0
votes
0answers
28 views

Configuring my.cnf file and parameters calculations

Hi i am new in database administration and learning to configure my.cnf. Can anyone help me about parameters in my.cnf and what values should be set for each parameter, and what are the calculations ...
0
votes
0answers
29 views

mysql processes still alive from processlist

I have already posted this on stackoverflow, but I got no answer: mysql processes still alive from processlist I have this in my my.cnf: wait_timeout=1800 interactive_timeout=1800 ...
0
votes
2answers
200 views

Please recommend changes for my.cnf

I am not having any performance problems per se but want to improve my sites' performance if possible. Would appreciate any advice for how I can improve my.cnf. I have just one server, not ...
0
votes
0answers
12 views

with innodb engine, connection timed out & MySQL server has gone away error occured [duplicate]

I have created chat application which ping server every sec for messages. Currently I have done load test with httperf, with 500 request/sec. "Connection timed out & MySQL server has gone away ...
0
votes
0answers
96 views

Importing old SQL database dump onto local Windows 10 desktop system

Hi I just installed MySQL 5.6 on Windows 10 x64. I'm trying to execute an old backup file that happens to be 5 gigs. Some of the insert lines are really long and so the server loses connection. I ...
0
votes
2answers
103 views

Proportion of MySQL variables

I made some research on MySQL performance. After doing some tests and verifyed the improvement, (thank you guys) I end up asking myself: "Is there any formula or metric between groups of variables?" ...
0
votes
0answers
29 views

Checking for replication options

I have a master/master setup with one DB in each. DB name and tables in one server are different from the other, and few 'user' tables are being replicated with the option replicate-do-table. (It's ...
0
votes
0answers
10 views

MySQL : Cannot add to the replication Ignore list [closed]

The my.cnf file already had 17 replicate_ignore_db = [Database Name] entries. I added one more. Then I restarted mysql. Then I logged in to mysql and did SHOW SLAVE STATUS \G; but still the newly ...
0
votes
0answers
221 views

Configuration help my.cnf Mysql

Is the following my.cnf file OK for a dedicated server with 56GB of RAM (on ubuntu server and 8 processors)? I'm running just one website on the server and there is a high demand on my cpu from ...
0
votes
1answer
43 views

1000 visitors per day have my web page and MySQL scratching at certain times and my.cnf [closed]

1000 visitors per day have my web page and MySQL scratching at certain times. "tuning primary" and I edit my my.cnf file is as follows. In what way do you optimize it the best I can. nice = 0 ...
0
votes
0answers
71 views

amazon small instance mysql query too slow

I have mysql database with 1.5 millions records with 2 million categories records. when i do query on categories and city where clause it takes 304989 milliseconds. on localhost it too fast. i tried ...
0
votes
1answer
6k views

Good configuration for 2gb (my.cnf) [duplicate]

I'm little newbie in configuring mysql and i seek a good configuration for mysql i have one site in ajax with many query and very slowly with VPS Iam in kimsufi 2gb i run only mysql in vps not apache ...
0
votes
2answers
2k views

How to configure my.cnf for Mysql 5.1, which is using too much CPU?

I am new Database engineer. I am having trouble in my server which is using too much CPU on database query(simple count statement). I have googled about it, so i found out it depends on system ...
0
votes
0answers
1k views

MySQL - Out of memory: Kill process 3046 (mysqld)

We run a MySQL (v5.6.17) dump backup every 4 hours, and today noticed: Apr 19 20:09:30 mysql1 kernel: Out of memory: Kill process 3046 (mysqld) score 970 or sacrifice child Apr 19 20:09:30 mysql1 ...
0
votes
0answers
2k views

MySQL: High sort_buffer_size setting value

Thing is I was getting plenty of 131104 20:10:36 [ERROR] /usr/sbin/mysqld: Sort aborted with 256M and rather erratic behaviour in my load test. Now at sort_buffer_size = 1024M ...
0
votes
0answers
668 views

MySQL is running but not working [closed]

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
701 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
109 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
35 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
206 views

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 ...
-1
votes
1answer
64 views

Got error while reverting mysql 5.7 to mysql 5.6

Got error while doing mysql service restart. Googled a lot, but nothing fix my issue. [ERROR] Fatal error: mysql.user table is damaged or in unsupported 3.20 format. 2016-04-23 11:10:38 22185 ...
-1
votes
1answer
2k views

mysql server is not starting [closed]

mysql server is not starting after modifying configurations key_buffer = 16M max_allowed_packet = 16M thread_stack = 192K thread_cache_size = 8 query_cache_size = 16M after ...
-5
votes
1answer
89 views

“general_logs” is not being written [closed]

I wonder why my data inside my "mysql" table "general_log" is not writing more record, stock given the last day was yesterday 04/27/2014. My my.cnf file is as follows: [mysqld] ...