MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (7)

-1
votes
1answer
77 views

Running PHP/MySQL on Windows Server 2008 [closed]

I have a client that has a fairly basic web ordering system that was built for them many years ago. It is based on runs fine on PHP 5.3. Now, it connects to a (even older) warehouse management system ...
0
votes
0answers
53 views

best logic to Load balancing YiiFramework web app

I'm going to launch a Yii framework app next days, and i'm currently searching the best way to deploy it in order to scale and support high traffic. I use Amazon RDS to host the DB, and 2 Memcached ...
0
votes
0answers
69 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 ?
1
vote
0answers
19 views

MySQL tuning memory [duplicate]

I have some MySQL problems, I am not sure how to tune memory settings From mysqltuner.pl: >> MySQLTuner 1.3.0 - Major Hayden <major@mhtx.net> >> Bug reports, feature ...
1
vote
1answer
100 views

How Come mysqld -u root will start my database, but mysqld_safe -u root gets “Permission denied”?

The title is fairly self-explanatory. I am a mysql newbie, so any help is appreciated. I can boot my database and everything works fine using mysqld. When I try to run mysqld_safe in a similar ...
1
vote
3answers
155 views

MySQL refuses to accept remote connections

I've just installed a fresh ubuntu server with mysql (percona 5.5), but it refuses to accept connections from remote hosts Here is what happens if I try to connect to this server remotely: mysql ...
1
vote
1answer
62 views

Trigger actions automatically when package is installed or user is added

When installing mysql-server on Debian Wheezy, the user "mysql" is created without a home directory. In my setup, directly after MySQL was installed, a new task is performed which relies on the mysql ...
1
vote
1answer
121 views

MySQL Server not running

I'm sorry for my bad English. After upgrading MySQL up to 5.6.17 version it's not working. I'm using Windows 7 as my server's operating system. Here is the my.ini and error log: [mysqld] ...
0
votes
0answers
91 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
326 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
30 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
563 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 ...
1
vote
3answers
106 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
46 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
240 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
40 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
47 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
45 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
87 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
73 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
118 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
89 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
88 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
86 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
63 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
92 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
94 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
169 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 ...
1
vote
3answers
259 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
33 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
644 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
53 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
63 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
46 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
64 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
113 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
51 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
377 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
79 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
801 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
140 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
179 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
92 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
395 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
194 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
59 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
46 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
86 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
167 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 ...