MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
0answers
12 views

Creating my.cnf leads to error with innodb

I got access to an existing mysqld server (5.5.35 from Debian Wheezy) with existing data in production use. I found no existing configuration file in /etc/my.cnf or /etc/mysql/my.cnf. So I copied the ...
0
votes
0answers
6 views

Migrate MUC (multi-user conference) data from Mnesia to MySQL in ejabberd

Ejabberd's mod_muc module supports db_type option, which can be either internal (Mnesia) or odbc (MySQL) to store MUC-related data. Is it possible to migrate from Mnesia to MySQL saving all the ...
4
votes
3answers
60 views

Replicating a linux web server

I'm planning on replicating a web server for high availability purposes. The server is running as a Ubuntu 15.04 virtual machine in Hyper-V and has MariaDB 10.0, Apache 2.4 and PHP-FPM 5.6 installed. ...
-1
votes
1answer
32 views

How can I deal with failures when connecting to a MySQL cluster?

Our company has created two MySQL servers that are kept in synch using a master-master strategy. The two-machine cluster is managed using crmsh. This is only a high-availability cluster, meaning that ...
0
votes
1answer
30 views

Can't access mysql docker container from the host

I have a debian server with docker 1.6.0 on it with a running official mysql container (https://registry.hub.docker.com/_/mysql/). I use a fairly basic firewall configuration in which all ports are ...
0
votes
1answer
24 views

phpMyAdmin - #1045 - Access denied for user - However my script still works

The login page on phpMyAdmin does not let me log in and gives me a 1045 - Access denied for user However my php script on the page which uses the exact same login data, still works no problem. ...
0
votes
1answer
14 views

Python Pip Install fails - Could not build the egg. Also cannot use 1.2.5 because of google cloud sql

I need mysql-python. I get error of could not build egg while installing 1.2.4 Everywhere it says install 1.2.5, which works for me too. But googleAppEngine's app.yaml supports only 1.2.4 ...
-1
votes
0answers
24 views

MySQL fail to add users during installation [on hold]

I'm using Windows 7, trying to install MySQL Server 5.6.24 Community Edition. I've chosen all default options, and given a root password and created 1 user, a DB Admin. At the Apply Server ...
0
votes
0answers
10 views

Installation for mysql_config with Percona already installed

I have a CentOS 6.6 installation with Percona XtraDB Cluster client installed on it. This version of Percona is a project requirement and can not be uninstalled. But I need the MySQLdb for Python ...
1
vote
1answer
21 views

MySQL not allowing remote connections from new server

I currently have one server that's connecting to a centralized MySQL server (say, 192.168.0.10). This server already allows remote connections from this IP address (say, 192.168.0.20), and in spite of ...
0
votes
1answer
18 views

mysql and redis services unavailable during high traffic times

I've have a webserver that runs some services like Apache, Mysql, Redis and some NodeJS apps. On times of high traffic my server seems to do not support the heavy load. When it's ocurring, often when ...
-1
votes
0answers
16 views

Need to deploy php and java application together on openshift.redhat.com [on hold]

I have a Java and PHP Website. Front end code in PHP and Java call some library. How can i deploy php and java application together ? I have a java war file, PHP Code and One database file.
2
votes
1answer
47 views

99% disk IO spikes with Percona

So we have a server that has seemingly random spikes in disk I/O, going up to 99.x% at random times and for no obvious reason, staying high for ~1 hour, and then going back down. This hasn't been much ...
-3
votes
1answer
68 views

Mysql showing 100% CPU usage [closed]

I'm experiencing some problems with my MYSQL server installed with Cpanel. My server is showing 100% usage of mysql even if I don't have too much traffic on web. I am running CentOS 6.5x64 with 80GB ...
-2
votes
0answers
10 views

Could not be resolved: Name or service not known

My site is running smoothly, but when I checked my db server and saw there is high memory use by mysqld. It is all the time 69.7%. Then I checked my mysqld.log and saw lots of Could not be resolved: ...
1
vote
1answer
32 views

Unable to Create MySql 64-bit System DSN on windows

I have a very similar problem to this: Unable to Create System DSN but none of the fixes suggested there have worked for me. System: windows 7 64-bit enterprise. I'm trying to create a DSN to use ...
3
votes
1answer
38 views

Enable HugePages on Linux for multiple services/processes

On one of my Debian machines I'm running a service on a JVM and a MySQL instance. I have enable the HugePages following various online guides but I'm having a problem. Here is my configuration: ...
-1
votes
1answer
30 views

make mysql to share all cpu

I am very new to linux server .I am using centos.Sometimes my cpu gets overloaded because of the process mysqld over 100% PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND ...
0
votes
1answer
36 views

Access db with dynamic IP using windows Application C#

I want to connect a Desktop Application (C#) with a website which is hosted on BLUEHOST Server (Shared Hosting). I have to add an IP on server to allow for remotely access to mysql database. But the ...
0
votes
2answers
45 views

SQLSTATE[HY000] [1045] Access denied for user 'admin'@'localhost' (using password: YES) [closed]

I've changed the password for admin user of mysql in phpmyadmin and now I can't access neither my Plesk panel and neither mysql via ssh. The error it triggers is: SQLSTATE[HY000] [1045] Access denied ...
4
votes
1answer
86 views
+100

MySQL package upgrades (Debian apt-get) always break master-master replication due to changes in mysql schema

I have master-master replication set up on 2 Debian servers, and they replicate everything, including the mysql database itself (so that new users and such also replicate). This generally works very ...
0
votes
0answers
34 views

Vagrant and MariaDB (provision)

I'm trying to create a provision file that installs MariaDB but it keeps failing. The provision looks like this: sudo apt-get install -y software-properties-common sudo apt-key adv --recv-keys ...
0
votes
1answer
31 views

MySQL intermittently fails to come up when data directory is configured on SAN via iSCSI

I am running Ubuntu Linux 14.04.2 on a Dell R610 Server. This box is used to host the MySQL service for my applications. The MySQL data directory is mounted on DELL SAN Equallogic so this box is also ...
0
votes
1answer
34 views

Can't connect to MySQL server on '198.211.37.xx'

For last couple of days I have tried many things to solve Can't connect to MySQL server. I would like to describe everything that I did so far. Create a mysql user and GRANT ALL Privileges. Bind ...
2
votes
0answers
16 views

odbc error connecting mysql: “sql server does not exist or access denied” [migrated]

For a few weeks now I have been trying to create an odbc connection with microsoft access and a mysql database on webhost server with no luck whatsoever. I have no problem connecting to the database ...
-1
votes
0answers
18 views

Low end vps at 90% RAM usage due to mysql [duplicate]

I am running a low end vps (512mb ram) 1 cpu with ubuntu 14 32bit. I am also running mysql for my user data and its taking up 50% memory resources making my ram run at 90%. I already tried to ...
-2
votes
0answers
30 views

ib_logfile corrupting every day, how can I find the cause? [closed]

I'm running CentOS with cPanel/WHM installed. Every day I'm having a ib_logfile issue which stops MySQL working for just one site on the server - I found a fix to rename the logfiles every time then ...
1
vote
3answers
64 views

MySQL connection - Access denied for user 'username'@'localhost' (using password: YES)

I have a user that I use from my php pages to make queries to mysql db, and now I´m trying to use the same user in eclipse/BIRT in order to build some reports but I get the error Access denied for ...
-4
votes
2answers
58 views

How to recover MariaDB database after a failed update? [closed]

Due to a failed update, now my VPS system is broken. I can only access to my files with rescue mode. So, where does MariaDB store his .sql files? So I can make a backup. The update was made by my vps ...
1
vote
1answer
14 views

MySQL Time Different from System Time

I'm having an issue where MySQL is reporting the time as six minutes later than the system time. I have verified all my timezone settings are correct but don't know how to troubleshoot the six minute ...
0
votes
1answer
34 views

SELinux - mysql/ and httpdoc/ in same folder?

Looks like my old faithful LAMP directory structure has come unstuck with SELinux. I prefer everything in the same place. CentOS 6.6 Apache 2.2.15 MySQL 6.5 /DATA/ /DATA/httpdocs/ /DATA/mysql/ ...
0
votes
0answers
20 views

Trouble connecting to MySQL from Tomcat, Connection refused: connect

I've been try to connect my tomcat server to MySQL via an eclipse project. I have the code working on a colleaguemachine but not on my own, so I believe it is a configuration problem. I have a MySQL ...
0
votes
2answers
23 views

MyISAM Throughput spike at 12000 record insert

I am testing database performance with bulk record inserts. Both systems are identical apart from storage engine **Database 1000 4000 12000** MySQL_InnoDB 60.95330976 ...
1
vote
0answers
45 views

mysql dump import incredibly slow on my developer's machine [migrated]

I have an SQL dump, it's pretty big (411 MB) and it took 10 minutes to import on server A, the same import on my workstation B has an estimate (pipeviewer) of 8 hours to import (it imported 31 MB in ...
0
votes
0answers
15 views

phpMyAdmin and MySQL ENCODE / DECODE [migrated]

I've got 2 different versions of phpMyAdmin installed on my webspace: v.4.0.10 and v.4.4.3. By running the following MySQL query in the phpMyAdmin interface SELECT DECODE(ENCODE('teststring', ...
3
votes
4answers
106 views

MySQL taking too much CPU

Below is my .cnf file and if I see my CPU consumption 99.99% of it my the mysqld commands. The MySQL server is connected from remote machines that update data in it frequently, but I make sure that ...
-1
votes
1answer
58 views

Why the latency increases on highload? [closed]

We have a system built on AWS. We use Beanstalk, we have autoscaling, our database (mysql) is hosted on RDS. We use apache and php. We wanted to test our system on highload. So, we chose large ...
1
vote
1answer
36 views

Apache 2.2 / MySQL Overload of Ubuntu Server

I've run into a problem and I just can't seem to figure out how to solve it; I have a regular Ubuntu 12.04 Server with apache 2.2 running a website. Every now and then the server overloads and starts ...
1
vote
2answers
34 views

Any solution for MySQL Servers to avoid rendering them unresponsive when running big queries?

I do run several mysql servers for several clients, there is a common problem I used to see. When I run some big query against big databases, for example: I have a MyISAM table with several fulltext ...
26
votes
1answer
3k views

Is MariaDB a secure replacement for MySQL?

I've been using MariaDB, "an enhanced, drop-in replacement for MySQL" on my Debian stable servers for years, because of its increased performance. However I've noticed that it appears to lag with ...
0
votes
1answer
56 views

t2.micro EC2 Ubuntu, t2.micro RDS MySQL. Server crashes after DB reaches ~60 connections [closed]

So I have the following setup: Server - t2.micro ECU Ubuntu instance Database - t2.micro RDS MySQL instance. The stack is a basic LAMP stack with default Apache settings. I am basically running ...
0
votes
0answers
8 views

MySQL 5.6 upgrade - reducing code changes / developer burden [migrated]

Does anyone know the key things that should be done when moving to MySQL 5.6 to reduce the amount of code changes required? I found that new installations of it have STRICT_TRANS_TABLES set for ...
1
vote
0answers
102 views

Installing php-mysql on centos 6.5 fails due to conflicts when percona client 5.5 also installed

Some background: I'm writing a Chef cookbook to set up a LNMP stack for local development. It requires the php-mysql library for PHP 5.4 (using the php package). We're using the yum-remi repository ...
0
votes
0answers
18 views

Linode resource splitting [duplicate]

We would like to move our sites to Linode and I have a theoretical question. Which is the best in speed and why? If MySQL runs on a different machine, is it give better result or worse? 1 option ...
0
votes
0answers
24 views

MySql JDBC - java.net.ConnectException: Connection refused, can't see why [duplicate]

I have a test environment with MySQL 5.6 server running on a Windows machine and a Linux machine running a webserver. When I start the webserver it tries to connect to MySQL via: ...
0
votes
1answer
13 views

multiple database syncing in different locations in MYSQL at periodic timings

i have a system at head office with MySQL installed. i have client machines at different locations. i need to sync all the database for example once a customer detail is entered in one client it has ...
0
votes
1answer
59 views

Website takes a long time to first byte [duplicate]

Recently, I migrated a joomla 2.5 site with K2 from a shared host to a dedicated web server with 1 GB of RAM and 8 CPU cores. My problem is now that the website loading is very slow, much slower than ...
0
votes
2answers
25 views

CentOS 7 won't connect to external MySQL database. Database works from other servers

I have a new CentOS server set up, with Apache and php-fpm. The php application fails to connect to an external MySQL server. This server is reachable from other servers, the firewall on the database ...
-1
votes
1answer
29 views

Tracking the slow - how to list all processes related to web-server?

I wanted to ask people in this community about administration of the Debian based web server - its a dedicated server, hosting a single website. From time to time the web site is slowing down, on ...
0
votes
1answer
64 views

How to upgrade MySQL 5.6 to MariaDB

We are using MySQL 5.6 on a productive Server which we want to migrate to MariaDB. Many reasons - but the main reason is the way the Master <-> Master Replication on MariaDB is working. There are ...