The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
23 views

MySQL Workbench InnoDB Buffer Usage at 100%, always

The InnoDB Buffer Usage graph is always at 100%. I believe this started to happen when I changed MySQL's temp folder to a much bigger drive, does that make sense? I suppose the thing to do in this ...
0
votes
2answers
143 views

MySQL consuming all system memory on INSERT … SELECT

The mysql daemon is getting killed because Linux is reaching out of memory: Oct 24 07:41:23 <hostname> kernel: [82297.673701] Out of memory: kill process 13816 (mysqld) score 1839626 or a child ...
1
vote
1answer
273 views

How to Install and Run multiple MySQL Servers versions on centos? [closed]

I am new to MySQL database and I would like to install and run multiple MySQL server versions in CentOS server. I have done following things but no luck. Installed mysql 5.1.86 with default ...
1
vote
1answer
551 views

mysql doesn't start after relocating data dir

I have a web-server where the default installation of mysql places all its database files in /var/lib/mysql. The partition where /var is mounted has only 2GB of space, so after running in space ...
0
votes
1answer
301 views

Apache configuration and mysql max_used_connection conflict on ubuntu 11.10

I have some serious problems with my production server running Ubuntu 11.10 with 48GB RAM. The setup of my webserver (Apache 2.1) is configured to use approximately 18 GB of RAM. I tried to calculate ...
4
votes
2answers
4k views

MySQL 5.1 vs MySQL 5.5 (5.1 twice as fast)

I recently installed MySQL 5.1 on CentOS 6.2 and had a performance gain over the MySQL 4.1 we are running. So I upgrade the MySQL 5.1 to MySQL 5.5 to see if there was even more of a gain but it ...
0
votes
1answer
250 views

MySQL is failing to connect

I am building two mysql machines in master-slave config. Master has: mysql> create user 'repl'@'%.%.%.abc.mydomain.com' identified by 'mypassword'; mysql> grant replication slave on *.* to ...
0
votes
1answer
52 views

How to retrieve all MySQL settings?

I have a configured MySQL server (MySQL 5.1.47-community) that works perfect. I installed a second server (MySQL 5.5.15-community) to see if the new version of MySQL would work with my application ...
10
votes
4answers
6k views

MySQL Master-Master Replication of ALL databases. How?

Background: I have two MySQL 5.1 servers setup in Master-Master row-based-replication (RBR) following this excellent guide. I want all databases replicated, and will be adding new databases ...
0
votes
1answer
107 views

mac os x server running mysql servererror - services wont start

Mysql server running on Mac OS X the my.cnf file had max_connections = 10000000 client got the error 'max connections reached' restarted server, now it won't start the mysql services bellow is an ...
0
votes
1answer
278 views

Is MySQL 5.5 worth it?

I am about to setup a couple of LAMP servers using Ubuntu 10.04. The problem is that I have noticed that Dovecot needs the MySQL-common package to work. I don't want to install that package since I am ...
1
vote
2answers
816 views

Revisit - MySQL 5.1 vs 5.5

Many months ago, while MySql 5.5 was still in beta this question was asked before. Now that it has been released and there are a few maintenance updates out, what do all y'all think?
1
vote
1answer
89 views

Limiting space for a MySQL user

I maintain a MySQL server. There is one user whose database size has very quickly grown enormously. Since he is using InnoDB, the /data/mysql/ibdata1 file has grown out of porpotions. I could mount a ...