The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
311 views

How to take mysql replication backup

I have a MySQL master-master replication setup with a slave for each master(only one master used for read/writes at a time) on Ubuntu server. Wondering what would be the best way to schedule backup of ...
3
votes
2answers
3k views

Maximum execution time of 300 seconds exceeded error while importing large MySQL database

I'm trying to import 641 MB MySQL database with a command: mysql -u root -p ddamiane_fakty < domenyin_damian_fakty.sql but I got an error: ERROR 1064 (42000) at line 2351406: You have an error ...
1
vote
1answer
108 views

Migrate to mysql replication server without interuption

I have a 3 apache2 / tomcat servers in a load balanced setup. Each tomcat server is connecting to a MySQL v5.0 database (all 3 share it). I created on the same network a MySQL v5.5 semisynchronus ...
2
votes
1answer
2k views

MySQL 5.5 replication setup on ubuntu 12.04

The following master-master configuration worked on MySQL Server 5.1.x(Ubuntu 10.04). Master1(192.168.2.80) ################################## #MySQL Replication ################################## ...
1
vote
3answers
4k views

Install MySQL 5.6 on CentOS 6.3 gone WRONG

I am trying to install MySQL 5.6 on CentOS 6.3 64bit using the .rpms provided by MySQL. I downloaded all the 64bit linux rpms into /usr/local/src/mysql and performed rpm -Uvh *. The installation gave ...
1
vote
2answers
3k views

Upgrading MySQL 5.5 to 5.6

I've decided to do the update of MySQL from 5.5 to 5.6 on my CentOS server. How can I backup MySQL5.5 in case I want to downgrade, and how can I install MySQL 5.6? Is there a way to use yum for ...
0
votes
1answer
220 views

MySQL causes iowait's since 5.5 - optimal my.cnf wanted

I upgraded my MySQL server from 5.1 to 5.5 on CentOS (with 2 cores and 2GB RAM). With my old my.cnf the mysql service doesn't start anymore (complains about a PID file), so I use an almost empty ...
2
votes
2answers
472 views

MySQL binary logging

My server is telling my that binary logging is disabled. When I do a mysqladmin variables, I see this: log_bin | OFF. This is my configuration file: [mysqld] ...
-3
votes
1answer
2k views

High Cpu Usage after MySQL Update (5.1 to 5.5) on CentOS 5.8 (64 Bit)

General Problem: Server load 20.92 (8 CPUs) [it varies from 7 to 40, normally it should be less than 1) Server Specs: Dedicated Server Intel Core i7 (8 Cpus) RAM: 8GB We use WHM and we have about ...
0
votes
1answer
787 views

How to bind mysql server to a certain IP?

In remote mysql 5.5 server I tried to add bind-address = 11.22.33.44 Where bind-address = 127.0.0.1 has commented out and 11.22.33.44 is the Ip of the web server communicating with the database ...
6
votes
3answers
5k views

Cant connect to mysql using self signed SSL certificate

After creating a self-signed SSL certificate, I have configured my remote mysqld to use them (and ssl is enabled) I ssh into my remote server, and try connecting to its own mysqld using ssl (mysql ...
1
vote
1answer
226 views

How does MySQL 5.5 and InnoDB on Linux use RAM?

Does MySQL 5.5 InnoDB keep indexes in memory and tables on disk? Does it ever do it's own in-memory caching of part or whole tables? Or does it completely rely on the OS page cache (I'm guessing that ...
1
vote
3answers
2k views

How to upgrade mysql5.0 to 5.5 on CentOS

I am trying to upgrade mysql from 5.0 to 5.5 on my local server. I have CentOS 5.8. I have php5.3 installed. When I type yum remove mysql mysql-* The following comes out. Removing: mysql ...
0
votes
1answer
2k views

What is the use of ibdata1 file in mysql [closed]

I have application which has the backend db as Mysql(InnoDb engine), and currently my client wants to decrease the size of the ibdata file to some fixed size. I found the three below solutions. ...
1
vote
1answer
2k views

Getting Error “Unknown MySQL server host” during importing the sql file?

In mysql server, when importing the sql file into the db. I am getting as error as below. So, can you help where the issues lies that is in mysql server config or the sql file ERROR 2005 (HY000) at ...
4
votes
2answers
5k 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 ...
1
vote
0answers
95 views

How can I set the original PHP mysql api driver to auto-reconnect by default in MySQL version > 5.0.13?

MySQL server turned off auto-reconnect by default in version 5.0.13: http://dev.mysql.com/doc/refman/5.0/en/auto-reconnect.html In MySQL 5.0, auto-reconnect was enabled by default until MySQL 5.0.3, ...
3
votes
1answer
1k views

Recover a crashed MySQL master server from the slave

we are building a simple master/slave MySQL configuration using asynchronous replication, with MySQL enterprise 5.5.17 on both servers and innoDB based tables. In case of a crash of the master server ...
2
votes
1answer
559 views

MySQL 5.5 on CentOS 6 — mysql user 'root@localhost' cannot grant privs

This is a new install and I have only set the root passwords for localhost, 127.0.0.1 and . I know the password is correct as I can log in with root@localhost to the mysql server and can also create ...
2
votes
1answer
3k views

Installing MySql 5.5 on Debian with the deb package

I'm setting up a debian server as a development server. apt-get gave me everything I need to install, except for mysql 5.5 as this version is still in the experimental branch. So what I tried to do ...
1
vote
2answers
1k views

Replication issue with mysql 5.5.8 while restoring the dump on master server.

While restoring the Mysql dump file it throws the following error. ERROR 1665 (HY000): Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one ...
0
votes
2answers
137 views

What production grade linux has MySQL 5.5? [closed]

I want production grade linux with LTS, long term support, that has MySQL 5.5. I.e. no third party repositories, no downloading binaries from mysql.org. Are there any available now or soon? The first ...
0
votes
1answer
658 views

Mysql rpm package build for Scientific Linux

In my organization we need to deploy custom mysql packages for our Scientific Linux nodes. We need the latest version of mysql and the install directory as /opt/mysql I am trying to build from ...
0
votes
1answer
131 views

MySQL-server-5.5.18 - Installation issues / doubts

1 ) How to relocate the data dir while installing the MySQL-server-5.5.18-1.linux2.6.i386.rpm. rpm -ivh MySQL-server-5.5.18-1.linux2.6.i386.rpm
3
votes
2answers
935 views

MySQL 5.5 InnoDB = OFF?

We run a server with MySQL 5.5. 95% of the tables are set to the InnoDB engine. However whenever I look at the my.ini file (using the MySQL Workbench) under mysqld section innodb is unchecked and OFF ...
1
vote
1answer
345 views

MySQL server 5.5 , my.ini settings

There are a view things that don't match in my MySQL .ini file. For example, everything that I have read/learned is to use config_settings = value however, in my configuration file there are: ...
1
vote
1answer
181 views

CSV engine on MySQL server

I don't think that this is a programming question so I am going to ask it here - Reading the book high performance mysql, I read about the CSV engine. The paragraph says: The CSV engine can treat ...
0
votes
1answer
96 views

Understanding MySQL Query Cache and when to implement it?

On our current MySQL server query cache is enabled. Qchache_hits: 31913 Qchache_inserts: 50959 Qchache_lowmem_prunes: 9320 Qchache_not_chached: 209320 Qchache_queries_in_chace: 986 com_update: 0 ...
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 ...
2
votes
1answer
492 views

Changing MySQL datadir on active server

I have a server that seems to be setup wrong by previous administrator.. The server has two disks, disk 0 which is the operating system (RAID1 clone) disk 1 which is 3 drives in a RAID5 setup with ...
1
vote
1answer
855 views

Cannot start MySQL 5.5 as normal user (fedora 15)

service mysqld start gives me: Starting mysqld (via systemctl): Job failed. See system logs and 'systemctl status' for details. [FAILED] ...
1
vote
3answers
3k views

Percona MySQL 5.5 fails to start

trying to setup new server here but keep getting this in error log: mysqld_safe Starting mysqld daemon with databases from /data/mysql/myisam [Warning] Can't create test file ...
0
votes
2answers
136 views

Where do I find a MySQL self-installer for OSX?

I don't have the resources or know-how to install MySQL from source, and the downloads page on Mysql.com only provides versions that require lots of manual linking. Isn't there anywhere that ...
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 ...
0
votes
1answer
133 views

Can't run Apache - Would having Ruby on Rails and mysql server installed on the same machine be the reason why?

everyone. I am trying unsuccessfully to run Apache on my machine. I used the command line to find out all the applications that are using port 80 and I ended them, but Apache refuses to run on my ...
1
vote
2answers
836 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?