MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
0answers
14 views

Django/Tastypie: RDS is damn slow compared to EC2-MySQL

Initially my setup was: EC2 (Apache -> Django -> Tastypie) -> MySQL on EC2 itself. One of our API (Tastypie) does almost 80 SQL SELECT queries to fetch related resources and attributes. For local ...
1
vote
1answer
21 views

Debugging a mysql connection

I am trying to figure out how to diagnose a mysql connection issue. When I run a group of queries locally on my machine it takes about 1s to run. When I run that same group of queries on an AWS ...
0
votes
1answer
48 views

MySQL crashing at service start. Hit a bug? DB corruption?

I've a web server that's offline at this moment because MySQL fails to start with an exception. I can't find the root cause of the problem, but I'm afraid of database corruption crashing the MySQL ...
1
vote
1answer
31 views

Why can't I connect to my remote MySQL Server?

I have a asterisk server that is set up in on a VPS provider. I need one of my local applications to connect to the database to pull reports, but I am having dificulty getting a read only connection ...
1
vote
1answer
38 views

MySQL 5.6 replicate live master WITHOUT down time

Following the steps to replicate an existing server, it seems most methods rely on the ability to either completely stop the master server or at least prevent it from writing using flush tables with ...
0
votes
0answers
37 views

mysql-apt-config takes a verry long time to install on Ubuntu 14.04.1

i'm trying to upgrade mysql from 5.6 to 5.7 using mysql-apt-config. i've downloaded the deb and trying to install it. but it 'hangs' on Setting up mysql-apt-config (0.3.2-1ubuntu14.04) ... and ...
1
vote
1answer
32 views

Catch 22 on moving from old-style passwords and mysql_upgrade [duplicate]

I have an ancient MySQL database that I've kept running for a very long time, probably about 14 years. Apparently, I'd missed to run mysql_upgrade on it long ago, perhaps during the upgrade from 4.x ...
-5
votes
1answer
28 views

Is running MySQL on a separate server on LAN is any slower then running MySQL server locally? [closed]

I wonder if there is any significant speed difference because of network latency when: running Apache + PHP against a MySQL server that runs locally running Apache + PHP against a MySQL server that ...
-1
votes
0answers
43 views

Installing MySQL in Cent OS 6.6 Final

I removed/ uninstalled MySQL version 5.5.40 from my VPS and want to install the latest version of MySQL but when I run the following command: sudo yum install mysql-server mysql I get the following ...
1
vote
0answers
18 views

mysql service status doesn't show started when it is started by monit

I installed monit on my Ubuntu 14.04 server and configured it to monitor mysql with the below config in monitrc. check process mysqld with pidfile /var/run/mysqld/mysqld.pid start program = ...
-1
votes
0answers
27 views

Intermittent database connection SQLSTATE[HY000] [2003] Can't connect to MySQL server

I migrated my web server from Windows to Ubuntu 14.10. There is a separate database instance also running in Rackspace which is utilized by the web server. As soon as we migrated we started ...
-1
votes
1answer
45 views

MySQL on iscsi drive CentOS7 wont start on boot

I configured Mariadb on CentOS 7 to run on iscsi drive mounted on /mnt/iscsi, but it wont start on boot with following error (it can be started manually): mariadb.service - MariaDB database server ...
0
votes
1answer
27 views

FTP and WWW services don't acknowledge connections

I have Lubuntu 14.04 LTS with vsftpd and the lamp stack (apache2, etc.) installed. Everything works fine on the LAN. Externally, the services don't acknowledge connection attempts. I can see packets ...
0
votes
0answers
13 views

MySQL insert creating more than one row [migrated]

I'm using MySQL on a CentOS server from a website running Apache and Perl. I'm seeing this behavior (mocked up): mysql> describe product; ...
0
votes
0answers
10 views

Sysbench MySQL cannot cannoect

I have created a user named sbtest, with no password, with all rights on sbtest, and the following error occurs. What am I doing wrong? $ sysbench --test=oltp run --debug sysbench 0.4.12: ...
2
votes
2answers
104 views

Hide list of MySQL databases [duplicate]

I'm trying to configure MySQL 5.1 on CentOS 6.6 in such a way that users will not be able to see databases to which they do not have any privileges. If they execute the command [SHOW DATABASES] it ...
-1
votes
0answers
29 views

Apache couldn't be started because port 8888 is in use by some other software [migrated]

I am having an issue starting up MAMP, when I attemp it, I get this error message: Apache couldn't be started because port 8888 is in use by some other software I have been trying for the last 2 ...
0
votes
0answers
38 views

Wordpress on Apache - Pageload Increased up to 30 Sec. - How to Debug?

I running a Wordpress Theme on a Google Compute Engine with Cloud SQL and Apache2 (W3 Total Cache which is off at the Moment). Actually no Visitors than me because it´s in development. The Problem ...
-1
votes
0answers
34 views

InnoDB Error in MySQL after server crash

My problem started on 26.01.2015 when my server (CentOS 6.5) crashed - database wasn't shut down properly (MySQL 5.1.71). After restart there is something weird in error.log 150126 8:03:49 InnoDB: ...
0
votes
0answers
32 views

COLLATION 'utf8_swedish_ci' is not valid for CHARACTER SET 'latin1'

When I try running the following full text search query SELECT * FROM Organizations WHERE (MATCH (name1) AGAINST ('."skå".') COLLATE utf8_swedish_ci) I get the following error: Error Code: 1253. ...
0
votes
1answer
43 views

How to tune MariaDB/MySQL in a docker container?

I understand that it's easy to get a MariaDB docker container up and running, and using nsenter to edit config files is possible. But how can I tune the config files in this container, e.g. the ...
0
votes
0answers
24 views

Failed when tried to compile apache with easyapache

I want to enable pdo and pdo mysql for magento. I have root access on the server. I tried to recompile apache using easyapache through whm and i received the following !! The server's system ...
-1
votes
1answer
47 views

Load balancing not possible with Zend Framework due to MySQL Adapter Error

I recieve the following error message when I set up load balancing between two servers that are running the zendframework called "SocialEngine" As it looks there is a problem that I can't connect ...
0
votes
1answer
69 views

Apache2 Serverload / CPU increase from 1% up to 90% - How to debug?

I´m using: Google Cloud Compute Engine Linux Debian + Apache2 Google Cloud SQL Wordpress Yesterday my CPU started increasing from 1-5% to 80-90%. I was developing on a wordpress site as it ...
0
votes
1answer
53 views

Mysql replication lags

I am 2 slaves and 1 master on aws, 1 slave is already in sync with master but 2nd slave create huge slave lg behind, after investigation i found , this slave create numerous relay log in Kb's but ...
0
votes
2answers
56 views

Replication server crash - > 18:39:32 UTC - mysqld got signal 11

Below you can see the part of the log showing the crash. The replication server is 5.6 and the master 5.5 but this setup has worked with warnings for the last week or so. Now, after trying to change ...
0
votes
1answer
20 views

How do I know if Postfix has MySQL/PostgreSQL support?

I'm not sure if my Postfix installation has MySQL or PostgreSQL support. How do I find out?
1
vote
0answers
61 views

error creating database using ansible on centos 7

I am trying to install mysql AND setup database using ANSIBLE on CentOS7(i have no idea why every documention in the world now ONLY talks about Ubuntu and NO CentOS anymore...really SAD!) here is my ...
-1
votes
1answer
32 views

How to open a mysql port for 2 server connected in LAN

I have 2 servers connected togheter in LAN, and both on external network too. One eth0 and the other eth1 adapter. On both servers I've installed mysql. I'm able from both server to connect to their ...
0
votes
1answer
26 views

mysql my.cnf is empty with webmin

mysqltune said that I need to make some changes in the my.cnf file Variables to adjust: query_cache_size (>= 8M) tmp_table_size (> 16M) max_heap_table_size (> 16M) thread_cache_size (start ...
0
votes
0answers
28 views

Can't connect to MySQL server on '127.0.0.1' (110)

I'm randomly getting a 110 error when connecting to a local mysql instance ( -h 127.0.0.1 ). Checking perror I see that it's a timeout: # perror 110 OS error code 110: Connection timed out The ...
1
vote
1answer
33 views

Any way to import MySQL tables with indexes intact?

Currently our live database server does daily downloads of large data dumps (on the order of 10GB), imports them into MySQL, normalizes the data, and builds a number of indexes (full-text indexes ...
0
votes
0answers
23 views

PHP & MySQL config for IIS server under heavy load

I am running a PHP/MYSQL website on Windows Server 2012 using IIS 8. I had performance issues on my old server with the CPU spiking above 100% during peak times. So I've just upgraded my server to a ...
1
vote
1answer
44 views

Identifying MySQL injection exploit

I know someone whose server with cPanel/WHM and phpBB 3.0.x was victimized by a MySQL injection attack against phpBB (or a plugin thereof). Certain information was leaked, but we do not know the ...
2
votes
1answer
26 views

Galera: Run slow ALTER without locking entire server

I have a 3-node galera cluster with a few hundred databases servicing various clients. I'm only using galera as an easy way to handle replication and fallover. I'm not actually using multiple masters ...
0
votes
0answers
53 views

Gitlab update from 7.2.0 centos(mysql) to 7.7.2 ubuntu(postgres), can't create ssh key, or new project

I had a CentOS server running gitlab 7.2.0, which uses mysql server. I updated to the omnibus version of 7.7.2 successfully porting the database from mysql to postgres using instructions found here ...
-2
votes
1answer
26 views

Set rules on exchange and save it to database [closed]

I wanna set exchange rules for my incomming backup mails. After receiving one message with "Backup Exec Alert: Job Success (Server: "SERVERNAME") (Job: "JOBNAME") " in the subject a script should be ...
0
votes
0answers
19 views

Application logs an INSERT into database but data is not there. Where to look for debug info?

I have a PHP shell application which essentially moves data from a MySQL table to a REMOTE MS SQL Server (2008 R2) server based on a number of business rules. This routine has been working flawlessly ...
-1
votes
0answers
30 views

Mysql service running very weird on Centos VPS [on hold]

I have a VPS hosted at 1&1 where I host some domains and I keep some others for development. The applications are not very hungry in resources as they are all wordpress instalations. Also the ...
-1
votes
0answers
9 views

MYSQL : unable to add privileges to newly created user [migrated]

I am just trying out Google Cloud SQL. Created a SQL server and white-listed one of my IPs to connect to it. I am able to connect as root@'%' there and do everything I wish, other than granting ...
1
vote
0answers
85 views

200 OK blank page setting up Wordpress on restore test VM

I'm testing a partial backup of a frankly rather outdated (legacy, what can you do?) CentOS/Apache/MySQL/PHP/Wordpress server by restoring to a VM with a fresh copy of the relevant packages. After ...
-2
votes
0answers
57 views

pam_mysql missing in CentOS 7

So it looks like in Centos 7 the pam_mysql package has been removed from EPEL, but I'm still in need of this package do to my reliance on a remote mysql database used for vsftpd. I stumbled on a ...
-3
votes
1answer
41 views

bash script mysql reset pass

It seems that this code is not working I tried using it on my debian 7 machine and the password it gives me is wrong. # Please confirm that you want to reset the MySQL passwords CONFIRM="n" echo -n ...
0
votes
0answers
34 views

CentOS MySQL Problems

Im having trouble with MySQL on my centos5 server. When I try to connect to the server I receive the following message ERROR 2002 (HY000): Can't connect to local MySQL server through socket ...
-1
votes
0answers
28 views

Configure inbound email using postfix

Postfix logs show "unknown user" when I send what I would expect to be a local user. I have the users specified in a mysql database and postfix has been compiled with mysql support. Other variables ...
0
votes
0answers
58 views

MySQL suddenly 'crashed' but not stopped, mysqld_safe 100% cpu on CentOS 6

Suddenly, today i see the website down. Checking the cpu with "top" in command, i found the mysqld_Safe at the top using all of the cpu. After some google i found some different solutions, i made a ...
0
votes
1answer
37 views

Can't connect to local MySQL via TCP (Error 1045)

root@127.0.0.1 exists, but still can't connect to local MySQL. It looks like MySQL verifies hostname instead of lo ip(127.0.0.1). root@castle /v/l/mysql# mysql -u root Welcome to the MySQL monitor. ...
1
vote
1answer
74 views

Low load average, but high %user and %system cpu usage

Summed up question: Why do we see one set of servers perform significantly worse with the same database and workload as others? Symptoms other than longer execution time is low (near zero) load ...
0
votes
0answers
71 views

How to reduce Tomcat response time (OR increase throughput)?

I have Tomcat 8 and MySQL 5.6 running in 2 Azure virtual machines (8 cores and 28 GB RAM). My web application provides a REST API to insert several data fields into DB. The application uses a common ...
0
votes
0answers
42 views

Install latest mysql 5.6 update (update 19 to update 22) on Ubuntu 14.04

A while ago I installed Mysql 5.6.19 via "apt-get install mysql-server-5.6" on a Ubuntu 14.04 amd64 server, now I want to upgrade this Mysql 5.6.19 to the latest stable update (5.6.22). I can't do it ...