The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
3answers
2k 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
9k views

Error 2013: Lost connection to MySQL server during query when executing CHECK TABLE FOR UPGRADE

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 ...
2
votes
2answers
162 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
966 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
122 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
675 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
109 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
4k views

MySQL - The server quit without updating PID file

I have installed MySQL 5.6.16 on Debain 7.4. But i encountered problems with starting mysql, where every time i start mysql i get this error: The server quit without updating PID file ...
1
vote
1answer
2k views

Mysql - innoDb - is in the future! Current system log sequence number

I have this error in my syslog. I restored an older dump to solve this problem, after some reading. Now The errors in syslog are far less than before. But still a few times an hour I get Sep 1 ...
1
vote
1answer
448 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
98 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
293 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
159 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
375 views

Issue with InnoDB engine while enabling and [ skip-innodb ] - [ERROR] Plugin 'InnoDB' init function returned error

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 ...
0
votes
1answer
191 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
159 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
610 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
360 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
534 views

how to enable remote access to a MySQL server on an AZURE virtual machine

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

Troubleshooting mySQL load problems

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

MySQL Server Not starting on Windows OS with Arabic

I have a MySQL server (The MySQL version is 5.5.25) that I packages with my software that I run on my Windows XP/7/8/Server, the MySQL server is starting up and running as required on the Windows OSes ...
0
votes
0answers
290 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 ...
0
votes
0answers
236 views

How to set debian with it_IT@EURO without converting the MySQL database?

I have a machine with Debian 6.0.x and MySQL Server version: 5.1.66-0 + squeeze1 (Debian). If I configure my machine with it_IT@EURO instead of en_US.UTF-8 Mysql is not happy, eg a table control / ...