I have my MySQL database server on Server 1. I want to have my Rails apps on two other servers - say A and B to be able to connect to this Server 1. What's the best way to do this? In the my.cnf file it appears I can use the bind-address to bind to one and only one IP address. I can't specify the IP addresses of both A and B in my.cnf. ...
Hi All, I want to use mysql server on two different ports on same machine. I made two separate cnf files for the same. when I am trying to connect to mysql server with second port which i have added I am unable to do so. I am working on Windows Vista. I tried to start mysqld from command line after specifying port. This is the sample f...
The following is my default production MySQL configuration file (my.cnf) for a pure UTF-8 setup with InnoDB as the default storage engine. [server] bind-address=127.0.0.1 innodb_file_per_table default-character-set=utf8 default-storage-engine=innodb The setup does the following: Binds to localhost:3306 (loopback) instead of the defa...
I am able to do this on my linux box in my.cnf sql-mode = "PIPES_AS_CONCAT" but on my OS X laptop, in my.cnf sql-mode = "PIPES_AS_CONCAT" immediately halts the server. not sure how to fix or further investigate. ...
Edit: This may be a 5.0-specific bug. (I'm on 5.0.83). Removing the innodb_log_file_size setting gets rid of the problem. Which makes complete sense. Not. Googling about finds a handful of similar, but not identical problems in 5.0 that were patched later. With the "wrong" settings in my.cnf, this create statement on MySQL 5.0 will...
Hello, Is there a way I can figure out which my.cnf mysql is currently using? The reason is because it's using the correct socket file to connect, but I can't figure out exactly which (if any) my.cnf it's using or trying to use so I can manually set the correct path on my local machine. ...
This is a pretty simple question about setting parameters in the my.cnf file for mysql 5.1. This page gives me the parameters I can tune: http://dev.mysql.com/doc/refman/5.0/en/server-parameters.html and so I think I would need to write key_buffer_size = 256M But when I open my current my.cnf, it has the line: key_buffer = 16M M...
Recently, sometimes I cannot open my site. I'm using VPS for hosting. and when I do mytop it shows me: User Host/IP DB Time Cmd Query or State -- ---- ------- ...
In /etc/my.cnf the following has been added character-set-server=utf8 collation-server=utf8_general_ci But for the database and tables created before adding the above how to convert the database and tables to utf8 with collation settings ...
Hello, I am having load problems on my database server (dual quad core 50 gb ram) load average: 4.26, 6.78, 11.25 here is the current my.cnf, can i optimize it? [client] port = 3306 socket = /var/run/mysqld/mysqld.sock [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0 [mysqld] user ...