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

learn more… | top users | synonyms

4
votes
1answer
2k 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 ...
0
votes
0answers
13 views

Things we can optimize when runnung TPC-H benchmark

I am a Graduate student running TPC-H benchmark on MYSQL 5.6 . I have EC2 instance M3 large instance with a Intel Xeon E5-2670 v2 , 7.5 GB memory and 2 vCPU. Can someone please suggest me what are ...
1
vote
2answers
3k 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] datadir=/var/...
0
votes
2answers
260 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
47 views

MySQL server keeps crashing on startup

MySQL keeps crashing on start with the following message. It crashed after I was trying to batch upload data into a table and now it can't start since. This is an already existing database so it ...
2
votes
2answers
55 views

Galera: any drawback of enabling wsrep_log_conflicts and cert.log_conflicts?

We have a HAProxy which balances reads and writes to only one (of three) Galera nodes. If this balancing works fine, the parameters wsrep_log_conflicts and cert.log_conflicts should never log any ...
1
vote
0answers
66 views

Slow MariaDB performance my.cnf

I migrated my eCommerce website database (Magento) from MySQL to MariaDB (10.0.25-MariaDB) and my site isn't performing as well as it did with MySQL. I've gone through my.cnf several times but to be ...
1
vote
1answer
22 views

Where do i change the my.cnf on mysql cluster

I'm trying to change the max_allowed_packet setting on mysql cluster (version 7.4.8) - i have 5 nodes 2x SQL Node 2x Data Node 1x Managament Node I have updated the my.cnf on all of the servers -> ...
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 ...
2
votes
2answers
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 ...
0
votes
0answers
29 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 ...
-1
votes
1answer
247 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
vote
1answer
2k views

Mysql Optimization suggessions

I have an InnoDB database table with more than 2 million rows. I am running efficienty indexed queries to reduce server load, but site becomes slower day by day. I ran Mysqltuner.pl to identify any ...
0
votes
0answers
30 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 net_read_timeout=...
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
1answer
284 views

How to set slow query log in MariaDB my.cnf?

It should be easy, but when I put these lines: log_slow_queries = 1 long_query_time = 1 log-slow-queries = /var/log/mysql/slow_query.log log_queries_not_using_indexes in [mysqld], MariaDB fails to ...
1
vote
0answers
30 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 ...
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 ...
5
votes
1answer
40k 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 ...
0
votes
2answers
256 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
1answer
1k 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
0answers
102 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 ...
4
votes
3answers
2k views

How can I make MySQL client read password from mylogin.cnf?

I'm trying to make the mysql client connect to a mysql server without requiring the password to be given interactively. Steps taken: 1) First create a mylogin.cnf file $ mysql_config_editor set --...
2
votes
0answers
114 views

Suggestion To Improve My.cnf INNODB

I'm after suggestions on how to increase mysql performance on my server, any help would be greatly appreciated. CPU - 4 core RAM - 16GB Databases - 14 Innodb databases with around 20 tables in each (...
2
votes
2answers
720 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 ...
3
votes
1answer
342 views

unknown variable 'log_slow_verbosity=query_plan'

What is the use of log_slow_verbosity = query_plan parameter in my.cnf ? I got an error when installing MySQL in my machine because of this parameter.
1
vote
1answer
84 views

Made changes to my.cnf and mysqld wont restart - no backup

I thought I'd be clever and update my.cnf file to add ft_min_word_len=2 and didn't back it up first. I will never make that mistake again. Luckily, our project is still in production and no harm done. ...
0
votes
2answers
112 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?" ...
2
votes
1answer
2k views

Can I reduce MySQL memory usage, or do I need to add more RAM?

I have a VPS with 2.25GB of RAM. MySQL is using 1.4GB with only four users on my site right now. It seems to use this amount even when no users are online. The available memory of my server regularly ...
1
vote
1answer
50 views

Recommendations for my.cnf on MySQL Replicant

I have replication environment running in a master-slave configuration. The replicant is doing all writes and doing selects only very rarely - and none in which high performance is a requirement. ...
1
vote
0answers
183 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, ...
0
votes
2answers
357 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 ...
1
vote
2answers
128 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 ...
5
votes
1answer
451 views

Tools for cnf management, generation? [closed]

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 ...
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
230 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 mysql....
2
votes
1answer
535 views

Upgrading to new cPanel Server with mySQL on SSD — What should I change in my.cnf?

I'm upgrading to a faster server with whm/cpanel and the mysql databases will be on a SSD. I've read a bit about not wanting any query cache and stuff like that, but as a novice, I've learned that ...
1
vote
1answer
4k views

MySQL wait_timeout setting ignored

I have a MySQL 5.5 instance running on a RedHat distro. I have edited my.cnf with the following setting: wait_timeout=30 However, client connections are sleeping and never getting killed. The ...
0
votes
1answer
212 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 ...
0
votes
1answer
46 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 ...
2
votes
1answer
2k 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 doesn'...
2
votes
1answer
1k views

MATCH AGAINST one character words returns empty rows with ft_min_word_len = 1

I've set ft_min_word_len = 1 to my.cnf file, also SHOW VARIABLES LIKE 'ft_min_word%' displays ft_min_word_len as 1. Then I've reloaded all database tables and it still doesn't search for one character ...
-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 ...
0
votes
0answers
72 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
0answers
693 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 ...
1
vote
1answer
7k 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 ...
2
votes
2answers
11k 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 ...
3
votes
1answer
6k 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 (...