MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
0answers
5 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
0answers
13 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 ...
-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
27 views

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

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
38 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
46 views

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

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
13 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
32 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
10 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
20 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
35 views

Configuration of MySQL Server 5.6.24 is taking longer that expected [on hold]

Having a little trouble finishing the configuration of MySQL. 'Starting server' has been attempting for about 60 mins now. I keep get the following message: Configuration of MySQL Server 5.6.24 is ...
-1
votes
0answers
13 views

things to do to ensure that data is secured on my virtual server [on hold]

I'm not much of an administrator but I'm maintaining a virtual server with Ubuntu OS where my website is hosted. I often connect to it using ssh, ftp and whatever the protocol MySQL uses. As my ...
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', ...
2
votes
4answers
75 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
53 views

Why the latency increases on highload? [on hold]

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 ...
-2
votes
0answers
18 views

how do I get plesk running correctly on Ubuntu? [closed]

I have installed Plesk 12 with the autoinstaller from http://autoinstall.plesk.com/one-click-installer. The installation succeeded with "Congratulations! All stages of the installation/upgrade ...
1
vote
1answer
30 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
32 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 ...
-1
votes
0answers
10 views

Chef automate MySQL replication cookbook and roles [closed]

So I found this cookbook https://supermarket.chef.io/cookbooks/mysql-multi and trying to put together recipe. Has anyone did it? Can you point to directions where to begin Thanks
25
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
43 views

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

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
66 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
23 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
12 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
53 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
20 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
23 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
44 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 ...
1
vote
1answer
27 views

MySQL PID Errors

While attempting to change the MySQL server timezone to CDT to match the Centos sytem time, something has messed up. I edited the my.conf in /etc/ in vim logged in to SSH as root, and saved it. On ...
-1
votes
3answers
27 views

how to recover all mysql tables of all databases in centos6 with mysql 5?

mysql is corrupt in centos 6 it is showing #1033 - Incorrect information in file: /xxxx/xxx.frm for all database and showing all tables empty. how to recover all databases?
0
votes
2answers
79 views

Strange “/var/lib/mysql too full!” message, with almost empty partitions

I've just encountered a strange problem on my server : it's a basic LAMP server I've just setup and when I try to restart MySQL, I get the following error. /etc/init.d/mysql: ERROR: The partition ...
0
votes
0answers
12 views

Can't enable binary logging (“index not found”) [migrated]

I have a MySQL 5.5.41 server running on Ubuntu 14.04 that already contains several databases of data, and I would like to enable binary logging. I want the binary logs to be placed in their own ...
0
votes
0answers
22 views

How to fix hung requests creating dead lock(/root/syn)?

We are running a search service using written in Java using solr We are noticing dead locks on the service. 14:00:30,465 WARN ThreadPoolAsynchronousRunner:416 - Task ...
-1
votes
0answers
14 views

What type of server is right for my requirements? [IOS Application API] [duplicate]

I am preparing for the startup of my iOS application. What type of server would be the best for my requirements. REQUIREMENTS MySQL DB PHP GET/POST Requests Sufficient Storage for Images Good ...
0
votes
1answer
21 views

cant turn on mysqld. I moved mysql to an XFS directory and pointed it there

hey guys hopefully someone has the answers for this but these are my errors ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) and in my ...
0
votes
2answers
38 views

Protecting mysql instance on Linux Azure VM

I have mysql running in a Linux Azure VM. It's currently bound to the "Internal IP Address" of the VM as looked up in ifconfig and the Azure Dashboard. I've turned on logging to see who and what is ...
-1
votes
0answers
27 views

High memory usage (compared to wamp) and unresponsive site at times

Lately my site (with 260000 posts, 12000 images, 2,360,987 mysql rows and 450.7 MiB size) is running slow and at times not loading for many mins I installed this Debug bar plugin ...
0
votes
0answers
22 views

Import outdated MySQL dump using console

I have a mysql dump file created by outdated MySQL version. I have no access to that server (console). If i use this command on my current server: mysql -u user -p dbname < dump.sql I get this ...
0
votes
0answers
30 views

Port 3306 for MySQL closed

It seems that the port 3306 for remote MySQL access is closed on my server. In /etc/mysql/my.cnf I changed the bind-address setting to my remote IP already and restarted the server. A nmap scan of ...
0
votes
1answer
22 views

MySQL Bad Handshake to MySQL Cluster behind Proxy

I have just set up a MySQL cluster using five hyperV linux boxes (2x management nodes, 2 data nodes and 1 proxy) having followed (with a bit of tweaking) the instructions here. Everything works fine ...
0
votes
1answer
47 views

Is it better to drop a MySQL database before doing a restore?

I have been doing a ton of database restores lately and have been thinking about better ways to do things. One thing I am not sure of is what is the best order of operations in terms of backup and ...
0
votes
0answers
151 views

MariaDB crashing with “Assertion failure in thread xxx in file rem0rec.cc line 580”

I have three MariaDB servers set up in a Galera cluster. I use one server at a time as a "primary" master (i.e., Galera is just for failover, the app doesn't actively use multiple masters). About ...
-3
votes
0answers
16 views

Reducing query cache for mostly INSERT-heavy database? [migrated]

What sort of MySQL query cache should I choose considering the following... Large, rapidly growing database (I got 500,000 rows). UPDATEs practically never happen. SELECTs are rare, but when they do ...
-1
votes
1answer
19 views

Need help importing data to new SQL server from MySQL folder

My hard drive crashed, and can no longer write, but it can still read. Because of this, I was unable to export my SQL database to an .sql file for later importing. I can still access the drive, and ...
-2
votes
0answers
30 views

MySQL table doesn't exist [migrated]

What I did before the disaster was: vi /etc/my.cfg I added innodb_buffer_pool_size=4G innodb_buffer_pool_instance=2 innodb_read_io_threads=12 innodb_write_io_threads=12 innodb_io_capacity=300 ...
0
votes
1answer
24 views

mysql command in command line return unknown variable

When I try to use: mysql -u [user] -p command (or any other "mysql") at my Debian server command line I get this error: mysql: unknown variable 'log=/var/log/mysql.log' mysql-client is ...
-1
votes
0answers
21 views

Connect EC2 with RDS

I am trying to move my CMS from 1&1 to AWS. The CMS was built using PHP + MYSQL. I have completed the following steps in AWS - I created an EC2 instace I uploaded a php script to test if ec2 ...