MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (7)

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
0answers
19 views

What mysql configuration offers the highest write performance

Which multiple mysql server configuration offers the highest write performance? We are looking at changing a web application which is heavy write and want to know what configuration is going to give ...
1
vote
1answer
157 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
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
306 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
86 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
38 views

Delay in loading site - not caused by Apache, MySQL. How to find the cause?

I've just moved two sites to a new server. They are both similar, Drupal based sites. One loads normally (1-3 seconds) but the other takes up to 12-15 seconds. After much logging and measuring I've ...
3
votes
1answer
186 views

RPM that installs to /opt/rh

I've noticed that the "mysql55" RPMs in the standard CentOS 5.10 repository install everything to /opt/rh. Is it expected that an end user might change this location somehow? It creates complications ...
1
vote
1answer
38 views

Updating usernames and passwords for 450 WordPress databases - 450 ftp Accounts and 450 MySQL user

How would you update these in a consistent, reliable manner? I'm new enough to system administration, self taught and still learning but - I have this problem to solve in no specific time and under my ...
0
votes
1answer
34 views

Postfix MySQL percentage error in query

I have a somewhat complex SQL query that I'm using to get alias forwarding e-mail in Postfix. The problem is that Postfix uses %s as it's insert of alias mark in the SQL query. I think this causes the ...
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
vote
1answer
65 views

Phpmyadmin table disappears, but website reads it perfectly

When I log into phpmyadmin, it only shows the information_schema. I have only one table that has been showing perfectly, but one day it decided not to show up. My website reads all the information in ...
-1
votes
2answers
100 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 ...
0
votes
2answers
79 views

How do I prevent a website on my server causing the whole server to crash

I have a server with 6GB of RAM and a 6-Core CPU. Number of websites hosted by the server is about 10, but sometimes 2 of them take 100% CPU and almost entire RAM which cause the whole server to crash ...
0
votes
1answer
74 views

Single ec2 instance with multiple mySQL databases on separate EBS volumes

I have a single ec2 instance on which I am running multiple separate wordpress sites. I want to store the database for each separate site on it's own mounted ebs volume, so that I can handle the db ...
1
vote
0answers
49 views

How to configure MySQL pid file permissions?

I know MySQLd will create a pid file as set up in mysqld.service: ExecStart=/usr/bin/mysqld --pid-file=/run/mysqld/mysqld.pid However, it creates the file with a 660 permission, meaning ...
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
1answer
83 views

5-7 second latency between Apache server and MySQL server when website calls on database server

I am currently running a virtualized environment for my web and db server. When I access the web server or the MySQL server individually, they are both fast. I also have websites running on the web ...
1
vote
3answers
122 views

Load Balancing - PHP/Mysql [closed]

I have a server which relies heavily on a MYSQL database. Recently, there have been load issues and max mysql connection issues. My idea is to have a primary server with the php code and files and a ...
0
votes
3answers
125 views

Changing the mysql bind-address within a script

What would be the best way to change the mysql bind-address in the my.cnf from a shell script? Is there a way using a tool like mysqladmin or should I use sed or should I simply append it to the ...
1
vote
0answers
28 views

Frequent CPU spikes on fresh install

I just reinstalled my Server (Windows Server 2008 R2) and after installing MySQL 5.6, the CPU spikes every few seconds: http://s15.postimg.org/dno7ztfjf/cpuspikes.png Even worse than the higher CPU ...
0
votes
1answer
271 views

MySQL replication error: Error_code: 1032

I setup MySQL read replica that is read only. Both master and slave are running MySQL 5.6. The slave never gets written to directly, but I can't seem to keep it synced for more than an hour or two. ...
1
vote
0answers
41 views

wrong directory 'cannot change the directory'

I am working on mysql cluster. I am following the mysql manual. But when I arrive at this step ndb_mgmd -f /var/lib/mysql-cluster/config.ini` ndbd I have this error: [ndbd] WARNING -- ...
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, ...
0
votes
1answer
55 views

Nginx using mysql result as variable to be used in headers more module

Without going into too much detail we have a requirement for the following: a) Query a simple single column, single row result from mysql. b) Use this variable as part of a more headers module, ...
0
votes
1answer
73 views

Amazon RDS MySQL limitations

I have a web app that's quite data-heavy. The application is currently storing approximately 5k rows (logs) a day into a MySQL RDS micro instance (all settings default - InnoDB, UTF8,etc). Each log is ...
0
votes
1answer
48 views

ISPconfig removing newly added database column causes SQL Replicate error

Recently, I added a "mongo_plugin" column into mysql on my IspConfig server. But after not having achieved the intended goal, I removed the "mongo_plugin" column from each table. And the error ...
0
votes
0answers
237 views

Mysql not starting after upgrading debian squeeze to wheezy

I recently bought a VPS box with Debian Squeeze pre-installed as the OS. I upgraded to Debian Wheezy and most things work fine (e.g. apache). The problem I'm having relates to MySQL - which is just ...
2
votes
2answers
72 views

PHP locking up webserver [closed]

Description of issue: So after "extensive" research I have determined that PHP on apache will not respond to multiple requests, only the request that its on. (So if your PHP server spends 5 seconds ...
1
vote
1answer
406 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 ...
2
votes
2answers
114 views

RAID 0 InnoDB speed - Comparing 8 x 7,200 RPM drives or 4 x 15,000 RPM drives

I am planning to set up a RAID array for scratch space use in a computational server (16 cores, 128 GB RAM). The users will routinely be creating large (500GB) MySQL InnoDB databases and storing these ...
1
vote
1answer
114 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
0answers
73 views

High availability MySQL with HA Proxy failover

I am looking to load balance a Percona cluster behind two HA Proxy nodes with failover (using keepalived) so there is no single point of failure. I have HA Proxy already setup with keepalived using a ...
1
vote
2answers
209 views

How can I synchronize 2 web server files with load balance?

I need to setup a website with load balance to accommodate more visitors, I've seen on forums that varnish(balance)->apache(web1&2)->mysql(dbserver) is the way to go. I know how to setup ...
1
vote
1answer
131 views

Duplicating data between two Percona Xtradb clusters using MySQL replication

We currently have a 3 node Percona Xtradb cluster running in a single data center. We want to add fault tolerance in case of disaster to prevent reliance on a single data center and synchronize our ...
-2
votes
3answers
53 views

Compiling from Source or Installing from Packages? [closed]

I'm trying to build a new web server & database server, I just usually install apache and mysql using YUM. I'm curious, why most experienced systems admins prefer to compile apache and mysql from ...
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 ...
0
votes
1answer
68 views

Configure Monit to delete /var/lib/mysql/mysql.sock after abrupt Centos6.5 machine shutdown

I have Monit monitoring Mysql. When the machine shuts down abruptly eg a power failure, mysqld cannot be restarted unless /var/lib/mysql/mysql.sock is deleted, due to the error Another MySQL daemon ...
1
vote
1answer
122 views

keepalived - no connect and doesn't listen on ports?

Following servers: ....:100::10 mysql1 master ....:100::20 mysql2 master ....:100::30 loadbalancer (keepalived) with virtual ip ...:100::40 Config: vrrp_instance V1 { state MASTER ...
1
vote
1answer
170 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
48 views

how to disable all caches types in mysql server in order to do performance testing for my queries

I'm using Mysql Server 5.6.15 and i have a huge database with many complex queries. it seems that when I run the query the first time it takes X amount of time. when I execute it again it takes ...
0
votes
0answers
60 views

UTF-8 encoding gone missing after enabling mysqlnd

I've enabled mysqlnd on my PHP 5.4.26 server using MariaDB 10.0.8. My SQL config contained this: [mysqlnd] character-set-server = utf8 collation-server = utf8_general_ci It was all working fine ...
3
votes
1answer
64 views

MySQL equivalent of `su - someuser` to assume identity of another user?

I run a MySQL server and I have MySQL root-level privileges on this instance: mysql> select CURRENT_USER(); +----------------+ | CURRENT_USER() | +----------------+ | root@localhost | ...
0
votes
2answers
53 views

Using Jenkins to access mysql files on the same instance

I have a Jenkins installation and running mysql server on the same box. One of my jenkins jobs is supposed to tar up the /var/lib/mysql folder but I get the following error tar: ...
0
votes
2answers
96 views

MySQL's InnoDb performance downfall

I'm trying to configure a MySQL production server using InnoDb and I can not get the performance I want out of it. I've used Percona tools to give me the following configurations: [mysql] # CLIENT # ...
0
votes
2answers
425 views

Zabbix not connecting to MySql database

I'm trying to get Zabbix running under Amazon Linux I've installed the following packages: zabbix20-server-2.0.11-1.el6.x86_64 zabbix20-server-pgsql-2.0.11-1.el6.x86_64 ...
1
vote
1answer
670 views

MySQL - The server quit without updating PID file

I have installed MySQL 5.6.16 on Debain 7.4. But i encountered problems with starting mysql, where every time i start mysql i get this error: The server quit without updating PID file ...