0
votes
2answers
31 views

Performance hit from moving DB to another drive symlink?

We're considering moving one database (there are 4 of them in total) with InnoDB tables, to a separate partition in a Ubuntu 14.04 VPS. This DB gets read/write intensive (500 writes per sec, about ...
1
vote
2answers
30 views

run second mysqld instance for backup restore

I am trying to start a second mysqld instance to restore data from backup (innoDB). Following the manual I put together this: P="/var/lib/reoback/backups/2014-06-30/var/lib/mysql" cd $P mkdir tmp ...
0
votes
2answers
51 views

resetting iptables seems to make connections clear faster

I have iptables setup on 2 servers. Server#1 is public and Server#2 only allows the ip address of Server#1 to have ACCESS. Server#2 has a mySQL database that Server#1 queries. I ran a query and it ...
2
votes
2answers
61 views

Two databases synced backup

I got a system that need two databases to work. I need a script to backup both databases at given point of time. I need databases to be in sync, so I need to be sure that backup does not allow changes ...
4
votes
1answer
45 views

strace shows long time reading from mysql socket - mysql takes long time to execute query?

My Apache server takes long time to process request. I attached strace to it and can see the two following delays: 1) Very critical (143 seconds to process) 1335 0.000037 write(16, ...
1
vote
2answers
89 views

tune up performance nginx php-fpm mysql

I am running a nginx+php-fpm+mysql on virtual server with 8 cores and 16G ram My aplication is a simple API provider server, which returns JSONs generated from mysql database on requests. Datasets are ...
0
votes
1answer
49 views

MySql stops running in combination with Laravel Queue, Supervisor, and FFMPEg

After setting up queue listener to process uploaded videos with FFMPEG, I've come back to the server several times to find that MySql has stopped running. I checked drive space and it's about 77% used ...
0
votes
0answers
4 views

temp table (#sql-7a87_230c32.ibd along with its .frm) still exists on slave [migrated]

I executed some alter statements on my master server, which have been successfully executed on master (now there is no temp table on master) and all alter also have been replicated on slave server ...
0
votes
1answer
30 views

uninstall mysql in linux server giving error

I'm trying to uninstall mysql 4.1 package in linux server. Command : yum remove mysql mysql-server It is giving error : Setting up Remove Process Resolving Dependencies --> Populating ...
1
vote
0answers
68 views

PhpMyAdmin Hangs On MySQL Error

I'm currently running PhpMyAdmin 4.0.10 (the latest version supporting PHP 4.2.X) on my Amazon EC2 connecting to a MySQL database on RDS. Everything works perfectly fine except actions that return a ...
0
votes
1answer
63 views

Got more ram, site slower [closed]

I was running my site on 256MB of ram with 2 cores and it was running ok, but I decided to upgrade to 1GB and 4 cores but now my site is slow.. I mean it takes more then 22 seconds to load 1 page.... ...
1
vote
0answers
45 views

MySQL SSL Problems

I need to configure SSL for a MySQL server. I've read all of the directions for doing self-signed certs but it's preferred that I sign and use the certs from a different CA running AD Certificate ...
0
votes
1answer
25 views

Linux CentOS dedicated server, process is dissapearing from WHM process manager

I have a script running on my dedicated server /usr/bin/php/home/user/public_html/myscript.php. When I log in to WHM/Process Manager, sometimes this script disappears from the list. Also, when I log ...
0
votes
0answers
48 views

MySQL stops working on AWS ec2 instance periodically for no reason

I run a development server on AWS which has worked perfectly fine without a hitch. Recently, periodically the mysql server starts to not work. I then type in service mysqld restart which yields ...
0
votes
0answers
22 views

Mysql Error 1130 only while additional IP address is active

Originally, I had two IP addresses on eth0 on my CentOS install. They both have the same gateway and are on the same subnet. Mysql works fine. Mysql connections originate from the first IP and ...
0
votes
0answers
42 views

Transfer mysql database from wamp to a server

i want to transer my data bbase from wamp on my local machine to my vps (ubuntu) can i juste copy the folder of the data base from C:\wamp\bin\mysql\mysql5.6.12\data to /var/lib/mysql ?
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 ...
1
vote
1answer
151 views

MySQL high CPU usage on small website

I have a small website hosted on a dedicated server (FreeBSD 9.2, MySQL 5.6.1 and php 5.5.5). The problem is that MySQL eats a lot of cpu resources even if the website have a few visitors. The ...
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
1answer
42 views

MySQL Replication across two mounts on AWS Amazon Linux

Recently we took advantage of the SSD instance stores available on AWS. While these are great, they obviously get deleted when the instance dies. Obviously the performance of non Provision IOPS is ...
-2
votes
3answers
86 views

Options for high-availability of a smallish website? [closed]

I'm running a website that gets ~1500 visitors a day. It's not a ton, but I want to make sure this site stays up nevertheless. Currently, we're hosted on a shared hosting provider and the site has ...
-1
votes
2answers
99 views

Linux/Debian server upgrading and Apache and MySQL servers installing [closed]

Situation description I have a linux server: Distributor ID: Debian Description: Debian GNU/Linux 5.0.10 (lenny) Release: 5.0.10 Codename: lenny Lately, the MySQL server was a litte ...
0
votes
1answer
88 views

Mysql service refuse to be started

Mysql service just stop working. once I typed: service mysql startThe linux system displayed the following: tail: invalid option -- n Try `tail --help' for more information. tail: invalid option -- n ...
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 ...
0
votes
0answers
39 views

MySQL-ZRM: net_write_timeout

I have a backup system using MySQL-ZRM. Since I have some growing tables on a few databases and I write everything to a NFS, backups are now failing. I suspect the problem here is net_write_timeout, ...
1
vote
1answer
394 views

Can't login to remote MariaDB server with phpMyAdmin, but works in shell

I recently configured two servers. The first to use Apache and phpMyAdmin. On the other server I have a maria-DB server correctly configured. phpMyAdmin it's reading the config file, but I can't ...
1
vote
1answer
113 views

Use a PHP script to authenticate users on Linux

I have a web application running built in PHP using MySQL as database. I'm trying to give specific users access to a Linux system via SSH to perform simple command-line tasks. Since I do already have ...
0
votes
2answers
45 views

What is the relationship between the socket specified in the [mysql] section and [mysqld] section of my.cnf?

I have a strange problem that I'm sure is down to the socket. I cannot specify the socket in the mysqld section of the my.cnf config, if I do, the server fails to start. I have another broader ...
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 ...
1
vote
3answers
122 views

Mysqladmin mistype

When entering a new password for the root account in mysql I accidentally did this: mysqladmin -u root -p password 'somepassword Where you can see I missed the second quote. and I got ...
1
vote
2answers
122 views

troubleshooting out of memory error messages from mysql

we have a web application (racktables) that's giving us grief on our production box. whenever users try to run a search, it gives the following error: Pdo exception: PDOException SQLSTATE[HY000]: ...
1
vote
1answer
108 views

MySQL import slowing, jbd2 high disk I/O

I'm importing a large .sql file into my servers MySQL Database, However the import has only so far imported a few tables and is currently on record ~17mill of one table. However the import pauses ...
1
vote
1answer
70 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
68 views

How to use screen with mysql import

I need to import a very large MySQL table on remote server. Usually I'm using mysql -u mysql_user -pMypass db_name < sql_data.sql But it takes about 5 hours to complete the task. I tried using ...
0
votes
1answer
3k views

RSA certificate configured for SERVER does NOT include an ID which matches the server name

I recently started a LAMP server (all the latest versions) w/ WordPress on it, and I'm trying to install a SSL certificate that I recently purchased. When I restart apachectl, error_log gives me this: ...
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
1answer
47 views

How to determine what memory was freed

We have a somewhat complex LAMP stack running a variety of websites using Litespeed instead of Apache on Centos 5. Once everything is up and running, the memory usage of the system is fairly ...
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 ...
-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 ...
1
vote
1answer
54 views

Apache MySQL Server Crashing - Large number of connections from localhost

I'm running a 2GB Centos 5.9 server with the standard LAMP setup. I'm running a wordpress website so it's nothing to demanding performance wise. However the MySQL server seems to keep crashing as I ...
0
votes
1answer
38 views

Remotely automate optimization of mysql database

I am not a mysql or sql expert by any means, and not too savy on FreeBSD, either. We have a server that regularly needs one table to have data deleted < a time frame that leaves only 1 month of ...
0
votes
1answer
575 views

Howto setup roundcube password plugin with sql driver and mysql encrypt using random salt?

I have a mailserver with postfix installed and configured as in http://flurdy.com/docs/postfix/index.html. I use a mysql database maildb with a table users with two fileds id='user@domain.com' and ...
-3
votes
1answer
49 views

Building a future-proof webapp [closed]

My app uses php, node.js, mysql and all the front-end trends. I am hosted on the Linode 4GB plan, 8 CPU (4x priority) and 8TB Transfer for the entire static website, api's etc, a cdn for static files ...
0
votes
2answers
33 views

Apache Configuration not use server capabilities

I have a web server with 16 GB of RAM. The server has a good traffic and have pics of 300 simultaneous requests. Unfortunately when these peaks arrive queries fall into error or are very very slow. ...
0
votes
1answer
50 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
98 views

How can i install mysql_config on Red Hat Linux 4?

I've been tasked with implementing a few upgrades on a Red Hat Linux 4 box that is already running MySQL. I've found the need for the mysql_config tool, but i can't locate it as already being ...
0
votes
1answer
46 views

Why would PHPMyAdmin connections fail when connections from the same server with the same credentials succeed?

I have a site hosted on Rackspace Cloud. It runs Joomla 2.5, some test scripts, and PHPMyAdmin 4.1.6. Joomla runs off a database hosted in Rackspace Cloud. The host is ...
0
votes
1answer
92 views

CentOS 5.8 - The most difficult MySQL installation ever?

To install I did: yum --enablerepo=remi,remi-test install mysql mysql-server Result of the last 3 lines: Installed: mysql-server.x86_64 0:5.0.95-5.el5_9 Complete! Then I did the following: ...
0
votes
0answers
14 views

Virtualmin not properly detecting mysql server

I'v just reinstaled virtualmin and for some reason it doesn't want properly detect mysql running on the server. Mysql is running but Virtualmin is not detecting it, while Webmin detects it in partial ...
2
votes
2answers
198 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 ...