0
votes
1answer
20 views

debug mysql crash

I have a production server which I am managing and I have been running a rails application on this server. The issue has happened twice in the past month or so and I am not sure how to debug this. ...
0
votes
1answer
14 views

Zenoss - install.sh doesnt ask for mysql password

i'm trying to install zenoss on a ubuntu-14.04 virtual machine. I followed the following guide "https://help.ubuntu.com/community/Zenoss". After some errors with dependencies, I have the following ...
-1
votes
2answers
40 views

how do I move where percona mysql stores the databases? [on hold]

I'm running low on disk space and want to move my database's to a new disk (NAS). I have no clue how to do this. Any help is appreciated. I'm using Ubuntu 13.04 and the latest version of Percona ...
3
votes
1answer
21 views

Exim4 crypteq with MySQL lookup always fails

I got an Exim 4.80 server on Ubuntu 14.04. I want to switch from Dovecot Auth to MySQL. The passwords are stored as crypt (with sha256, beginning with $5$). The expansion looks like this: ...
0
votes
1answer
30 views

Postfix and MySQL configuration

I have the problem with configuration of Postfix on my server. I have been used this link like tutorial for creating and configuration Postfix. ...
1
vote
1answer
51 views

MySQL shutting down without worning, out of memory?

I'm scratching my head on this. I have New Relic tracking, and my log files on the server, but MySQL keeps stopping, and all I have is this when I check logs, New Relic has nothing. Only thing I'm ...
0
votes
1answer
48 views

trouble running mysqldump on Ubuntu via cron job

I'm trying to set up a cron job to back up my database every night at midnight. Based on a few tutorials I've read, I've written a script that executes the following command: mysqldump -u my_username ...
0
votes
1answer
27 views

Mysqld shutting down by itself

I'm running a Wordpress Blog that gets medium-high traffic. It is hosted in an Ubuntu Server 2GB Memory 2 Core Processor 40GB SSD Disk, 3TB Transfer. The problem is that MySQL shuts down by itself ...
0
votes
0answers
37 views

After software update, why is webmin showing wrong mySQL version?

I did a full OS/package update on a server running webmin. Now when I go into webmin, it's showing the correct new version of Ubuntu, Apache, etc...but it's still showing the old version of mySQL. ...
-1
votes
0answers
31 views

MySQL Server Is Slow

I have two MySQL servers and one was just recently setup. The one I just recently setup is a bit slower than my older one, which kind of bothers me because I don't want my clients to be upset with the ...
0
votes
0answers
57 views

Amazon EC2 Instance - m1.medium Ubuntu 12.04 - Started to crash three days ago

The environment: Amazon EC2 Instance - m1.medium Ubuntu 12.04 Apache 2.2.22 - Running a Drupal Site Using MySQL DB Server RAM info: ~$ free -gt total used free shared ...
1
vote
1answer
40 views

Locked out of my own MySQL Database [duplicate]

I logged into my SQL server today using PhpMyAdmin, and it seems to be acting weird throwing random [Token Mismatch] errors, only while trying to create a new user account. I tried multiple times, ...
3
votes
2answers
72 views

/etc/mysql permissions don't let non superuser connect to socket

We're running Ubuntu server 13.10 under Vagrant, and have come across an interesting problem. We're overriding the socket location in conf.d/my.cnf [client] port = 3306 ...
-1
votes
1answer
58 views

what is the purpose of support files in MySQL?

I have installed MySQL 5.6.17 on my Ubuntu 14.04 following the instructions at http://dev.mysql.com/doc/refman/5.0/en/binary-installation.html. The instructions says to use the optional command : ...
1
vote
1answer
208 views

How to install MySQL 5.1 libraries on Ubuntu 14.04 or CentOS?

I've got two VMs: CentOS 6.5 and Ubuntu Server 14.04. Neither of their package management systems has the MySQL 5.1 libraries available (they both have MySQL 5.5). I need to know how to install the ...
-3
votes
1answer
58 views

Improve LAMP performance Ubuntu 12.0.4 [closed]

cpu 1.3% mem 476/490MB swap 347/511mb tasks: 43, 29 thr; 1 running load average: 0.10 0.08 0.06 via htop:<br> /usr/sbin/apache2 -k start (listed 8x @ 8.1% mem each) /usr/sbin/mysqld (listed ...
-4
votes
2answers
54 views

How, with a mounted disk image, can I migrate a MySQL database to a new server?

One Ubuntu EC2 VPS is fried after an upgrade that went awry. I don't have the server live, but I have its disk mounted on another (Ubuntu EC2) VPS. How can I migrate the contents of a database on ...
0
votes
1answer
55 views

Ubuntu 13.04 MySQL won't start

My main SolusVM Node / OpenVZ Node needed a reboot today out of the blue and a kernel upgrade. So we finished that then on a couple of the VPS units for some reason MySQL won't start after the reboot. ...
0
votes
0answers
64 views

PHP application response time increases when application requests decrease

I've got a very powerful dedicated server, running a PHP 5.5.3, MySQL (Percona 5.6) SMF forum. It's running Ubuntu 13.10, it's a Xeon E3-1270 V2, 1TB disk space (0.7% full), 16GB DDR3 (15% used). I'm ...
0
votes
2answers
29 views

How to backup sql relations for server re-installation?

I am in need to re-install the nginx ubuntu 12.04 server I'm using in another machine. I've already got all the scripts (php,js,html, etc) so every data in the server is secured, but how can I do the ...
0
votes
1answer
284 views

access mysql remotely from raspberry pi? [closed]

I am using ubuntu 13.10 and I connect the raspberrypi with my laptop using ethernet cable. Now MySql Server is run on my laptop machine. Machine IP's IP Address (laptop machine) : 10.42.0.1 IP ...
0
votes
3answers
85 views

How to safely restart an ubuntu server lamp stack?

I've searched, and all resources are about how to perform the restart. I know how to reload, restart, stop; Apache, MySQL, etc and how to restart the OS. My question is how to perform a server ...
0
votes
0answers
64 views

Postfix with Dovecot on Ubuntu - create group for local users only

Could someone provide me with info how to setup Postfix mail server to have one special group of users whom will only have a permission to send or receive mails inside domain. They can not send mail ...
1
vote
0answers
58 views

Unexplained excessive database response times - very powerful hardware, tiny database

I've a strange problem that's repeatedly troubled me across 3 different servers now. The problem Please see the graph from NewRelic showing the huge amount of time spent in the database. The ...
1
vote
1answer
167 views

MySQL Socket configuration issue in my.cnf

I've got an issue that's causing very long "time in database" in my application. The DB is Percona MySQL 5.5.35. The application works perfectly, and can read/write from the database just fine. The ...
0
votes
1answer
22 views

Ubuntu upgrade 11.10 to 12.04 - MySQL migration

Some time ago, I tried upgrading my Ubuntu 11.10 to 12.04, but it failed on several points, so I rolled back the LVM snapshot. One of the problems was MySQL. During the upgrade process, it started ...
1
vote
1answer
69 views

MySQL/mariadb overloading server [closed]

I have openVZ VPS with 1gb ram, 1gb swap and 3 cpu. It is running ubuntu with Nginx, PHP, MySQL (that I replaced with mariadb). This is TOP: 3934 www 20 0 30908 10m 4152 S 2 1.0 ...
0
votes
1answer
56 views

Cannot open './/ib_buffer_pool' for reading: No such file or directory

I've realised that my Percona DB which has several InnoDB tables doesn't actually have InnoDB buffer pool running as it wasn't specified in the my.cnf. I had a buffer pool size specified of 256MB, ...
0
votes
3answers
60 views

What could cause these (see graph) spikes in DB response times?

I've a LAMP stack running Percona MySQL. Via New Relic, I'm monitoring/tweaking/tuning my new server ready for it to be used live. Something that's irritating me though, is that I get periodic ...
0
votes
0answers
44 views

Server intrusion - MySQL row altered

I have an AWS EC2 and an RDS instance running MySQL. The web app is Magento. We're facing an issue where the attacker has changed a row in the database - this is the PayPal seller's email address. ...
1
vote
2answers
24 views

Limiting MySQL User to connect from Second interface

The web server and the MySQL servers have a second interface on a network with no public internet access. How can a MySQL user be restricted to connect only from within the private network and ...
0
votes
0answers
33 views

Server stays up for about 15 minutes, then high load and crashes.

Apache/2.4.6 Ubuntu 13.10 Hello, I've recently had a lot of traffic coming to my site and it took me off guard. My server is hosted in Digital Ocean and I have 16 cores and 48gb ram. My issue is ...
-2
votes
1answer
446 views

Removing Unnecessary Services & Packages in a MySQL Ubuntu 12.04 Server [duplicate]

As part of hardening a standalone/dedicated MySQL 5.6 server running on Ubuntu 12.04 LTS, unnecessary services and packages will have to be removed. For a server that is serving only as a MySQL ...
2
votes
1answer
29 views

Regarding binding MySql and Apache to localhost

I've been reading articles on securing MySql and Apache on Ubuntu, and one of the suggestions was 'Make sure MySQL only allows connections from localhost.' This means doing [bind-address = ...
0
votes
0answers
27 views

MySQL Service allow local connections through hosts.allow

I have my hosts.deny set up as ALL: ALL but when I do this I can't seem to allow MySQL in hosts.allow. I need it just on the local network. I've tried: mysql: LOCAL mysqld: LOCAL and as a last ...
0
votes
0answers
15 views

How to monitor ubuntu server 24/7 for memory usage correlated with server events? [duplicate]

I have a ubuntu server running : apache2, mysqld and a python script. In the past, I've ran out of memory which caused mysql to corrupt the database. I'd like to run a monitor tool that can register ...
0
votes
1answer
139 views

Why is innodb engine disabled by default in ubuntu 13.10 mysql server?

We all know that InnoDB is the default engine as of MySQL 5.5 but ... for some reason an extra configuration file zentyal.cnf is included in MySQL's conf.d directory when installing mysql server ...
2
votes
1answer
85 views

MySQL Master-Master Replication Slave Thread Issue

I'm currently trying to set up Master-Master MySQL replication between 2 servers, but I'm encountering an unusual issue. I'm getting this error on my MySQL log: Slave: Table 'phpmyadmin.pma_recent' ...
2
votes
2answers
197 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
1answer
68 views

How to execute multiple SQL statements in virtualmin / mysql

Using the "Execute SQL" feature of the mysql addin for virtualmin, what is the syntax for executing multiple statements? For example if I want to do: delete from Table1; delete from Table2; I get ...
0
votes
1answer
60 views

MySQLd all queries 'Lost Connection'

I am running mysql 5.5 on ubuntu 12.04 I have many databases : the main one has ~15k innodb tables with a ~2GB size and the other one is a db for simple machine forum ~50MB. 2 days ago, all my ...
0
votes
2answers
270 views

mysql multi threading for a single query

I have big db of size 8GB and having 9 million contacts in this db. When we try to retrieve all contacts, it takes nearly 1 or 2 hour (in some cases result in timeout) to retreive all contacts for the ...
1
vote
1answer
132 views

Issues with MySQL restart on running through a crontab scheduler

I have written a shell script which starts MySQL when its killed/terminated. I am running this shell script using a crontab. My cron looks for the script file named mysql.sh under /root/mysql.sh ...
3
votes
3answers
399 views

Why is apache running wild and killing mysql?

Apache has got out of control over the past few days and made mysql crash twice. It all started when I migrated a wordpress website over which also contains a phpbb forum. Im not very experienced in ...
1
vote
2answers
139 views

Percona 5.6 not starting automatically after server reboot on Ubuntu with Virtualmin

I've got a new install of Ubuntu 12.04 + Virtualmin. I've upgraded from the default mysql 5.5 to Percona 5.6. Everything works except for one problem: when the server reboots, Percona is not ...
0
votes
2answers
197 views

how can I install PHP5 manually on Ubuntu

I have a new VPN with Ubuntu server 10.04 LTS which came with Mysql 5.1 installed, that was not supporting Barracuda file formats, so I manually installed and configured Mysql 5.6. Which works ...
0
votes
0answers
40 views

How do I choose a failover strategy for Mysql 5.5?

I have 2 mysql 5.5 database servers that I've just set up on Ubuntu 12.04. What I would like to do is provide a means of having these failover. Ideally using an HA strategy like keepalived so that ...
2
votes
2answers
461 views

CentOS 6 or Ubuntu 12.04? [closed]

I need MySQL (with a lot of querys) and an HTTPs service. Should I use CentOS 6 or Ubuntu 12.04 on a virtual server? Are there differences in the performance (with default config) or differences in ...
0
votes
1answer
160 views

Failed to start production mysql server. No log messages either

This is a production instance (EC2) we are managing for a client. Downtime already 5 hours. I am screwed. The Story This morning I found one of our clients mysqld process in killed state. I did ...
0
votes
1answer
321 views

Setup machines network in Windows Azure

I'm building a web application and I've decided to host it on Windows Azure. My application has three components: A front-end created with Play Framework (machine A) A back-end core written in Java ...