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

learn more… | top users | synonyms

0
votes
3answers
327 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
1answer
190 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
298 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
1answer
713 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 ...
0
votes
0answers
38 views

How can I check the number of TCP/IP connections in MySQL's Connection Queue ( back_log )?`

I'm chasing connection issues with a very busy MySQL server and I've increased the back_log setting from the default of 50 to 2048. I can see that the setting has taken affect in the DB, but I was ...
0
votes
0answers
378 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
252 views

my.cnf configuration for 1and1 XL8 Server 8 core cpu and 8gig ram

I am trying to tweak my server's my.cnf file because I have been receiving numerous "too many connection" warnings when doing database back ups among other things. I know I also need to tweak other ...
0
votes
0answers
111 views

Relation between max values for table_open_cache and open_files_limit?

From MySQL documentation: Max value limit for open_files_limit is 65536 and table_open_cache is 524288. When I applied max limit, mysql server started but with following warnings in error log: ...
0
votes
0answers
37 views

MySQL innodb monitor and insert/update operation

There is only one table in MySQL that has two columns like id(int) and data(blob) And, the problem I've faced is that it looks like there's something wrong with insert/update operations. For some ...
0
votes
0answers
62 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
411 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
140 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
68 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 ...