Tagged Questions

I am not sure if this is possible or not but I have 3 servers.
Server A, B and C
Server A has database A_dataBase, B_database
Server B has database A_dataBase, B_database and C_database
Server C has ...

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 ...

SSD VPS with one Magento site on it.
Recently whenever I make a save to a product, the mysql QPS skyrockets and server load goes up tenfold for several minutes (even though the admin page loaded long ...

i moved my Master/slave database architecture to Amazon RDS and everything works fine.
But i have a slave out of the RDS service which should keep sync with the new Master server, to do so i have to ...

I have a MySQL server that serves a couple of databases including a Magento e-commerce store.
We have been suffering with corruption in the ibdata1 file for a while, but it has now reached a critical ...

I have MySQL Server version: 5.0.77-log Source distribution on a RHEL6 server.
I need to reinstall it on a second RHEL6 server to set up a testing environment but I cannot find where to download this ...

I know there is a bug in MySQL 5.0 which prevents aborted connections from being logged in the error log (http://bugs.mysql.com/bug.php?id=24761).
However, aborted connections should still be logged ...

I have an AZURE virtual machine with a MySQL server installed on it running ubuntu 13.04. I am trying to remote connect to the MySQL server however get the simple error "Can't connect to MySQL server ...

Currently i'm setting up Centos 6.3 (64 bit) on vm and installing Wordpress:
Already adjust /etc/php.ini but seems like overwritten by other settings.
Suspect this is due to selinux feature. My goal ...

I have a MySql server which has 2 active databases which are used for a web application and 3 inactive ones (left for archival purpose but not currently used). The problem is that the server seems to ...

I am using CentOS 5.7 with 64 bit. In my machine already have MySQL 5.0.88 version. Now I want to upgrade MySQL to 5.5 version. I followed this link to start my installation process. When i give "yum ...

After upgrading MySQL to version 5.6.10 from version 5.5 I'm getting the following errors when starting MySQL server:
2013-03-19 05:32:38 2666 [Note] /usr/sbin/mysqld: ready for connections. Version: ...

I just upgraded Ubuntu from 11.10 to 12.04. My rails app now returns the (passenger) error "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) (Mysql2::Error)". I ...

Sorry, I seen similar threads but I still couldn't find it addressing my issue plus, I needed some more info on this.
Requirement: To create an exact replica 'db4' of an existing DB 'db3'.
Procedure ...

I have a server with multiple databases on it. Its actually an instance on AmazonRDS so I do not have access to the my.cnf file. What I am trying to do is a create a log for each database separately ...

I have a centos5.5 system and have MySQL 5.0.27 install. Now I want to upgrade this to MySQL 5.5.28(Latest). I have two questions,
What is the difference between RPM(Redhat) which is recommended and ...

We have a MySQL server at one location, replicating to another in a Master->Slave configuration. There are about 5-7 different databases on this server. We are wanting to do this...
We have a second ...

In Ubuntu 12.04, I'm having difficulties creating a script (since I'm not experienced with it), and is assigned to add multiple users from a list of names in file usernames.txt.
The users will have ...

In production server as of now we are running with MyIsam tables only, hence we have disabled the innodb engine with skip-innodb option. But now onwards we need to enable the innodb engine as well for ...