Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [mysql5.1]

20 questions
17
votes
4 answers

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 regularly. Goal: I would like to be able to add new…
Andrew Ensley
  • 912
  • 2
  • 16
  • 30
7
votes
2 answers

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 problems, I decided to relocate mysql's data…
king_nak
  • 193
  • 1
  • 1
  • 6
4
votes
0 answers

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 situation is to try and increase the innodb…
GGGforce
  • 669
  • 2
  • 7
  • 10
4
votes
2 answers

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 actually ran half the speed of the MySQL 5.1 setup. The…
David
  • 295
  • 4
  • 10
3
votes
1 answer

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

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 settings. Trying to install another MySQL server version…
suresh
  • 39
  • 1
  • 3
2
votes
1 answer

Bugzilla migration from ubuntu 10.04 to 14.04 with Mysql 5.1 to Mysql 5.5

I am running Bugzilla 4.0 on Ubuntu 10.04.4 LTS running on physical server & thought of upgrading it to Ubuntu 14.04 on Hyper-V for testing. After migration of bugzilla webroot 4.0 to Ubuntu 14.04 with MySql 5.1 server to MySql 5.5 & other required…
Caterpillar
  • 1,122
  • 2
  • 22
  • 47
1
vote
0 answers

Trouble getting automysqlbackup to keep connection to mysql server

I am trying to follow the instructions from the following page to set up backups for mysql. https://www.howtoforge.com/tutorial/mysql-incremental-backup-point-in-time-recovery/ However, once I get to the step where I run the automysqlbackup, I…
user2850818
  • 111
  • 1
1
vote
0 answers

Joomla website migration from IIS7/PHP5.3 to Apache 2.4/PHP5.6.13: The MySQL adapter 'mysql' is not available

it's been 2 days I can't figure out why I can't connect to MySQL from my Apache Website. I have a Windows 2008 R2 Server that hosts the company website on IIS7, with Joomla 1.5.3 and PHP 5.3 (installed in c:\program files (x86)\php\v5.3). It's…
Morenz
  • 23
  • 5
1
vote
1 answer

MySQL database name with hyphen

I have recently upgraded my staging database server from MySQL 5.0.84 to 5.1.72. I am trying to restore the mysqldump after upgrade. The database name in the dump is gss-app. But the database folder name under /var/lib/mysql turned to be…
Manny0606
  • 143
  • 1
  • 2
  • 9
1
vote
2 answers

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?
Zak
  • 1,032
  • 2
  • 15
  • 25
1
vote
1 answer

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 small partition and put his database there but…
Henno
  • 1,046
  • 5
  • 19
  • 33
0
votes
0 answers

Migrating MySQL 5.1 to MariaDB 10

I plan on migrating my data from MySQL 5.1 to MariaDB 10. At the same time I will be upgrading hardware so I will have a completely new server. Is it possible to simply mysqldump from MySQL 5.1 and import into MariaDB 10?
go0n
  • 59
  • 1
  • 6
0
votes
1 answer

Unable to log in to MySQL

I am trying to connect to MySQL through the command prompt. But I always get "access is denied for 'admin'@'localhost' user." (Error 1045). This MySQL is running on Windows 2012 R2 server. There I have two instances of MySQL server running on…
WannaBeGeek
  • 121
  • 4
0
votes
1 answer

MySQL connections peak right after restart

I have a fairly busy server, with about 200 qps and a read/write ratio of about 10, running on MySQL 5.1.73 64bit on CentOs 6.6 Most aspects are optimized, however, whenever i restart mysql, it goes to about 80% of available connections. After 10-30…
radoo
  • 3
  • 3
0
votes
2 answers

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 kernel: [82297.673701] Out of memory: kill process 13816 (mysqld) score 1839626 or a child There is a link with some workaround on this. That…
siete
  • 23
  • 5
1
2