MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (7)

1
vote
3answers
2k views

MySQL-5.5.10 - Lost connection to MySQL server during query (Both Web Clients and MySQL Slaves)

We've just upgraded our existing MySQL5.1 DB servers to newer (much better) hardware with MySQL 5.5, and things have been going mostly smoothly for almost 6 weeks. Just the last few days, I've ...
0
votes
2answers
1k views

How do I get my ubuntu server to listen for database connections?

I am having a problems connecting to my database outside of phpmyadmin. Im pretty sure this is because my server isn't listening on port 3306. When I type: sudo netstat -ntlp on my OTHER working ...
0
votes
0answers
20 views

Database Organizational Structure, DB Groups

I'm setting up a web server where users can create their own databases. In order to prevent name clashing, I've typically seen hosting companies handle this by prefixing any DB name the user creates ...
0
votes
3answers
989 views

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I am facing this error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) I tried every thing I found on Internet, but can not solve the ...
0
votes
2answers
1k views

HAProxy + Percona XtraDB Cluster

I am attempting to setup HAproxy in conjunction with Percona XtraDB Cluster on a series of 3 EC2 instances. I have found a few tutorials online dealing with this specific issue, but I am a bit stuck. ...
3
votes
1answer
58 views

How can I drop a MySQL user whose username contains unprintable characters?

I have a user in MySQL 5.6 that was somehow created with a non-printable character in the username. How can I drop this user? mysql> select user,host from mysql.user where user like 'wiki%'; ...
0
votes
1answer
28 views

Force a connect to mysql

My Mysql server instance has crashed (I assume its been 10 hours and its not running) - I have tried show full processlist but the new connection can't connect. I've tried using mysqladmin and that ...
0
votes
1answer
16 views

Lowering MySQL Full Text Word Length

Hello I just installed MySQL 5.6 on my vps and I realized numbers were not searching in full text searches. Then I came across this article ...
-1
votes
1answer
37 views

MySQL recovery procedure [closed]

After the server die, I have "old" HD (it is external now) with sock file and data files in mysql directory. Where I should find information how to restore the data in fresh installed MySQL? What ...
0
votes
1answer
29 views

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 ...
36
votes
10answers
27k views

`mysql_upgrade` is failing with no real reason given

I'm upgrading from MySQL 5.1 to 5.5, running mysql_upgrade and getting this output: # mysql_upgrade Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck FATAL ERROR: Upgrade failed ...
0
votes
1answer
33 views

MYSQL - lacked sufficient buffer

I'm getting this error on my MYSQL Server Version is 5.0.4: An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full When I ...
0
votes
1answer
82 views

Suddenly mysql/mariadb won't start

Suddenly, after simply adding a few tables to database within the install... the service won't start. Any help welcome. systemctl start mariadb Job for mariadb.service failed. See 'systemctl status ...
0
votes
0answers
4 views

Local MySQL instance running extremely slow compared to remote version [migrated]

I posted here, on ServerFault, because make more sense over StackOverflow. The code below is just to show that my MySQL function is very simple, I think. I'm working on a local project and it have a ...
10
votes
1answer
6k views

What is “freeable memory”?

Amazon RDS has a metric for 'freeable memory'. It appears to go down in a sawtooth pattern: https://skitch.com/adamnelson/rnhpu/aws-management-console This leads me to believe that it's memory that ...
0
votes
0answers
15 views

Is this normal binary logging behaviour - maintaining one ever growing file despite expire_logs_days? [migrated]

I have a Percona MySQL DB running on a dedicated server. I have in my.cnf # REPLICATION # log_bin=/var/lib/mysql/binlogs/mysql-bin expire_logs_days=7 My issue is that the log file mysql-bin.000001 ...
1
vote
1answer
927 views

mysql becomes unresponsive at same time every day

My server goes down every day at same time. I found that the issue was due to mysql. I tried show processlist; and found that data base was entering in to sleep mode. I saw there was so many inserts ...
0
votes
1answer
1k views

Run mysqld under a different user (linux)

I've been trying to start mysqld under a different user as well as with a different data path. I've done so by modifing the my.cnf file as follows: [mysqld] datadir=/bob/database ...
0
votes
0answers
37 views

MySQL allows zero date(0000-00-00 00:00:00) after I enabled strict mode

I want to configure a MySQL db instance not to accept zero dates(0000-00-00 00:00:00) because the software running on top of it fails to run if it encounters such a field. The server is running ...
0
votes
1answer
25 views

Salvaging inaccessible MySQL db without InnoDB log files

In the past few weeks, I have been playing with the configuration of our test MySQL server, without first making a mysqldump of applications running on it. Aim was to increase performance and enable ...
0
votes
2answers
804 views

MySQL Cluster transaction isolation level - READ_COMMITTED

I'm learning by mostly reading the documentation. Unfortunately, http://dev.mysql.com/doc/refman/5.1/en/set-transaction.html#isolevel_read-committed doesn't say anything, while it says everything. ...
1
vote
2answers
82 views

Postfix - Dovecot - Can Send Emails But Wont Receive - NOQUEUE - Relay Access Denied

I have set up a mail server on ubuntu. Ive checked ports are open and I've double checked all config files, checking with every google search result I could find. Most of the similar posts have more ...
0
votes
1answer
15 views

mysql server mostly stops working when binlog disabled

Performance was a little slower than I'd like on a mysql server, and we don't use replication and don't need point-in-time restores. So one recommended way to improve performance seems to be turning ...
0
votes
2answers
1k views

Can't allocate nodeid for API

I'm running a pretty minimal MySQL cluster with configuration pretty much taken straight from the documentation. The data nodes are connecting fine, but the management server refuses to accept the ...
0
votes
0answers
10 views

Side effect of warning ip address could not be resolved name or service not known mysql [duplicate]

I setup Master Slave replication on two servers. It is working fine. But when I was reading error logs I found out the following warning - warning ip address could not be resolved name or service not ...
1
vote
0answers
20 views

Timed windows server event to prepare csv file for third party FTP collection

I hope this is posted in the correct forum. I have a Windows 2008R2 web server that runs MySQL. I need to execute a SQL script against the mysql database to create a CSV file, and save to a defined ...
1
vote
1answer
298 views

Telnet 3306 fails to connect to Amazon EC2

Ok, I know this has been asked a lot, but I've tried every advice I can find and I still can't telnet to my Amazon server on port 3306. Add iptables entry for accepting connections on port 3306: ...
0
votes
0answers
34 views

Intermittent mysql database connection lost

i recently installed Ubuntu 14.04.1 LTS on Azure VM; and installed MYSQL Server version: 5.6.19-0ubuntu0.14.04.1 (Ubuntu) VM hardware is D-Series (1 core, 3.5 GB RAM, 50 GB SSD) My applications on ...
0
votes
0answers
34 views

Unable to connect to remote MySQL from VPS

I am trying to establish a remote MySQL connection from one VPS to another. I have tried and done everything, I have allowed the outgoing TCP port (3306) in csf.conf, I have used Iptable rules online ...
1
vote
2answers
992 views

When to increase AWS RDS MySQL Server instance to larger CPU/RAM?

I'm wondering at what stage do I need to increase the image for the RDS MySQL server to a larger CPU/RAM instance. The CPU utilization graph is near 0. The Avg Free Memory is around 150MB. The Avg ...
-1
votes
3answers
255 views

MariaDB 10.x on CentOS 7?

Why there is no MariaDB 10.x RPM for CentOS/RedHat 7? How can I install it? I'm trying to install the most recent stable version on my server, but it seems, that official repo is absent. 5.5 is ...
-1
votes
0answers
102 views

mysql_upgrade fatal Error on CentOS 7

I just upgrade MariaDB (Mysql) 5.5.40 to MariaDB 10.0.15 by following this step by step. I have failed to enable the mysql and also mysql_upgrade with the following errors mysql_upgrade -u root -p ...
-1
votes
0answers
26 views

Mysql queries peak to several millions every few days and kill the mysql. How to find the culprit?

There are 10s of sites hosted on this VPS and most are WP sites. How would one find the culprit behind this odd behaviour? Monthly view weekly view daly view
25
votes
3answers
116k views

How to enable MySQL logging?

I am running MySQL 5.0.45 on OS X 10.6.1 and I cannot get MySQL to log anything. I am debugging an application and need to see all queries and errors. I added to the etc/my.cnf: [mysqld] ...
0
votes
0answers
49 views

High CPU load because high CPU time for sys

I am using MariaDB galera cluster with two nodes + one node for arbiter. My system has 24 core CPU. I am getting stuck with CPU bound. Sometimes, my system consume CPU time to 1000% and CPU load get ...
1
vote
2answers
1k views

mysql thread_cache_size reduce CPU and max connection?

Recently found out my MySQL server hits 90% high CPU utilization when simulating over concurrent 100-500 threads request with the default settings plus following in my.cnf max_connections = 500 ...
0
votes
2answers
2k views

Can't connect to MySQL server error (61)

I use Sequel Pro as a remote MySQL client. Today I tried to connect to my server with these settings: I get this error message when I click connect: I don't understand how only a few days ago ...
2
votes
2answers
4k views

1286 - Unknown storage engine 'InnoDB'

I am trying to use roundcube and it recently just broke. I don't know if this is due to a MySQL update that happened recently or not but in phpMyAdmin I get the following error if I try and view a ...
1
vote
2answers
1k views

MySQL connecting issue with Zend App

I've set up a VirtualHost on my local machine (Windows XP with XAMP installed) and installed Zend there as well, now I'm trying to connect to the MySQL database and I get the following error message: ...
-2
votes
0answers
12 views

initial Connection to Mysql is slow [migrated]

My intial connection time from my azure IIS server to my VM having mysql is Connection time: 0.04 However subsequent connection times are well under 0.01 Connection time: 0.01 I dont think this ...
0
votes
1answer
99 views

yum dependancy error - looking for the wrong version of php-mysql

So I was trying to upgrade from MariaDB 5.5 to 10.0. (which is essentially MySQL fork) The installation instructions say to yum remove mariadb-server mariadb-common mariadb-compat then re-install ...
1
vote
1answer
917 views

InnoDB “log sequence in the future!” crashing, won't start

I stopped mysql only to find that it wouldn't come back up, /etc/init.d/mysql start only outputs . . . . . . failed. I've narrowed it down to an issue with InnoDB. The database starts when ...
2
votes
2answers
1k views

Multiple root user accounts for mysql on Ubuntu

I'm using ubuntu 12.04 and trying to get things secured. I'm still pretty new to Linux so I'm not quite sure how to interpret this. I logged into my root account using mysql -u root -p and then to ...
0
votes
2answers
959 views

MySQL Memory Limit Windows Server 2003

I am running MySQL 5.0.51a on Windows Server 2003 Standard Edition on an HP DL580 G4 with 3GB installed. One of my database tables has grown to 5.3 GB with an index file of 2.5 GB, which I believe is ...
0
votes
2answers
400 views

MYSQL Permission: Access denied for user 'debian-sys-maint'@'localhost

Got a problem with a mysql server installation on Debian. (Not my server so I have no idea what caused this...) Installing new applications that add a database fail with error: ERROR 1045 (28000): ...
0
votes
2answers
2k views

OpenVZ MySQL InnoDB won't start

I have a OpenVZ Server with 4GB RAM and have tried to install MySQL on several distros (Ubuntu 12.04 64Bit, Ubuntu 12.10 64Bit, Debian 7 64Bit) and I always get the same errors: 130718 6:57:27 ...
1
vote
2answers
935 views

Centos MySQL optimization 4gb ram

I am using Centos 6 64bit on vps with 4gb ram. 1 wordpress website and 2 wallpapers script websites. Wordrpess have 10k visits daily. Site is slow. My.cnf # Example mysql config file for large ...
2
votes
3answers
839 views

Amazon RDS Pros/Cons of Multiple DBs per instance

I run two completely independent websites. I am moving their MySQL databases to Amazon RDS. I'm not going to do Multi A/Z deployment - let's remove that variable from this question. I'm not sure ...
0
votes
4answers
4k views

Can't connect to mysql server (13) using php function

I opened every links google results had thrown to me in regards to this MySQL error. I have been spending hours to get this to work.. I have a web server (apache in centos installed in host B, and ...
0
votes
1answer
1k views

Can not restart mysql service after getting Error 2002 Can't connect to local mysql server

Starting yesterday, I'm getting this error when connecting to mysql: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I haven't touched my ...