MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
0answers
174 views

Google Cloud SQL - Lost connection and Timeout errors

I keep getting the following errors when attempting a simple connection to a Google Cloud SQL database instance from a PHP script. Lost connection to MySQL server at 'reading initial communication ...
1
vote
1answer
113 views

why is my mysql-proxy always doing selects on master?

My selects are always going to master and if i stop master I got some 'Cannot connect, all backends are down.' [read_query] 89.216.31.228:64166 current backend = 0 client default db = nivo client ...
3
votes
1answer
77 views

Is it possible to install MySQL extensions on Amazon RDS?

We are about to migrate our existing system from local MySQL instances on the same EC2 to a proper remote Amazon-RDS. Unfortunately there is a functionality called Median that MySQL is missing. Our ...
0
votes
1answer
31 views

How do I find out when a MySQL root password was last changed?

I have looked for solutions to this. I am able to change it, but I need to find out when it was last done and preferably also seeing who was logged in when it was done. Need proof for a security ...
0
votes
0answers
25 views

Why has MariaDB created database directories with @ in?

A backup script on a Debian server looked at /var/lib/mysql/*/ to find local database names. Having recently installed Seafile, this no longer works because although the databases are called normal ...
1
vote
1answer
134 views

How to remove MySQL from Ubuntu 14.04?

I tried to move my datadir on a working MySql install, which apparently I messed up. I have tried to uninstall / reinstall numerous times, only to get the same errors on reinstall. The ...
0
votes
1answer
100 views

ISPconfig / Dovecot - Mysql went down = Mails gone? [closed]

So im running ISPconfig with Dovecot as mail-server (storing mails via mysql). Yesterday i made some changes to the mysql-config. I wanted the server to answer also External Requests. The Problem ...
1
vote
0answers
54 views

Destination Host Unreachable and Communications link failure when I connect to MySQL database using D2RQ library

I have a question: I have a web service which runs on a virtual machine located on a remote server with Ubuntu 12.04 operating system. Now, I want to test this Web Service and I'm using this code ...
0
votes
0answers
34 views

Local MySQL connection using eth0 rather than lo loopback

We've installed MySQL 5.6.22 on RHEL6.6 and noticed terrible performance compared to a previous install on RHEL6.5 and MySQL 5.6.20 The main thing that we've noticed is that all the traffic appears ...
-2
votes
2answers
111 views

How to start mysql automatically if that stop for any reason? [closed]

I have a digitalocean ubuntu vps for development use only, But sometimes the mysql server stop working. As per my investigation I don't have enough memory to handle few laravel installation. As I use ...
0
votes
1answer
125 views

how to permanently increase innodb_buffer_pool_size on ubuntu

I have read lot of posts & manuals to try to find out how to increase memory in mysql 5.6 on Ubuntu, which say there are 3 methods: by editing innodb_buffer_pool_size in the my.cnf by command ...
0
votes
1answer
72 views

Two browser windows hitting same MySQL app, both can't run at the same time

I have a LAMP web application that has some pages that do quite a bit of processing and take a while to complete. Sometimes as the developer I like to do two things at once as I'm working on a ...
5
votes
1answer
748 views

Can I copy the entire /var/lib/mysql folder to a different server? (mysql vs mariadb, different versions)

I used to have a Linux system (LMDE) with MySQL. The system used innodb_file_per_table for most of the databases. (not sure about the version, whatever is the "latest" in LMDE) I am now on a new ...
-1
votes
2answers
143 views

Configure MySQL so it doesn't automatically change values in NOT NULL columns

Surprisingly (at least to me), the following queries will insert records. CREATE TABLE null_1 ( id INT NOT NULL, text1 VARCHAR(32) NOT NULL, text2 VARCHAR(32) NOT NULL DEFAULT 'foo' ); INSERT ...
0
votes
0answers
42 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 ...
3
votes
2answers
85 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
30 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
45 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
39 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
34 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 ...
0
votes
1answer
551 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
1answer
100 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
41 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 ...
-2
votes
1answer
50 views

PHP website grinds to halt for an hour, then runs fine…how to debug?

I have a PHP website which uses $_SESSION variables. It runs on Apache, Mysql and Ubuntu 14.04 on a very resourceful server (Amazon EC2 - M3.X-large) For some unknown reason, the website virtually ...
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
1answer
25 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 ...
0
votes
1answer
38 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
1answer
37 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
0answers
91 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
74 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 ...
0
votes
0answers
108 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 ...
2
votes
2answers
597 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
922 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
0answers
191 views

MySQL 5.6 Community Server failed to start in CentOS 6

MySQL 5.6 Community Server failed to start on CentOS 6. Before, I have successfully installed mysql community server (file: mysql-community-release-el6-5.noarch.rpm) on my CentOS 6, the binary source ...
-1
votes
1answer
40 views

Time of MySQL database removal [closed]

Is there a method where we could probably find when a MySQL database was removed/dropped from the server? Is this logged anywhere? Does it have a separate logfile which probably needs to be enabled in ...
-1
votes
1answer
57 views

Monitoring MySQL – “Execution failed”

Got some trouble with a VPS where MySQL dies on me from time to time. As a temporarily fix I've installed Monit to make sure that the process is restarted when it dies. I checked the site today and it ...
1
vote
1answer
122 views

How to run mysql prompt in windows powershell ISE?

I want to use PowerShell ISE tab to be able to connect mysql client and tun sql statements, however as soon as I connect to client using following command - >mysql.exe ...
0
votes
1answer
66 views

Using lvm2 snapshot of MySQL InnoDB file-per-table, do I need to stop the server for backup?

I've read a bunch of articles on taking consistent backups of mySQL, including What's the meaning of consistent dataset? (MySQL), but I still don't think I know enough to answer this question with ...
1
vote
2answers
88 views

How to interpret iostat for a crumbling MySQL server

We have a combined application/MySQL-server which has started to crumble. Right now, it gets stuck on copying a 125 million row MySQL MyISAM table (INSERT INTO a_copy SELECT * FROM a with KEYS ...
1
vote
0answers
167 views

2006: MySQL server has gone away

I am getting 'Lost connection to MySQL server' and '2006: MySQL server has gone away' errors so frequently that the server is unusable. There are questions related to this issue, but none that apply ...
2
votes
1answer
1k views

Cause of error: Invalid (old?) table or database name 'lost+found'

My MySQL log shows duplicated errors: 141223 5:47:21 [ERROR] Invalid (old?) table or database name 'lost+found' I have a database named #mysql50#lost+found but I cannot seem to delete it. ...
0
votes
1answer
44 views

Moving MySQL files from Mac to Linux

I had a mysql server running on a Mac. Unfortunately, the Mac died. However, I got a backup. I am now trying to restore the server on a Linux machine. I have moved the mysql files located in ...
0
votes
1answer
91 views

File Location of mysql startup script on Ubuntu

When we run a command as "service mysql start" [OR] "/etc/init.d/mysql start", The mysql daemon it starts. Who is providing the job mysql to start to those commands? What is the startup script file ...
0
votes
0answers
180 views

MySQL unable to repair, dump, upgrade table (simply crashes)

I need to backup one of my databases from MySQL (Running MariaDB). The issue is that aside from all of my other databases that backup perfectly fine, this database has issues backing up and crashes ...
1
vote
1answer
82 views

SSH from Windows to Jump Server to MySQL [closed]

We have a MySQL instance running on a Linux machine and had to open a tunnel to access the server. This worked fine until admin decided to add a steppingstone / jump server. Now i can't seem to ...
-1
votes
2answers
86 views

“Cannot open SSH Tunnel” on MySQL (corrected)

(help, patience and mercy... begginer lost haha) -Ok heres the deal, im trying to connect a EC2 Instance to MySQL throught SSH in MySQL Worckbrench -I set up the configurations this way SSH ...
1
vote
1answer
262 views

FreeRadius Accounting not working, bad passwords not cheked

I'm trying to configure a captive portal using a router with OpenWRT+ChilliSpot and an external server with Freeradius and a Web Server. ChilliSpot 1.3.0 My issue right now is that the freeradius ...
0
votes
0answers
52 views

Backup MySQL with LVM, questions about the MySQL Session

I want backup my mysql database with lvm. I will do the backup with cronjob. Here the pseudocode Open mysql session Run SQL FLUSH TABLES WITH READ LOCK Do backup lvcreate -l100%FREE -s -n ...
-1
votes
1answer
225 views

Why the time taken to fetch results of a query for 10,000 times from a RDS is so uneven? (experiment)

tl;dr : Why the time taken to fetch results of a SELECT statement for 10,000 times from a RDS when requested from an EC2 is so uneven? Updated the question with results of small and medium RDS ...
0
votes
1answer
67 views

How to generate unique Auto increament id field across multiple data centers?

I have multiple mysql servers deployed in three different data centers. Now my database has few tables with Auto increment id column. I want these columns in all three data center must have unique id ...