MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
1answer
210 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
55 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
32 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
47 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
24 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
34 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
54 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
49 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
64 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
212 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
290 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
128 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
38 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
78 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
50 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
72 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
126 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 ...
1
vote
1answer
629 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
39 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
41 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
121 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
60 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
75 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
175 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
31 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
123 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
48 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 ...
0
votes
0answers
27 views

Forward traffic to MySQL over two+ SSH hops

I am trying to get from my computer through a gateway VPS to the database VPS and leave a forward port open back to my computer so I can access MySQL. For example, using port 9999 on my machine I was ...
-1
votes
1answer
32 views

MySQL - data inside vm on shared storage? [closed]

I'm planning on moving all my VMs to shared storage, and I have a question about how to deal with a MySQL VM: Currently the size of the VM image is 100GB, where most of the space is taken up by the ...
1
vote
2answers
81 views

Can't connect to MySQL from another server

I have two servers on the same subnet. 192.168.100.1 (mysql) 192.168.100.2 (php) MySQL seems to be running fine on it's box but I can't seem to connect to it. These are both ubuntu boxes and ...
2
votes
2answers
210 views

No changes made but MySQL InnoDB overloading CPU

I haven't changed any scripts or settings what so ever. Now I have CPU load at least 4 times higher. Mysqld is taking around 360 %CPU according to TOP. It's Debian, I'm running some MyISAM tables but ...
0
votes
1answer
380 views

ERROR 1130 (HY000): Host 'host' is not allowed to connect to this MySQL server, only on slave

So I have a master and a slave in a mysql cluster, the syntonization works as it should however I am not able to connect to the slave from any host except from the server it self. I have no problems ...
0
votes
2answers
79 views

Running 'show process list' simultaneously

I have two scripts put into a cron that runs every single minute. Both the scripts connect to the same database and runs a show full processlist. Is it okay if two show full processlist commands are ...
-2
votes
3answers
190 views

I can not do anything with mysql [closed]

Debian woke up in a bad mood. I worked on it until 9pm yesterday using LAMP. The process that I made yesterday to today was off and on the machine. When I called today mysql just does not work. Follow ...
-1
votes
1answer
366 views

Mysql crashing/restarting, InnoDB: Unable to lock ./ibdata1. Can't kill via 'stop';

My server seems to crash/restart under a load that would not have previously made it crash. How can I troubleshoot this? VPS is running Centos 6.x, 8GB ram Mysql is crashing/restarting itself ...
0
votes
1answer
107 views

Postfix MySQL Dovecot Roundcube configuration

I am in the process of setting up a mail server and I was hoping to get some help. It starts with Roundcube webmail, when I tried to login with an existing correct user name and password it gives me ...
0
votes
1answer
98 views

Mysql crashed, dumped DB's in recovery mode. What now?

I ran into an InnoDB issue that only seemed to get worse as I tried to fix it. Started with InnoDB: Unable to lock ./ibdata1, error: 11, I moved and then copied it back. I soon had an ib_logfile issue ...
0
votes
0answers
69 views

How to change the execution time of the my.ini file using Chef

I'm attempting to get an existing Drupal site set up using Vagrant Drupal Development but have come across a few problems. My first is that I cannot seem to connect to the database to import my SQL ...
0
votes
0answers
191 views

MySQL Error 1114 the table is full

I've got a MySQL cluster where I build a new database for each customer. The databases are relatively small in size and I currently only have 4 databases on this cluster. I just tried to run my ...
0
votes
1answer
92 views

mysqldump running extremly slow

I posted this in stackoverflow but it rightly got moved (apologies about duplication!) I'm testing a new set of db servers on dell m820s running esx5.5 with debian wheezy using ext4 as a VM on each ...
0
votes
0answers
54 views

mysql: relocation error after installing in centOs?

I remove any mysql package and now after installing mysql after type this command mysql -u root -p this error occured: # mysql -u root -p mysql: relocation error: mysql: symbol strmov, version ...
-1
votes
1answer
234 views

Can't install mysql in centos6.4

When i try to install mysql 5.6 and i remove mysql 5.1 from centos now not installing any mysql in my VPS. yum install mysql-server Loaded plugins: fastestmirror, refresh-packagekit Setting up ...
0
votes
1answer
35 views

It is possible having MySQL server and MariaDB server together in the same Ubuntu 14.04 using official packages?

It is possible having MySQL server and MariaDB server together in the same Ubuntu 14.04 using official packages? I want to have both servers running in the same machine, using different listening ...
-1
votes
1answer
67 views

Unable to import dump.sql via a .sql file which will be run through mysql command line

I have a MySQL database that contains almost 100 tables. I want to set up N additional MySQL databases on the same server, each running on a different port. And I want each additional database to ...
0
votes
0answers
14 views

Web Based Server Monitoring and Alerts For In-house server [duplicate]

I'm currently working on a project that has an in-house set of CentOS 6.5 servers for both Apache and MySQL. What happens is that it doesn't have a monitoring system so, if it happens for the server ...
-1
votes
1answer
63 views

Error when setting up mysql cluster

I am trying to set up the mysql cluster. But when I try to start the mysqld(API) node, I get this error: 2014-12-02 17:02:37 0 [Warning] Using unique option prefix key_buffer instead of ...
0
votes
1answer
143 views

MySQL/MariaDB stops running. How do I find out why?

Today I've seen MySQL/MariaDB stop running on a CentOS VPS. When I check the status I get: # service mysql status ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists So I ...