MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (7)

0
votes
0answers
11 views

CentOS 6.5 Lampp (Xampp) and MYSQL CDR

I was wondering if it was possible and if so, how to use Lampp's MYSQL to store the call detail records in. I've tried installing the mysql-devel package and i've tried changing the modules.conf, ...
1
vote
1answer
15 views

Invalid parameter config_hash: Attempting to install mysql (and Openstack) via Puppet

I've searched around for hints on how to solve this but I haven't been able to find anything concrete. I've seen Puppet apache module causing 'Error 400 on SERVER: Invalid parameter ...
0
votes
0answers
24 views

Apt-get install older version of mysql server [on hold]

I am looking to install mysql 5.5.31 via apt-get. I've tried: apt-get install mysql-serve=5.5.31 but that didn't work. I don't know if there are additional repositories that I could add to apt-get ...
0
votes
0answers
11 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
1answer
17 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. ...
1
vote
0answers
10 views

Transfer user data of a Tigase server

I'm trying to transfer a Tigase XMPP server from an Ubuntu VPS to a CentOS VPS. Unfortunately there isn't any official documentation available and I need to experiment in order to preserve all of the ...
-1
votes
0answers
20 views

Two small VPSs or one bigger VPS? [duplicate]

I have a relatively busy WordPress site (http://ndsmcobserver.com). I'm currently on Linode 2GB plan, but performance is pretty sluggish, especially when performing searches and working every night ...
0
votes
0answers
24 views

Zabbix-server-mysql can't allocate shared memory - Access denied

I'm trying to run an instance of zabbix-server-mysql on Fedora 20, but Zabbix keeps saying that cant allocate shared memory space for history cache due to an Access Denied error. i'm sure that the ...
1
vote
1answer
11 views

Query cache for MariaDB Galera cluster

I've read from multiple sources now that you can't have query caches with Galera, but my current application could really benefit from a query cache. I'm load-balancing this cluster with HAProxy and ...
0
votes
1answer
23 views

Connect failed: Can't connect to MySQL server on xx.xx.xx.xx [on hold]

i'm having this problem on my server, i installed MySQL, and i've created databases, tables, etc... now, every time i use this MySQL server, i get a: Connect failed: Can't connect to MySQL server on ...
-2
votes
0answers
14 views

Plesk 11.5 and MySQL 5.6 [on hold]

According to this site, Plesk 11.5 does not appear to be compatible with MySQL 5.6 Does anyone have any experience with this configuration? Thanks in advance
0
votes
0answers
11 views

Apache password mismatch using mod_dbd

I Using Apache 2.4, using mod_dbd authentication i followed all steps to configure but when i tries to login, shows me AH01617: user pedro: authentication failure for "/": Password Mismatch But i ...
0
votes
0answers
9 views

Cluster Manager Ignoring Config File

I have just setup my first cluster manually (not using the auto install) and it all works great. I have 1 SQL node, 2 data nodes and 1 management node (all on separate machines). I intend to port ...
0
votes
2answers
12 views

Distributed LAMP vs DB and Web Server same box

We have a very read heavy semantic web (RDF) application which is RHEL 5/Apache 2.2.3/Tomcat 6/Java 6 on one Server, and MySQL 5.1 on another. Apache and MySQL are backported Red Hat repo stuff, so ...
0
votes
1answer
41 views

Can't install mysqldump on Ubuntu

Another technician recently reinstalled our mysql on our LAMP-server and now I can't use mysqldump anymore. # mysqldump The program 'mysqldump' is currently not installed. You can install it by ...
0
votes
1answer
47 views

Processing Conflict: mysql55w-libs-5.5.36-3.w6.x86_64 conflicts mysql-libs < 5.5

I'm trying to install the latest webtatic MySQL 5.5 edition via yum (http://webtatic.com/packages/mysql55/) on CentOS 6.5 but every time I try I get the following output ending in error: # yum ...
1
vote
0answers
14 views

MAGMI fails while importing big chunks of records. Ideal Mysql configuration for Magmi

Configuration: Linux Centos 6, NGINX, Mysql We are trying to use MAGMI a common tool for mass importing of data in Mysql based on webbrowser. I run in an issue. As a try to import more than a small ...
0
votes
0answers
49 views

MySQL unable to find PID file [on hold]

Recently I've been encountering the dreaded ERROR! The server quit without updating PID file" when trying to stop It was trying to look for the PID file under: ...
-1
votes
0answers
19 views

How to acheive Concurrency in mysql when there is 500+ request simultaneously to the server

I am using Mysql (InnoDb), in this I am facing problem when we checked the curl request upto 500 connection at a time (simultaneously) but when we try more than that then my servers goes to idle ...
0
votes
0answers
16 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 ...
3
votes
1answer
51 views

BGINFO with MySQL for storing computer information

We are trying to set up BGinfo to record network computers' information in a centralized database. We intend to set up BGinfo to start up for all users and record logon and logoff time plus setting up ...
1
vote
0answers
36 views

RoundCube too many sleep connections in mysql

we have a mail service with these details: 1-Centos 6.4 2:Postfix 2.6.6 3:roundcube 0.8 4:dovecot 2.0.9.7 5:mysql-server 5.1.71 everything is ok but in peak usage time ...
2
votes
1answer
21 views

What is the rdsadmin user and should I care?

I've inherited control of an AWS MySQL RDS instance. I'm curious to know what the 'rdsadmin' user is and whether I should know the password for this or whether this is purely for use by the Amazon Web ...
0
votes
0answers
20 views

mysql synchronization databases [migrated]

hello, i have 5 MySQL servers masters each one have mysql slave , and i have to synchronize data from those masters to one other mysql(central mysql who contain the common data : it can be ...
-1
votes
1answer
31 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
13 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
29 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
16 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
38 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
43 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
22 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
42 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
23 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
16 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
43 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
27 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
27 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
59 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
17 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
115 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
votes
0answers
8 views

multiple refresh from browser server get slow to respond and it creates huge process for apahce

I have linode and i have hosted my website on that.. ? is my website i am using ispconfig and when i am trying to multiple refresh my site from browser.. it takes time to load.. i have tried ...
1
vote
1answer
32 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
16 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
28 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 ...
0
votes
0answers
12 views

MySQL/MariaDB CLI limits max password? [migrated]

I've got strange problem - my MariaDB instance CLI (Linux) does enforce limit on how long password can be. For example, setting password like this UPDATE mysql.user SET ...
-2
votes
3answers
77 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
53 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
53 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
75 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
62 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 ...