The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
3answers
3k views

Screwed libmysqlclient-dev in Ubuntu

I have messed with symlinks and libraries in /usr/lib. I modified libraries like libmysql*. someone suggested to reinstall libmysqlclient-dev package. Is libmysqlclient-dev holding Mysql libraries? ...
2
votes
2answers
167 views

Upgrade from MySQL 4 to Mysql 5 - same my.cnf - lots of random disconnects

I've recently moved from MySQL4 to MySQL5 (we had apps that required MySQL4 which we'd finally replaced) Since then, I've been having LOTS of issues similar to:- connect() failed: Lost connection to ...
1
vote
2answers
2k views

Nginx + php-fpm - recv() error

I get the follow error in the nginx log [error] 17734#0: *6643 recv() failed (104: Connection reset by peer) while reading response header from upstream, client: [cut], server: [cut], request: ...
0
votes
2answers
288 views

Queries going to mysql server even when no one is connected to it

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 ...
0
votes
2answers
1k views

Mysql 5.5 is not installed in CentOS 5.7

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 -...
0
votes
2answers
135 views

MySQL is converting MyISAM tables to INNODB automatically

I recently upgraded MySQL server on CentOS 5 with MySQL 5.0.96 After upgrade when i am trying to import old database dump which has got both MyISAM and INNODB tables in a single database, MySQL is ...
1
vote
1answer
801 views

max_used_connections in mysql keeps on increasing on ubuntu 11.10

We are having mysql 5.1.58 running on ubuntu 11.10 server edition with 48 gb ram and intel e5620 processor together with apache 2.2.20. But we are facing an issue that prevents Mysql from accepting ...
0
votes
1answer
212 views

different servers different databases replication mysql

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 ...
0
votes
1answer
170 views

Can't connect to local MySQL via TCP (Error 1045)

root@127.0.0.1 exists, but still can't connect to local MySQL. It looks like MySQL verifies hostname instead of lo ip(127.0.0.1). root@castle /v/l/mysql# mysql -u root Welcome to the MySQL monitor. ...
0
votes
1answer
276 views

Where to download MySQL server 5.0.77-log

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 ...
0
votes
1answer
748 views

MySQL 5.0 not logging aborted connections in general log

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 ...
0
votes
1answer
585 views

Unable to adjust php.ini max upload size directive on Centos 6.3

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 ...
0
votes
1answer
311 views

Detect mysql password changes from logs

How can I find out who last changed the MySQL database password for the "root" user. I'm using Ubuntu.
0
votes
1answer
166 views

Problem with high mysql cpu load on Ubuntu server

I am running MySQL 5 on a production Ubuntu 8.04 server. Two separate php based sites are served, both of which involve intensive mysql queries. What I noticed is that when I request a page on the ...
0
votes
1answer
706 views

mysql 5.1 skip skip-networking param

I don't know why my mysql doesn't read the my.cnf file. I write a commented line # skip-networking on my.cnf, restart mysqld and when exec #ps aux | grep mysql returns: root 7737 0.0 0.0 ...
1
vote
0answers
675 views

MySQL rebuild after Corrupt ibdata1

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 ...
1
vote
0answers
2k views

How do I set my root account in mysql to be accessed locally?

I am running into a bit of a problem here. I have a mysql server setup on an Ubuntu 12.04 distro. After the initial install I have been using MySQL Workbench to do all my db creation and ...
0
votes
0answers
25 views

Dbmail causing massive number of updates for relatively low load

I've been using dbmail 2.2.10 for a while now, and have just become aware that it's causing a very large number of updates to its database for only a moderate load. For instance, yesterday I handled ...
0
votes
0answers
416 views

Cannot install php-mysql

I have a VPS with CentOS 6.6 x86-64 and ISPManager, PHP 5.4.43, Server version: 5.5.45 MySQL Community Server (GPL) by Remi and an version phpMyAdmin. I upgraded php from 5.3 to 5.4 and mysql from 5.1 ...
0
votes
0answers
685 views

MySQL 5.6 Create Table VERY slow

I recently upgraded my MySQL server from 5.1 to 5.6 (running on CentOS 6.x). Ever since the upgrade, when I try to perform certain table tasks the queries take a REALLY long time. This is really ...